Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
XML RTC txt file - automation
eagle_eye
Member Posts: 130
I have gotten NAV 2009 to export as text no problem (as a test leading up to my real challenge).
I need to (nightly) pick up a text file and suck it into a journal. Same file name, every night.
I thought I would use NAS - which I have used in previous NAV versions for XML files. OK, I though I could just use a dataport, but no go (cannot use dataports with NAS). So, then I decided to use an XMLPort and suck in a TXT file that way.
I am having all types of issues (i.e. testing is not going well - since it seems you cannot test in classic, and I don't know if it is posisble to debug in the RTC. I decided to just try exposing the XMLPort on a page to see if I could at least get it to manually work. But I am getting an error about the default template name being blank).
My goal is to just import the text fields and then use code inside the XMLPort to take the data and write the records as I need (i.e. set the journal name, template name, line no, fill the data and insert the record).
So ... my questions are ...
I put the code in the on insert trigger of the table node - why is it trying to insert a record here?? I am importing text field?
Does my plan seem viable (i.e. have NAS run an xmlport for a text file)?
Arg. So very frustrated.
Any guidance would be greatly appreciated.
Thanks!!
I need to (nightly) pick up a text file and suck it into a journal. Same file name, every night.
I thought I would use NAS - which I have used in previous NAV versions for XML files. OK, I though I could just use a dataport, but no go (cannot use dataports with NAS). So, then I decided to use an XMLPort and suck in a TXT file that way.
I am having all types of issues (i.e. testing is not going well - since it seems you cannot test in classic, and I don't know if it is posisble to debug in the RTC. I decided to just try exposing the XMLPort on a page to see if I could at least get it to manually work. But I am getting an error about the default template name being blank).
My goal is to just import the text fields and then use code inside the XMLPort to take the data and write the records as I need (i.e. set the journal name, template name, line no, fill the data and insert the record).
So ... my questions are ...
I put the code in the on insert trigger of the table node - why is it trying to insert a record here?? I am importing text field?
Does my plan seem viable (i.e. have NAS run an xmlport for a text file)?
Arg. So very frustrated.
Any guidance would be greatly appreciated.
Thanks!!
0
Comments