[ic] More problems with Spreadsheet Export

Joachim Leidinger interchange-users@interchange.redhat.com
Fri Dec 28 18:31:25 2001


Jason Kohles wrote:
> 
> On Fri, Dec 28, 2001 at 05:06:25PM -0500, cfm@maine.com wrote:
> > On Fri, Dec 28, 2001 at 10:39:05PM +0100, Joachim Leidinger wrote:
> > >
> > > I did do that and I've not found any hint about the length of any excel
> > > fields. But, I'm not well in perl.
> > > Which module with restrict length of excel fields did you talking about
> > > or which module is IC using for reading a excel file?
> >
> > IC is **NOT** using the perl modules to read/write excel; that is why it works.
> Interchange uses both Spreadsheet::ParseExcel and Spreadsheet::WriteExcel
> for doing .xls conversion.  See the backup_database and import_fields
> usertags.

I'm in a muddle....

(108) mvend@BPA > bin/interchange -v
Interchange version 4.8.3 Copyright 1996-2001 Red Hat, Inc.

(109) mvend@BPA > grep -r excel *
doc/icdatabase.8:security pretty quickly. It has excellent capability in
that area, and
lib/Vend/Table/Common.pm:       my $excel = '';
lib/Vend/Table/Common.pm:       my $excel_addl = '';
lib/Vend/Table/Common.pm:               $excel = <<'EndOfExcel';
lib/Vend/Table/Common.pm:               $excel_addl = <<'EndOfExcel';
lib/Vend/Table/Common.pm:                       $excel
lib/Vend/Table/Common.pm:                       $excel
lib/Vend/Table/Common.pm:                               $excel_addl
lib/Vend/Table/Common.pm:                               $excel
lib/Vend/Util.pm:                       xls            
application/vnd.ms-excel
lib/DBI/FAQ.pm:and has excellent support. More information is available
on the Hughes
lib/DBI/FAQ.pm:Oracle's WWW site is an excellent source of more
information.
...


                    (110) mvend@BPA > ls -al usertag/
total 95
-rw-r--r--   1 mvend  mvend    374 Dec  2 22:35 bar_button.tag
-rw-r--r--   1 mvend  mvend   5364 Dec 17 15:04 button.tag
-rw-r--r--   1 mvend  mvend   1458 Dec  2 22:35 convert_date.tag
-rw-r--r--   1 mvend  mvend    773 Dec  2 22:35 db_date.tag
-rw-r--r--   1 mvend  mvend    192 Dec  2 22:35 delete_cart.tag
-rw-r--r--   1 mvend  mvend    431 Dec  7 16:36 delete_record.tag
-rw-r--r--   1 mvend  mvend   1172 Dec  2 22:35 email.tag
-rw-r--r--   1 mvend  mvend    974 Dec  2 22:35 email_raw.tag
-rw-r--r--   1 mvend  mvend    358 Dec  2 22:35 fcounter.tag
-rw-r--r--   1 mvend  mvend  12568 Dec  2 22:35 fedex_query.tag
-rw-r--r--   1 mvend  mvend   6304 Dec  2 22:35 formel.tag
-rw-r--r--   1 mvend  mvend    924 Dec  2 22:35 fortune.tag
-rw-r--r--   1 mvend  mvend    619 Dec  2 22:35 get_url.tag
-rw-r--r--   1 mvend  mvend   8392 Dec  2 22:35 image.tag
-rw-r--r--   1 mvend  mvend    400 Dec  2 22:35 load_cart.tag
-rw-r--r--   1 mvend  mvend    637 Dec  2 22:35 loc.tag
-rw-r--r--   1 mvend  mvend    331 Dec  2 22:35 rand.tag
-rw-r--r--   1 mvend  mvend    543 Dec  2 22:35 reconfig.tag
-rw-r--r--   1 mvend  mvend    302 Dec  2 22:35 reconfig_time.tag
-rw-r--r--   1 mvend  mvend    623 Dec  2 22:35 reconfig_wait.tag
-rw-r--r--   1 mvend  mvend    103 Dec  3 15:36 remote_addr.tag
-rw-r--r--   1 mvend  mvend      0 Dec  3 15:32 remote_addr.tag~
-rw-r--r--   1 mvend  mvend    696 Dec  2 22:35 save_cart.tag
-rw-r--r--   1 mvend  mvend    899 Dec  2 22:35 summary.tag
-rw-r--r--   1 mvend  mvend   7441 Dec  2 22:35 table_organize.tag
-rw-r--r--   1 mvend  mvend    662 Dec  2 22:35 title_bar.tag
-rw-r--r--   1 mvend  mvend    811 Dec  2 22:35 ups_query.tag
-rw-r--r--   1 mvend  mvend     93 Dec  2 22:35 usertrack.tag
-rw-r--r--   1 mvend  mvend    836 Dec  2 22:35 var.tag
-rw-r--r--   1 mvend  mvend   6413 Dec  2 22:35 xml_generator.tag

Where is backup_database and import_fields usertags?

Joachim

-- 
Hans-Joachim Leidinger | Dipl.-Phys.Ing. Entwicklung eCommerce
[Hans-Joachim.leidinger@bpanet.de]
Black Point Arts Internet Solutions GmbH
http://www.bpanet.de