Jump to content
Sign in to follow this  
Rob Halliday

Want to treat files ending .csv as text

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 by Guest

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.