Announcement

Collapse
No announcement yet.

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

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

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

    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

    Comment


    • #3
      Hello Giovannino and jm

      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

      Comment


      • #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

        Comment


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

          Comment


          • #6
            Originally posted by jamieO View Post
            Hello Giovannino and jm

            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
            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 ?

            Comment

            Working...
            X