[ic] Help shop doesnt't work this morning :(

[interchange-users@interchange.redhat.com]

Quoting Stefan Hornburg (Racke) (racke@linuxia.de):
> mheins@redhat.com writes:
> 
> > Quoting Rene Hertell (rene@hertell.com):
> > > > I find it !
> > > >
> > > > I reinstall IC and recreate a new catalog.
> > > > I move all files one per one.
> > > > And the problem was my variables.txt that i have modified with microsoft
> > > > excel.
> > > > Excell add " to my file and this was the mistake.
> > > 
> > > When you open a file with excel, *you have to make sure* all fields are in
> > > "text" format (also numeric-fields etc). If not, excel makes too many
> > > decisions instead of you, and this may screws up your whole table, as you
> > > probably noticed...
> > > 
> > 
> > Someone might mention "Database variable EXCEL 1", but it must be
> > added *above* "VariableDatabase  variable" in catalog.cfg, i.e.:
> > 
> > 	Database  variable  variable.txt  TAB
> > 	Database  variable  EXCEL         1
> > 	VariableDatabase variable
> > 
> > If there is a variable.dbm in your dbconf/* directory, you will want
> > to remove it to avoid a warning message.
> > 
> > Also, if you have the Spreadsheet::ParseExcel and Spreadsheet::WriteExcel
> > modules installed, you can export/import XLS files directly. (Remember
> > to make the sheet name the table name, as is done on export.)
> 
> Yeah, and AFAIK there are DBI modules out for XLS files :-;
> 

Yes, it even works with Interchange, but it is read-only. Same for
DBD::Xbase.

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

My wife is great.  She doesn't care where I go, just as long as I don't
have any fun.  -- Lee Trevino