Need some logic idea for importing data to database (multitasking) - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Need some logic idea for importing data to database (multitasking) (/showthread.php?tid=52269) |
Need some logic idea for importing data to database (multitasking) - El Forum - 06-04-2012 [eluser]Shiro[/eluser] Dear all, I would like to get some logic idea how your guys will write this kind of logic. I would like to import an Excel file to my database. Here is my logic step 1. Upload Excel / CSV file to webserver 2. Read the file, match the header file with database column. 3. Importing the data Here is the part I need your guys suggestion. While importing the data, I need a progress bar to display the complete percentage. User can have the option wait until 100%, or they can leave the page, go to other page. The process still working at the backend. If you user prefer to leave it, I can have an option for the user to enter their email, once it is done, the system will send an notification to the user. How I can archive this. I need to complete this in CI 2.1.0 Anyone have idea or sample project for me to reference. Thanks! Need some logic idea for importing data to database (multitasking) - El Forum - 06-04-2012 [eluser]Cristian Gilè[/eluser] Check this script: http://www.uploadify.com/ Need some logic idea for importing data to database (multitasking) - El Forum - 06-04-2012 [eluser]Shiro[/eluser] Hi Cristian Gile, Thanks for your information. This one is upload file process. I need the source (which is already upload to server) import to database. I need the process bar is showing the raw data import to database. I hope I make my question clear. Please do not hesitate to ask more detail. Thanks! Need some logic idea for importing data to database (multitasking) - El Forum - 06-05-2012 [eluser]Shiro[/eluser] Hi, I need something similar like this http://www.youtube.com/watch?v=8iklkBxO6y0#t=4m36s How to code the progress bar? Any idea? Need some logic idea for importing data to database (multitasking) - El Forum - 06-05-2012 [eluser]Cristian Gilè[/eluser] You can use this jQuery plugin for the progress bar: http://t.wits.sg/jquery-progress-bar/ Check this link to get inspiration on how to implement the logic: http://stackoverflow.com/questions/4899745/progress-bar-updates-from-a-php-script Need some logic idea for importing data to database (multitasking) - El Forum - 06-05-2012 [eluser]Mistmoore[/eluser] You can create your own progress bar with cambas & html5, just set the % of progress and draw it in the progress bar (just in case you want to make it for your own). Regards. Need some logic idea for importing data to database (multitasking) - El Forum - 06-05-2012 [eluser]Near[/eluser] you can use this in uploading csv file http://www.youtube.com/watch?v=uTCa1KpZDLU |