• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need some logic idea for importing data to database (multitasking)

#1
[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!

#2
[eluser]Cristian Gilè[/eluser]
Check this script: http://www.uploadify.com/

#3
[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!

#4
[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?

#5
[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/48997...php-script

#6
[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.

#7
[eluser]Near[/eluser]
you can use this in uploading csv file

http://www.youtube.com/watch?v=uTCa1KpZDLU


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.