I have created 1000 customers with project for each customer. To assign the Users for the projects, there is no Import Option using CSV or Excel File. Suggest if this feature be added. Version Dolibar 7.0.0
First use phpMyAdmin to export the mySQL Dolibarr tables WITH HEADERS! These headers (field names) are used in the next step to “synchronize” your existing data structure with the one expected by Dolibarr.
Then “massage” your existing data eg. with EXCEL or any other spreadsheet so they resemble the field order of the data just exported in the first step.
ATTENTION: Eventually you have to import your customer data first. Then export this table just generated again to get the required key-values needed to connect projects and tasks of that customer from your original data to the Dolibarr customers. This step is done by “pairing” line by line the customer key already generated with the customer fileld in your project data.
Customer, Address, … import INTO Dolibarr
KEY, Customer, Adress … export FROM Dolibarr
Customer, Project, Task_1, Task_2, … then should look like
KEY, Project, Task_1, Task_2, … before import into project table
As a last step you import your original project data (now containing the Dolibar customer key) into the Dolibarr project table.
The principal of import of any CSV file with phpMyAdmin is explained here:
https://stackoverflow.com/questions/3635166/how-to-import-csv-file-to-mysql-table
