Dataport Import

(0) Share

Report

Posted on by MowaH

I created a dataport in Navision to import Engineering BOM lines from a text file. I wasn't able to successfully import the lines into Navision, and i wasn't getting any error messages at all. i pretty new to designing dataport. I would gladly appreciate your help.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (2)

ManishS 86 on at

Like (0)

Report

Can you post a snapshot of the dataport what you have designed.

Was this reply helpful? Yes No
MowaH 65 on at

Like (0)

Report

Here is a copy of the dataport

Was this reply helpful? Yes No
Verified answer

ManishS 86 on at

Like (0)

Report

Try putting Engineering BOM lines.INSERT at the end.

Was this reply helpful? Yes No
MowaH 65 on at

Like (0)

Report

I did, but it still wouldn't import the data, and i get no errors at all :(

Was this reply helpful? Yes No
MowaH 65 on at

Like (0)

Report

I was able review the codes and was able to import the data, but my issue now it to match Quantity to Quantity Per.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

In your dataport fields you only have No. and Quantity, how are you getting the BOM Number, if you include all the fields in the file & in the dataport fields then you don't need to add any code, the dataport will import it. Include your BOM Number, Line Number and for Description you can add the code to retrieve it. Check the standard dataport like 5901.

Was this reply helpful? Yes No
MowaH 65 on at

Like (0)

Report

I took your advice, and added those columns but i am really not sure how to write the code to pull in the item description into the Engineering BOM line. I would appreciate your help.

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report

In OnAfterImportRecord Trigger just add this code

IF Item.GET("No.") THEN

"Description" := Item.Description;

IF NOT INSERT THEN

MODIFY;

Was this reply helpful? Yes No
MowaH 65 on at

Like (0)

Report

I was able to complete the dataport import process, this is my final code.

Thanks.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

You don't need to use Item.INIT statement and the IF condition to check for type::Item since you already have Item.GET statement. After Line No. Insert you just need this code

IF Item.GET("No.") THEN

"Description" := Item.Description;

IF NOT INSERT THEN

MODIFY;

Was this reply helpful? Yes No