Import street and zip code csv file ?

Help with the POS Pizza databases, Items + Toppings, Employees, Customers, etc
New Member
Posts: 2
Joined: Fri Nov 09, 2007 7:03 am

Import street and zip code csv file ?

Postby Mohamed » Fri Nov 09, 2007 7:07 am

Hi all,

1°) is it possible to import a csv file taht contain street and nother one that contain zip code ?

2°) when i type a street that ins't in the database street on the new customer form , is that street recorded in street database (File > Support data > Street database)? or i need to add it to street database manualy for a next use?

Thx.

Site Admin
User avatar
Posts: 2149
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Postby Scott » Wed Nov 14, 2007 8:47 am

The "Auto Merge" utility (separate download at our main site) will create DB streets from the existing customer base.

Streets are not added automatically from the new customer form to prevent spelling errors or uppoer/lower case problems. You can use the above utility to add any streets found in the customer base however that are not already in the current streets database.

To import streets you need to use the "Utility Pack2a" sub-menu street import utility which is added whenever you install an Update Pack. It can import Either a CSV containing Streets only, or a CSV containing Streets and Zipcodes.

Zipcodes will have to be added manually. We have a file that contains almost all of the US Zipcodes but it is quite large so we don't ship it with the product by default. Most people are only interested in the zipcodes that are near them.

Scott

New Member
Posts: 2
Joined: Fri Nov 09, 2007 7:03 am

Postby Mohamed » Wed Nov 14, 2007 10:51 am

Thank you for your replies,

Your software is wonderfull keep going !!

im from belgium, do you have a resseler program ?

Thx

Site Admin
User avatar
Posts: 2149
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Postby Scott » Thu Nov 15, 2007 8:56 am

We do have a reseller program. To get information on the current criteria you can email info@summitcn.com


Scott

Return to v5 Database Help

Who is online

Users browsing this forum: No registered users and 1 guest