Announcement

Collapse
No announcement yet.

Importing .XLS files to database

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Importing .XLS files to database

    Hello All,
    I want to import XLS sheets to mysql database using control application. I used the document datatype to browse xls file from local computer and import it in mysql database. But i am stucked, where scriptcase store the document temporarily, before uploading it to database. I used PHP-ExcelReader for importing functionality. But i went wrong somewhere since i am not able to implement it properly. I used $data->$this->Ini->path_doc; to point to xls file. Is this the right way or i am missing something?

    Regards
    Bishal Pantha

  • #2
    Re: Importing .XLS files to database

    check in you php.ini the upload_tmp_dir or something like this.

    You can do a print_r in the array $_FILES. On the event onValidateSuccess ... write this code:

    echo "<pre>";
    print_r($_FILES);

    and you'll see the information that you are needing.

    Comment


    • #3
      hello I have a problem you know what happens is I need to upload a csv file to the database file entry in the direction of my pc
      eg
      LOAD DATA INFILE '/ home/jaime/Escritorio/ensayo3.csv'
      / / INTO TABLE test FIELDS TERMINATED BY ','

      and it works but I have created a control application and add a field (document = file name) and I need that when the user adds a file that can be placed within the

      LOAD DATA INFILE '"but here would have to go the file attachment"'
      / / INTO TABLE test FIELDS TERMINATED BY ','

      please help is very important

      Comment

      Working...
      X