47 πŸ’» Upload and roundtripping: examples

  1. Download any current file and do any of the following:
    1. make any ordinary trivial edits like changing a name, and/or add ordinary columns/fields, upload, must just work
    2. Same, but optionally delete any of the main 5 tabs
    3. Add rows. Note this does not add linked entries in linked tables.
    4. Delete rows. Note this does not delete linked entries in linked tables.
  2. Only with a statements tab,
    1. with a column text and optionally source_id, question_id and maybe other fields. should this add the source and question ids to the source and question tables?
  3. Only with a links tab
    1. which has just from_label and to_label columns (and no from or to columns but optionally others) and no factors tab
    2. which has numerical from and to columns which (optionally, usually) relate at least partially to a factors tab which has a factor_id column and (optionally, usually) a label column.
    3. also with statement ids? should it create these in the statements table?
  4. Just a sources and/or questions tab
    • should be straightforward?

47.1 Preparing and uploading/importing your .xlsx file

You provide this table, and any other tables you might need as one xlsx file.

Your statements can have non-Latin characters like Γ , Γ¨, ΓΉ, Π±, ΠΆ, etc, the app should reproduce these perfectly.

47.1.1 What if you have merged cells so e.g.Β source_id spans many rows?

https://www.extendoffice.com/documents/excel/1139-excel-unmerge-cells-and-fill.html