Import street and zip code csv file ?

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

Import street and zip code csv file ?

Post by Mohamed »

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.
User avatar
Scott
Site Admin
Site Admin
Posts: 2566
Joined: Wed Apr 16, 2003 5:35 pm
Location: Western PA

Post by Scott »

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
Mohamed
New Member
New Member
Posts: 2
Joined: Fri Nov 09, 2007 7:03 am

Post by Mohamed »

Thank you for your replies,

Your software is wonderfull keep going !!

im from belgium, do you have a resseler program ?

Thx
User avatar
Scott
Site Admin
Site Admin
Posts: 2566
Joined: Wed Apr 16, 2003 5:35 pm
Location: Western PA

Post by Scott »

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


Scott
Post Reply