Export/Import customer

[Zsirafovics]

I'd like to upload customers and vendors to a new database.
My problem is, that base data and addresses are in two different table.
Is there any easy way to export/import related data together?

Thanks for any advice

[Zsirafovics]

Ok. I solved the export.
I created a query in Direct SQL and copied the result to an LO Calc sheet.
I just focused too much on export command. :)

However, I don't know yet how I'm going to import it all at once.

[Tekki]

There is an export for customers in the menu. (Seems there is the problem with the button if you don't use the English translation. I'll look into that.)
You should be able to take this spreadsheet, delete the ID column an import it into the new database. Always create a snapshot before such experiments.
It's rarely a good idea to access the content of the database directly. Especially in this case, you import entries with IDs into the new database that will quite probably overlap with future new entries.

[Zsirafovics]

Oh, how foolish I am!
I modified the menu.ini file and forgot to put those two.

Thank You very much!