Strange CSV Import result on Join Tables

[swissgregi]

Hello
I have a Table "Product" where i have joins to the tables "Shop" and "Brand".
Now i try to do a import with CSV.
I exported the CSV from LibreOffice.

After import i got only one product "Hat" with shop name "Composhop" and brand "Applosoft".
This means, the import only takes the first row for the "product" table, and the last rows for "shop" and "brand". But why?

Now i tried the same with this table (with product.id)

After import i got all three products in the "product" table. (Hat, Shoe and Tablet PC).
But no entries in the "shop" and "brand" tables.

Did i do something wrong?
Is the CSV import buggy?

Thanks for your help!

 

[cheesegrits]

Can you do a CSV export from some existing test data on your products table, select all the elements we offer to export, and include raw data.

Paste the output here.

-- hugh

 

[cheesegrits]

Just FYI, importing CSV data from a single flat, non-relational spreadsheet, into a joined, relational database is not a trivial task.

So the best way to approach it is to look at how Fabrik exports some test data, then provide that exact same format for importing.

-- hugh