Jump to content

allaudio

Members
  • Content count

    26
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Jeff Ladd
  1. thanks, a million! that fix got my 1300 products loaded. now, if my other supplier's product list is as easy to edit as this I'll have a fully loaded store. now, all I have to do is get about 50 mb of images loaded
  2. Well, I have lots of commas in my descriptions. How can I fix this error? There is no way I can take commas out of several thousand product descriptions. Is there no way for EP to read with the commas? What is your suggestion?
  3. Mibble, Can you help with this one? 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'power cord
  4. it looks as though it was set to semicolons? AverageJoe, you're awesome! I actually got a few products uploaded with your suggestion. Now here is my next error: File uploaded. Temporary filename: /tmp/phpQ4c8dK User filename: testwmalpha1.txt Size: 108209 | 12158 | www.wholes | Canvas Car | Holds GPS | | 19.95 | 0.16 | | 30-May-05 | 25 | Magellan | ELECTRONIC | taxable go | active !New Product! | 91599 | www.wholes | Telephone | Decora Sty | | 4.95 | 0.1 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 42075 | www.wholes | 3-Port Qui | QuickPort | | 55.95 | 0.04 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 91600 | www.wholes | Dual Rocke | Decora Com | | 12.95 | 0.18 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 12149 | www.wholes | Universal | Swivel act | | 9.95 | 0.08 | | 30-May-05 | 25 | Superior C | ELECTRONIC | taxable go | active !New Product! | 12151 | www.wholes | Dual-Mode | UniversalW | | 19.95 | 0.25 | | 30-May-05 | 25 | Superior C | ELECTRONIC | taxable go | active !New Product! | 91601 | www.wholes | Dual Rocke | Decora Com | | 12.95 | 0.19 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 91602 | www.wholes | Three Rock | Decora Com | | 16.95 | 0.19 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 91603 | www.wholes | Telephone | Decora Sty | | 4.95 | 0.1 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 42076 | www.wholes | 3 Port Qui | QuickPort | | 55.95 | 0.7 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 42077 | www.wholes | Blank Wall | Modules sn | | 6.95 | 0.04 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 91605 | www.wholes | Three Rock | Decora Com | | 16.95 | 0.19 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 91606 | www.wholes | Three Rock | Decora Com | | 16.95 | 0.19 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 42078 | www.wholes | Single Gan | Smooth-fac | | 2.95 | 0.06 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 42079 | www.wholes | Triple Gan | Smooth-fac | | 7.95 | 0.12 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 42080 | www.wholes | Quadruple | Smooth-fac | | 12.95 | 0.15 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 91607 | www.wholes | Telephone | Decora Sty | | 4.95 | 0.1 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 42081 | www.wholes | 3 Port Qui | QuickPort | | 55.95 | 0.71 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 42082 | www.wholes | Blank Wall | Modules sn | | 6.95 | 0.02 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 91608 | www.wholes | Dual Rocke | Decora Com | | 12.95 | 0.18 | | 30-May-05 | 25 | Leviton | ELECTRONIC | taxable go | active !New Product! | 51640 | www.wholes | The Boss P | For areas | | 449.95 | 25.8 | | 30-May-05 | 25 | Eureka | ELECTRONIC | taxable go | active !New Product! 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'power cord 484 watt air power with 101.2 CFM air flow 137 INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url) VALUES ( '48', 1, 'The Boss Plus', ' For areas up to 8000 square feet 3 stage motor with 12.9 amps Utility/inlet valve and ABS construction 6.6 gallon dirt container and 6' power cord 484 watt air power with 101.2 CFM air flow 137" water lift and weigh 29lbs Permanently self-cleaning cloth filter, outside venting not required May be used as cyclonic or with Filteraire disposable paper bags 15" diameter x 37"H', '' )
  5. any good suggestions on where i can buy a 3rd party cart system? oh, you're using EP also. and looks like you don't know how to use it either. maybe you could limit your comments to either questions about the problems you are having with the system or solutions on how to fix someone else's problems. after all, that's what this forum is for. not for you to attack me for my frustrations. thanks B)
  6. Do you see any errors in my data? This is copied straight from the file in /catalog/temp/ - the file being uploaded from EP. EP is obviously uploading the files, but no products are being added to my catalog: v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_tax_class_title v_status EOREOR 12158 www.wholesalemarketer.com/images/products/1/big_jpegs/A404medium_part1/00-69032-000.jpg Canvas Carry Case "<li>Holds GPS receiver and spare batteries<li>Zipper opening, large belt loop<li>Padded and durable canvas" 19.95 0.16 30-May-05 25 Magellan ELECTRONICS taxable goods active EOREOR 91599 www.wholesalemarketer.com/images/products/1/0 Telephone Wall Jack <li>Decora Style telephone wall jack<li>4 conductor wall jack<li>Attractive Decora styling compliments any interior 4.95 0.1 30-May-05 25 Leviton ELECTRONICS taxable goods active EOREOR 42075 www.wholesalemarketer.com/images/products/1/big_jpegs/A404medium_part1/000-40803-0BI.jpg 3-Port QuickPort Flush Mount Wall Plate <li>QuickPort modules snap right in<li>Includes color-matched mounting screws 55.95 0.04 30-May-05 25 Leviton ELECTRONICS taxable goods active EOREOR 91600 www.wholesalemarketer.com/images/products/1/0 Dual Rocket Switches <li>Decora Combination dual single-pole rocker switches<li>Rated: Individual switch 15A-120V AC / Device total 20A-120V AC<li>Attractive Decora styling compliments any interior<li>Space-saving device for kitchens and bathrooms 12.95 0.18 30-May-05 25 Leviton ELECTRONICS taxable goods active EOREOR
  7. What fields are required in the header? If I don't use attributes, etc. can those fields be deleted? Would having no data in certain fields prevent EP from uploading my data?
  8. Problem I see with error in data is that the EP doesn't know how to read product descriptions. I notice that my inventory file descriptions are read by Excel as multiple fields. It doesn't appear to matter whether it is saved as tab delimited, csv, or other format. The descriptions simply don't remain in one field, which throws the whole file off. Any fix? Anything I can do in Excel to fix this without manually eliminating tabs, returns, semicolons, etc in every product record? I have several thousand products I need to upload to my cart.
  9. So, how do you fix an error with the data? I tried to upload the sample inventory file that came with EP download. I got 1 product to load.
  10. Andrew, I appreciate your concern, but I get no software support from my web host. osCommerce doesn't have a "manual" to speak of. And, this EP contribution seems to be just another extension of the nonsense way in which a person has to spend countless hours trying to get things running, when they ought to be spending their time marketing their product/service offerings. I assume everyone here has a product or service to market. Otherwise, why would you need osCommerce to begin with, much less EP. So, in a forum full of so called "business people, entrepreneurs, sales people, etc", why is it that we all want to spend so much time trying to develop and test technology? I am looking for a solution that allows me to plug it in, and get to selling. That's what I am here for. I don't know about the rest of you. And, this EP doesn't work, just like osCommerce doesn't work. So many bugs and so much corruption, all I can do is keep reinstalling. And starting over. And reinstalling. And starting over. And it never works. So, again Andrew, while I appreciate your concern, your energy would be better spent on a solution rather than commenting on my harsh criticisms of the developer of this contribution. After all, what is a contribution for? And what is this forum for? To help those of us poor numbskulls that just want to use the software that just doesn't seem to work. The forum only really has 2 purposes: contribute or complain. Since I can't contribute anything, I'll just stick to complaining. Okay with you?
  11. I am fed up. I have spent 3 days trying to upload products and am no further than I was when I began. I did get 1 product to upload from the list of 28 that came in EP2005May29-2210 file with the EP contrib download. So, if the person that created the contribution can't provide a format that works with his contribution, how am I supposed to make it work on my product database?
  12. i just reinstalled the easy populate and now it appears to load products, but no data, no products: File uploaded. Temporary filename: /tmp/phpFLhTmt User filename: test1.txt Size: 3874 This was the result of attempting to load 1 product. Looks like it was uploaded, but there is no product. Yes, permissions are set.
  13. this is line 666 in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 666: // get the entire file into an array $readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name); } this is line 689 in /home/allaudio/public_html/catalog/admin/easypopulate.php : // now we string the entire thing together in case there were carriage returns in the data $newreaded = ""; foreach ($readed as $read){ $newreaded .= $read; Is there an error here, or somewhere else?
  14. Here is what I am getting this morning with one line of data: File uploaded. Temporary filename: /tmp/php0oaPXo User filename: test1.txt Size: 3874 Warning: file(/home/allaudio/public_html/catalog/temp/test1.txt): failed to open stream: No such file or directory in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 666 Warning: Invalid argument supplied for foreach() in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 689
  15. Okay, changed that. Here is what I get now: File uploaded. Temporary filename: /tmp/php3A05Pu User filename: megagoods5.txt Size: 57086 But, still no products present.
×