Codeunit with three XMLports - Rollback?

pn7 · 2016-03-16

Hello

This is my first post to mibuso so bear with me.

So I have a Codeunit which launches three XMLports. The problem shows up when the codeunit reaches the last XMLport and if the run time error occurs with some validation -> There are no Rollbacks. How one must build this that it rolls back each used XMLport?

To give you context: I'm importing sales headers and sales lines from different files.

Navision version: 2015

Has any one have solution for that kind of problem?

Yours truly,

pn7

postsaurav · 2016-03-16

I am not sure but this seems to be the appropriate solution as per my understanding -
Assuming you xmlport are XMLA, XMLB and XMLC

1. Create Temp (staging Table) for all these three tables where actually want to import record.
2. insted of XMLA.Import(parameters) Use

  TransferRecord  := FALSE;

  IF(XMLA.Import(parameters)) THEN 
   XMLA.Close;
  ELSE
    TransferRecord := FALSE;

  IF XMLB.Import(parameters)) THEN
    XMLB.Close;
  ELSE
    TransferRecord := FALSE;

  IF XMLC.Import(parameters)) THEN BEGIN 
    XMLC.Close;
    TransferRecord := TRUE;
  END;

IF TransferRecord THEN 
  // Code to Transfer Record to Actual Tables and Delete Record from Staging Tables.
ELSE
  // Code to Delete records from Staging tables.

Where TransferRecord Is a Boolean.

kriki · 2016-03-16

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

Codeunit with three XMLports - Rollback?

Comments

Categories