get last filename?

[wintergreen]

is there a script step or calculation that can be used to get the filename of an imported file (assuming the import is done using a script)?

[Lee Smith]

See my Reply to your other question in Importing & Exporting.

[wintergreen]

Sorry, I just re-read my question and it's ambiguous. What I actually mean here, is if a user browses and selects a file to import, is there any way to get the "result" of this, e.g. so the original file's filename can be stored automatically in a field somewhere?

[Lee Smith]

I'm not sure I'm understanding your question.

Are you using the Script Step "Import Records"

Lee

[wintergreen]

yes. "Import records.." user then selects a file to import, script takes care of the rest.

but... I want to capture the name of the file ("importedfile.doc") and store that in a field (if possible)

[Lee Smith]

Okay, I see what you mean now.

I don't have an answer on this, maybe someone else does. In the mean time, I'll fool around with it and see what I can come up with.

Lee

[Lee Smith]

After playing around with this for awhile, I came up with a cheezy workaround. BTW, I did a search for your keywords, and it didn't turn anything useful up. However, it was very similar, if not identical to to this thread Here that comment pointed to in another Thread just a few minutes ago (also in the Import and Export Topic).

What I came up with was to use the Insert File Script Step and inserted the file (by reference) into a new container field in each record via a loop script, and then capture the file name from the file path from it.

HTH

Lee

Edited August 17, 2006 by Guest
add some things

[wintergreen]

Very interesting. Thanks, I will experiment with this, but it looks like it will fit my needs perfectly.