XMLport how to check value if exist in the table befor insert record

(0) Share

Report

Posted on by Community Member

Hi all,

i'am trying to start coding my own XMLport and i need to know how to check the value before the insert in the table for exemple :

the table contain item 1 and item 2 with price P1 and P2 I use an XMLport to upgrade prices but my file containe item 1 and new price NP1 and item 3 and new price NP3 so my database doesn't have item3 i want the XMLport to update only Item1 and ignor the item 3

how can i do it ?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

check the properties of Item dataitem in xmlport and set AutoSave to No.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

this will stop the xmlport from importing the data automatically and i need a code to check if the value exist and import it.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

it will not import if data is not not available in table. no need to write code to check.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i just try this and now it doesn't update the prices

Was this reply helpful? Yes No
Suggested answer

RobertasR 5,004 on at

Like (0)

Report

Hi,

could you try on the 'Import::OnBeforeInsertRecord' trigger putting something like this:

If NOT Item.GET(ItemNo) THEN CurrXMLPort.SKIP;

Robertas

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

also set AutoUpdate to Yes.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (0)

Report

Hey,

Import::OnBeforeInsertRecord'

Writing code on this trigger will too solve your case.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yes AutoUpdate is to yes but doesn't update

also in the dynamic nav walkthrough (msdn.microsoft.com/.../dd338609(v=nav.90).aspx x) they say "If AutoSave is set to No, then an imported record is not automatically written to the appropriate table. To insert or modify records manually, add code to the OnBeforeInsertRecord Trigger and the OnBeforeModifyRecord Trigger." i need just example for insert records from xmlport manyally.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RockWith NAV do you have some samples of code that insert the records on table ?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

i add this code

IF Item.FIND('-') THEN BEGIN

currXMLport.SKIP; END

in the OnBeforeInsertRecord() trigger and set the AutoSave to Yes it worked for me

Was this reply helpful? Yes No