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]> To: rbase-l <[email protected]> Sent: Sat, Jan 18, 2020 1:19 pm Subject: Re: [RBASE-L] - Re: QB help? #yiv5037555853 blockquote.yiv5037555853cite {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;}#yiv5037555853 blockquote.yiv5037555853cite2 {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;margin-top:3px;padding-top:0px;}#yiv5037555853 a img {border:0px;}#yiv5037555853 , #yiv5037555853 {list-style-position:inside;}#yiv5037555853 body {font-family:Segoe UI;font-size:12pt;}Karen: At last year's Conference, Razzak unveiled the new R:BASE <> QBooks interface. You will likely find your solution there. BruceSafeSectors, Inc. ------ Original Message ------From: "Michael Byerley" <[email protected]>To: "RBASE-L" <[email protected]>Sent: 1/18/2020 8:15:01 AMSubject: [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 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/5159009e-6f71-4c3c-8d44-dc88f9a03dcd%40googlegroups.com. -- 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/em26bac62a-ce71-46c7-9d26-23f83b093b39%40pathfinder. -- 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/1556357002.16731456.1579564353395%40mail.yahoo.com.
