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);
Comments
It may be validating location before importing and some code may be revalidating the location code while importing..
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
i tried putting the code under Header - Import::OnAfterInsertRecord() but the additional data is still not inserted
where is sa_header.MODIFY?
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
are you technical person?
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
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..
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
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.
from where did you get location and brand data?
To get the record you should code something like this.
Contact your senior for help..
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
from what i understand, xmlports read text files per line right?
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..
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
Please contact your senior..
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
i dont even understand why im having a hard time accomplishing this in navision. this wouldve been easy in vb and sql @_@ oh well