I’m preparing strategy to import third parties and contacts in Dolibarr., can you give me best practice please ?
I see 2 ways :
1-is it possible to force Third-Party rowid when importing ?
then import contacts is easy.
2-if not possible to force Thirdparty rowid , then I’d need
-to import Third parties,
-export thirdparties with rowid,
-map this file with contact file in excel
-import contacts with fk_soc from contacts table filled with Thirdparty rowid.
The best way to do this is to create a sql script that will populate your thirdpaties and contacts tables
and with this method you will be able to import every kind of information : products, prices, categories, orders, shipments or invoices
Doing this, you can begin with Dolibarr, with the dats from your old erp
hi PCbleu,
thanks for your advise,
unfortunately I don’t have access to dolibarr intsance with SQL;
any hint how to build this import through dolibarr excel import tool ?
thanks lot
Phil
