Import classification / taxonomy from CSV

English Import/export
12

@Hilikus Thanks for the output screenshot.

The taxonomy data is already formatted and structured as csv in the files I posted above. It is not a traditional csv file as repeating data is only listed once.

Two changes are needed:

  1. The First fields are Levels 1..N where N is the number of levels for Taxonomy. Level N needs to be moved to Level 0 as the first field (Security).
  2. Level 1 contains the Taxonomy or Without Classification. It needs to contain the Taxonomy and move Without Classification to Levels 2.
  3. I’d suggest a third, Rename Levels N fields to LevelN to make the grammar more correct and remove the space in the field name label.

I have concatenated the taxonomy data files, reformatted it with the first change but not the other changes, and attached it to the bottom of this post. Feel free to open it in a spreadsheet and filter by the first row.

Taxonomy_kommer.csv (38.4 KB)

Now again, Which website(s) have the data? Can you provide a sample data download, preferably with a couple of taxonomies for at least one security? (Even better to do all kommer securities and taxonomies.)

Once we have a data source we can design the transformation process. Also, fix the flaw with the import process that does not allow importing updates to existing records.