Avatar

Importing a customer address database

0

I have a customer database accross canada and I'd like to know if it's possible to import it to Identify areas and create routes etc. It's broken out by street address, city, province. PC, phone number etc 

Is this possible? or do I have to make several hundred different entries? 

Any help would be awesome!!!

Mauricio Muniz

Please sign in to leave a comment.

5 comments

Avatar

Hi, 

Yes it is definitely possible. We do have tools to import from CSV files into many areas of MyGeotab, including Routes and Zones. In addition, we also provide a full-featured software development kit that enables you to write custom importers or integrate with other software if needed.

0
Geotab Developers 0 votes
Avatar

my client is not able to work with the SDK at this time. they would like to know if we have a way to import a file, similar to how we can import Zones into Geotab, that has routes already created. they use a program called Fleet Route and are able to download the route into any file format. i ask this because it was stated above that you are able to upload routes and zones.

0
Mauricio Muniz 0 votes
Avatar

Unfortunately at the moment we have no other way to import routes other then the SDK.

0
Geotab Developers 0 votes
Avatar

Try this: 
Save your data in Excel in the correct column format as illustrated in the "Import Routes sdk example". 

[routeName]|[ZoneName]|[Comment] 

Review this web site so you can change your delimiter for this example. 

http://www.howtogeek.com/howto/2145...of-commas/ 

You want to save your excel file as CSV but it will replace the comma with a "|" pipe character by following the above instructions in the link. 

Then open the file in notepad. Copy and paste into the box on the "Import Routes sdk example". 

Hit import and it will load the Routes into your database. 

You can do the same for Route Plan items, however they are usually meant to be done daily or on a regular schedule and can change. The SDK using code is best for the Route Plan items. 

Michael 

0
Mauricio Muniz 0 votes
Avatar

There is no currently supported method to do this. Please keep in mind that if the user exists in only one database, specifying it when logging in should not be necessary.

0
Geotab Developers 0 votes