How does QuickBooks handle IIF imports?

Posted by dwwilson66 on Super User See other posts from Super User or by dwwilson66
Published on 2012-05-13T14:43:26Z Indexed on 2012/06/05 4:43 UTC
Read the original article Hit count: 462

Filed under:

import

|

quickbooks

I've received a 'template' for an IIF file for Quickbooks transactions, and there's like seventy-bazillion fields in there, lots of which I never even user. It's a tab delimited file, with the following lines--field headers for transactions and respective splits for those transactions, followed by an end-of-transaction marker.

!TRNS FIELD1 FIELD2 FIELD3 ... FIELD48
!SPL  FIELD1 FIELD2 FIELD3 ... FIELD48
!ENDTRNS
TRNS FIELD1_DATA FIELD2_DATA FIELD3_DATA ... FIELD48_DATA
SPL  FIELD1_DATA FIELD2_DATA FIELD3_DATA ... FIELD48_DATA
ENDTRNS
...

What drives data to a particular field? Is it the field header with corresponding data, or is it the tabular position relative to the head of the line? E.G., Let's say all I have to import is the data in FIELD1, FIELD3 and FIELD5: Would I need

 by header:
 !TRNS FIELD1 FIELD3 FIELD5
 !SPL  FIELD1 FIELD3 FIELD5
 !ENDTRNS
 TRNS FIELD1 FIELD3 FIELD5
 SPL  FIELD1 FIELD3 FIELD5
 ENDTRNS

or

 by tabular position:
 !TRNS FIELD1 FIELD2 FIELD3 FIELD4 FIELD5
 !SPL  FIELD1 FIELD2 FIELD3 FIELD4 FIELD5
 !ENDTRNS
 TRNS FIELD1_DATA FIELD2_BLANK FIELD3_DATA FIELD4_BLANK FIELD5_DATA
 SPL  FIELD1_DATA FIELD2_BLANK FIELD3_DATA FIELD4_BLANK FIELD5_DATA
 ENDTRNS

Alternately, if it were a comma delimited input, would I need:

DATA1,DATA3,DATA5

or

DATA1,,DATA3,,DATA5

Anyone have any experience with what Quickbooks is doing?

© Super User or respective owner

Related posts about import

E: Sub-process /usr/bin/dpkg returned an error code (1) seems to be choking on kde-runtime-data version issue

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
12.04 LTS, on a dell mini 10. Install stable until about a week ago. Updated about 1x a week, sometimes more often. Several days ago, I booted up and the system was no longer working correctly. All these symptoms occurred simultaneously: Cannot run (exit on opening, every time): Update manager, software… >>> More
Python ImportError when executing 'import.py', but not when executing 'python import.py'

as seen on Stack Overflow - Search for 'Stack Overflow'
I am running Cygwin Python version 2.5.2. I have a three-line source file, called import.py: #!/usr/bin/python import xml.etree.ElementTree as ET print "Success!" When I execute "python import.py", it works: C:\Temp>python import.py Success! When I run the python interpreter and type the… >>> More
Python Wildcard Import Vs Named Import

as seen on Stack Overflow - Search for 'Stack Overflow'
Ok, I have some rather odd behavior in one of my Projects and I'm hoping someone can tell me why. My file structure looks like this: MainApp.py res/ __init__.py elements/ __init__.py MainFrame.py Inside of MainFrame.py I've defined a class named RPMWindow which extends wx.Frame. In… >>> More
Import, Can I import all lib's, how to ??

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to import all lib's in python in a code,, how should i do this ?? >>> More
how to import the blog.py(i import the 'blog' folder)

as seen on Stack Overflow - Search for 'Stack Overflow'
my dir location,i am in a.py: my_Project |----blog |-----__init__.py |-----a.py |-----blog.py when i 'from blog import something' in a.py , it show error: from blog import BaseRequestHandler ImportError: cannot import name BaseRequestHandler i think it… >>> More

Related posts about quickbooks

Extending QuickBooks Reporting with the QuickBooks ADO.NET Data Provider

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The ADO.NET Provider for QuickBooks comes with several reports you may request from QuickBooks by default. However, there are many more that are not readily available. The ADO.NET Provider for QuickBooks makes it easy for you to create new reports and customize existing ones. In this article… >>> More
Subversion and Quickbooks Files

as seen on Server Fault - Search for 'Server Fault'
I currently have a large problem on one of the file servers I manage for an Accounting Firm. Quickbooks has a tendency to create multiple files of the same thing over and over to prevent data loss. This is a good thing when you handle just a few files. But at an accounting firm it becomes a problem… >>> More
Open source alternatives for quickbooks?

as seen on Super User - Search for 'Super User'
Not much else to ask about this. I'd like something that runs in linux. Any suggestions? >>> More
Sync Google Contacts with QuickBooks

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The RSSBus ADO.NET Providers offer an easy way to integrate with different data sources. In this article, we include a fully functional application that can be used to synchronize contacts between Google and QuickBooks. Like our QuickBooks ADO.NET Provider, the included application supports both the… >>> More
Connect to QuickBooks from PowerBuilder using RSSBus ADO.NET Data Provider

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The RSSBus ADO.NET providers are easy-to-use, standards based controls that can be used from any platform or development technology that supports Microsoft .NET, including Sybase PowerBuilder. In this article we show how to use the RSSBus ADO.NET Provider for QuickBooks in PowerBuilder… >>> More