Article View: alt.comp.software.financial.quickbooks
Article #123Re: Import Data not Imorting
From: mblockNO_SPAM
Date: Thu, 28 Dec 2000 16:24
Date: Thu, 28 Dec 2000 16:24
70 lines
3491 bytes
3491 bytes
On Thu, 28 Dec 2000 15:51:49 GMT, "Jesse Castleberry" <Jesse@msdlg.com>
wrote:
>I actually had SEVERAL problems, but the largest of which was the fact that
>I misspelled "ENDTRNS". I had "ENDTRANS", and that was enough to screw the
>whole thing up.
>
>I have had problems with Tab delimited files. I find that comma's (,) in
>just about ANY field, whither or not I'm using Tab or Comma delimited files
>is a problem too. Boy, this thing is picky!.
>
This is not a QuickBooks problem. There were problems with commas,
in tab delimited files and "," delimited files, in every computer
program I have used since 1960.
>-= Jesse =-
>http://www.msdlg.com
>http://www.davinci-mims.com
>"Jeff H" <support@REMOVEqtools.com> wrote in message
>news:uPg26.93919$I5.2366998@news1.rdc1.sdca.home.com...
>> There is probably an error in the format you're using for importing
>> transactions.
>>
>> Why don't you post the IIF headers that you are using and a single
>> transaction. In other words, the lines beginning with:
>>
>> !TRNS ...
>> !SPL ...
>> !ENDTRNS
>> TRNS ...
>> SPL ...
>> SPL ...
>> SPL ...
>> ENDTRNS
>>
>> We should be able to troubleshoot it from there...
>>
>> -Jeff Hamblin
>> Qtools Software
>> www.qtools.com
>>
>>
>> "Jesse Castleberry" <Jesse@msdlg.com> wrote in message
>> news:jC726.132163$58.14709146@typhoon.tampabay.rr.com...
>> > We have a custom program that I've written that I have modified to
>create
>> > .IIF files for importing data from that program into QuickBooks.
>> Customers
>> > and Inventory items seem to be working just fine. However, Invoice
>> > Transactions are not. When I try to import inovices, it automatically
>> > creates the customers for each invoice if that customer does not already
>> > exist, but the transaction itself is not imported. Does anyone have any
>> > hints?
>>
>>
>>
>>
>
Mike Block - Tax Cut CPA
World's #1 QuickBooks Top Tester
FREE NetLedger accounting
FREE 462p QB books/error codes
100+ QB add-ons http://blocktax.com/
QB no-spam news: biz.comp.accounting
-----------------------------------
Spam bait admin@localhost abuse@localhost
webmaster@localhost postmaster@127.0.0.1
enforcement@sec.gov cyberfraud@nasaa.org
Technical Details
Message-ID:
<3a4b6946.96004997@news.mindspring.com>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!router1.news.adelphia.net!logbridge.uoregon.edu!cyclone-west.rr.com!news.rr.com!news-west.rr.com!newsfeed2.earthlink.net!newsfeed.earthlink.net!news.mindspring.net!not-for-mailReferences:
<jC726.132163$58.14709146@typhoon.tampabay.rr.com> <uPg26.93919$I5.2366998@news1.rdc1.sdca.home.com> <pkJ26.205637$vc3.34600955@typhoon.tampabay.rr.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 112670,4183ec794e22e1b4 X-Google-Attributes: gid112670,public X-Google-Thread: fbe20,f05599485ed0fc1b,start X-Google-Attributes: gidfbe20,public X-Google-ArrivalTime: 2000-12-28 08:57:28 PST Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!router1.news.adelphia.net!logbridge.uoregon.edu!cyclone-west.rr.com!news.rr.com!news-west.rr.com!newsfeed2.earthlink.net!newsfeed.earthlink.net!news.mindspring.net!not-for-mail From: <mblockNO_SPAM@blocktax.com> (Mike Block, Tax Fighting C.P.A.) Newsgroups: alt.comp.software.financial.quickbooks,biz.comp.accounting Subject: Re: Import Data not Imorting Date: Thu, 28 Dec 2000 16:24:54 GMT Organization: MindSpring Enterprises Lines: 73 Approved: mblock@blocktax.com Message-ID: <3a4b6946.96004997@news.mindspring.com> References: <jC726.132163$58.14709146@typhoon.tampabay.rr.com> <uPg26.93919$I5.2366998@news1.rdc1.sdca.home.com> <pkJ26.205637$vc3.34600955@typhoon.tampabay.rr.com> NNTP-Posting-Host: d1.56.a3.b1 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Server-Date: 28 Dec 2000 16:57:20 GMT X-Newsreader: Forte Agent 1.5/32.452