XMLPorts - CSV / Fixed Width Files

Jonathan2708
Member Posts: 552
Hi,
I've found that Dataports are not supported under the Nav Application Server and so am investigating XMLPorts. My question is can XMLPorts be used to import CSV/Fixed Width files? I notice there is a Format property which has Xml/Variable/Fixed options. If it is possible are there tips on how to structure the Elements. Ideally I'd like to load the fields into variables.
Any help appreciated,
Jonathan
I've found that Dataports are not supported under the Nav Application Server and so am investigating XMLPorts. My question is can XMLPorts be used to import CSV/Fixed Width files? I notice there is a Format property which has Xml/Variable/Fixed options. If it is possible are there tips on how to structure the Elements. Ideally I'd like to load the fields into variables.
Any help appreciated,
Jonathan
0
Comments
-
You can run a codeunit through Nav Application Server that launch a dataport . I don't think you can read csv with XML ports._____________________
NAV Freelance Consultant0 -
No I've found Dataports do not run at all under Application Server, whether they are called from Codeunits or Reports.
So far with XMLPorts I've only been able to output text in XML format, even when the 'Format' property is set to 'Variable'.0 -
Sorry my misstake thougt I'd done this before but I hadn't.
I think the best way is to develop a codeunit that parse the csv file. If you want to do this flexible then you can also use a table to define the fileds this way you can import different types of csv files in one codeunit. I've parsed csv files with codeunits and it works fine think that there are some posts here how to do this as well._____________________
NAV Freelance Consultant0
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