Hi elogic,
where exactly is your error or aren't you able to find a concept for
your import?
The way I did this once: Build a Behavior that is able to build an
Object from the imported Csv Data (File Class is your friend). Then
Import the data, call the Csv to Object method and save it to the
database.
Kind regards,
Vulinux
On 6 Jul., 04:09, elogic <asymo...@elogicmedia.com.au> wrote:
> Hi All,
>
> I have setup a file upload feature for my application using the below
> plugin. Now that I have the csv uploading using an upload controller
> and model I now need to insert the csv into a mysql table. I haven't
> had much luck with the samples I have found online. Does anyone know
> how I can do this? I can get my client to name the fields however it
> needs to be done so that isn't an issue.
>
> MY UPLOADS_CONTROLLER
> -------------------------------------------------------------------------
> class UploadsController extends AppController
> {
>
> var $name = 'Uploads';
>
> // CSV UPLOAD
> // ------------------------------------------------------------------
>
> function upload() {
>
> if (!empty($this->data))
> {
> $this->Upload->create();
> if($this->Upload->save($this->data))
> {
> $this->Session->setFlash(__('The file
> has been saved', true));
> //print_r($this->data);
> $thefilename =
> $this->data['Upload']['file']['name'];
> echo $thefilename; // the uploaded
> CSV FILE NAME!
>
> // TO DO PROCESS UPLOADED FILE INTO
> PROPERTIES DATABSE
> }
> else
> {
> $this->Session->setFlash(__('The file
> could not be saved. Please,
> try again.', true));
> }
>
> }
> }
>
> }
>
> --------------------------------------------
>
> MY UPLOADS MODEL
> ---------------------------------------------------------
> <?php
> class Upload extends AppModel {
> var $name = 'Upload';
> var $actsAs = array(
> 'FileUpload.FileUpload' => array(
> 'uploadDir' => 'files',
> 'forceWebroot' => true, //if false, uploads will be saved to
>
> //the uploadDir as a direct path.
>
> //default: true
> /*
> 'fields' => array(
> 'name' => 'file_name',
> 'type' => 'file_type',
> 'size' => 'file_size'
> ),
> */
> 'allowedTypes' => array(
> 'csv' => array('text/csv', 'application/csv')
> ),
> 'maxFileSize' => '1000000', //in bytes
> 'unique' => false, //uploaded files will overwrite existing
> files
> 'fileNameFunction' => false, //execute sha1 on fileName if
> required,
> not though
> )
> );}
>
> ------------------------------------------------------
>
> Thanks
>
> FILE UPLOAD
> PLUGIN:http://www.webtechnick.com/blogs/view/221/CakePHP_File_Upload_Plugin
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
