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/ > > > Karen > > > > -----Original Message----- > From: Bruce Chitiea <[email protected] <javascript:>> > To: rbase-l <[email protected] <javascript:>> > 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" <[email protected] <javascript:>> > To: "RBASE-L" <[email protected] <javascript:>> > 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 > --- > 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 [email protected] <javascript:>. > 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 > --- > 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 [email protected] <javascript:>. > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/53f95a62-74b1-434d-b0ce-a72547ab73ee%40googlegroups.com.
