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. I ran the import wizard, clicked validate. Everything was good. Import the data. Success. 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 res

Sequence changed on Import Validation

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
회계
재고 관리
PoS
Project
MRP

All apps

모든 게시물 사용자 배지

태그 (모두 보기)

odoo accounting v14 pos v15

게시판 정보

도움말

Sequence changed on Import Validation

import validate update sequence changed

1 회신

5848 화면

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.

I ran the import wizard, clicked validate. Everything was good.
Import the data. Success.
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?

AJ Schrafel Paper Corp

베스트 답변

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

tim diamond

작성자

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

작성자

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

AJ Schrafel Paper Corp

glad it worked for you.

토론이 재미있으신가요? 직접 참여해보세요!

지금 바로 가입하여 독점 서비스를 이용해보고 특별한 커뮤니티와 소통하세요!

가입

관련 게시물	답글	화면
How do you disable ean13 validation? 해결 완료 import validate	4 3월 15	8746
Update odoo records based on custom field import update employees	1 8월 24	1670
Update data by import via .csv files? 해결 완료 import csv update	4 11월 23	32115
Cannot update product information through External ID import update external_id	5 4월 18	8507
Invoice Numbers not be created? invoice validate sequence	12 1월 17	14460

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!