Problem with importing parameters of a Part via CSV

Part-DB / Part-DB-server

Part-DB is an Open source inventory management system for your electronic components

https://docs.part-db.de/

GNU Affero General Public License v3.0

881 stars 96 forks source link

Problem with importing parameters of a Part via CSV #651

Open LozanAyip opened 2 months ago

LozanAyip commented 2 months ago

Im importing parts via CSV, everything is working except the parameters of a Part. It gets imported, but not used. I even exported a existing Part as csv_full and made the same structure but it still doesnt work. Is it even possible and how should I do it? Thanks for the help!

jbtronics commented 1 month ago

What do you mean by "imported but not used"?

The general problem with CSV is that it is only useful for "flat" data. If you have data with nested information (like multiple parameters for a part), then this is only possible with some tricks (a column for every possible sub entry).

Something like JSON or YAML is a much better fit if you want to import complex data structures.

NikoDelarich commented 2 weeks ago

I have the same issue: I can export a component in Full-JSON format and import it back, but the parameters are missing after the import...

Here's what I'm doing:

Create part with parameters
Export part ("Full")
Delete part
Import part

After the import, the part is created but the parameters are missing. Do I need to change anything in the import file? I already tried all the different import formats (JSON, CSV, XML, YAML)...