How to import a new file using XML port in nav classic client.

(0) Share

Report

Posted on by bharathkarunakaran

475

I have created a XML port with sales header as a parent and sales line as a child and i want to import some data to it .But when i do this the empty records in the sales order must be skipped and move on to the next record .

For Ex.

In sales header I have a field called alternate number and i want skip the header which does not contain alternate number and the correspnding lines must also be skipped and the next record must be imported.

Please help...

Thanks in advance..

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Hannes Holst 5,767 on at

Like (0)

Report
IF "Alternate Number" = '' THEN CurrXMLport.SKIP;

Add the above in the OnBeforeInsertRecord-trigger of the parent dataitem (Sales Header).

https://docs.microsoft.com/en-us/dynamics-nav/skip-function--report--xmlport-

https://docs.microsoft.com/en-us/dynamics-nav/developer/triggers/devenv-onbeforeinsertrecord-trigger

Was this reply helpful? Yes No
bharathkarunakaran 475 on at

Like (0)

Report

Thanks hannes holst for your answer I will check with that

Was this reply helpful? Yes No
bharathkarunakaran 475 on at

Like (0)

Report

Thanks for the reply.

I have this much so far now i am able to import but i am unable to skip a particular data .I tried using your code by using it in XML port but it doesn't work

Ex.In the above notepad file when something data(ex.model or line no)is missing then the complete detail about that vehicle must be skipped and it should pass on to the next data present in the notepad file.

please advice...

Thanks in advance

In Xml port on the onafter get record trigger

IF Vehicle.Mode ='' THEN

CurrXMLPort.Skip;

but this not working for me .

Its skip all records and only empty records are transffered to the tables,Can anyone suggest me how skip the error while import and pass to next value in the table.

Any help would be appreciate.

Thanks

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

You need add the code in OnBeforeInsertRecord Trigger.

Was this reply helpful? Yes No
bharathkarunakaran 475 on at

Like (0)

Report

Hi Skulla

I have tried this but it doesn't seems to work . Is there any other way to work around for this issue.

Was this reply helpful? Yes No
bharathkarunakaran 475 on at

Like (0)

Report

Screen_5F00_Shots.zip

Hi

I tried to add a new code unit which will delete the multiple lines while importing the XML data and I called that codeunit in the corressponding codeunit which is used to import the data .But it doesn't seems work for me.

Have anybody done this before ..Can anyone suggest me some ideas

Warm regards,

Bharath

Was this reply helpful? Yes No
bharathkarunakaran 475 on at

Like (0)

Report

I attached the screenshots file above...

Was this reply helpful? Yes No
Hannes Holst 5,767 on at

Like (0)

Report

hi,

See attached. Works a treat.

Not sure which version you are on. You are able to call XMLports directly.
Check the other parts of your code.

[View:/cfs-file/__key/communityserver-discussions-components-files/34/XMLport-Skip-Test.zip]

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

It should work, what line of code did you add OnBeforeInsertRecord trigger?

Was this reply helpful? Yes No