search

linjunpop / riif

🏦 A DSL to generate QuickBooks IIF file.
MIT License
47 stars 30 forks source link

Quickbooks Desktop and Semicolons #42

Open jaredmoody opened 5 years ago

jaredmoody commented 5 years ago

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.

linjunpop commented 5 years ago

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

jaredmoody commented 4 years ago

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?

linjunpop commented 4 years ago

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.