search

ErwinKomen / RU-MultiL

0 stars 0 forks source link

Excel: import #3

Closed ErwinKomen closed 9 months ago

ErwinKomen commented 2 years ago

Add code to import an Excel and turn it into a correct JSON file.

The tab pages of the Excel to import are:

  1. Dataset - this contains all the data
    1. And there are a number of columns that should be converted to separate tables and then referred to with an FK: long_cite, 'short_cite,data_collection,target_language,other_language,task_type, task_detailed,morphosyntactic_property_type,morphosyntactic_property_detailed, bilingual_group,target_option,nontarget_option,dependent_measure,dependent_measure_type`, ...
  2. Explanation columns - this contains the field name and an explanation
    1. But not: the rows that do not have anything in column B 'Description' should be ignored
ErwinKomen commented 2 years ago

(For the moment this is done using an online tool)