Dan, I use a direct export to IIF files, which Quickbooks can read natively.
IIF files can be tricky to handle, though since you have to get the account names(or numbers) just right to make the export populate the correct accounting lines. You'll need a copy of the customers QB database (and Quickbooks of course) and then be prepared to run the import and keep restoring the database until you get the lines just right on the import file. Quickbooks also supports the Web Connect file format, which is much easier to use as you can assign things line-by-line and QB remembers your selection on future imports. Unfortunately only Financial Institutions are supported for Web Connect at this time. Hopefully, they will standardize a schema that can be used to import orders, invoices, and customers at some time in the future. I've got an accounting component that I use to handle the exports and delivery of the files, but the schemas used for the file formats are specific to my company and my cart solution . I haven't played with the WebConnector software (http://marketplace.intuit.com/ webconnector/) since it's a Windows-Only deal and I use QB for the Mac, but that might be an easier solution if your client is on Windows. Jon P.S. If you still want to have a go at rolling your own IIF's, feel free to e-mail me off-list. On Apr 4, 2007, at 9:07 PM, Dan Vega wrote: > I am looking for someone who is familiar with quick books. I have a > customer > who has about 30 online orders per day. The orders are not tied > into quick > books in any way so at the end of each day the customer has to go > back and > manually insert each order. I have never used Quick Books and I am > not sure > where to begin. Does anyone know of a batch import through xml or > csv? If so > I think it would be really easy for me to provide the customer a > download of > these orders in one of those formats so they can enter them much > quicker. > Any help is grateful. > > -- > Thank You > Dan Vega > [EMAIL PROTECTED] > http://www.danvega.org > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274629 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
