Want to treat files ending .csv as text

[Rob Halliday]

Hi...

For a variety of reasons, I'm trying to import a folder full of text files into a FM10 table, with the entire contents of each file appearing as one field of one record, and the title of the file appearing as another field of the same record.

I am using:

Import Records > Folder

then specifying the folder path.

Unfortunately, this fails because the files within the folder are supplied with the '.csv' file extension (even though they are not .csv files) - FM is clearly seeing the '.csv' extension and deciding to reject the file based on that.

Is there any way of telling FM to 'get over it' - ie. to force it to treat files within a folder as text regardless of the file extension?

(Renaming the files to end .txt works, but is a little tedious to do across a number of files and also requires manual intervention on the user's part).

Any ideas?

Thanks,

Rob.

[comment]

If this is on a Mac, you could use Applescript to rename the files. The user wouldn't have to intervene, since you can perform Applescript during Filemaker's importing script.

[Rob Halliday]

Hi,

Yup, thought of that. In fact, on a Mac you don't even need to rename the file: you can just set the file type to text. FM clearly checks that before checking the file extension and so quite happily imports the files.

Trouble is, this solution will ultimately be used on PCs as well as Macs...

Rob.

Edited May 22, 2009 by Guest

[comment]

Well, maybe you could do something similar with Send Event on Windows - though I don't know if you can avoid forcing the user to select the folder twice there.