Import data using dataport

snes
Member Posts: 3
Hi I am new at NAV and i have trouble to import data using dataport to NAV
I have data in csv file formated like this.
Name Address City Phone
Mike Adress1 City1 00000
Luke Adress2 City2 111111
Paul Adress3 citiy 44444
1. I am using code like this
Contact.INIT;
Contact."No.":=NoSeriesManagement.GetNextNo ('Contact', TODAY, TRUE);
Contact.VALIDATE(Contact.Name,Name);
Contact.VALIDATE(Contact.City,City);
Contact.VALIDATE(Contact.Address,Address );
Contact.VALIDATE(Contact.Address,Phone);
Contact.INSERT;
I insert NO. like ID that is generate and that is saved in table Contact but others filed Name,Address,City,Phone(these are global variables) are not insered in table from csv file.
File format is set as variable
And filed seperator is set as ;
I have data in csv file formated like this.
Name Address City Phone
Mike Adress1 City1 00000
Luke Adress2 City2 111111
Paul Adress3 citiy 44444
1. I am using code like this
Contact.INIT;
Contact."No.":=NoSeriesManagement.GetNextNo ('Contact', TODAY, TRUE);
Contact.VALIDATE(Contact.Name,Name);
Contact.VALIDATE(Contact.City,City);
Contact.VALIDATE(Contact.Address,Address );
Contact.VALIDATE(Contact.Address,Phone);
Contact.INSERT;
I insert NO. like ID that is generate and that is saved in table Contact but others filed Name,Address,City,Phone(these are global variables) are not insered in table from csv file.
File format is set as variable
And filed seperator is set as ;
0
Best Answer
-
I have solve it;
My mistake was that did not use same name in datafield and global variables.
I defined Name in global variable as Nm and in datafiled i use Name and it did not use data from csv file to my global variables
5
Answers
-
Mike Adress1 City1 00000
I can't see your field Seperator in this line ...
What is your dataItem ?Austrian NAV/BC Dev0 -
I have solve it;
My mistake was that did not use same name in datafield and global variables.
I defined Name in global variable as Nm and in datafiled i use Name and it did not use data from csv file to my global variables
5
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions