Notifications
Announcements
I'm using XMLport to import data . The format is like first line is the header, second line is blank, third line contains data next line is blank. How to handle such situation ?
*This post is locked for comments
Did't you tried something like this, For any single field you can try
If Rec.Field = '' THEN
CurrXMLport.SKIP;
I have tried that.
What is the RecordSeparator and the field separator in this file? It's not clear from the image.
one of the field is a primary key while importing error is thrown Field ='' already exist.
on Field -Import::OnBeforePassVariable I've coded i
If Field='' then currXMLport.skip;
still doesn't work
Ok thanks. If so, I think that in Import::OnBeforeInsertRecord() you can test if fields are blank and then use currXMLport.SKIP.
May be you are writing in incorrect trigger. That's the only standard way to Skip in Report Dataport and Xmlport.
You were right Steffano, I had to put the test condition on port::OnBeforeInsertRecord() and it worked.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
HoangNam 7
