DogTags

I'd be interested in this, too :)

Sorry, I should have mentioned which helpdesk contrib: http://www.oscommerce.com/community/contributions,859 Thanks :)

Hi All Does this mod have any problems with case related to account and customer names? What I've heard about some qb modules is that if the customer name is in the wrong case, then QB just makes a new account. Instead, any import should not be case-sensitive. Many thanks :)

Hi All Helpdesk seems to be only half working. 1. Tickets are not created 2. User fields of logged-in users do not get filled I'm wondering what it might be. Could it be placement of some of the helpdesk code perhaps? Like, where should the following go: Should the 'define(blahblah....)' be put into a specific place on application_top.php, or can it just be plugged in anywhere? Thanks :)

Thanks, John. This seems very interesting. Much appreciated :)

Thanks, John :) I'm not sure how to apply mysql odbc directly, but might you know of any mysql tools, either win based or lin, that can do this? Maybe there is a tool out there that can be aimed at the db to do the extractions. Many thanks :)

Hi All Trying the Sales Report tool - very nice Would like to make it a more general data export tool For instance, would be great if it could export customer shipping address data to be used for an address label mailmerge. Has anyone tried this? Is it possible? Any other export tools around? So far, haven't found any. Many thanks :)

I think this is it: http://www.oscommerce.com/community/contri...,order+download

Hi All Just plugged in the Linkpoint Module: http://www.oscommerce.com/community/contri...earch,linkpoint Got the same curl error :( The lpphp.php file that comes with the latest Linkpoint Module download is version 2.0.007 Where can I get lpphp.php v. 3.0.005 ? Since the latest download seems to have an old file, is there an fully updated Linkpoint Module available? In lpphp.php v. 2.0.007, the only code that seemed relevant looks like this (starting about line 142): // if php version > 4.0.2 use built-in php curl functions. // otherwise shell out to curl if ($this->PHP_CURLFUNCS != 1) #call curl directly without built in PHP curl functions { if ($this->DEBUGGING == 1) echo "<BR>NOT using PHP curl methods<BR><BR>"; $cpath = $this->curlpath; // Win32 command yikes! # $result = exec ("$cpath -E \"$key\" -m 90 -d \"$xml\" $host", $retarr, $retnum); // *NIX command $result = exec ("'$cpath' -v -E '$key' -m 90 -d '$xml' '$host'", $retarr, $retnum); } else # use PHP curl methods { # if ($this->DEBUGGING == 1) # echo "<BR> Using PHP curl methods <BR>"; // then encrypt and send the xml string $ch = curl_init (); curl_setopt ($ch, CURLOPT_URL,$host); curl_setopt ($ch, CURLOPT_POST, 1); curl_setopt ($ch, CURLOPT_POSTFIELDS, $xml); curl_setopt ($ch, CURLOPT_SSLCERT, $key); curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); $result = curl_exec ($ch); } if ($this->DEBUGGING == 1) { echo "\n\nserver response: " . $result . "\n\n"; } Notice the "-m 90" andn some other stuff within the code above. This doesn't match what is in lpphp.php version 3.0.0005 version 2.0.007 // *NIX command $result = exec ("'$cpath' -v -E '$key' -m 90 -d '$xml' '$host'", $retarr, $retnum); version 3.0.005 $result = exec ("'$cpath' $args -E '$key' -d '$xml' '$host'", $retarr, $retnum); So, I'm not sure at this point whether it's safe to substitute the code from 3.0.005 into the 2.0.007 file I've been searching around for any updates, but no luck so far. If anyone could point me in the right direction to get a fully updated Linkpoint Payment Module, I would be very grateful. Thanks very much :)

You could search here: http://www.oscommerce.com/community/contributions I haven't had a chance to search, but the Contributions location is where a lot of this is posted. I could use the FedEx thing, too :) Cheers :)

Thanks, Matt. I'll see if I can find it and give it a go. Much appreciated :)

Hi All Total Newbie, but researching as fast as I can :) Will the Imp/Exp module work for orders? I'm trying to find a way to imp/exp order data as tab-delimited spreadsheets. Thanks very much :)

Yes, that would be great. Could you place a link to it perhaps? Thanks :)

Hi All I need to set up Free First Class Shipping for designated items if those items are shipped by First Class and if the Shipping Address is a U.S. address (or other designated shipping location). So, it's a test for two variables - shipping method (usually First Class) and shipping address location (usually country) Otherwise, regular shipping tables apply. Also, if a Free Shipping item is part of an order that includes non-free-shipping items AND that order is shipped by First Class (or other designated method) AND that order is shipped to the free-shipping location, then the free-shipping item would not be calculated in the shipping, but the other items would be. Example: Item 1234 - Free First Class Shipping if Shipped to U.S. address Item 6789 - regular item Order 100 U.S. Address Item 1234 - quant: 5 First Class Shipping Shipping Charge: $0.00 Order 101 Australia Address Item 1234 - quant: 5 First Class Shipping Shipping Charge: $5.00 Order 102 U.S. Address Item 1234 - quant: 5 Overnight Shipping Shipping Charge: $18.95 Order 103 U.S. Address Item 1234 - quant: 5 Item 6789 - quant: 1 First Class Shipping Shipping Charge: $2.00 (just for Item 6789) Order 104 U.S. Address Item 1234 - quant: 5 Item 6789 - quant: 1 Overnight Shipping Shipping Charge: $25.00 (for both Item 1234 and 6789) Basically, I'm trying to nail down shipping method and shipping location (for specified items). Regular shipping rates apply if one or both of those criteria are not met for the designated items. Is this possible? Would be reeeeeally great to do :D :D Thanks very much :)