Previous pageReturn to chapter overviewNext page



Inventory & Picture Exporting

-- A new export option allows you to export lists of

   inventory along with the pictures and the picture names.

   This can be extremely useful as it can allow you to create

   catalog sheets and greatly simplify the addition of your

   inventory to your web site. The export can be done from

   two parts of the program: The inventory report screen

   where you can export large sections of your inventory in

   bulk or from the tag printing screen where you can select

   a list of individual sku numbers.


   **[[To export in bulk  choose the Inventory Report screen

     (6,5), select your

     criteria (major code, etc) and change the output option

     from "Display" to "Image List"

   To export by individual Sku numbers choose Print

   Inventory Tags then change the output option from

   "Thermal" to "Image List."


   In both cases the export list is called PICTLIST.XLS and is

   located in the JSREPORT folder on the Windows desktop.

   This file contains the inventory details and contains links

   to the pictures. Another copy is in the INV folder inside

   the JSREPORT folder.


   If, when creating the Image List,

   you choose to create a copy of the selected pictures those

   pictures will be put in the IMAGES folder which is in the

   INV folder inside the JSREPORT folder.


   Having this

   separate and isolated copy of the pictures may be useful if

   your webmaster intends to upload the export to a website.


   Version 9.7 includes some sample MS Word picture-merge

   templates to create index cards and catalog sheets based

   on the PICTLIST.XLS export file. These MS-Word templates are

   in the complink.js folder called PIX5385.DOC PIX5160.DOC



In MS-Word retrieve the template document and run the mail

merge (tools, mail merge, merge)


When you get a new document you have to refresh

it by pressing Ctrl-A (to select all) and then

press the F9 key.


For exporting to HTML the 1 column layout is better formatted.

(In Word choose save as web/html to save in HTML format)


Don't save over the provided Word templates.


The Pix3Col document gives a 3-column catalog sheet.

The Pix5160 gives a 3 column by 10 row sheet that is formatted

for mailing labels (but you can print to plain paper)


The Pix5385 document gives index card formatted output for

Avery 5385 index cards