Importing .XLS files to database

Developers General
#1

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.

#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