Importing File Name into Record

[seidel1]

I am building an routine in which, on a daily basis, I want to import several small text files into Alpha 5.

The files will be placed into a predetermined directory, than at "X" time they would be imported into the database and deleted from the directory. I would also like the name of the file being imported copied into one of the fields in the DB.

I have build the import piece no problem, however because I have limited xbasic experience I need help getting the file name into a field in the record and deleting the file after it has been imported.

Can someone help me with this code?

Thanks in advance.

Jim

[Daniel Weiss]

RE: Importing File Name into Record

Jim
When you run your import you must know the file name
For example; import_filename = "myimportfile.txt"

All you have to do is

open the table you want to record to the file name
ex. t = table.open(�import_table�)

fetch to the record you want to write to (if the table has more then one record)
ex. t.fetch_goto(3) or use any other way to fetch to the record you want

write to the field
t.change_begin()
ex. t.filename_store = import_filename
t.change_end(.t.)

close the table
ex. t.close()

delete the import file
ex.
if file.exists(import_filename)
file.remove(filename)
end if


Daniel Weiss

[seidel1]

RE: Importing File Name into Record

Thanks Daniel, I'll give it a try. Will the code you wrote handle multiple files? How does it step to the next file?

What I had planned on doing is importing all the files in the directory. Some days there might be 5 files to import, other days there might be 100 files. So I would need code that reads (1) file at a time than deletes the (1) file and moves onto the next.

Is my thinking correct?

[dik_coleman]

RE: Importing File Name into Record

just listening
D

[Daniel Weiss]

RE: Importing File Name into Record

Jim
Is t kind of hard to explain exactly how to do it with knowing exactly what the rest of your code is
But you can use this a guide

Use the �FILEFIND.GET()� function to create a list of your files
Ex.
list= FILEFIND.GET("c:\myimportdir\*.*") see the help on how to use this function
count1 = line_count(list) count1 = line_count(list)
dim import_filename[count1] as c
import_filename.initialize(list)
for i = 1 to count1
'put the import and all other codes in here
'but insted of just using "import_filename" for the file names
' add the arrey # number to it as "import_filename[i]"
next

Daniel Weiss