January 13, 200322 yr I need to export from my FM inventory sytem to Quick Books. Quick Books needs the data in an ".iff" format. FM will not export in this format, and neither will Excel. Any ideas how to get my FM data in to Quick Books? Steven, Outdoor Sportz
January 13, 200322 yr Here is one option http://www.filebookslink.com/ Plugin for connecting to quickbooks
January 13, 200322 yr If you don't want to use a plugin, you'll have to learn how an IIF file is formatted (it's just a text file, but the fields have to be organized in a specific way).
January 14, 200322 yr I've had a look at the format of .iif files. You can export this format from Filemaker by creating some text calculation fields and then exporting these as a tab delimited file. However, it can be somewhat complex getting it set up. To find out the format of an .iif file. Try exporting some data from Quickbooks as .iif, and then open it up in a text editor to see how it is arranged. It's easy enough to see from that how the data is laid out. Then, you just have to create the text calculations in Filemaker to match.
Create an account or sign in to comment