Tim

I'm trying to send you the missing catalog but I keep getting

------------------------------------------------------------------------------------------------------------------

The original message was received at Wed, 11 Apr 2007 07:57:04 +0100 (BST)
from host81-152-60-203.range81-152.btcentralplus.com [81.152.60.203]

  ----- The following addresses had permanent fatal errors -----
<timyoungelevatesoft.com>
   (reason: 554 Transaction failed - invalid subject header)

  ----- Transcript of session follows -----
... while talking to mail.elevatesoft.com.:.
>>> DATA
<<< 554 Transaction failed - invalid subject header
554 5.0.0 Service unavailable

------------------------------------------------------------------------------------------------------------------

I've attached it here but there's something weird going on. I've just checked the original email and your address definitely had the @ in it

Roy Lambert

Roy,

<< I'm trying to send you the missing catalog but I keep getting >>

That means that you're using a keyword in the subject header that our mail
server is blocking.  What was the Subject header for the email ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

Okay, the issue with the import is that your import file has a bunch of
0-00-00 entries for dates.   This is most likely from version 1.00, which
was exporting NULL dates as 0-00-00 when they should have simply been blank.
There are also a couple of issues with the .csv file caused by 1.00.  I
would suggest that you create a .csv using the latest 1.02, and try the
import that way.

Also, I've managed to replicate the "index page empty" error and a fix will
be in 1.02 Build 2.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>That means that you're using a keyword in the subject header that our mail
>server is blocking. What was the Subject header for the email ?

Dunno now but all I did was reply to your email which means that TMaN would have added a Re: at the front.

Roy Lambert

Tim

>Okay, the issue with the import is that your import file has a bunch of
>0-00-00 entries for dates. This is most likely from version 1.00, which
>was exporting NULL dates as 0-00-00 when they should have simply been blank.
>There are also a couple of issues with the .csv file caused by 1.00. I
>would suggest that you create a .csv using the latest 1.02, and try the
>import that way.

Must have been mangling it a bit more than that since the original csv file was created from my actual accounts and QuickBooks really hates me to not enter a date

Roy Lambert

Roy,

<< Must have been mangling it a bit more than that since the original csv
file was created from my actual accounts and QuickBooks really hates me to
not enter a date >>

The _Reconciled date column values were all NULL.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

Ahhh a little light goes on. Not a piece of information exported from QuickBooks but a brand new column in my table. But its set to nullable in the catalog so shouldn't a null import OK?


Roy Lambert

Roy,

<< Ahhh a little light goes on. Not a piece of information exported from
QuickBooks but a brand new column in my table. But its set to nullable in
the catalog so shouldn't a null import OK? >>

Yes, but some other screw-ups were in there that messed up the import
process, even for valid dates.  1.02 fixes all of these formatting issues
with dates.

--
Tim Young
Elevate Software
www.elevatesoft.com