Subject Re: Exporting to Excel from PHP firebird and Importing from excel to a database
Author pirulo64
Well the reason I want to do this way is because any given user needs
to download a report once the click a time period would just not show in the webpage screen but rather download and keep it for a records
that is the main issue here.


--- In, Lester Caine <lester@...> wrote:
> pirulo64 wrote:
> > I'm a new to firebird I need a way to export my web report php to excel
> > and import to from excel to a database users new this ability to do it
> > but most important is export.
> Well I use .csv between spreadsheets and what is happening in the database. My
> 'report generator' displays the results on the screen, and also offers a .csv
> dump which users can simply open in OO or Excel and then use the data from.
> Import is a little more difficult, but ibwebadmin will copy a .csv file into a
> database table, and I have several packages in bitweaver which process .csv
> from various sources and build a suitable copy of the data in the database.
> There is not a single way of doing it in PHP, but for test purposes,
> FlameRobin allows you to export csv, which is one of the sources I then use so
> import into other applications.
> It does depend on what you are trying to transfer. In many cases it's simply
> easier to provide functions in you PHP application to do some of the work,
> rather than doing it in excel.
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact -
> L.S.Caine Electronic Services -
> EnquirySolve -
> Model Engineers Digital Workshop -
> Firebird -