Jump to content

w3it

Members
  • Content count

    77
  • Joined

  • Last visited

Everything posted by w3it

  1. Hi Theo How did you get on? I am doing something similar right now. You edit the zones module to have 4 zones. Then when you install the module, you will see four zone entry methods. Enter your provinces per zone and the weight to price ratios. Ian
  2. Hi I had this. Its actually the bottom line. Make sure there are no blank line outside the <?php tags. Ian
  3. Hi, has anyone tried to install Wayne Wetterhahns contribution into MS2? If so were there any problems to look out for? Thanks Ian
  4. how good is your SQL? That error denotes something is wrong with the SQL comment. At first glance and until I get this module installed try this: select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by limit '0, 20' I'm hoping to get to this module soon. So I will play catch up then. Ian
  5. Care to elaborate a bit. I am persisting with this as a client of mine is interested in such a module (donation coming of course), but just from what I read here is might not be a good idea to place on MS2? Your thoughts people. Thanks, Ian
  6. Thanks. Its actually under MS2 that I'm deploying this on first. Any more comments out there? In short, it works in the end right? :? Ian
  7. Hi been reading this thread and wondered how easy/stable this contribution is under both MS1 and MS2. Any problems or suggestions, that I should be aware of? I have a virgin MS1 and MS2 but one shop is a "mess" of contributions and I wondered what experiences people have been having. Thanks for any response. Ian
  8. w3it

    stable?

    duh! lets post it in the thread shall we...! :roll:
  9. w3it

    stable?

    Hi been reading this thread and wondered how easy/stable this contribution is under both MS1 and MS2. Any problems or suggestions, that I should be aware of? I have a virgin MS1 and MS2 but one shop is a "mess" of contributions and I wondered what experiences people have been having. Thanks for any response. Ian
  10. w3it

    easy populate error

    I know the urge is to "install and go" but just look at how much time has been involved in sorting out issues. It takes 10 minutes to read the manual and get an understanding. 30 seconds for the text file that comes with the image mod. I cannot back loxly enough. Read up and become your own expert. Its worth it in the end. "duplicate products" ... impossible if you follow how to setup correctly with EP. Its a database thing! The db will not allow duplicate records... it will allow duplicate product names though... hint! Best Ian
  11. w3it

    easy populate error

    You really need to read the manuals. Read the text file that comes with dynamic mo pics. Ian
  12. w3it

    easy populate error

    Yes it does and for every language too. Check your <table> tags layout... Ian
  13. w3it

    easy populate error

    Yes it does and for every language too. Check your <table> tags layout... Ian
  14. w3it

    easy populate error

    I see, I did not page down that far. You seem to be having a hard time with this! Any chance you have been editing some osc files? product_info.php for example? Ian
  15. w3it

    easy populate error

    Looked ok to me, what do you mean? Ian
  16. w3it

    easy populate error

    Absolutely! I made a mod to MS1 so that when the upload completes, instead of an error message, you will now see a message that it completed ok. I also added a record count so you see how many products were actually uploaded. Best Ian
  17. w3it

    easy populate error

    Thank Christ for that :D I must say you had me worried there for a while. Well done! Best Ian
  18. w3it

    easy populate error

    Follow Loxlys advice and readup on the mod and what you need to do. In EP, where it says uncomment, thats all you need do. Do not edit the other code at will if you do not know what you are doing. The error 1690 and the parse errors you mentioned point to more than just uncommenting. Have a good weekend... Ian
  19. w3it

    easy populate error

    I can recommend one aswell ;) Ian
  20. w3it

    easy populate error

    I get this after every product, but nothing shows in catalog or admin Yes I am an end user, however, I don't have much experience. The only reason I'm looking at using this is I have a supplier who has the products in a dat file. I am putting together another store under MS2 using different products than my MS1 store. I really don't want to hand input 250+ items. I know I'm getting close, I'm in the process of changing the field names. I wanted to use big images, but it doesn't work on MS2, so I'm installing dynamic mo-pics and having trouble configuring. I have 2 sets of images, 1 set thumbs, 1 set regular size. I want the thumbs for product_info and the reg for pop-up. Can your hosting service help or is it a "we offer but dont support" hosting package you have? Its like loxly was hinting at, if you are moving away from the "standard" install that your hosting company provide, then you will need to know what buttons to push. I take it you have read the manual? Have a go with the images, if you dont have any success, dare I say it... come on back! Seriously though, think about a supported oscommerce service, you might find it a lot cheaper in the long run. Best Ian
  21. w3it

    easy populate error

    This line appears at the end of every successful upload. It is looking for more products and you have to come to an end at some point! It is NOT a real error. Hi Loxly to put you in the picture as this has been a bit of an epic, in chfields case he has not had a successful upload at all. If EP cannot find a field called "product_model" then EP exists with an error "No products_model field in record. This line was not imported", that much is true. However it is not the case that it appears at the end of every successful upload. It can appear in an unsuccessful upload too. It is merely the last loop of an if statement in the code and unfortunately instead of there being one more loop to say "file upload success" (maybe I'll put that mod in?), the current program simply finishes by displaying this error message. It seems someone informed you that this can be interpreted as being a successful upload. The message says "No products_model field in record. This line was not imported" - and that is exactly what it means. Yes it does display it at the end of a successful upload... it also displays it when the "products_model" is not found. To demonstrate. Take a .txt file and rename the products_model field to sku (or something). Run EP and you will see this output below: ................................................................................ ........ File uploaded. Temporary filename: /tmp/php8fqcrB User filename: mpqtest.txt Size: 94 | 15000 | 480 | 1000 No products_model field in record. This line was not imported | 19110 | 40 | 1000 No products_model field in record. This line was not imported | | | No products_model field in record. This line was not imported ................................................................................ ........ Two records, a blank line(EOF) and no products_model field will give 3 error messages. The actual problem is that there is no check for the end of the file, EOF, which could then display a message like <b>upload successful</b>. It IS a real error and the fault lies in the way the program terminates. However you will not read that in the manual. Best Ian
  22. w3it

    easy populate error

    Hi I'll have a look through the code. FIELD SEPERATOR Here is something I missed that might help you. You can set your OWN field seperator! No need therefore to replace what you had with TABs. Sorry about that. COLUMN PLACEMENT From looking at the code, no you do not need to specify the column layout. You must lable the columns with the EP know column field names but you do not have to move them around. IMAGES You have a lot of questions! Are you an end user? I take it your hosting company does not give you much support! I found code that will support an image mod. You might like to look into that. We'll get there... Ian
  23. w3it

    easy populate error

    Hi hold your horses! All you have to do is match your table fields to the EP table fields. I would rather do that than type 5 products in by hand. For example SKU replace with v_product_model, weight replace with v_weight, etc. Drop the itemid column. If you still do not see, tell me and we'll try to clear this up, as typing all your products in is what EP is built to automate! That is the point of EP. I'm obviously not getting my point across if you think typing everything in will take just as long. Out of interest, how many products are you thinking of entering? Best Ian
  24. w3it

    easy populate error

    Well I can see where the confusion lies! EP expects the .txt file to have headings like the following: v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_head_title_tag_1 v_products_head_desc_tag_1 v_products_head_keywords_tag_1 v_products_name_2 v_products_description_2 v_products_url_2 v_products_head_title_tag_2 v_products_head_desc_tag_2 v_products_head_keywords_tag_2 v_products_name_3 v_products_description_3 v_products_url_3 v_products_head_title_tag_3 v_products_head_desc_tag_3 v_products_head_keywords_tag_3 v_products_name_4 v_products_description_4 v_products_url_4 v_products_head_title_tag_4 v_products_head_desc_tag_4 v_products_head_keywords_tag_4 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_tax_class_title v_status EOREOR You will have to rename all the columns to support this. Also, make sure to include v_status where you have "active" in the data. When you make a download .txt using the EP system, you will see these headings. The headings you have are standard, but not what EP is expecting for it to work. For furher information and an "understanding of what you are using"... read the documentation. Best Ian
×