Skip to Content
This question has been flagged
importvalidateupdatesequencechanged
1 Respondre
6518 Vistes
Avatar
tim diamond

I have an object with a sequence that is updated in the create() method. I ran into an odd problem today, when I was importing data:

To illustrate, my next number in the sequence was 50. And lets say I was importing 75 records.

  1. I ran the import wizard, clicked validate. Everything was good.
  2. Import the data. Success.
  3. Check the assigned sequence: They were 125-200 instead of the expected 50-125!

So clearly, the import validation button is actually running the create() method? Then deleting the results? If this is the case, is there a way I could check the context to make sure that If the import validation is running that I do NOT assign a sequence number? Anyone run into this problem before?

Avatar
Descartar
Avatar
AJ Schrafel Paper Corp
Best Answer

If you have the column "id" mapped properly the sequence will be preserved, items without a sequence will be flagged.

also, if you have imported things and deleted them, those sequence numbers will not be reclaimed, number will start with the last highest.

if you have id - name 1 - A 2 - B 3 - C < delete this

and then you import more stuff number will start at 4. 1 - A 2 - B 4 - D 5 - E

if you have id - name 1 - A 2 - B 3 - C < delete this

and then you import this: id - name 3 - D 4 - E

you would end up with 1 - A 2 - B 3 - D 4 - E

Avatar
Descartar
tim diamond
Autor

Thank you for your answer. However, I still a bit confused. What exactly do you meanby mapping the column id? I'm importing new products, and thus NOT using an external_id column in the import. When openerp sees this, it simply adds a new product for me. Please, could you be a little more specific? Thanks again!

tim diamond
Autor

Actually, THANKS!! I had to change the sequence entry to be "No Gap".

AJ Schrafel Paper Corp

glad it worked for you.

Related Posts Respostes Vistes Activitat
How do you disable ean13 validation? Solved
import validate
Avatar
Avatar
Avatar
Avatar
Avatar
4
de març 15
9727
Update odoo records based on custom field
import update employees
Avatar
Avatar
1
d’ag. 24
2657
Update data by import via .csv files? Solved
import csv update
Avatar
Avatar
Avatar
Avatar
Avatar
4
de nov. 23
33628
Cannot update product information through External ID
import update external_id
Avatar
Avatar
Avatar
Avatar
5
d’abr. 18
9425
Invoice Numbers not be created?
invoice validate sequence
Avatar
Avatar
Avatar
Avatar
Avatar
12
de gen. 17
15729