Skip header record on CSV when using XMLport

ricky76

Does anyone know if this can be achieved?

Wisa123

Just create a Bool - Variable

Firstline - Boolean

-OnPreXMLPort-
firstline := true;

-OnBeforeInsertRecord- (or wherever you start processing)
IF firstline then begin
firstline := false;
currxmlport.skip;
end;

ricky76

I don't believe this type of approach works on xmlports does it? I have tried this just to verify and it doesn't.

Wisa123

I've spent the last 2 Months nearly eclusively designing XMLPorts and i approached that problem a LOT.

Its quite simple: Find out if you are in the first line. In this case just currxmlport.skip.

If you dont like my solution maybe this can help you out: http://mibuso.com/forum/viewtopic.php?t=54346

yukon

Hi ricky76,

Wisa123 wrote:

Just create a Bool - Variable

Firstline - Boolean

-OnPreXMLPort-
firstline := true;

-OnBeforeInsertRecord- (or wherever you start processing)
IF firstline then begin
firstline := false;
currxmlport.skip;
end;

I agree with Wisa123. That's correct solution. But we can't see your xml port design.




Best Regards,
Yukon

ricky76

If a have a decimal field in the csv file though and that column has a header of 'Amount' then i don't get the chance to access any triggers on the XMLPort except the onPreXMLPort before it throws an error at me.

yukon

Hi ricky76,

That's is different error. If you don't mind, could you show your xml port at here. I hope someone also can help to you.

Regards,
Yukon

bob_up

Just wondering if anyone knows the solution to the difficulty that Ricky mentioned in his most recent post?

bob_up

I cant use the method recommended in this thread because it only works if all the elements are of the "Source Type" text. I was using this method but discovered that I couldnt perform the necessary field validation/assignment in code because of a problem with Xrec. I have to use the inbuilt validation of the XMLPort. To do that I need to import straight into the record variables, some of which are decimal.