Insert record from text file

Business Central/NAV Developers Forum
1

Urgent: I am a beginner in Navision, I make a small application to insert, starting from a text file on my desktop, a new record in the database using navision application server( run my code in a NAS). I wish find anyone who can help me …

thanks

2

what you have tried so far and what help you needed?

PS: please change the subject name to an appropriate one

3

I think ur exporting data from text file to navision database (sql).

Am i correct what is ur doubt ?

tell me…

4

sorry ur Importing a data from text file to Nav database (Sql)

5

hi…u import the data from xls…

6

thank you for your help, but I’ll explain my problem more precisely: (all via the NAS)
1 - How to access a text file?
2 - read the contents of this file is a record?
3 - save this record in a specific table base NAVISION
****** Note: This line is syntactically well formed to be compatiblewith the table fields.

thanx…

7

thank you for your help, but I’ll explain my problem more precisely: (all via the NAS)
1 - How to access a text file?
2 - read the contents of this file is a record?
3 - save this record in a specific table base NAVISION
****** Note: This line is syntactically well formed to be compatiblewith the table fields.

thanx…

8

You have to either create a batch job(report) or codeunit in ehich you have to read the file and Open the file and import to nav table

or call a dataport from above created report or codeunit to import the txt values to nav table.(not tested this)

9

tanks, I have a question, its not working with data port for data transfer?