how to add data during xmlport import?

jr_macarilay · 2011-07-25

Hi,

i want to add additional data during import while using xmlport. the import runs fine w/o any errors but when i check the table, the additional data that i want to add is not included. can someone check if im doing something wrong? thanks

here's a cut from my xmlport code.

Header - Import::OnBeforeInsertRecord()
  sa_header.VALIDATE(location,xLocation);
  sa_header.VALIDATE(brand,xBrand);
  sa_header.VALIDATE("load date",xDate);

mohana_cse06 · 2011-07-25

Did you try by shifting the code in

Header - Import::OnAfterInsertRecord()

It may be validating location before importing and some code may be revalidating the location code while importing..

jr_macarilay · 2011-07-26

Hi mohana,

i tried putting the code under Header - Import::OnAfterInsertRecord() but the additional data is still not inserted

mohana_cse06 · 2011-07-26

Do you want to modify sa_header record?

where is sa_header.MODIFY?

jr_macarilay · 2011-07-26

if i put sa_header.MODIFY, i get an error saying the record does not exist.

mohana_cse06 · 2011-07-26

Where did you get the exact record of sales audit header?

are you technical person?

jr_macarilay · 2011-07-26

its from a txt file that im trying to import using an xmlport. im trying to add additional data that is not included in the txt file.

mohana_cse06 · 2011-07-26

mohana_cse06 wrote:

are you technical person?

You should get the record to add additional information..
as shown in screenshot you are trying to add additional information to a record which is not existing..

you have to find the appropriate record and add additional information..

jr_macarilay · 2011-07-26

im sorry but i dont think we are understanding each other.

i am a technical person but as i've said, i am new to navision. i just want to add additional data during my xmlport import. for example:

the text file contains something like:

[transaction type], [transaction date], [transaction time]

the table i created have these fields:

[type] [date] [time] [location] [brand]

as you see, there is no location and brand data on the txt file, and thats what im trying to add. if that makes sense.

mohana_cse06 · 2011-07-26

i understood your requirement correctly..

from where did you get location and brand data?

To get the record you should code something like this.

sa_header.RESET;
sa_header.SETRANGE(transaction type,transaction type);
sa_header.SETRANGE(ransaction date,ransaction date);
sa_header.SETRANGE(transaction time,transaction time);
IF sa_header.FINDFIRST THEN BEGIN
  sa_header.VALIDATE(location,xLocation);
  sa_header.VALIDATE(brand,xBrand);
  sa_header.VALIDATE("load date",xDate);
END:

Contact your senior for help..

jr_macarilay · 2011-07-27

the location and brand are from user input which are stored in the variables xLocation and xBrand.

mohana_cse06 · 2011-07-27

above code worked or not?

jr_macarilay · 2011-07-27

i have a question, why do i need to put SETRANGE?

from what i understand, xmlports read text files per line right?

mohana_cse06 · 2011-07-27

offf....

let me explain..

you have 5 lines in table and you are inserting line 6 in to table from xmlport..
you imported line 6..and you want to modify line 6..
As per your first code..it dont know which line it has to modify..
You have to get line 6 by coding with setrange..

jr_macarilay · 2011-07-27

im trying to import to an empty table @_@

mohana_cse06 · 2011-07-27

still you need to find the first line, right?

Please contact your senior..

jr_macarilay · 2011-07-27

that's what i wouldve done the first time, except i dont have a senior right now that's why im asking here and hoping someone can help me.

i dont even understand why im having a hard time accomplishing this in navision. this wouldve been easy in vb and sql @_@ oh well

Howdy, Stranger!

Quick Links

Categories

how to add data during xmlport import?

Comments