[ic] Need Quickbooks Import Help Pls

Grant listbox at email.com
Sun Jul 27 20:03:44 EDT 2003

> An update on what I've found so far, some of this
> might help others using the quickbooks module.  And
> thanks to Jon for the link to the newsgroups, google
> groups is perfect for getting through the info there.
> >First, it seems that when you have a quotation mark
> in
> >the item description, it messes up the import into
> QB.
> > Say  57" Windsock.  I tried escaping it with  57\"
> >Windsock and that didn't work.  In the import I get
> >the SPLID in the quantity field as a negative
> quantity
> >and the date in the sku field when I have something
> >like this.  If I take the " out, then it works fine.
> >Any ideas?
> It seems this is a bug with QB, at least with the
> version I'm using which is a bit older (2000).  QB
> considers the " mark to be a field delimiter.  My
> solution, in case anyone else needs it, is going to be
> a cron job to run just after midnight each day which
> simply does a replace on the .iif file from the
> previous day to replace all " with ''  (the '' looks
> just like a " when it prints in their invoices and I
> do want that to appear).  Not elegant, but certainly
> functional and won't require me to figure out any
> place the " might show up, including places customers
> might accidentally enter it like in company name and
> address and such.

Do you export your items list from QB to IC?  If so, the " will show up as
'' there too and that can get annoying.  I know because I do basically the
same thing you're doing and I'm annoyed :).

- Grant

More information about the interchange-users mailing list