Download and extract the following to c:\catalog
http://www.peachsoftware.net.au/downloads/Deploy_CreateCatalog.zip" rel="nofollow - http://www.peachsoftware.net.au/downloads/Deploy_CreateCatalog.zip
Instructions are in the program on tab 2 when you run it.
SPREADSHEET FORMAT:
The spreadhsheets shoud be first copied into the specified folder. Name them with upper & lower case characters and only contain letters A to z _ and & characters Words should be separated with an undesrcore _
Column 1 = Make Column 2 = Model
Row 1 = headings - upper and lower case to look best Row 2 = single character defining the type of column it is: M for any column that further describes the make or model or series (dont include if exactly the same as column 1 or 2) E for any column that describes the engine eg Capacity, Cyl, KW etc Y for any column that specifies the year (some catalogues have it in one column and others have a from and to year) D for any column that is a general description N for any column with a lengthy note (otherwise use D) I for any column that defines a distinct Item Type and you want to use in the Item dropdown to refine the search P for each column that contains actual part numbers
New or amended spreadhsheets can be copied into the folder, formatted as above. Then run steps 1 and 2 to Display and Create Catalog - either select individual catalogs or update all again. Once it has run error free run step 3 to copy the database to the live system on your server.
|