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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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