[interchange-cvs] interchange - danb modified 3 files
interchange-core@icdevgroup.org
interchange-core@icdevgroup.org
Sat Jul 20 17:31:01 2002
User: danb
Date: 2002-07-20 21:30:17 GMT
Modified: extensions/quickbooks ic_qb.pod mv_metadata-additions.asc
Modified: extensions/quickbooks/etc trans_quickbooks
Log:
* Item name updates (Mike Heins <mike@perusion.com>)
- Length filter now customizable via QB_ITEM_LENGTH
- Default is 30 (backwards compatible)
- Item name taken from 'title' first, 'description' second.
* Change [var] notation to __...__ for readability
* A little more documentation
Revision Changes Path
2.2 +2 -9 interchange/extensions/quickbooks/ic_qb.pod
rev 2.2, prev_rev 2.1
Index: ic_qb.pod
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /var/cvs/interchange/extensions/quickbooks/ic_qb.pod,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -r2.1 -r2.2
--- ic_qb.pod 20 Jul 2002 15:59:41 -0000 2.1
+++ ic_qb.pod 20 Jul 2002 21:30:17 -0000 2.2
@@ -224,7 +224,8 @@
=20=20
cat >>/path/to/your/products/variable.txt <<EOF
QB_DISABLE_DOCNUM Quickbooks
- QB_TITLE_PREFIX Quickbooks
+ QB_ITEM_PREFIX Quickbooks
+ QB_ITEM_LENGTH Quickbooks
QB_FILE_SUFFIX Quickbooks
QB_SHIPPING_ACCOUNT Quickbooks
QB_SHIPPING_ITEM Quickbooks
@@ -242,14 +243,6 @@
=20=20
cat >>/path/to/your/products/mv_metadata.asc <mv_metadata-additions.asc
=20
-=3Dhead2 Compatibility Modifications
-
-Quickbooks versions 6.0 and 99 may have a problem with item names that are=
longer
-than 30 characters. The current version limits the item names to 45 chara=
cters=20
-(known to work on Quickbooks 2000 and later version), but can be easily ch=
anged in
-the etc/trans_quickbooks file. Please report any compatibility problems t=
o the=20
-interchange-users@icdevgroup.org mailing list.
-=20
=3Dhead2 Restart the catalog
=20
This can be done by restarting the Interchange server or by clicking
2.2 +6 -5 interchange/extensions/quickbooks/mv_metadata-addition=
s.asc
rev 2.2, prev_rev 2.1
Index: mv_metadata-additions.asc
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /var/cvs/interchange/extensions/quickbooks/mv_metadata-additions.=
asc,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -r2.1 -r2.2
--- mv_metadata-additions.asc 20 Jul 2002 15:59:41 -0000 2.1
+++ mv_metadata-additions.asc 20 Jul 2002 21:30:17 -0000 2.2
@@ -1,9 +1,10 @@
-variable::Variable::QB_DISABLE_DOCNUM yesno <b>Yes</b> will cause=
the invoice number (AKA DOCNUM & Document Number) to be blank. <b>No</b> =
will cause etc/trans_quickbooks the use of the Interchange order number as =
the Quickbooks invoice number. Some prefer to have the number left blank s=
o as not to cause Quickbooks to change its auto-count.
-variable::Variable::QB_TITLE_PREFIX text A prefix applied to all =
product names (the unique identifier in Quickbooks).=20=20
+variable::Variable::QB_DISABLE_DOCNUM yesno <b>Yes</b> will cause=
the invoice number (AKA DOCNUM & Document Number) to be blank. No by defa=
ult. <b>No</b> will cause etc/trans_quickbooks the use of the Interchange =
order number as the Quickbooks invoice number. Some prefer to have the num=
ber left blank so as not to cause Quickbooks to change its auto-count.
+variable::Variable::QB_ITEM_PREFIX text A prefix applied to all p=
roduct names (the unique identifier in Quickbooks). Empty by default. For=
example, some Quickbooks users may have a category for all the products so=
ld on their website such as "E-Commerce Products:" (the colon is a category=
deliniator for Quickbooks). Other Quickbooks users may use the same categ=
ory scheme in in their Interchange store as they do in their Quickbooks ite=
m lists, in which case something to this effect would be applicable: "[ite=
m-field category]:"=20=20
+variable::Variable::QB_ITEM_LENGTH text The item name maximum len=
gth for product line items (any characters past this length will be truncat=
ed). 30 by default. Quickbooks versions 6.0 and 99 may have a problem wit=
h item names that are longer than 30 characters; however, lengths of 45 and=
longer have been known to work on Quickbooks 2000 and later version. Plea=
se report any compatibility problems/information to the interchange-users@i=
cdevgroup.org mailing list.
variable::Variable::QB_FILE_SUFFIX text If left blank, the curren=
t date will be used and each order will be appended to the file. <BR><BR>A=
nother option is to use [value mv_order_number] to cause the creation of a =
separate file for each order.
-variable::Variable::QB_SHIPPING_ACCOUNT text The income account a=
ssociated with shipping. Default "Other Income" if left blank.
-variable::Variable::QB_SHIPPING_ITEM text The item name given for=
the shipping. Default "Shipping" if left blank.
-variable::Variable::QB_DEFAULT_ACCOUNT text The income account as=
sociated with each product line item. Default "Other Income" if left blank=
; however, the highest precence is 'account' field in the 'inventory' table=
=20
+variable::Variable::QB_SHIPPING_ACCOUNT text The income account a=
ssociated with shipping. "Other Income" by default.
+variable::Variable::QB_SHIPPING_ITEM text The item name given for=
the shipping. "Shipping" by default.
+variable::Variable::QB_DEFAULT_ACCOUNT text The income account as=
sociated with each product line item. "Other Income" by default; however, =
the highest precence is 'account' field in the 'inventory' table.=20
variable::Variable::QB_SALES_TAX_ACCOUNT text The liability accou=
nt associated with sales tax. "Sales Tax Payable" by default.
variable::Variable::QB_SALES_TAX_AGENCY text The name of the sale=
s tax agency for your locality. "State Board of Equalization" by default (=
the name given in the Quickbooks 2000 sample products based business).
variable::Variable::QB_SALES_TAX_ITEM text The item name (Quickbo=
oks unique identifier) for the sales tax. "Sales Tax Item" by default (fro=
m Quickbooks 2000 sample products based business).
2.4 +17 -8 interchange/extensions/quickbooks/etc/trans_quickbooks
rev 2.4, prev_rev 2.3
Index: trans_quickbooks
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /var/cvs/interchange/extensions/quickbooks/etc/trans_quickbooks,v
retrieving revision 2.3
retrieving revision 2.4
diff -u -r2.3 -r2.4
--- trans_quickbooks 20 Jul 2002 15:59:41 -0000 2.3
+++ trans_quickbooks 20 Jul 2002 21:30:17 -0000 2.4
@@ -140,7 +140,7 @@
[fcounter etc/qbline.number]
[scratch TRNSTYPE]
[scratch DATE]
-[either][item-data inventory account][or][var QB_DEFAULT_ACCOUNT][or]Other=
Income[/either]
+[either][item-data inventory account][or]__QB_DEFAULT_ACCOUNT__[or]Other I=
ncome[/either]
[scratch CUSTNAME]
=20
-[item-subtotal noformat]
@@ -149,7 +149,16 @@
N
-[item-quantity]
[item-price noformat=3D1]
-[item-filter 45][var QB_TITLE_PREFIX][item-field title][/item-filter]
+[seti DESC][filter
+ interpolate=3D1
+ op=3D"strip mac __QB_ITEM_LENGTH__ 30"
+ ]
+ [either]
+ __QB_ITEM_PREFIX__[item-field title]
+ [or]
+ __QB_ITEM_PREFIX__[item-description]
+ [/either]
+[/filter][/seti][scratch DESC]
=20
[if-item-field nontaxable]N[else][scratch NAMEISTAXABLE][/else][/if-item-f=
ield]
N
@@ -160,7 +169,7 @@
[fcounter etc/qbline.number]
[scratch TRNSTYPE]
[scratch DATE]
-[either][var QB_SHIPPING_ACCOUNT][or]Other Income[/either]=20
+[either]__QB_SHIPPING_ACCOUNT__[or]Other Income[/either]=20
[scratch CUSTNAME]
=20
-[shipping noformat=3D1]
@@ -169,7 +178,7 @@
N
-1
[shipping noformat=3D1]
-[either][var QB_SHIPPING_ITEM][or]Shipping[/either]
+[either]__QB_SHIPPING_ITEM__[or]Shipping[/either]
=20
N
N
@@ -180,8 +189,8 @@
[fcounter etc/qbline.number]
[scratch TRNSTYPE]
[scratch DATE]
-[either][var QB_SALES_TAX_ACCOUNT][or]Sales Tax Payable[/either]
-[either][var QB_SALES_TAX_AGENCY][or]State Board of Equalization[/either]
+[either]__QB_SALES_TAX_ACCOUNT__[or]Sales Tax Payable[/either]
+[either]__QB_SALES_TAX_AGENCY__[or]State Board of Equalization[/either]
=20
-[salestax noformat=3D1]
[value mv_order_number]
@@ -189,7 +198,7 @@
N
-1
=20
-[either][var QB_SALES_TAX_ITEM][or]Sales Tax Item[/either]
+[either]__QB_SALES_TAX_ITEM__[or]Sales Tax Item[/either]
=20
N
N
@@ -203,7 +212,7 @@
$Scratch->{qb_trans} =3D~ s/\s*$/\r\n/;
return;
[/calc]
-Logging transaction to orders/qb[either][var QB_FILE_SUFFIX][or][scratch F=
ILEDATE][/either].iif: [tag op=3Dlog umask=3D022 file=3D"orders/qb[value mv=
_order_number].iif" type=3Dtext interpolate=3D1][scratch qb_trans]
+Logging transaction to orders/qb[either]__QB_FILE_SUFFIX__[or][scratch FIL=
EDATE][/either].iif: [tag op=3Dlog umask=3D022 file=3D"orders/qb[value mv_o=
rder_number].iif" type=3Dtext interpolate=3D1][scratch qb_trans]
[/tag]
=20
[calc]