In my case, we have so much that exists on Solaris and so little
that exists on Windows in terms of infrastructure code. It's not
all Perl, so it's not a simple matter of duplicating the environment.
And even with the Perl pieces, Windows is brain-dead enough that I
have to drop at least a few pieces to make the transition. That's
why processing on Solaris is preferred. And, although Samba allows
Windows users to easily see UNIX directories as shared drives for
free, there is no software for free that goes the other way and
presents Windows shares as UNIX mount points. So we end up with a
view where all clients look "into" the Solaris world as the server
space, the place to dump raw data, etc.
I've done the Windows-as-an-intermediate thing and was left with
gaping holes in the process every time.
> -----Original Message-----
> From: Neil Lunn [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 02, 2001 9:21 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Extract data from MS Excel Spreadsheets. Can it be done?
>
>
> > -----Original Message-----
> > From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, May 02, 2001 10:56 PM
> > To: 'Simon Oliver '
> > Cc: '''[EMAIL PROTECTED]' ' '
> > Subject: RE: Extract data from MS Excel Spreadsheets. Can
> it be done?
> >
> >
> > Also I would think that this is a big enough issue to
> > address, since most of
> > the servers are not NT and most of the clients are win32,
> therefore if
> > clients are working on excel which is later uploaded to the
> > server (Unix),
> > it should be processed on the server side, rather than having
> > users save as
> > CSV.
>
> I think we have side tracked here somewhat and are getting
> away from seeing
> the problem. What needs to be addressed?
>
> For an Excel Document to exist, there must be a Windows
> Machine somewhere.
> Information can be extracted from this using ODBC, OLE, ADO,
> and all manner
> of text ripping that Perl is well suited to. As a "database
> client", this
> Windows machine has all of the Native Windows ways of doing
> things and, of
> all wonderous suprises, a Perl that runs on it too.
>
> It seems that the focus of this thread has hitherto been
> about getting an MS
> Excel spreadsheet onto Solaris and then processing the
> contents. The point
> that should be open for consideration is, do you really want the whole
> spreadsheet anyway, or is this just a simple tool for a user
> to fill in
> table
> information?
>
> Unless you have some arcane layout of information in the
> Spreadsheet, your
> probably just want to extract a table with DBD::ADO or
> DBD::ODBC. In fact if
> the layout is anything but a table, DBI is just not your tool.
>
> The simple thing to do is process the Excel Data on the Win32
> box and send
> that data to your database of choice. This can be done from
> either end, very
> easily with just a little thought put into the process.
>
> -- Neil
>
>
> > Ilya Sterin
> >
> > -----Original Message-----
> > From: Simon Oliver
> > Cc: ''[EMAIL PROTECTED]' '
> > Sent: 05/02/2001 2:27 AM
> > Subject: Re: Extract data from MS Excel Spreadsheets. Can
> it be done?
> >
> > Steve Sapovits wrote:
> >
> > > If I'm wrong about this and someone's used either DBD::ADO or
> > > DBD::ODBC on Sun/Solaris, I'd like to hear how you did it.
> > One can't use DBD::ADO because that uses Win32::OLE which
> > needs a Win32
> > Operating System.
> >
> > --
> > Simon Oliver
> >
>
> ______________________________________________________________
> ____________
> Please Note :
> Only the intended recipient is authorised to access or use
> this e-mail. If
> you are not the intended recipient,
> please delete this e-mail and notify the sender immediately.
> The contents
> of this e-mail are the writer's
> opinion and are not necessarily endorsed by the Gunz Companies unless
> expressly stated.
>
> We use virus scanning software but exclude all liability for
> viruses or
> similar in any attachment.
>
>
