[ic] IC in a Hosting Service

[Brian Kosick]

IC can import Excel Docs (at least IC Ver 4.8.x can.  If you have the perl 
modules Spreadsheet-ParseExcel and Spreadsheet-Write Excel installed)
the easiest way to do this is

perl -MCPAN -e'install Spreadsheet::ParseExcel'
perl -MCPAN -e'install Spreadsheet::WriteExcel'

You can take the first line from the default products.txt and use it for a 
template in excel.  I have a few clients using this feature, it works 
fairly well YMMV though.  The best way, is to use access, and export to a 
tab delimiated txt file, and import that.


At 12:17 PM 9/6/01 -0700, you wrote:
>My client has asked me to setup IC in a hosting environment in order to host
>several IC
>catalogs.  They want to have a single in-house administrator take care of
>setting up the initial
>catalog for individual company's products in the IC Admin interface
>(subsequently their
>customers will be able to change pricing, inventory, etc.).
>
>Therefore, they want a utility or template or form in Excel or even a
>HTML-based form which
>the end users can enter their product data something like this:
>
>    Item Name   |   Item Description | Part number | List Price |  Inventory
>Count |  gif pic
>
>And, then the customer could email the form to the administrator for 'rapid'
>implementation.
>
>I have searched the archives for any kind of utilities written to support
>IC.  I have searched for
>"easy customer template/form/utility to add items to catalog" and come up
>empty.  Does anyone
>remember seeing a posting like this before?
>
>Has anyone created this kind of form?
>
>Does anyone know of a list of utilities written to support IC?
>
>Is this just a crazy, hair-brained idea?
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users

Brian Kosick
Web Programmer
New Age Consulting Service, Inc.
216-619-2000
briank@nacs.net