riif icon indicating copy to clipboard operation
riif copied to clipboard

Published 20 hours ago • verified publisher icon linjunpop

Quickbooks Desktop and Semicolons

Open jaredmoody opened this issue 4 years ago • 3 comments

I've noticed that when a field contains a semicolon, Quickbooks Desktop gives an error and does not import the IIF file. Since that seems like a character that just isn't allowed, it seems like it would be a nice feature to automatically strip semicolons from any text fields in this library. What do you think, I'm happy to submit a PR if you like the idea.

jaredmoody avatar Oct 03 '19 23:10 jaredmoody

Thanks for reporting this. Can you attach the official Quickbooks document on this feature/bug?

linjunpop avatar Oct 07 '19 08:10 linjunpop

Hi, sorry for the delay on this. I'm not aware of any existing Quickbooks documentation on IIF at all - generally what I've read is that IIF is not officially supported.

So, I'm not sure how to provide you what you're asking for - I've just observed that IIF imports fail if the field contains a semicolon.

Are you aware of any existing IIF documentation?

jaredmoody avatar Dec 03 '19 21:12 jaredmoody

Maybe this one: https://quickbooks.intuit.com/learn-support/en-us/manage-lists/iif-overview-import-kit-sample-files-and-headers/00/201577

Looks like it does provide some examples. Let me check if these files can be used as the unit test fixtures.

linjunpop avatar Dec 03 '19 23:12 linjunpop