>From the user forum comments, I concluded Intuit is the AT&T of software houses..
So I'm wondering how effective a read/write odbc driver might be to satisfy your issue: https://www.cdata.com/drivers/quickbooks/odbc/?gclid=Cj0KCQiAmZDxBRDIARIsABnkbYQ7AzOI18ZV2R6nCspydJUxslVsseLhVbDPs4gLWtXPAkGCp0W6MQwaAjoJEALw_wcB On Sunday, January 19, 2020 at 9:55:09 AM UTC-5, Karen Tellef wrote: > > 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] <javascript:>> > To: RBASE-L <[email protected] <javascript:>> > 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 > <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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/7452920c-abe5-493d-bce0-350f70dd365a%40googlegroups.com.
