Alpha Video Training
Results 1 to 5 of 5

Thread: Import .txt files from different location and name

  1. #1
    Member
    Real Name
    Danny W.
    Join Date
    Oct 2007
    Posts
    5

    Default Import .txt files from different location and name

    I thank you in advance for your help as I am new to A5.

    I need to import a text file each day into my database, but each file will have a different name and the customer may not have downloaded the file in the same locations as my test data.

    What I need to have happen is when they click "IMPORT" it brings up a folder system browser and the customer can navagate to the file and open it.

    I used the import feature but you have to assign it a filename so I don't think that is the answer.

    Thank you

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Import .txt files from different location and name

    You can turn an import operation into an xbasic script. (Right click on its name in the control panel, choose Show Xbasic) You can edit that script to ask the user for the filename and supply that to the coded import. (UI_get_file())

  3. #3
    Member
    Real Name
    Danny W.
    Join Date
    Oct 2007
    Posts
    5

    Default Re: Import .txt files from different location and name

    Wow, quick response, will give it a try.

    I see you are from Bowling Green, where my Corvette was built.


    Thanks so much.

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Import .txt files from different location and name

    Example attached.

  5. #5
    Member
    Real Name
    Danny W.
    Join Date
    Oct 2007
    Posts
    5

    Default Re: Import .txt files from different location and name

    Stan,

    Had an error in line 25, but figured it out and works GREAT.

    Thank you so much.

    Hope to chat again.

Similar Threads

  1. A5V6 Crashes on import of txt
    By vwater in forum Alpha Five Version 6
    Replies: 10
    Last Post: 02-11-2005, 05:22 AM
  2. Unable import .txt file
    By deano in forum Alpha Five Version 5
    Replies: 13
    Last Post: 06-18-2003, 08:56 PM
  3. Importing txt files
    By Richard Kern in forum Alpha Five Version 5
    Replies: 1
    Last Post: 04-15-2003, 11:10 AM
  4. Import txt with Thousands Separator
    By Glen Beer in forum Alpha Five Version 4
    Replies: 8
    Last Post: 03-05-2001, 11:07 AM
  5. Need to print .txt files when button is pressed
    By David Smothers in forum Alpha Five Version 4
    Replies: 4
    Last Post: 04-30-2000, 09:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •