[ic] Quickbooks IIF generation

Joachim Schubert joachim at schubis-dd.de
Fri Dec 9 04:05:00 EST 2005


Hello Curt,

On Thu, Dec 08, 2005 at 09:32:48PM -0600, Curt Hauge wrote:
> Hi all,
> 
> IC5.2.0	Perl 5.8.2	MySQL 3.23	Apache 1.3.22	Redhat 7.2	4.8 Construct catalog
> updated
> 
> I am trying to get Quickbooks working with Interchange. It is installed and
> working for the most part, however, I am having trouble with one selection
> on the generate_new_iif.html page. If you select "Generate any new IIF
> files", this query does not include a record UNLESS the comment field
> already has data in it:
> 
> [tmp sql]
> 	SELECT	*
> 	FROM		transactions
> 	WHERE		1=1
> 	AND		deleted <> 1
> 
> [snip stuff]
> 
> 	[if cgi query_type eq 'any_new']
> 		AND comments NOT LIKE '%(syncronized)'
> 		LIMIT [scratch any_new_limit]
> 	[/if]
> [/tmp]
> 
> If comments field is empty, the transaction is not included in the list, but
> it SHOULD be.
> If comments fields has data in it (but without (syncronized) on the end), it
> is included, like it should be.
> If comments field has (syncronized) at the end of the file, it is not
> included, and it shouldn't be.
> 
> The comments field obviously could be empty, so this is not good.
> 
> I have searched the mail archives and I am currently using the above code
> which I extracted from the 5.3.2 release. I have tried changing the field
> type to varchar(255) instead of TEXT, but comments is currently a TEXT
> field. I've also tried changing the expression around a bit without any
> luck.
> 

have you tried (if the default value for comments is NULL):
...
   [if cgi query_type eq 'any_new']
       AND ( comments NOT LIKE '%(syncronized)' OR comments is NULL )
                                                -------------------
       LIMIT [scratch any_new_limit]
   [/if]

...
good luck

	Achim

> Can anyone see an obvious solution and offer some assistance?
> 
> Thank you.
> 
> 
> Curt Hauge
> Office 763-689-4984
> Cell   612-598-5530
> www.IWantAConsultant.com
> www.MNWebDesign.com
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users



More information about the interchange-users mailing list