search

SmartDataAnalytics / OpenResearch

Public issue system for OPENRESEARCH/ConfIDent
8 stars 3 forks source link

External Spreadsheet editing for Event Series #236

Closed WolfgangFahl closed 2 years ago

WolfgangFahl commented 3 years ago

see #230

tholzheim commented 3 years ago

Situation: Event Series 3DUI is given Action: Edit it with an external csv editor(spreadsheet application such as excel, numbers, LibreOffice, Visual Studio csv plugin, google sheets ...) Expected result: Corresponding Event pages such as 3DUI 2014 and 3DUI 2020 are changed. New pages created if needed

Possible csv output:

State,Country,Ordinal,End date,Submission deadline,pageTitle,Acronym,Series,has Proceedings Link,Start date,Homepage,Type,City,Title 
South Carolina,USA,,2016/03/20,,3DUI 2016,3DUI 2016,3DUI,,2016/03/19,,Conference,Greenville,IEEE Symposium on 3D User Interfaces 
,USA,,2020/03/26,2019/09/03,3DUI 2020,3DUI 2020,3DUI,,2020/03/22,http://ieeevr.org/2020/,Symposium,Atlanta,IEEE Symposium on 3D User Interfaces 
,USA,15,2010/03/21,,3dui 2010,3DUI 2020,3DUI,https://www.computer.org/csdl/proceedings/3dui/2010/12OmNAsTgX7,2010/03/20,http://ieeevr.org/2020/,Symposium,Waltham,IEEE Symposium on 3D User Interfaces
tholzheim commented 3 years ago

op_export_import

WolfgangFahl commented 3 years ago

see https://rq.bitplan.com/index.php/Workdocumentation_2021-06-30_TH#Try_CSV_import_.26_export

WolfgangFahl commented 3 years ago

The csv separator used is currently ",". That is not recognized as the default separator in some environments. See https://superuser.com/questions/606272/how-to-get-excel-to-interpret-the-comma-as-a-default-delimiter-in-csv-files

We'll need an option e.g. to specify the separator.

MusaabKh commented 3 years ago

Further developments: https://rq.bitplan.com/index.php/Workdocumentation_2021-07-09_MK#CSV_Generation

WolfgangFahl commented 3 years ago

Past CSV exports have created broken results such as:

WolfgangFahl commented 3 years ago

Use https://github.com/WolfgangFahl/ConferenceCorpus/issues/10 as a service

MusaabKh commented 2 years ago

When we create the csv, the separator and locality is taken into account. The locality consists of two things; The country and the language. Default locality: DE, Germany, EN, USA. Far away from the standardized ISO version. Internationalization issue involves column of type dates and floating points. The columns need to survive the round trip in the same shape. When we get the data back it is not ruined.

WolfgangFahl commented 2 years ago

The base functionality is available now so closing this ticket. Please file new issues if there any problems in detail.