26.05.2010, 17:41
I work for a home delivery company, and my problem stems from lack of integration between routing software (Microsoft Streets and Trips) and our database. I am in need of a csv file to upload into our database that contains the route points in order.
When I found the Route Converter, I thought my problem was solved. However, when I convert the exported GPX file from Streets and Trips, I don't get a csv format that is very useful.
I understand that my use of Route Converter differs that most if not all of you, but I am still hoping that I can find a way to make this work. So here is what I need:
A CSV file that has the points in order and separate columns for each of the description of points. Specifically, the description of points lists the name, address, city, state, zip separated by commas in one column. I need the name in it's own column.
I checked all possible CSV formats and did not see one that did this, but I am hoping that there is a format or setting that would solve this.
Any help from this forum would be greatly appreciated. Please let me know if I can clarify what I am hoping to accomplish.
When I found the Route Converter, I thought my problem was solved. However, when I convert the exported GPX file from Streets and Trips, I don't get a csv format that is very useful.
I understand that my use of Route Converter differs that most if not all of you, but I am still hoping that I can find a way to make this work. So here is what I need:
A CSV file that has the points in order and separate columns for each of the description of points. Specifically, the description of points lists the name, address, city, state, zip separated by commas in one column. I need the name in it's own column.
I checked all possible CSV formats and did not see one that did this, but I am hoping that there is a format or setting that would solve this.
Any help from this forum would be greatly appreciated. Please let me know if I can clarify what I am hoping to accomplish.