Jump to content

Importing entire csv into one field


DG
 Share

This topic is 5703 days old. Please don't post here. Open a new topic instead.

Recommended Posts

There are ways to fake it.

1. Rename the file's extension to ".txt"

Put into a folder by itself

Import Folder, Text files

2. Use AppleScript on a Mac to read the file into a variable and set a field to that.

3. Use command line on either platform to do much the same as above. On Windows you'd probably need a plug-in to get text returned of above; not really sure; such as the free Abstrakt Shell plug-in, which works fine on Mac OS (for now, not Universal Binary, but then neither is FileMaker, yet); and it probably works on Windows, though they don't say for FileMaker 7.

4. Use Troi File plug-in to read the file.

5. Just import into a FileMaker table, then do whatever you need to do, and/or reassemble/move the data to where you want it. There are various tools to help do this. Replace works on all found records, to break down a field into several pieces. You can then use a Loop to put it together, or Copy All Records, or the Custom Function GetRows (at Brian Dunning's web site, but by Bruce Robertson; it's an awesome CF :)-).

Link to comment
Share on other sites

3. Use command line on either platform to do much the same as above. On Windows you'd probably need a plug-in to get text returned of above; not really sure; such as the free Abstrakt Shell plug-in, which works fine on Mac OS (for now, not Universal Binary, but then neither is FileMaker, yet); and it probably works on Windows, though they don't say for FileMaker 7

Ai, Fenton my dear friend. Always with the plugins for Windows :)

VBscript is just a powerful as AppleScript. Anything you can do with AppleScript I can do with VBscript.

The only extra hoops is that FMI didn't give us a way to set a field value directly from the outside. Keeping that in mind the VBscript would have to substitute all CR/LF characters with something else, trigger a FM import script and FM should then substitute the changed characters back to CR/LF.

Link to comment
Share on other sites

This topic is 5703 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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