I am providing a csv file containing for example __export__.res_partner_22 external id to the record(s). When the csv is imported, the id is not the one I provided.
How is supposed to maintain relationships between old records if this happens?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Księgowość
- Zapasy
- PoS
- Projekt
- MRP
To pytanie dostało ostrzeżenie
3
Odpowiedzi
5532
Widoki
It doesn't matter if the database id changes between ols and new databases:
the partner id could be "156", but the external id preserves the old (__export__.res_partner_22), so this way the relationship between (for example user_id) is preserved. The only difference is that in old database:
id = 22
external id: *_22
and in the new database:
id = 156
external id: *_22
Podoba Ci się ta dyskusja? Dołącz do niej!
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
1
mar 18
|
4146 | ||
|
1
mar 16
|
4114 | ||
|
2
mar 15
|
11678 | ||
|
|
1
mar 15
|
10053 | ||
|
1
lut 21
|
5309 |
Are you importing the CSV file via the User Interface? A module? If via the User Interface, what field are you mapping the External ID field to?
Thanks, @Ray Carnes seems I found the answer myself.. I was wrong in something. Here's the post.
In the original question, I inferred that id and external_id should preserve the same number, and I was wrong in that.