Sorry, should've read this email too. Yep -- the "example" is dated 2008!!!!
One thing that other link says is that there is a new option after attempting and failing to import to "import the data anyway and I'll fix it later". What that does is that QB makes a guess to correct the errors and then you to go in and manually fix any wrong guesses row by row. I tried that, and the one thing it guesses on (the "item type", which I need to be "inventory" so it can be sold) is assigned a different value and you are unable to change it! Not that my user would be happy manually changing hundreds of rows anyway..... One user responded to my question with a link to a consultant's blog which blasts Intuit for breaking the import of data from outside programs. He says you HAVE to "import and fix later" and have your users manually fix the rows. Again, they guess incorrectly on a piece of data that is not changeable..... What's funny is that my user is so used to me having the ability to directly contact RBTI with issues and get immediate fixes, that they don't understand why I can't get that from Intuit! Karen -----Original Message----- From: Michael Byerley <[email protected]> To: RBASE-L <[email protected]> Sent: Sat, Jan 18, 2020 10:15 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 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/1537645321.15963296.1579445705557%40mail.yahoo.com.
