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.
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
PIX1COL.DOC and PIX3COL.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