How obtain the FULL PATH and file name of a file to UPLOAD

Applications Forms
#1

Dear all,

I need to identify the full path of a csv file I have to upload to mySQL database.
User can choose using a ‘Document file field’ a file in his own PC disk .
I have to store in addition to the name that’s quite easy to identify also the full path of it.

I have to use the full path later in order to insert a CSV file of data into the DB.

Something like that:

load data local infile ‘[glo_path_and_file]’
INTO TABLE XYZ

I’m stucked and please help me soon !!
Bye
Giovannino

#2

hi Giovannino,
Did you solved this already.

I do have same problem.

Regards

#3

Hello Giovannino and jm :slight_smile:

I believe the default upload path is http://domain/_lib/file/ - there you have two extra folders one called “doc” and another called “img”, as Im sure you can see documents default to “doc” folder and images default to “img” folder.
However within scriptcase if you edit the field you can also add a default sub folder for upload, with the option to create the folder if it doesnt exist.

hope that helps!

Jamie

#4

Thank you Jamie,

The full-path I’d like to know is the REMOTE full path.

I mean: the original place of the file that I want to load into the remote server.

Anyone knows how to obtain this?

Regards,

JM

#5

You can not get the full remote path. It is not transferred, only the filename and the file data/

#6

[QUOTE=jamieO;15243]Hello Giovannino and jm :slight_smile:

I believe the default upload path is http://domain/_lib/file/ - there you have two extra folders one called “doc” and another called “img”, as Im sure you can see documents default to “doc” folder and images default to “img” folder.
However within scriptcase if you edit the field you can also add a default sub folder for upload, with the option to create the folder if it doesnt exist.

hope that helps!

Jamie[/QUOTE]

I don’t mean to hijack the post, but where is it defined the default upload path ? I have an application that works with the file upload on my testing environment but it does not upload the file to the production environment. I have checked and made sure I have the /_lib/file and have set the permissions for that folder, is there something I am missing ?