You might first try changing the Quote setting just to check if it's QB inflexibility between double and single quotes, which would be a very easy fix.
On Thursday, January 23, 2020 at 10:25:30 AM UTC-5, Karen Tellef wrote: > > As I mentioned, my developer buddy (SJ) was looking at my files and he had > a few suggestions for me to try -- ONE OF WHICH WORKED!!!! > > Believe it or not, the problem was RBase putting quotation marks around > the text values! Manually removing the quotations marks and importing > worked perfectly! So something changed in the 2020 QB version. This > should be easy to fix! > > Karen > > > > > -----Original Message----- > From: Karen Tellef <karen...@cs.com <javascript:>> > To: rbase-l <rba...@googlegroups.com <javascript:>> > Sent: Wed, Jan 22, 2020 12:29 pm > Subject: Re: [RBASE-L] - Re: QB help? > > Yeah interesting! Looks like SDK is the way to go. Their explanation of > the new "validation" process is accurate, their error file is very > descriptive. With the old version there was no feedback at all, however > our IIF files never once failed. And it's funny how even Intuit themselves > is recommending the "import it for me and I'll fix it later". I just can't > imagine users being happy that they have to go in and manually make > corrections to maybe hundreds of imported rows, one at a time. > > I'm crossing my fingers... a developer buddy of mine says he uses Excel to > bring RBase data into QB, but he uses the Online version which I guess is > quite different from the Desktop version that we are using and he doesn't > import the type of transactions that I am. But he's taking a look at the > Excel file that I used (and failed). So I'm hoping he'll spot something! > > Karen > > > > -----Original Message----- > From: Michael Byerley <baue...@gmail.com <javascript:>> > To: RBASE-L <rba...@googlegroups.com <javascript:>> > Sent: Wed, Jan 22, 2020 11:16 am > Subject: Re: [RBASE-L] - Re: QB help? > > > Here's a link that may add substance to your argument about using ODBC > instead. It is not a long read. > > https://www.exigobusiness.com/post/quickbooks-desktop-2019-enhanced-iif-import > > > On Monday, January 20, 2020 at 6:54:36 PM UTC-5, Karen Tellef wrote: > > An FYI for anyone who might be interested. I spoke with RBTI's support. > This is not an RBase product, but is a third-party software. It is > basically a QB ODBC driver, and RBase can be connected via this driver > using SQL commands to communicate. I'm going to ask my user if they want > me to investigate further. > > https://qodbc.com/what-is- qodbc/ <https://qodbc.com/what-is-qodbc/> > > > Karen > > > > -----Original Message----- > From: Bruce Chitiea <rby...@safesectors.com> > To: rbase-l <rba...@googlegroups.com> > Sent: Sat, Jan 18, 2020 1:19 pm > Subject: Re: [RBASE-L] - Re: QB help? > > Karen: > > At last year's Conference, Razzak unveiled the new R:BASE <> QBooks > interface. You will likely find your solution there. > > Bruce > SafeSectors, Inc. > > ------ Original Message ------ > From: "Michael Byerley" <baue...@gmail.com> > To: "RBASE-L" <rba...@googlegroups.com> > Sent: 1/18/2020 8:15:01 AM > Subject: [RBASE-L] - Re: QB help? > > > > On Saturday, January 18, 2020 at 9:54:40 AM UTC-5, Michael Byerley wrote: > > Did you look at this first? > > https://quickbooks.intuit.com/ learn-support/en-us/manage- > lists/iif-overview-import-kit- sample-files-and-headers/00/ 201577 > <https://quickbooks.intuit.com/learn-support/en-us/manage-lists/iif-overview-import-kit-sample-files-and-headers/00/201577> > > I can see since the first row of the IIF contains the description of the > data, it couldn't be directly imported or at least the first row would > not. But just a quick scan of the information on the page and all of the > samples, seems like you should be able to get to a conclusion. > > > Well you can probably ignore my info. A shallow dive into the QB forum on > IIF header formats shows that those samples are more than a decade old and > one frustrated user says he cannot even import an IIF file that was > Exported from QB. The culprit in his example is that the column > description character length is inaccurate so the import fails, further on > that example site, QB states they won't provide any support help for the > import or export of said IIF files. > > > > > > > On Friday, January 17, 2020 at 4:30:05 PM UTC-5, Karen Tellef wrote: > > Going out on a limb here.... A client upgraded their Quickbooks software, > so the IIF file that we've used for literally decades to import RBase data > no longer works. I've exhausted their phone tech support and online forums > (both of which pointedly say they no longer support importing IIF files). > I've tried their 2 methods of importing Excel spreadsheets and I can't get > either of those to work. The only data we bring in is an "Item List" > > Is anyone on here fluent in bringing in either IIF files or spreadsheets > -- with the 2019/later version? We would have you dial into their system, > and I would show you the IIF file that has the data to bring in. Obviously > pay for the time. > > Any QB peeps out there? > > > Karen > > -- > For group guidelines, visit http://www.rbase.com/support/ > usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rba...@ googlegroups.com. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/rbase-l/5159009e-6f71- 4c3c-8d44-dc88f9a03dcd% 40googlegroups.com > <https://groups.google.com/d/msgid/rbase-l/5159009e-6f71-4c3c-8d44-dc88f9a03dcd%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- > For group guidelines, visit http://www.rbase.com/support/ > usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rba...@ googlegroups.com. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/rbase-l/em26bac62a-ce71- 46c7-9d26-23f83b093b39% 40pathfinder > <https://groups.google.com/d/msgid/rbase-l/em26bac62a-ce71-46c7-9d26-23f83b093b39%40pathfinder?utm_medium=email&utm_source=footer>. > > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rba...@googlegroups.com <javascript:>. > To view this discussion on the web visit > > https://groups.google.com/d/msgid/rbase-l/53f95a62-74b1-434d-b0ce-a72547ab73ee%40googlegroups.com > > <https://groups.google.com/d/msgid/rbase-l/53f95a62-74b1-434d-b0ce-a72547ab73ee%40googlegroups.com?utm_medium=email&utm_source=footer> > > . > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/9226c962-7f06-4a5d-a9fc-4f0daee48d27%40googlegroups.com.
