bongo

I have installed the Export all data to csv file version 2.2 and this works just fine. Can export orders and change what i should export. But i have one question about it, when i export it i get all in one row. Sow if the customer has 5 products on their order i get this on one line. Does anyone of you now how i can make the export make a new line for each product on the order? like this Ordernumber Productid 1 120020 1 120021 1 120022 Hope that someone can help me with this. And also a happy new year to everyone -Thomas

I think i have figured it out now, it seems that on line 128 in newsletter_products.php it says: $content = join('', file(DIR_WS_TEMPLATES . $this->template)); In my configure file it already is a line named that DIR_WS_TEMPLATES sow i changed it to DIR_WS_TEMPLATES2 and then i got it to show the template. But the only problem i have now is that it want save my template file when i upload it in the newsletter file. I have to go to my mysql admin panel and insert the file myself. Does someone now why it doesnt save the template file? -Thomas-

I have figured out how i can set all the products with a free products, used sql :D But i see now when i have fixed this and tried to buy some products, that for each products i insert in the basket the gift also get included. Sow if i buys 5 various proucts i also get 5 gifts. How can i manage sow that i only get one gift no matter how many products i buys? Hope you can help me with this. Best Regards Thomas

Hello, I have tried out this contribution and everything works great, except the template. I have made an easy template with the logo at the top. I have given the folder templates 777 permissions, i have tried to use the template from my computer and from the webserver but no matter where i choose it, it isnt included in the newsletter. Can you help me with this? I have checked the configure.php file and it doens't seem to be any wrong there. Is there some special name the template fil should be named, or how can i include it? Since when i chooses the template i get to my locale computer. Hope someone here has the solution for this problem :D Best Regards -Thomas

Was a bit fast there, i have this error in checkout_process.php Fatal error: Call to a member function on a non-object in /home/vhosts2/v/o/localhost/www/checkout_process.php on line 282 The text i have in line 282 is: if (is_array ($free_product = $this->get1free ($products_id))) { Do you now what is wrong here? If i take away that line i get everything to work but i makes a new line for each products the customer buys included the free product that say: 0 x 0% 0.00 NOK: 0.00 NOK: 0.00 Hope you can help me with this bug. -Thomas-

First of all this was a really great contribution. Worked right away even with a heavily modified oscommerce shop :D I tried to see if i could figure it out but i tought i would ask you Jim, i would like my customers to get one free product no matter what they buy. Like the contribution is now you have to choose one and one product to set an free gift, is there someway i can choose all my products in a fast way? Thanks again for this great contribution. -Thomas-

Thanks for a great contribution :D For everyone that get the x'ed out picture when changing the $images_query can change it to this and then the picture will appear again $images_query = tep_db_query("select p.products_id, p.products_image, pd.products_name, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in(" . $this->products . ") and pd.language_id=" . $languages_id); } Again thanks -THomas-

Hi, I have installed the Print Batch Without Frames with labels 2. It works just great for the normal stores. But when i tries to include it with scrambled ordernumber i get an error: Fatal error: Cannot redeclare bit_rotate() (previously declared in c:\programfiler\easyphp1-8\www\borgedata\admin\includes\functions\scrambled_order_num.php:40) in c:\programfiler\easyphp1-8\www\borgedata\admin\includes\functions\scrambled_order_num.php on line 40 It takes out the first order and then it just give me this error. Does anybody now how to make this work? Best Regards Thomas B

I have now figured out what was wrong, it had an products_price1 value in the script i had forgotten to delete. But its some other things i am wondering about when i comes to deleting products. I saw that you could use EP_STATUS_DELETE instead of EP_STATUS_ACTIVE. But i have an store where i only get an text file every day that i import to my store. I don't now what products that are new or old and deleted. And i saw that the products wasn't deleted even if i delete it in the product file. Does anybody now how i can manage to make this work? Hope someone can help me. Best Regards Thomas B

Hi, I have installed the Easypopulate v. 2.90B and everything works for exporting products now after i took away the # 'v_products_price1_qty' => $iii++, But when i try to import an productfile i get this error: File uploaded. Temporary filename: C:\PROGRA~1\EASYPH~1\\tmp\php9E.tmp User filename: EP2006May30-1503.txt Size: 6342 | MG200MMS | matrox/mg2 | Matrox G20 | | www.matrox | Matrox G20 | | www.matrox | Matrox G20 | | www.matrox | 299.99 | 23.00 | | 30.05.2006 | 32 | Matrox | Taxable Go | EP_STATUS_ Updated | MG400-32MB | matrox/mg4 | Matrox G40 | | www.matrox | Matrox G40 | | www.matrox | Matrox G40 | | www.matrox | 499.99 | 23.00 | | 30.05.2006 | 32 | Matrox | Taxable Go | EP_STATUS_ Updated | MSIMPRO | microsoft/ | Microsoft | | www.micros | Microsoft | | | Microsoft | | www.micros | 49.99 | 7.00 | | 30.05.2006 | 2 | Warner | Taxable Go | EP_STATUS_ Updated | DVD-RPMK | dvd/replac | The Replac | | www.replac | Die Ersatz | | www.replac | The Replac | | www.replac | 42 | 23.00 | | 30.05.2006 | 13 | Microsoft | Taxable Go | EP_STATUS_ Updated | DVD-BLDRND | dvd/blade_ | Blade Runn | | www.blader | Blade Runn | | www.blader | Blade Runn | | www.blader | 35.99 | 7.00 | | 30.05.2006 | 17 | Warner | Taxable Go | EP_STATUS_ Updated | DVD-MATR | dvd/the_ma | The Matrix | | www.themat | Matrix | | www.whatis | The Matrix | | www.themat | 39.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated | DVD-YGEM | dvd/youve_ | You\'ve Go | | www.youveg | e-m@il f?r | | www.youveg | You\'ve Go | | www.youveg | 34.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated | DVD-ABUG | dvd/a_bugs | A Bug\'s L | | www.abugsl | A Bug\'s L | | www.abugsl | A Bug\'s L | | www.abugsl | 35.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated | DVD-UNSG | dvd/under_ | Under Sieg | | | Alarmstufe | | | Under Sieg | | | 29.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated | DVD-UNSG2 | dvd/under_ | Under Sieg | | | Alarmstufe | | | Under Sieg | | | 29.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated | DVD-FDBL | dvd/fire_d | Fire Down | | | Fire Down | | | Fire Down | | | 29.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated | DVD-DHWV | dvd/die_ha | Die Hard W | | | Stirb Lang | | | Die Hard W | | | 39.99 | 7.00 | | 30.05.2006 | 10 | Fox | Taxable Go | EP_STATUS_ Updated | DVD-LTWP | dvd/lethal | Lethal Wea | | | Zwei stahl | | | Lethal Wea | | | 34.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated | DVD-REDC | dvd/red_co | Red Corner | | | Labyrinth | | | Red Corner | | | 32 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated | DVD-FRAN | dvd/franti | Frantic | | | Frantic | | | Frantic | | | 35 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated | DVD-CUFI | dvd/courag | Courage Un | | | Mut Zur Wa | | | Courage Un | | | 38.99 | 7.00 | | 30.05.2006 | 10 | Fox | Taxable Go | EP_STATUS_ Updated | DVD-SPEED | dvd/speed. | Speed | | | Speed | | | Speed | | | 39.99 | 7.00 | | 30.05.2006 | 10 | Fox | Taxable Go | EP_STATUS_ Updated | DVD-SPEED2 | dvd/speed_ | Speed 2: C | | | Speed 2: C | | | Speed 2: C | | | 42 | 7.00 | | 30.05.2006 | 10 | Fox | Taxable Go | EP_STATUS_ Updated | DVD-TSAB | dvd/theres | There\'s S | | | There\'s S | | | There\'s S | | | 49.99 | 7.00 | | 30.05.2006 | 10 | Fox | Taxable Go | EP_STATUS_ Updated | DVD-BELOVE | dvd/belove | Beloved | | | Menschenki | | | Beloved | | | 54.99 | 7.00 | | 30.05.2006 | 10 | Warner | Taxable Go | EP_STATUS_ Updated | PC-SWAT3 | sierra/swa | SWAT 3: Cl | | www.swat3. | SWAT 3: El | | www.swat3. | SWAT 3: Cl | | www.swat3. | 79.99 | 7.00 | | 30.05.2006 | 16 | Sierra | Taxable Go | EP_STATUS_ Updated | PC-TWOF | gt_interac | The Wheel | | www.wheelo | The Wheel | | www.wheelo | The Wheel | | www.wheelo | 99.99 | 10.00 | | 30.05.2006 | 16 | GT Interac | Taxable Go | EP_STATUS_ Updated | PC-DISC | gt_interac | Disciples: | | | Disciples: | | www.strate | Disciples: | | | 90 | 8.00 | | 30.05.2006 | 17 | GT Interac | Taxable Go | EP_STATUS_ Updated | MSINTKB | microsoft/ | Microsoft | | | Microsoft | | | Microsoft | | | 69.99 | 8.00 | | 30.05.2006 | 16 | Microsoft | Taxable Go | EP_STATUS_ Updated | MSIMEXP | microsoft/ | Microsoft | | www.micros | Microsof I | | | Microsoft | | www.micros | 64.95 | 8.00 | | 30.05.2006 | 10 | Microsoft | Taxable Go | EP_STATUS_ Updated | HPLJ1100XI | hewlett_pa | Hewlett Pa | | www.pandi. | Hewlett-Pa | | www.hp.com | Hewlett Pa | | www.pandi. | 499.99 | 45.00 | | 30.05.2006 | 8 | Hewlett Pa | Taxable Go | EP_STATUS_ Updated | TEST1 | hewlett_pa | Denne vare | | www.pandi. | Denne vare | | www.hp.com | Dette er e | | www.pandi. | 500.00 | 4300.00 | | 30.05.2006 | 8 | Hewlett Pa | Taxable Go | EP_STATUS_ !New Product! 1136 - Column count doesn't match value count at row 1 INSERT INTO products ( products_image, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'hewlett_packard/lj1100xi.gif', 'TEST1', '500.00', '', '1', CURRENT_TIMESTAMP, "30.05.2006 15:03", NULL, '1', '4300.00', '8', '9') [TEP STOP] The file im importing is: v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_name_2 v_products_description_2 v_products_url_2 v_products_name_3 v_products_description_3 v_products_url_3 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_tax_class_title v_status EOREOR MG200MMS matrox/mg200mms.gif Matrox G200 MMS www.matrox.com/mga/products/g200_mms/home.cfm Matrox G200 MMS www.matrox.com/mga/deutsch/products/g200_mms/home.cfm Matrox G200 MMS www.matrox.com/mga/products/g200_mms/home.cfm 299.99 23.00 30.05.2006 15:03 32 Matrox Taxable Goods EP_STATUS_ACTIVE EOREOR MG400-32MB matrox/mg400-32mb.gif Matrox G400 32MB www.matrox.com/mga/products/mill_g400/home.htm Matrox G400 32 MB www.matrox.com/mga/deutsch/products/mill_g400/home.cfm Matrox G400 32MB www.matrox.com/mga/products/mill_g400/home.htm 499.99 23.00 30.05.2006 15:03 32 Matrox Taxable Goods EP_STATUS_ACTIVE EOREOR MSIMPRO microsoft/msimpro.gif Microsoft IntelliMouse Pro www.microsoft.com/hardware/mouse/intellimouse.asp Microsoft IntelliMouse Pro Microsoft IntelliMouse Pro www.microsoft.com/hardware/mouse/intellimouse.asp 49.99 7.00 30.05.2006 15:03 2 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-RPMK dvd/replacement_killers.gif The Replacement Killers www.replacement-killers.com Die Ersatzkiller www.replacement-killers.com The Replacement Killers www.replacement-killers.com 42 23.00 30.05.2006 15:03 13 Microsoft Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-BLDRNDC dvd/blade_runner.gif Blade Runner - Director\'s Cut www.bladerunner.com Blade Runner - Director\'s Cut www.bladerunner.com Blade Runner - Director\'s Cut www.bladerunner.com 35.99 7.00 30.05.2006 15:03 17 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-MATR dvd/the_matrix.gif The Matrix www.thematrix.com Matrix www.whatisthematrix.com The Matrix www.thematrix.com 39.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-YGEM dvd/youve_got_mail.gif You\'ve Got Mail www.youvegotmail.com e-m@il f?r Dich www.youvegotmail.com You\'ve Got Mail www.youvegotmail.com 34.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-ABUG dvd/a_bugs_life.gif A Bug\'s Life www.abugslife.com A Bug\'s Life www.abugslife.com A Bug\'s Life www.abugslife.com 35.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-UNSG dvd/under_siege.gif Under Siege Alarmstufe: Rot Under Siege 29.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-UNSG2 dvd/under_siege2.gif Under Siege 2 - Dark Territory Alarmstufe: Rot 2 Under Siege 2 - Dark Territory 29.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-FDBL dvd/fire_down_below.gif Fire Down Below Fire Down Below Fire Down Below 29.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-DHWV dvd/die_hard_3.gif Die Hard With A Vengeance Stirb Langsam - Jetzt Erst Recht Die Hard With A Vengeance 39.99 7.00 30.05.2006 15:03 10 Fox Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-LTWP dvd/lethal_weapon.gif Lethal Weapon Zwei stahlharte Profis Lethal Weapon 34.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-REDC dvd/red_corner.gif Red Corner Labyrinth ohne Ausweg Red Corner 32 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-FRAN dvd/frantic.gif Frantic Frantic Frantic 35 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-CUFI dvd/courage_under_fire.gif Courage Under Fire Mut Zur Wahrheit Courage Under Fire 38.99 7.00 30.05.2006 15:03 10 Fox Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-SPEED dvd/speed.gif Speed Speed Speed 39.99 7.00 30.05.2006 15:03 10 Fox Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-SPEED2 dvd/speed_2.gif Speed 2: Cruise Control Speed 2: Cruise Control Speed 2: Cruise Control 42 7.00 30.05.2006 15:03 10 Fox Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-TSAB dvd/theres_something_about_mary.gif There\'s Something About Mary There\'s Something About Mary There\'s Something About Mary 49.99 7.00 30.05.2006 15:03 10 Fox Taxable Goods EP_STATUS_ACTIVE EOREOR DVD-BELOVED dvd/beloved.gif Beloved Menschenkind Beloved 54.99 7.00 30.05.2006 15:03 10 Warner Taxable Goods EP_STATUS_ACTIVE EOREOR PC-SWAT3 sierra/swat_3.gif SWAT 3: Close Quarters Battle www.swat3.com SWAT 3: Elite Edition www.swat3.com SWAT 3: Close Quarters Battle www.swat3.com 79.99 7.00 30.05.2006 15:03 16 Sierra Taxable Goods EP_STATUS_ACTIVE EOREOR PC-TWOF gt_interactive/wheel_of_time.gif The Wheel Of Time www.wheeloftime.com The Wheel Of Time www.wheeloftime.com The Wheel Of Time www.wheeloftime.com 99.99 10.00 30.05.2006 15:03 16 GT Interactive Taxable Goods EP_STATUS_ACTIVE EOREOR PC-DISC gt_interactive/disciples.gif Disciples: Sacred Lands Disciples: Sacred Land www.strategyfirst.com/disciples/welcome.html Disciples: Sacred Lands 90 8.00 30.05.2006 15:03 17 GT Interactive Taxable Goods EP_STATUS_ACTIVE EOREOR MSINTKB microsoft/intkeyboardps2.gif Microsoft Internet Keyboard PS/2 Microsoft Internet Tastatur PS/2 Microsoft Internet Keyboard PS/2 69.99 8.00 30.05.2006 15:03 16 Microsoft Taxable Goods EP_STATUS_ACTIVE EOREOR MSIMEXP microsoft/imexplorer.gif Microsoft IntelliMouse Explorer www.microsoft.com/hardware/mouse/explorer.asp Microsof IntelliMouse Explorer Microsoft IntelliMouse Explorer www.microsoft.com/hardware/mouse/explorer.asp 64.95 8.00 30.05.2006 15:03 10 Microsoft Taxable Goods EP_STATUS_ACTIVE EOREOR HPLJ1100XI hewlett_packard/lj1100xi.gif Hewlett Packard LaserJet 1100Xi www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100 Hewlett-Packard LaserJet 1100Xi www.hp.com Hewlett Packard LaserJet 1100Xi www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100 499.99 45.00 30.05.2006 15:03 8 Hewlett Packard Taxable Goods EP_STATUS_ACTIVE EOREOR TEST1 hewlett_packard/lj1100xi.gif Denne varen er min www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100 Denne varen er min www.hp.com Dette er en testvare www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100 500.00 4300.00 30.05.2006 15:03 8 Hewlett Packard Taxable Goods EP_STATUS_ACTIVE EOREOR I have copied one of the other products and just made som changes to names and sow on. When i tried to upload the original productfile only, i got an error in every product description because some of the names was something like the bug's life. Is there some way i can make the script ignore this and insert it with the bug\'s life on itself? Best Regards Thomas B

Janz, Thanks for your help :D Now it worked for me too. Your the best :D Best Regards Thomas B.

I figured it out tonight. The problem i made was not to upload the scrambled_order_num.php file where it belonged on my live webserver :D Thanks again for an great contribution. Best Regards Thomas B

I just want to say thanks for an great contribution. I have installed it and all worked great on my localhost, but when i uploaded it to my live website i only get blank pages, on account.php, account_history.php, account_history_info.php and all admin files that has something to do with the orders. Does anyone know the answer to this? Is there some versions of php i supports and some not or is there something else i have to do? Thanks in advance Best Regards Thomas Borge

Janz, Thanks for your reply :D I tried the code, but it doesn't seems to remember the customers_group. I still see the wrong information and wrong shipment methods for the customers. Do you have any other suggestions? Best Regards Thomas B

Hi, Im using this great contribution Batch print center. Everything works for printing and sow. But when printing packing slip i get the line across Verified by, and all the text is outside the boxes. Is there someone that nows how i can fix it?. I have tried to figure it out, but im not that good in php sow i didn't manage it. Cheers Thomas B

Hi, Thanks for an great contribution. I have installed Separate Pricing Per Customer 413, and it works great. I wanted to make the seperate pricing per customer work on it own, and therefore i made an checkbox just like gender on create account. When an customer clicks on company or private it choose the right id for the customer group. But it seems that when they have finished register the customer group is right but the values for the customer does show right. Like the company should only be able to make payment by invoice and prices is exl. But it shows up with taxes and not the invoice payment but ordinary post as the private customer group has. And to fix it the customer must log out and in again. When he dos this all works as it should. Does anybody nows how to make this work without any problems sow that the customer must login and out again? Hope somebody can help me because im stuck here. Best Regards Thomas B

Hi, I have installed More Category Boxes on my web site. Im trying to make this include the theme i have bougt for my site. Tried to make it work, but dont get it all to work. Here is the code for the original file that i want to implement sow that the design is right on the More Categoy Boxes script. Hope somebody can help me :D The script is just fantastic when you want seperate categories. Thanks :thumbsup: Best Regards Thomas B

I also have this problem with this module. Mean somebody talked about have to change the format of the weight in the sql database? can this be right? -Thomas-

I have installed the import/export module and everything is working great :D But can somebody help me with making two things work. 1. product information link 2. Picture link like http//.www.website.com/images/xxxx.jpg now it's only xxx.jpg Hope someboy can help me here. Best Regards Thomas Borge

I have installed the latest version of kelkoo export. But it seems that this one doesn't take out more than the main categorie, and kelkoo requires all categories. Like computer - Hp and not just Computer. Else it looked great :D Hopes somebody can help me with this. -Thomas-

I have installed the newest version of great contribution and think its great. But i have one problem. I dont now how to fix it. In the categories i get an big jump between the lines, is there somehow to fix this? I want the menu to be like the original oscommerce menu but with with to images, one for the main categories and one for the subcategories. like on the picture. Also i put in an image of the categories -Thomas-

Hello, I also have problems with the credit card module. I norway we have 16 digits in our card number. + 3 safety digits. But when i enter the first numbers that usualy is 4925 i get an error that that number isn't an valid number. Does anybody now why? I use the basic credit card module since i use an external payment terminal. Hope you guys can help me. -Thomas-

Hi everyone. I have just installed version 1.2B and everything works fine in admin. But when i tries to read the article i get the same errors as rag here. But i haven't Header Tags and STS installed. Does anyone now what is wrong here? The contribution looks great :D Thanks Thomas

Janz, I did as you told me too and this is what i got Array ( [0] => ) Is this right or should it be more here? Thanks for your help. Best Regards Thomas Borge

Janz, In the array the product name and the products image is there but not shown. Here is the array it printed. Array ( [0] => Array ( [products_image] => DKU-2.jpg [products_name] => Nokia Data Cable DKU-2 [products_id] => 31 [manufacturers_id] => 10 [products_price] => 319.2000 [products_tax_class_id] => 1 [specials_new_products_price] => [final_price] => 319.2000 [master_id] => 28 [slave_id] => 31 ) ) Best Regards Thomas Borge