Importing OFX file into a global field?
Any thoughts on how to get the data from an OFX or QIF file into a global text field, so I can add new records to my checking database? Right now I'm opening the file in TextEdit and then copy/pasting the data into FileMaker. It works, but I'd like to automate the process with a script if possible. I'm pretty sure it will involve Applescript, where I'm very inexperienced.
Thanks a lot!
AFAIK, OFX is a flavor of XML, so you should be able to import an OFX file directly, using a suitable XSLT sylesheet.
Alternatively, if you don't want to learn XSLT, look for a utility to convert OFX into .csv or another format that Filemaker can import (I believe Apple Numbers could do this, too).