Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
5951 Widoki

I have a structure like this:


ACME

-- ACME East

------ Mark Jones


ACME and ACME East are companies, Mark is a contact at ACME East.


I read at \https://www.odoo.com/forum/help-1/question/multi-level-customer-structure-how-can-i-add-a-subsidiary-to-a-company-record-not-a-contact-i-need-a-grandparent-parent-child-hierarchy-for-my-customer-record-122659 that this structure is supported.


How can I structure my Excel/CSV import files so that I can import thousands of contact and company records?



Awatar
Odrzuć
Najlepsza odpowiedź

Use a file like this:


Note: ID is to uniquely identify the record - it is like a social security number or national identification number for the record [your previous system may already have one] and is needed because you will be importing TWICE.


The first import will create the records without any relationships.

The second import will update the record to add the relationship.


ID is also used if you are importing prior to Go Live and want to do another import at Go Live, so you can UPDATE any record where emails or phone numbers change and ADD any record where new Companies or People are added.


Your first import will be like this:


Note that you are NOT importing the Parent (because it doesn't exist and unless you can sort your file so that all grandparents and parents are before all children Odoo won't find the Parent because it won't be created)


Your second import will be like this:



When you are done with both imports, you will have this:




Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
9
sie 20
7161
1
sty 24
1807
1
sie 24
1658
9
lis 22
10672
1
wrz 21
4155