Ha, I love that!!! Especially since this same user is right now embroiled in an argument with AT&T over $1500 in every-month phone charges that she's been disputing for half a year now.... Intuit also now offers an Excel import option, both a simple and an advanced. The simple won't work for this type of list, so I went to the advanced. It is very similar to doing a field-to-field mapping to set up UPS Worldship, which I've done a couple times, so I thought this'd be a perfect replacement! So I did my mapping, there's only 6 or 7 fields if I remember correctly. Press the "save and test" button. And I get an error message something like this: "Your current Unit of Measure setting is Off, but you made this mapping while the Unit of Measure is On. Edit your mapping or add a new one" Wait, huh?? We don't use UOM (inventory is serialized), so yes UOM is set off. But how is it all of a sudden "On" when I created the map? I tried setting UOM back on for a moment, but then I get tons of error messages that every inventory item needs a UOM (slight freakout so I turned it back Off).
I added a UOM field to my Excel file and did a mapping to it, and I get an error message: "You specified a UOM, but your setting is Off" .... So I remove the column, try again, the same message that I created the map with my UOM turned ON. If I cared enough, I'd be banging my head on the wall... Karen -----Original Message----- From: Michael Byerley <[email protected]> To: RBASE-L <[email protected]> Sent: Sun, Jan 19, 2020 9:09 am Subject: Re: [RBASE-L] - Re: QB help? >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]> 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 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 [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. -- 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/1402396801.15949515.1579455082516%40mail.yahoo.com.
