Re: Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode

This suggestion is tangential to your unicode question, but has other advantages. Why not skip the XML and just use DBD::ODBC or DBD::Excel to read the Excel file directly? If you need to end up with XML in addition to the database and HTML, then you might be able to generate the XML from the database (or directly from the spreadsheet) using DBD::AnyData.

Comment on Re: Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode

Replies are listed 'Best First'.
Re^2: Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode by davis (Vicar) on Oct 06, 2004 at 15:33 UTC
Why not skip the XML and just use DBD::ODBC or DBD::Excel to read the Excel file directly? Because the data extraction process is complicated, and I've already done it. There are many guidelines to be stretched as needed, and there are a couple of different versions of these files, to which I've already built a uniform interface cheers anyway! davis It wasn't easy to juggle a pregnant wife and a troubled child, but somehow I managed to fit in eight hours of TV a day.	[reply]

Replies are listed 'Best First'.

Re^2: Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode
by davis (Vicar) on Oct 06, 2004 at 15:33 UTC

Why not skip the XML and just use DBD::ODBC or DBD::Excel to read the Excel file directly?

complicated

cheers anyway!

davis

It wasn't easy to juggle a pregnant wife and a troubled child, but somehow I managed to fit in eight hours of TV a day.

[reply]