Progress bar for Excell Import to Mysql Through PHP

January 6th, 2009

I currently have a php script that imports an uploaded Excel spreadsheet into a MySQL database. I would like to make the process a little easier for our importer by making a progress bar that displays the processing of the PHP script, and the stages, and decisions made in the script.

For instance, the script first checks to make sure if the data already exists in the table, if so, it updates the record, if not, it creates a new record, and assigns it to a user for processing. Ideally i would like to create a progress bar that uses the total number of records as the 100% mark, and builds the percentage from the current record number. I would also like to list below the progress bar the records that are dropped for not meeting certain criteria, the number of records updated, and the number of records inserted. And of course report any errors along the way that don't kill the process entirely.

Is this possible with Ext, or anything else for that matter? I couldn't think of a way because I can't figure out how to make a running php script communicate with ext.

Thanks in advance for any help.

I is possible,but a lot of work. Since you're new to this stuff, why not start off small?

it does indeed get quite complicated, and requires a rather advanced technique called comet or reverse ajax. and even this is a hack at best currently, with no direct server or client support.
that said I do use it to give status updates from a php reporting engine I use that takes up to 15 minutes to run.
It would certainly be best to start off with a simple dialog that just has a spinner or something on it and worry about the status updates later.

#If you have any other info about this subject , Please add it free.#

Posted in weletomylife.com | edit

Search

Archives

Progress bar for Excell Import to Mysql Through PHP