import txt files using xmlport

jr_macarilay
Member Posts: 29
Hi,
Im just new to navision so pardon me for being clueless. Im trying to import a txt file using a custom xmlport and trying to insert it into a custom table. the thing is, the txt file doesnt have a record separator, its just written in one straight line with / as field separators.
here's a part of the txt file:
the quote already have three records, but my xmlport is reading it as one. ideas, suggestions and help will be greatly appreciated.
Thank you
Im just new to navision so pardon me for being clueless. Im trying to import a txt file using a custom xmlport and trying to insert it into a custom table. the thing is, the txt file doesnt have a record separator, its just written in one straight line with / as field separators.
here's a part of the txt file:
89/110703/1050/11935/1/001000003//ZZ///////////////89/110703/1201/11935/1/11846//ZZ///////////////89/110703/1226/11935/1/11846//ZZ///////////////
the quote already have three records, but my xmlport is reading it as one. ideas, suggestions and help will be greatly appreciated.
Thank you
0
Comments
-
read it as a binary text file using a codeunitDavid Machanick
http://mibuso.com/blogs/davidmachanick/0
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