Good idea. In the previous versions I had to change the quotes to double to get the other IIF to work all these years. So first I'll try keeping it at single quotes Karen -----Original Message----- From: Michael Byerley <[email protected]> To: RBASE-L <[email protected]> Sent: Thu, Jan 23, 2020 11:37 am Subject: Re: [RBASE-L] - Re: QB help? - SOLUTION!
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 <[email protected]> To: rbase-l <[email protected]> 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 <[email protected]> To: RBASE-L <[email protected]> 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/ 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? 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 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. -- 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. 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 rba...@ googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/ msgid/rbase-l/53f95a62-74b1- 434d-b0ce-a72547ab73ee% 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/9226c962-7f06-4a5d-a9fc-4f0daee48d27%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/332807918.18611124.1579804151805%40mail.yahoo.com.
