MachineVisionUiB / machinevision

We are developing a database to map and interpret the representations and uses of machine vision technologies in digital art, computer games and narratives such as science fiction novels, movies and creepypasta.
http://uib.no/en/machinevision
4 stars 0 forks source link

Data export generates different output than shown in preview #13

Closed jilltxt closed 3 years ago

jilltxt commented 5 years ago

E.g. this view: https://old.machine-vision.no/admin/structure/views/view/machine_vision_clone_of_data_export_all_works/edit/views_data_export_1 --> should display works + sentiments but instead the export has works + years + themes.

Test export

steinmb commented 5 years ago

I'll start looking into this today and later this week.

steinmb commented 5 years ago

Odd bug. Always "fun". Can you test it know? Included link to the export page in issue summary (first comment). Are we still missing stuff?

Example export

"ELMCIP Node ID","Title"                                                                                           ,"TID: Sentiment","Sentiment"
"210"           ,"10.000 Moving Cities – Same but Different, VR (Virtual Reality)"                                 ,""              ,""
"239"           ,"79530 Self Portraits"                                                                            ,"2000186"       ,"Uncanny"
"239"           ,"79530 Self Portraits"                                                                            ,"2000194"       ,""
"239"           ,"79530 Self Portraits"                                                                            ,"2000190"       ,"Inaccurate"
"239"           ,"79530 Self Portraits"                                                                            ,"200097"        ,"Exciting"
"204"           ,"Adversarially Evolved Hallucination"                                                             ,"200096"        ,"Alien"
"71"            ,"AI Generated Nude Portraits "                                                                    ,""              ,""
"86"            ,"AI, Ain't I a Woman"                                                                             ,""              ,""
"131"           ,"Alien: Blackout"                                                                                 ,"200098"        ,"Helpful"
"233"           ,"Any Vision"                                                                                      ,"200098"        ,"Helpful"
"233"           ,"Any Vision"                                                                                      ,"2000193"       ,"Revealing"
"233"           ,"Any Vision"                                                                                      ,"200096"        ,"Alien"
"153"           ,"Autonomous"                                                                                      ,"2000107"       ,"Oppressive"
"153"           ,"Autonomous"                                                                                      ,"2000100"       ,"Intimate"
"153"           ,"Autonomous"                                                                                      ,"200098"        ,"Helpful"
"212"           ,"Autonomous Trap 001"                                                                             ,"2000145"       ,""
"118"           ,"B.I.T. Plane"                                                                                    ,"2000101"       ,"Neutral"
"47"            ,"Beholder"                                                                                        ,""              ,""
"65"            ,"Belief Systems"                                                                                  ,""              ,""
"200"           ,"Black Mirror:  Shut Up and Dance"                                                                ,"200099"        ,"Hostile"
"195"           ,"Black Mirror: Fifteen Million Merits"                                                            ,"2000100"       ,"Intimate"
"195"           ,"Black Mirror: Fifteen Million Merits"                                                            ,"2000107"       ,"Oppressive"
"197"           ,"Black Mirror: The Entire History of You"                                                         ,"2000100"       ,"Intimate"
"197"           ,"Black Mirror: The Entire History of You"                                                         ,"2000107"       ,"Oppressive"
"197"           ,"Black Mirror: The Entire History of You"                                                         ,"2000193"       ,"Revealing"
"198"           ,"Black Mirror: White Christmas"                                                                   ,"2000100"       ,"Intimate"
"198"           ,"Black Mirror: White Christmas"                                                                   ,"2000107"       ,"Oppressive"
"198"           ,"Black Mirror: White Christmas"                                                                   ,"2000145"       ,""
"156"           ,"Body Devices"                                                                                    ,"2000100"       ,"Intimate"
"156"           ,"Body Devices"                                                                                    ,"200097"        ,"Exciting"
"6"             ,"Breathe: A Ghost Story"                                                                          ,"2000100"       ,"Intimate"
"6"             ,"Breathe: A Ghost Story"                                                                          ,"200096"        ,"Alien"
"8"             ,"Cheese"                                                                                          ,""              ,""
"75"            ,"CMYK Deep Face Dude "                                                                            ,""              ,""
"31"            ,"CV Dazzle"                                                                                       ,""              ,""
"162"           ,"Daemon"                                                                                          ,"200099"        ,"Hostile"
"162"           ,"Daemon"                                                                                          ,"2000107"       ,"Oppressive"
"162"           ,"Daemon"                                                                                          ,"2000129"       ,"Dangerous"
"162"           ,"Daemon"                                                                                          ,"200096"        ,"Alien"
"208"           ,"DELIVERY FOR MR. ASSANGE"                                                                        ,""              ,""
"186"           ,"Desperados: Wanted Dead or Alive"                                                                ,"2000101"       ,"Neutral"
"186"           ,"Desperados: Wanted Dead or Alive"                                                                ,"200098"        ,"Helpful"
"180"           ,"Detroit: Become Human"                                                                           ,"200098"        ,"Helpful"
"203"           ,"deus X mchn"                                                                                     ,""              ,""
"169"           ,"Digital Scores (after Nicéphore Niépce)"                                                         ,"2000101"       ,"Neutral"
"90"            ,"Dissonant Imagery"                                                                               ,""              ,""
"15"            ,"Do Not Feed the Monkeys"                                                                         ,""              ,""
"110"           ,"Drawing Operations "                                                                             ,"200097"        ,"Exciting"
"151"           ,"Dream House"                                                                                     ,"2000101"       ,"Neutral"
"159"           ,"Drone Selfies"                                                                                   ,"2000101"       ,"Neutral"
"159"           ,"Drone Selfies"                                                                                   ,"2000100"       ,"Intimate"
"33"            ,"Drones"                                                                                          ,""              ,""
"157"           ,"Drones Don't Kill People"                                                                        ,"2000101"       ,"Neutral"
"176"           ,"Echo"                                                                                            ,"2000100"       ,"Intimate"
"176"           ,"Echo"                                                                                            ,"200098"        ,"Helpful"
"146"           ,"Encounters"                                                                                      ,"2000104"       ,""
"146"           ,"Encounters"                                                                                      ,"200098"        ,"Helpful"
"146"           ,"Encounters"                                                                                      ,"200097"        ,"Exciting"
"104"           ,"eXistenZ"                                                                                        ,"200097"        ,"Exciting"
"92"            ,"Face Your Feelings"                                                                              ,""              ,""
"224"           ,"Facial Features Not Recognized"                                                                  ,""              ,""
"29"            ,"Facial Weaponization Suite"                                                                      ,""              ,""
"116"           ,"Fall of the House of Usher"                                                                      ,"200097"        ,"Exciting"
"137"           ,"Five Nights at Freddy's"                                                                         ,""              ,""
"123"           ,"Get Lauren"                                                                                      ,"200098"        ,"Helpful"
"80"            ,"Hardcore Henry"                                                                                  ,""              ,""
"127"           ,"Has Anyone Else Used ExpressionCaptioner?"                                                       ,"200099"        ,"Hostile"
"102"           ,"Her"                                                                                             ,"2000100"       ,"Intimate"
"37"            ,"Home"                                                                                            ,""              ,""
"135"           ,"Horizon Zero Dawn"                                                                               ,"2000193"       ,"Revealing"
"135"           ,"Horizon Zero Dawn"                                                                               ,"200098"        ,"Helpful"
"226"           ,"I Created an AI to Make Procedurally Generated Movies, But They're Horrifying"                   ,"200099"        ,"Hostile"
"26"            ,"I Spy with my Machine Eye"                                                                       ,""              ,""
"220"           ,"I'm going to die, and probably soon, because of what I saw through an unsecured webcam one night","2000100"       ,"Intimate"
"220"           ,"I'm going to die, and probably soon, because of what I saw through an unsecured webcam one night","2000129"       ,"Dangerous"
"25"            ,"In the Robot Skies: A Drone Love Story "                                                         ,""              ,""
"69"            ,"Interface"                                                                                       ,""              ,""
"40"            ,"Iris"                                                                                            ,""              ,""
"144"           ,"Jamming with Edward"                                                                             ,"200097"        ,"Exciting"
"184"           ,"Jller"                                                                                           ,"200098"        ,"Helpful"
"45"            ,"Just Dance 2019"                                                                                 ,"200098"        ,"Helpful"
"45"            ,"Just Dance 2019"                                                                                 ,"2000193"       ,"Revealing"
"45"            ,"Just Dance 2019"                                                                                 ,"2000191"       ,"Intelligent"
"106"           ,"La Region Nationale"                                                                             ,"200097"        ,"Exciting"
"167"           ,"Lessons on Leaving Your Body"                                                                    ,"2000100"       ,"Intimate"
"167"           ,"Lessons on Leaving Your Body"                                                                    ,"200097"        ,"Exciting"
"167"           ,"Lessons on Leaving Your Body"                                                                    ,"2000129"       ,"Dangerous"
"167"           ,"Lessons on Leaving Your Body"                                                                    ,"200096"        ,"Alien"
"173"           ,"Little Brother"                                                                                  ,"2000107"       ,"Oppressive"
"173"           ,"Little Brother"                                                                                  ,"2000129"       ,"Dangerous"
"73"            ,"Machine Vision"                                                                                  ,""              ,""
"213"           ,"MegaPixels: Faces"                                                                               ,"2000107"       ,"Oppressive"
"213"           ,"MegaPixels: Faces"                                                                               ,"2000100"       ,"Intimate"
"141"           ,"Minority Report"                                                                                 ,"2000107"       ,"Oppressive"
"187"           ,"Mosaic Virus and Myriad (Tulips) "                                                               ,"200098"        ,"Helpful"
"222"           ,"My Camera Knows Something I Don't"                                                               ,"200098"        ,"Helpful"
"61"            ,"Nail Art Museum"                                                                                 ,""              ,""
"179"           ,"Narciss"                                                                                         ,"2000100"       ,"Intimate"
"179"           ,"Narciss"                                                                                         ,"2000145"       ,""
"129"           ,"NieR: Automata"                                                                                  ,""              ,""
"53"            ,"Night Trap"                                                                                      ,""              ,""
"202"           ,"Nineteen Eighty-Four"                                                                            ,"200099"        ,"Hostile"
"202"           ,"Nineteen Eighty-Four"                                                                            ,"2000107"       ,"Oppressive"
"165"           ,"No More Selfies - A Kardashian Dystopia"                                                         ,"200099"        ,"Hostile"
"165"           ,"No More Selfies - A Kardashian Dystopia"                                                         ,"2000107"       ,"Oppressive"
"55"            ,"Nothing to Hide"                                                                                 ,""              ,""
"44"            ,"Orwell"                                                                                          ,""              ,""
"228"           ,"Outlast"                                                                                         ,"200098"        ,"Helpful"
"228"           ,"Outlast"                                                                                         ,"2000193"       ,"Revealing"
"77"            ,"Parametric Expression"                                                                           ,""              ,""
"49"            ,"Pokémon Go"                                                                                      ,""              ,""
"63"            ,"Postcards from Google Earth"                                                                     ,""              ,""
"122"           ,"pplkpr"                                                                                          ,"200098"        ,"Helpful"
"10"            ,"Ralph Breaks the Internet"                                                                       ,""              ,""
"98"            ,"Ready Player One"                                                                                ,"200097"        ,"Exciting"
"98"            ,"Ready Player One"                                                                                ,"2000145"       ,""
"98"            ,"Ready Player One"                                                                                ,"2000129"       ,"Dangerous"
"59"            ,"Remember/Imagine"                                                                                ,""              ,""
"42"            ,"République"                                                                                      ,""              ,""
"218"           ,"Satellite Images"                                                                                ,"200099"        ,"Hostile"
"218"           ,"Satellite Images"                                                                                ,"200097"        ,"Exciting"
"125"           ,"Selfies"                                                                                         ,"200099"        ,"Hostile"
"133"           ,"Someone to Watch Over Me"                                                                        ,"2000100"       ,"Intimate"
"67"            ,"Song of the Machine"                                                                             ,""              ,""
"57"            ,"Sorting Daemon"                                                                                  ,""              ,""
"149"           ,"Status Symbols: Twitter Portraits"                                                               ,"2000101"       ,"Neutral"
"231"           ,"Surveillance Kanshisha"                                                                          ,"200098"        ,"Helpful"
"96"            ,"Sword Art Online"                                                                                ,"200099"        ,"Hostile"
"51"            ,"Tacoma"                                                                                          ,""              ,""
"154"           ,"The Blue Pill"                                                                                   ,"2000107"       ,"Oppressive"
"216"           ,"THE GOOGLE TRILOGY – 3.The Driver and the Cameras"                                               ,""              ,""
"82"            ,"The Machine Stops"                                                                               ,""              ,""
"193"           ,"The Normalizing Machine"                                                                         ,"2000107"       ,"Oppressive"
"235"           ,"The Sims 4"                                                                                      ,"2000101"       ,"Neutral"
"217"           ,"The Virtual Watchers"                                                                            ,"2000107"       ,"Oppressive"
"19"            ,"The Webcam Project"                                                                              ,""              ,""
"229"           ,"Tom Clancy's Ghost Recon: Wildlands"                                                             ,"200098"        ,"Helpful"
"112"           ,"Totally Normal"                                                                                  ,"2000101"       ,"Neutral"
"114"           ,"Transdimensional Serpent"                                                                        ,"200097"        ,"Exciting"
"164"           ,"Trette Menn"                                                                                     ,"200098"        ,"Helpful"
"164"           ,"Trette Menn"                                                                                     ,"200097"        ,"Exciting"
"164"           ,"Trette Menn"                                                                                     ,"2000145"       ,""
"21"            ,"TV-Helmet (Portable living room)"                                                                ,""              ,""
"206"           ,"U"                                                                                               ,"2000100"       ,"Intimate"
"192"           ,"Unmanned"                                                                                        ,"2000129"       ,"Dangerous"
"121"           ,"Us+"                                                                                             ,"200098"        ,"Helpful"
"20"            ,"VFRAME – Visual Forensics and Advanced Metadata Extraction"                                      ,"200098"        ,"Helpful"
"237"           ,"Voyeur"                                                                                          ,"2000193"       ,"Revealing"
"24"            ,"WATCH_DOGS 2"                                                                                    ,"2000187"       ,"Ambiguous"
"108"           ,"Young Ones"                                                                                      ,"2000101"       ,"Neutral"
"94"            ,"“Thoughts and Prayers”"                                                                          ,""              ,""
jilltxt commented 4 years ago

This will probably go away with upgrade. At least not worth worrying about until it happens again after upgrade. I'll tag with postpone.

steinmb commented 4 years ago

Going to revisit this old issue. Will also force me to recreate the data export from scratch.

steinmb commented 3 years ago

Fix and the rest is out of date. Closing