How to rollback if the import is failed?

julkifli33 · 2011-01-12

hi all , i create i report to import to sales header and sales line (1 file inserted to these 2 tables)
my code is first insert into sales header off course
and then i inserted to sales line... using Sales Header."No." become Sales Line."Document No."
but sometimes if i want to add Sales Line, it got an error because we haven't input the item
but it still create the header....
if we import once again, it will create sales header and sales line, which is will be redundant
so... what should i do, to prevent it create sales header before it check that sales line is correct
thanks

hemantOne · 2011-01-12

Hi,

Temporary table may be useful.
I think first insert in temporary table of Sales Header and line .If no error after all records passed then insert temporary into real tables.

raveendran.s · 2011-01-12

I suggest to use RIM tool here. This will give us the list of errors at the time of importing

kine · 2011-01-12

1) There must be some COMMIT in the process. Just use the client monitor to find it.
2) The commit is not in standard I assume. It seems like bad concept.

rmv_RU · 2011-01-13

kine wrote:

1) There must be some COMMIT in the process. Just use the client monitor to find it.
2) The commit is not in standard I assume. It seems like bad concept.

In additional, you can protect code from the unexpected commit by adding SalesHeader.consistent(false) before the import routline and SalesHeader.consistent(true) after

ara3n · 2011-01-13

That's a good trick. =D>

reijermolenaar · 2011-01-13

Applause indeed!! =D>

This will save me a lot of time the next time I have to search for a commit.

David_Singleton · 2011-01-14

rmv_RU wrote:

kine wrote:

1) There must be some COMMIT in the process. Just use the client monitor to find it.
2) The commit is not in standard I assume. It seems like bad concept.

In additional, you can protect code from the unexpected commit by adding SalesHeader.consistent(false) before the import routline and SalesHeader.consistent(true) after

=D>

WOW that is brilliant.

It makes you think two things. First, D'oh why didn't I think of that. And Second, isn't it great that after all these years in Navision I can still learn something new.

Howdy, Stranger!

Quick Links

Categories

How to rollback if the import is failed?

Comments