xml import skipping a line

Kisu

I'm having a problem with xml import with purchase lines.

I'd need to skip specific lines from xml file that has entryrowtype <> 0.

I know how to skip lines but this is a little problematic.

The 3rd party xml line has this entryrowtype under child tag of the rowtags so it gets the value after first line is init.
ex:
<invoice>
-> <header>
-> <row>
--> <entryrowtype>

Is there any better solution than making a temp table for the line data and fetch the lines that way?

ara3n

you can use xmldom and create a new xml from the original xmlfile and then send that to xmlport.

Kisu

Cheers for this again ara3n, I got it working already but good to have other solutions behind ear too.

Ravi_Thakkar

Hello All,

I have the same requirement.
I just want to skip the first Line of CSV file as it's a title of columns.

How can I do that? Please provide the suggestion.

ara3n

Is this a xmlport or dataport?

jup

I think that CSV -> dataport.. isn't it?

If so, please try to first set the AutoSave property to "No" on the dataport DataItem, then create a global bool called i.e. glFirstLineSkipped and finally insert this code in the OnAfterImportRecord:

IF NOT glFirstLineSkipped THEN
  glFirstLineSkipped := TRUE
ELSE
  IF NOT yourTable.INSERT(TRUE) 
    THEN yourTable.MODIFY(TRUE);

ara3n

you can use xmlport for csv as well.

jup

Really? Never tried..

Ravi_Thakkar

Thanks all for your help.
My problem has been resoved by the procedure as JUP has suggested.

Thanks again.