#11 Data Uploading - Yii2 Tutorial

Lecture #11/12 -As an alternative to the development of dedicated xls like forms for input of 'bulk' data in our database (eg companies revenue) we have developed an uploading tool that allow users to copy+paste data from a spreadsheet directly into the application. These data can be subsequently used to insert/update/delete records in the tables of the database.
The up-loader is implemented in (Model)class XLSpad and can be modified so as to provide a quick way to upload tabular data to any table of the database (the example given is for table rule).
We have also provided code for creating a simple file depository in a sub-folder of the app.
Finally we have hinted on the challenges involved when one wishes to upload large volumes of data

The compressed file (orionbbw11) in the link below contains all Models+Views+Controllers necessary for the lecture

https://drive.google.com/file/d/13PwbGvtgbyoIDVBZe4v5FzspaWmg3KWu/view?usp=sharing

______________________________________________________________________________________________
!!!!NB!!!!: The code you have downloaded, uploads files to subfolder
^uploads
NOT to
^my_uploads
as mentioned in the lecture
______________________________________________________________________________________________

The compressed file orionbbw11.zip, also contains xlspad.sql. It must be imported id database ic

You can use the material in the video freely as long as you reference your sources.

We would greatly appreciate your support at:

buymeacoff.ee/gpap

Many thanks