Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
TomTom Work GPS Tracking - Import Data into Nav
sirpete
Member Posts: 15
We are looking into using TomTom Work to track our vehicle fleet as well as dispatch work orders and retrieve field reports. TomTom allows for users to query data from their servers via an HTTPS request, and then responds with the data in a CSV file.
I am not sure how to tackle requesting the data and then brining into Nav. I'm currently using a report scheduler that was developed for us to schedule activites to occur automatically, so ideally I would build a report that would open the webpage by building the https:// url, receive the CSV file, then import it into a Nav table that stores the tracking and event data.
I have no idea how to do the save the file and then import the file from the CSV. Can anyone post some sample code for this?
I am not sure how to tackle requesting the data and then brining into Nav. I'm currently using a report scheduler that was developed for us to schedule activites to occur automatically, so ideally I would build a report that would open the webpage by building the https:// url, receive the CSV file, then import it into a Nav table that stores the tracking and event data.
I have no idea how to do the save the file and then import the file from the CSV. Can anyone post some sample code for this?
0
Comments
[Commercial text removed by Administrator]
Downloading content in NAV (>=4.0) can be done this way. Https should not be a problem.
1. Download the *.csv file and save in a %temp% directory.
2. Process the content.
3. Delete the *.csv file.
*Tip: if possible use XML (xmlports), way more reliable than csv.
Rvduuren