Guest Posted June 2, 2008 Share Posted June 2, 2008 Hi! I had an earlier version of EP installed and now I installed 2.76g. Before and now too, I can't download the complete .csv file to edit. I did it a couple of times - I don't know how and why, I suppose because I did it at night, but now I can't at all - I get an error: Internet Explorer cannot display the webpage and that's it. I have about 600 products and the details for EP are these: EP vers: 2.76g-MS2 osCommerce 2.2-MS2 OS: Linux 2.6.12-1.1381_FC3smp HTTP: Apache/1.3.34 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2635 DB: MySQL 4.1.22-standard-log PHP: 4.3.11 (Zend: 1.3.0) Temp Directory: /home/*****/public_html/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: on Split files on: 300 records Model Num Size: 16 Price with tax: true Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false Why isn't it working? Thank you. Quote Link to comment Share on other sites More sharing options...
surfalot Posted June 2, 2008 Share Posted June 2, 2008 why, is this something that's been tried already, from that contribution? it already has an entry in the db in the products_attributes category, "options_values_weight" ..same place you get options_value_price and options_value_id. I'll mess around with it over the weekend... I don't know of any that have tried it. Quote Link to comment Share on other sites More sharing options...
nudylady Posted June 2, 2008 Share Posted June 2, 2008 how do you submit to google base? It gives .csv. but.txt or .xml is required Quote Link to comment Share on other sites More sharing options...
surfalot Posted June 2, 2008 Share Posted June 2, 2008 how do you submit to google base? It gives .csv. but.txt or .xml is required please use a google base contrib. it is not correct in EP and will not be supported in the future. Quote Link to comment Share on other sites More sharing options...
Guest Posted June 3, 2008 Share Posted June 3, 2008 Hi. I managed this morning to download a custom .csv file, but I can't open it completely with Excel - it doesn't totally load. How do I solve this? I'm sure it's answered somewhere, but I can't find the solution. Thanks. Quote Link to comment Share on other sites More sharing options...
surfalot Posted June 3, 2008 Share Posted June 3, 2008 Hi. I managed this morning to download a custom .csv file, but I can't open it completely with Excel - it doesn't totally load. How do I solve this? I'm sure it's answered somewhere, but I can't find the solution. Thanks. Can I look at the file? Can you download partial files using the category/manufacturer filters I added? Quote Link to comment Share on other sites More sharing options...
jayc2004 Posted June 4, 2008 Share Posted June 4, 2008 I am getting the following error message at the top when I try to upload my file back to my db. Filename: EP2008Jun03-12124.csv Warning: Invalid argument supplied for foreach() in /home/melsfire/public_html/catalog/admin/easypopulate.php on line 1185 Does anyone know more about this message? Quote Link to comment Share on other sites More sharing options...
Guest Posted June 4, 2008 Share Posted June 4, 2008 I managed this morning to download a complete csv file - I didn't use the category or manufacturer filter. When I try to open the file with Excel I get this error : "File not loaded completely" "This error is usually encountered when an attempt to open a file with more than 65,536 rows or 256 columns is made. Excel is limited to 65,536 rows of data and 256 columns per worksheet. You can have many worksheets with this number of rows and columns, but they are usually capable of fitting into one workbook (file). The number of worksheets you can have per workbook is limited only by the amount of available memory your system has. By default, Excel can manage 3 worksheets, more if there is available memory to support the quantity of data. Truncation of rows or columns in excess of the limit is automatic and is not configurable. This issue can usually be remedied by opening the source file with a text editor, such as Microsoft Office Word, and then saving the file off into multiple files with row or column counts within the limits of an Excel worksheet. These files can then be opened or imported into Excel worksheets. If you are using a data format that does not support use of a text editor, it may be easier to import the data into Microsoft Office Access and then use the export feature of Access to import the data to an Excel format. Other methods of importing large source material into multiple worksheets are available, but may be more complex than using either a text editor or Access." But now, although I get this error the file loads completly and I can use it to upload data in another osc shop. I have no idea why yesterday it wasn't ok and now it is almost ok.... (if I had more attributes - more columns, the data wouldn't fit , because the Excel workshet suddenly ends somewhere on the right). I still have a problem or two: - On some rows the product description is messed up, actually the formatting: <FONT face='\"arial,' size=2 sans-serif\? helvetica,> and it gives an error when uploading. This is for about 20 prodcts out of 600. If I manually look for errors like this and correct them it's ok when uploading. - For some products data appears not on one row, but on two, product_model ok, product_name ok, but then product description on two rows, in the columns for other data. Hard to explain... I'd show you the file, how do I do that? Anyway, with all the problems I have, this is a great contribution, it helps me a lot and I have to say a biiig Thank you! for it. Quote Link to comment Share on other sites More sharing options...
surfalot Posted June 6, 2008 Share Posted June 6, 2008 I managed this morning to download a complete csv file - I didn't use the category or manufacturer filter.When I try to open the file with Excel I get this error : "File not loaded completely" "This error is usually encountered when an attempt to open a file with more than 65,536 rows or 256 columns is made. Excel is limited to 65,536 rows of data and 256 columns per worksheet. You can have many worksheets with this number of rows and columns, but they are usually capable of fitting into one workbook (file). The number of worksheets you can have per workbook is limited only by the amount of available memory your system has. By default, Excel can manage 3 worksheets, more if there is available memory to support the quantity of data. Truncation of rows or columns in excess of the limit is automatic and is not configurable. This issue can usually be remedied by opening the source file with a text editor, such as Microsoft Office Word, and then saving the file off into multiple files with row or column counts within the limits of an Excel worksheet. These files can then be opened or imported into Excel worksheets. If you are using a data format that does not support use of a text editor, it may be easier to import the data into Microsoft Office Access and then use the export feature of Access to import the data to an Excel format. Other methods of importing large source material into multiple worksheets are available, but may be more complex than using either a text editor or Access." But now, although I get this error the file loads completly and I can use it to upload data in another osc shop. I have no idea why yesterday it wasn't ok and now it is almost ok.... (if I had more attributes - more columns, the data wouldn't fit , because the Excel workshet suddenly ends somewhere on the right). I still have a problem or two: - On some rows the product description is messed up, actually the formatting: <FONT face='\"arial,' size=2 sans-serif\? helvetica,> and it gives an error when uploading. This is for about 20 prodcts out of 600. If I manually look for errors like this and correct them it's ok when uploading. - For some products data appears not on one row, but on two, product_model ok, product_name ok, but then product description on two rows, in the columns for other data. Hard to explain... I'd show you the file, how do I do that? Anyway, with all the problems I have, this is a great contribution, it helps me a lot and I have to say a biiig Thank you! for it. What version of Office are you using? no need to see the file, you told me what I needed to know. MS Office 2007 (and maybe Open Office) doesn't have the column limit. If you open the file like you have, and resave it, you may loose data. If you see a description wrap down to a second row, that is OK. It means there is a [RETURN] embedded in the description. That version of EP should handle that, and it should not affect the import. I have to say, I am a little surprised that some HTML is causing problems on the import. It may have something to do with country specific settings and your office. I would like see is a small portion of the export that contains the description causing the problem. You can put the file on your web-space and post or PM me the link to it. Quote Link to comment Share on other sites More sharing options...
surfalot Posted June 6, 2008 Share Posted June 6, 2008 I am getting the following error message at the top when I try to upload my file back to my db. Filename: EP2008Jun03-12124.csv Warning: Invalid argument supplied for foreach() in /home/melsfire/public_html/catalog/admin/easypopulate.php on line 1185 Does anyone know more about this message? welcome to the forums Jason. When posting a problem, you need to provide much more information for someone to help you. Info like the version of EP you are using, the PHP version, the EP settings you are using, and a sample of the file you are importing. The versions of EP I have uploaded have a section in the Docs called Support. It has instructions about how to ask for help. Also, be sure to read through the forum rules (link at top of page). It also has tips on how to organize a post that will generate a response. Quote Link to comment Share on other sites More sharing options...
laptop13 Posted June 6, 2008 Share Posted June 6, 2008 I am sure this has been answered but the search function is pulling up tons of links to everywhere but on this thread. If you are running the latest version of oscom, which version should i be using? Also im assuming this is the contrib i need in the first place. i am trying to lower a portion of my products price by 5% in one shot rather then doing them one by one, Is EP going to help me do that? Quote Link to comment Share on other sites More sharing options...
Guest Posted June 6, 2008 Share Posted June 6, 2008 I don't know of any that have tried it. Well, now you can say you don't know of anyone that's tried it successfully :D . I do believe it can be done easily though...just not by me. I was trying to replicate the options_values_price into weight, which I do believe is the key, but there were too many other variables that I don't understand enough, messing me up. I found someone from 2005 that says it would be easy to do, so I sent her a line, no response. probably moved on in life. Too bad, it's really a valuable contribution that would be awesome to have work with this. Oh well, Thanks. Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted June 7, 2008 Share Posted June 7, 2008 I am sure this has been answered but the search function is pulling up tons of links to everywhere but on this thread. If you are running the latest version of oscom, which version should i be using? Also im assuming this is the contrib i need in the first place. i am trying to lower a portion of my products price by 5% in one shot rather then doing them one by one, Is EP going to help me do that? Chris You would have to download your entire product range into a file using EP. Then use a package such as excel to increse the price. Then upload the file. Another way is to use mysql to UPDATE the price field of every record by 5%. www.w3schools.com has a good primer on mysql. Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
laptop13 Posted June 7, 2008 Share Posted June 7, 2008 Chris You would have to download your entire product range into a file using EP. Then use a package such as excel to increse the price. Then upload the file. Another way is to use mysql to UPDATE the price field of every record by 5%. www.w3schools.com has a good primer on mysql. I have been told about using my sql but i am a bit scared to try that, haha. Which version of EP should i get for php 4/mysql 4/ RC2a? Quote Link to comment Share on other sites More sharing options...
ting Posted June 8, 2008 Share Posted June 8, 2008 I've just uploaded some products using Easy Populate and now have the letters thth appearing at the top left of some pages, can anyone tell me why. Here is the data I input: v_products_model 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_image v_products_price v_products_quantity v_products_weight v_date_avail v_date_added v_categories_image_1 v_categories_name_1_1 v_categories_name_1_2 v_categories_name_1_3 v_categories_image_2 v_categories_name_2_1 v_categories_name_2_2 v_categories_name_2_3 v_categories_image_3 v_categories_name_3_1 v_categories_name_3_2 v_categories_name_3_3 v_categories_image_4 v_categories_name_4_1 v_categories_name_4_2 v_categories_name_4_3 v_categories_image_5 v_categories_name_5_1 v_categories_name_5_2 v_categories_name_5_3 v_categories_image_6 v_categories_name_6_1 v_categories_name_6_2 v_categories_name_6_3 v_categories_image_7 v_categories_name_7_1 v_categories_name_7_2 v_categories_name_7_3 v_manufacturers_name v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_options_name_1_2 v_attribute_options_name_1_3 v_attribute_options_id_2 v_attribute_options_name_2_1 v_attribute_options_name_2_2 v_attribute_options_name_2_3 v_attribute_options_id_3 v_attribute_options_name_3_1 v_attribute_options_name_3_2 v_attribute_options_name_3_3 v_attribute_values_id_3_1 v_attribute_values_name_3_1_1 v_attribute_values_name_3_1_2 v_attribute_values_name_3_1_3 v_attribute_values_price_3_1 v_attribute_values_id_3_2 v_attribute_values_name_3_2_1 v_attribute_values_name_3_2_2 v_attribute_values_name_3_2_3 v_attribute_values_price_3_2 v_attribute_values_id_3_3 v_attribute_values_name_3_3_1 v_attribute_values_name_3_3_2 v_attribute_values_name_3_3_3 v_attribute_values_price_3_3 v_attribute_values_id_3_4 v_attribute_values_name_3_4_1 v_attribute_values_name_3_4_2 v_attribute_values_name_3_4_3 v_attribute_values_price_3_4 v_attribute_values_id_3_5 v_attribute_values_name_3_5_1 v_attribute_values_name_3_5_2 v_attribute_values_name_3_5_3 v_attribute_values_price_3_5 v_attribute_options_id_4 v_attribute_options_name_4_1 v_attribute_options_name_4_2 v_attribute_options_name_4_3 v_attribute_values_id_4_1 v_attribute_values_name_4_1_1 v_attribute_values_name_4_1_2 v_attribute_values_name_4_1_3 v_attribute_values_price_4_1 v_attribute_values_id_4_2 v_attribute_values_name_4_2_1 v_attribute_values_name_4_2_2 v_attribute_values_name_4_2_3 v_attribute_values_price_4_2 v_attribute_values_id_4_3 v_attribute_values_name_4_3_1 v_attribute_values_name_4_3_2 v_attribute_values_name_4_3_3 v_attribute_values_price_4_3 v_attribute_values_id_4_4 v_attribute_values_name_4_4_1 v_attribute_values_name_4_4_2 v_attribute_values_name_4_4_3 v_attribute_values_price_4_4 v_attribute_options_id_5 v_attribute_options_name_5_1 v_attribute_options_name_5_2 v_attribute_options_name_5_3 v_attribute_values_id_5_1 v_attribute_values_name_5_1_1 v_attribute_values_name_5_1_2 v_attribute_values_name_5_1_3 v_attribute_values_price_5_1 v_attribute_values_id_5_2 v_attribute_values_name_5_2_1 v_attribute_values_name_5_2_2 v_attribute_values_name_5_2_3 v_attribute_values_price_5_2 v_tax_class_title v_status EOREOR 981035 ARCHERS AQUA PEACH. 12 x 275ML 18.58 Alcopops ARCHERS EOREOR 737447 ARCHERS AQUA PEACH. 1 x 70CL 3.94 Alcopops ARCHERS EOREOR 981848 ARCHERS AQUA RASBERRY. 12 x 275ML 18.58 Alcopops ARCHERS EOREOR 737546 ARCHERS AQUA RASPBERRY. 1 x 70CL 3.94 Alcopops ARCHERS EOREOR 783510 CARIBBEAN TWIST MANGO/PASSION FRUIT. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR 110875 CARIBBEAN TWIST PARADISE. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR 714594 CARIBBEAN TWIST PINEAPPLE. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR 23515 FAT FROG. 24 x 275ML 31.60 Alcopops FAT FROG EOREOR 23494 FAT FROG. 1 x 70CL 3.42 Alcopops FAT FROG EOREOR 65643 MOJITO BLUE. 24 x 275ML 32.09 Alcopops MOJITO EOREOR 65708 MOJITO RED. 24 x 275ML 32.09 Alcopops MOJITO EOREOR 735739 RED SQUARE BLUE ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR 543516 RED SQUARE CHERRY ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR 729734 RED SQUARE GREEN ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR 722746 RED SQUARE PINK ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR 713289 RED SQUARE RELOADED. 12 x 275ML 14.86 Alcopops RED SQUARE EOREOR 717638 RED SQUARE RELOADED. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR 110787 RED SQUARE RELOADED BLUE. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR 717836 RED SQUARE WHITE ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR 534345 REDSQUARE RELOAD JUICED. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR 738312 RED STAR BLUE. 12 x 275ML 9.02 Alcopops RED STAR EOREOR 749433 RED STAR LEMON. 12 x 275ML 9.02 Alcopops RED STAR EOREOR 744416 RED STAR LIME. 12 x 275ML 9.02 Alcopops RED STAR EOREOR 749136 RED STAR ORANGE. 12 x 275ML 9.02 Alcopops RED STAR EOREOR 574974 REEF ORANGE & PASSION FRUIT. 24 x 275ML 30.30 Alcopops REEF EOREOR 495756 BACARDI BREEZER BLUEBERRY HALF SUGAR. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR 689719 BACARDI BREEZER BLUEBERRY HALF SUGAR. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 973355 BACARDI BREEZER COCONUT. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 973278 BACARDI BREEZER COCONUT 4PACK. 6 x 275ML 13.00 Alcopops RON BACARDI EOREOR 567543 BACARDI BREEZER LIME. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR 567499 BACARDI BREEZER ORANGE. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR 744625 BACARDI BREEZER ORANGE. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 567576 BACARDI BREEZER PINEAPPLE. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR 738345 BACARDI BREEZER PINEAPPLE. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 518930 BACARDI BREEZER POMEGRANATE HALF SUGAR. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 568386 BACARDI BREEZER WATERMELON. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR 738280 BACARDI BREEZER WATERMELON. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 718569 SHOT IN A TUBE . 72 x 55.78 Alcopops SHOOTERS EOREOR 268130 SIDEKICK TROPICAL FRUIT. 6 x 3CL 18.21 Alcopops SIDEKICK EOREOR 438650 SIDEKICK CHOCOLATE MINT 14.5%. 1 x 35CL 5.62 Alcopops SIDEKICK EOREOR 665661 SIDEKICK MIX CREAM 4PK. 6 x 3CL 18.21 Alcopops SIDEKICK EOREOR 712633 BOTTLES ICE. 24 x 275ml 36.44 Alcopops SMIRNOFF EOREOR 730482 SMIRNOFF BLACK ICE. 24 x 275ML 38.11 Alcopops SMIRNOFF EOREOR 919535 SMIRNOFF BLACK ICE. 1 x 70CL 3.92 Alcopops SMIRNOFF EOREOR 729592 SMIRNOFF ICE. 1 x 70CL 3.33 Alcopops SMIRNOFF EOREOR 240480 SMIRNOFF ICE PET. 24 x 275ML 36.25 Alcopops SMIRNOFF EOREOR 559544 SMIRNOFF ICE 6 FOR 4 PACK . 4 x 275ML 30.67 Alcopops SMIRNOFF EOREOR 280262 SMIRNOFF ICE P.E.T.. 24 x 275ML 37.18 Alcopops SMIRNOFF EOREOR 479022 SMIRNOFF ICE P.M 2.99 OR 2 FOR 5.00. 1 x 70CL 3.22 Alcopops SMIRNOFF EOREOR 979380 SMIRNOFF RED ICE 4PACK. 6 x 250ML 33.46 Alcopops SMIRNOFF EOREOR 978262 VS VODKA SORTED APPLE&KIWI. 1 x 70CL 2.18 Alcopops VS EOREOR 736187 VS VODKA SORTED BLUE. 12 x 275ML 9.28 Alcopops VS EOREOR 728946 VS VODKA SORTED BLUE. 1 x 70CL 2.18 Alcopops VS EOREOR 736275 VS VODKA SORTED IRN BRU. 12 x 275ML 9.28 Alcopops VS EOREOR 720830 VS VODKA SORTED IRON BREW. 1 x 70CL 2.18 Alcopops VS EOREOR 736121 VS VODKA SORTED LEMON. 12 x 275ML 9.28 Alcopops VS EOREOR 721222 VS VODKA SORTED LEMON. 1 x 70CL 2.18 Alcopops VS EOREOR 978273 VS VODKA SORTED TROPICAL ORANGE. 12 x 275ML 9.28 Alcopops VS EOREOR 978284 VS VODKA SORTED TROPICAL ORANGE. 1 x 70CL 2.18 Alcopops VS EOREOR 735937 VS VODKA SORTED WATERMELON. 12 x 275ML 9.28 Alcopops VS EOREOR 721475 VS VODKA SORTED WATERMELON. 1 x 70CL 2.18 Alcopops VS EOREOR 748272 BOTTLES BLUE . 1 x 275ml 3.94 Alcopops WKD EOREOR 744933 BOTTLES BLUE 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR 745084 BOTTLES IRON BREW 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR 830416 BOTTLES RED . 1 x 275ml 3.94 Alcopops WKD EOREOR 122629 BOTTLES RED 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR 744944 WKD BLUE 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR 748128 WKD BLUE 5%. 12 x 275ML 19.88 Alcopops WKD EOREOR 569668 WKD IRON BREW. 12 x 275ML 18.58 Alcopops WKD EOREOR 744834 WKD IRON BREW 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR 747990 WKD IRON BREW 5%. 12 x 275ML 19.88 Alcopops WKD EOREOR 748173 WKD IRON BREW 5%. 1 x 70CL 3.94 Alcopops WKD EOREOR 829362 WKD RED. 12 x 275ML 19.88 Alcopops WKD EOREOR 829999 WKD RED 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR Quote Link to comment Share on other sites More sharing options...
lth98105 Posted June 8, 2008 Share Posted June 8, 2008 i used Easy Populate 2.76g-MS2 (with attributes) from surfalot and using the new_field_everywhere contrib to add 3 extra fields author, isbn, and binding/publisher. everthing working fine except one important function: the search function: I CANNOT SEARCH ON ANY OF THE 3 EXTRA FIELDS ADDED. What is the issue? :( Laurent Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted June 9, 2008 Share Posted June 9, 2008 The extra fields are not in the search. How can the existing search code know which fields everyone who has added the contribution is using? Guess you need to hack the code to do this or get someone to do it for you. Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
surfalot Posted June 9, 2008 Share Posted June 9, 2008 i used Easy Populate 2.76g-MS2 (with attributes) from surfalot and using the new_field_everywhere contrib to add 3 extra fields author, isbn, and binding/publisher. everthing working fine except one important function: the search function: I CANNOT SEARCH ON ANY OF THE 3 EXTRA FIELDS ADDED. What is the issue? :( I would wonder why you are asking about support for the contrib new_field_everywhere in the Easy Populate topic. Quote Link to comment Share on other sites More sharing options...
surfalot Posted June 9, 2008 Share Posted June 9, 2008 I've just uploaded some products using Easy Populate and now have the letters thth appearing at the top left of some pages, can anyone tell me why. Here is the data I input: v_products_model 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_image v_products_price v_products_quantity v_products_weight v_date_avail v_date_added v_categories_image_1 v_categories_name_1_1 v_categories_name_1_2 v_categories_name_1_3 v_categories_image_2 v_categories_name_2_1 v_categories_name_2_2 v_categories_name_2_3 v_categories_image_3 v_categories_name_3_1 v_categories_name_3_2 v_categories_name_3_3 v_categories_image_4 v_categories_name_4_1 v_categories_name_4_2 v_categories_name_4_3 v_categories_image_5 v_categories_name_5_1 v_categories_name_5_2 v_categories_name_5_3 v_categories_image_6 v_categories_name_6_1 v_categories_name_6_2 v_categories_name_6_3 v_categories_image_7 v_categories_name_7_1 v_categories_name_7_2 v_categories_name_7_3 v_manufacturers_name v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_options_name_1_2 v_attribute_options_name_1_3 v_attribute_options_id_2 v_attribute_options_name_2_1 v_attribute_options_name_2_2 v_attribute_options_name_2_3 v_attribute_options_id_3 v_attribute_options_name_3_1 v_attribute_options_name_3_2 v_attribute_options_name_3_3 v_attribute_values_id_3_1 v_attribute_values_name_3_1_1 v_attribute_values_name_3_1_2 v_attribute_values_name_3_1_3 v_attribute_values_price_3_1 v_attribute_values_id_3_2 v_attribute_values_name_3_2_1 v_attribute_values_name_3_2_2 v_attribute_values_name_3_2_3 v_attribute_values_price_3_2 v_attribute_values_id_3_3 v_attribute_values_name_3_3_1 v_attribute_values_name_3_3_2 v_attribute_values_name_3_3_3 v_attribute_values_price_3_3 v_attribute_values_id_3_4 v_attribute_values_name_3_4_1 v_attribute_values_name_3_4_2 v_attribute_values_name_3_4_3 v_attribute_values_price_3_4 v_attribute_values_id_3_5 v_attribute_values_name_3_5_1 v_attribute_values_name_3_5_2 v_attribute_values_name_3_5_3 v_attribute_values_price_3_5 v_attribute_options_id_4 v_attribute_options_name_4_1 v_attribute_options_name_4_2 v_attribute_options_name_4_3 v_attribute_values_id_4_1 v_attribute_values_name_4_1_1 v_attribute_values_name_4_1_2 v_attribute_values_name_4_1_3 v_attribute_values_price_4_1 v_attribute_values_id_4_2 v_attribute_values_name_4_2_1 v_attribute_values_name_4_2_2 v_attribute_values_name_4_2_3 v_attribute_values_price_4_2 v_attribute_values_id_4_3 v_attribute_values_name_4_3_1 v_attribute_values_name_4_3_2 v_attribute_values_name_4_3_3 v_attribute_values_price_4_3 v_attribute_values_id_4_4 v_attribute_values_name_4_4_1 v_attribute_values_name_4_4_2 v_attribute_values_name_4_4_3 v_attribute_values_price_4_4 v_attribute_options_id_5 v_attribute_options_name_5_1 v_attribute_options_name_5_2 v_attribute_options_name_5_3 v_attribute_values_id_5_1 v_attribute_values_name_5_1_1 v_attribute_values_name_5_1_2 v_attribute_values_name_5_1_3 v_attribute_values_price_5_1 v_attribute_values_id_5_2 v_attribute_values_name_5_2_1 v_attribute_values_name_5_2_2 v_attribute_values_name_5_2_3 v_attribute_values_price_5_2 v_tax_class_title v_status EOREOR 981035 ARCHERS AQUA PEACH. 12 x 275ML 18.58 Alcopops ARCHERS EOREOR 737447 ARCHERS AQUA PEACH. 1 x 70CL 3.94 Alcopops ARCHERS EOREOR 981848 ARCHERS AQUA RASBERRY. 12 x 275ML 18.58 Alcopops ARCHERS EOREOR 737546 ARCHERS AQUA RASPBERRY. 1 x 70CL 3.94 Alcopops ARCHERS EOREOR 783510 CARIBBEAN TWIST MANGO/PASSION FRUIT. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR 110875 CARIBBEAN TWIST PARADISE. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR 714594 CARIBBEAN TWIST PINEAPPLE. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR 23515 FAT FROG. 24 x 275ML 31.60 Alcopops FAT FROG EOREOR 23494 FAT FROG. 1 x 70CL 3.42 Alcopops FAT FROG EOREOR 65643 MOJITO BLUE. 24 x 275ML 32.09 Alcopops MOJITO EOREOR 65708 MOJITO RED. 24 x 275ML 32.09 Alcopops MOJITO EOREOR 735739 RED SQUARE BLUE ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR 543516 RED SQUARE CHERRY ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR 729734 RED SQUARE GREEN ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR 722746 RED SQUARE PINK ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR 713289 RED SQUARE RELOADED. 12 x 275ML 14.86 Alcopops RED SQUARE EOREOR 717638 RED SQUARE RELOADED. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR 110787 RED SQUARE RELOADED BLUE. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR 717836 RED SQUARE WHITE ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR 534345 REDSQUARE RELOAD JUICED. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR 738312 RED STAR BLUE. 12 x 275ML 9.02 Alcopops RED STAR EOREOR 749433 RED STAR LEMON. 12 x 275ML 9.02 Alcopops RED STAR EOREOR 744416 RED STAR LIME. 12 x 275ML 9.02 Alcopops RED STAR EOREOR 749136 RED STAR ORANGE. 12 x 275ML 9.02 Alcopops RED STAR EOREOR 574974 REEF ORANGE & PASSION FRUIT. 24 x 275ML 30.30 Alcopops REEF EOREOR 495756 BACARDI BREEZER BLUEBERRY HALF SUGAR. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR 689719 BACARDI BREEZER BLUEBERRY HALF SUGAR. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 973355 BACARDI BREEZER COCONUT. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 973278 BACARDI BREEZER COCONUT 4PACK. 6 x 275ML 13.00 Alcopops RON BACARDI EOREOR 567543 BACARDI BREEZER LIME. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR 567499 BACARDI BREEZER ORANGE. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR 744625 BACARDI BREEZER ORANGE. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 567576 BACARDI BREEZER PINEAPPLE. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR 738345 BACARDI BREEZER PINEAPPLE. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 518930 BACARDI BREEZER POMEGRANATE HALF SUGAR. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 568386 BACARDI BREEZER WATERMELON. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR 738280 BACARDI BREEZER WATERMELON. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR 718569 SHOT IN A TUBE . 72 x 55.78 Alcopops SHOOTERS EOREOR 268130 SIDEKICK TROPICAL FRUIT. 6 x 3CL 18.21 Alcopops SIDEKICK EOREOR 438650 SIDEKICK CHOCOLATE MINT 14.5%. 1 x 35CL 5.62 Alcopops SIDEKICK EOREOR 665661 SIDEKICK MIX CREAM 4PK. 6 x 3CL 18.21 Alcopops SIDEKICK EOREOR 712633 BOTTLES ICE. 24 x 275ml 36.44 Alcopops SMIRNOFF EOREOR 730482 SMIRNOFF BLACK ICE. 24 x 275ML 38.11 Alcopops SMIRNOFF EOREOR 919535 SMIRNOFF BLACK ICE. 1 x 70CL 3.92 Alcopops SMIRNOFF EOREOR 729592 SMIRNOFF ICE. 1 x 70CL 3.33 Alcopops SMIRNOFF EOREOR 240480 SMIRNOFF ICE PET. 24 x 275ML 36.25 Alcopops SMIRNOFF EOREOR 559544 SMIRNOFF ICE 6 FOR 4 PACK . 4 x 275ML 30.67 Alcopops SMIRNOFF EOREOR 280262 SMIRNOFF ICE P.E.T.. 24 x 275ML 37.18 Alcopops SMIRNOFF EOREOR 479022 SMIRNOFF ICE P.M 2.99 OR 2 FOR 5.00. 1 x 70CL 3.22 Alcopops SMIRNOFF EOREOR 979380 SMIRNOFF RED ICE 4PACK. 6 x 250ML 33.46 Alcopops SMIRNOFF EOREOR 978262 VS VODKA SORTED APPLE&KIWI. 1 x 70CL 2.18 Alcopops VS EOREOR 736187 VS VODKA SORTED BLUE. 12 x 275ML 9.28 Alcopops VS EOREOR 728946 VS VODKA SORTED BLUE. 1 x 70CL 2.18 Alcopops VS EOREOR 736275 VS VODKA SORTED IRN BRU. 12 x 275ML 9.28 Alcopops VS EOREOR 720830 VS VODKA SORTED IRON BREW. 1 x 70CL 2.18 Alcopops VS EOREOR 736121 VS VODKA SORTED LEMON. 12 x 275ML 9.28 Alcopops VS EOREOR 721222 VS VODKA SORTED LEMON. 1 x 70CL 2.18 Alcopops VS EOREOR 978273 VS VODKA SORTED TROPICAL ORANGE. 12 x 275ML 9.28 Alcopops VS EOREOR 978284 VS VODKA SORTED TROPICAL ORANGE. 1 x 70CL 2.18 Alcopops VS EOREOR 735937 VS VODKA SORTED WATERMELON. 12 x 275ML 9.28 Alcopops VS EOREOR 721475 VS VODKA SORTED WATERMELON. 1 x 70CL 2.18 Alcopops VS EOREOR 748272 BOTTLES BLUE . 1 x 275ml 3.94 Alcopops WKD EOREOR 744933 BOTTLES BLUE 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR 745084 BOTTLES IRON BREW 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR 830416 BOTTLES RED . 1 x 275ml 3.94 Alcopops WKD EOREOR 122629 BOTTLES RED 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR 744944 WKD BLUE 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR 748128 WKD BLUE 5%. 12 x 275ML 19.88 Alcopops WKD EOREOR 569668 WKD IRON BREW. 12 x 275ML 18.58 Alcopops WKD EOREOR 744834 WKD IRON BREW 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR 747990 WKD IRON BREW 5%. 12 x 275ML 19.88 Alcopops WKD EOREOR 748173 WKD IRON BREW 5%. 1 x 70CL 3.94 Alcopops WKD EOREOR 829362 WKD RED. 12 x 275ML 19.88 Alcopops WKD EOREOR 829999 WKD RED 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR When posting a problem, you need to provide much more information for someone to help you. Info like the version of EP you are using, the PHP version, the EP settings you are using, and a sample of the file you are importing. The versions of EP I have uploaded have a section in the Docs called Support. It has instructions about how to ask for help and how to post a useful sample of your data. Also, be sure to read through the forum rules (link at top of page). It also has tips on how to organize a post that will generate a response. Quote Link to comment Share on other sites More sharing options...
laptop13 Posted June 9, 2008 Share Posted June 9, 2008 Which version of EP should i get for php 4/mysql 4/ RC2a? Any one know this answer? Quote Link to comment Share on other sites More sharing options...
surfalot Posted June 10, 2008 Share Posted June 10, 2008 Any one know this answer? v2.76g is the most "fixed". But it is really the contributions you have installed that would make the most impact on the version you choose. Quote Link to comment Share on other sites More sharing options...
laptop13 Posted June 10, 2008 Share Posted June 10, 2008 v2.76g is the most "fixed". But it is really the contributions you have installed that would make the most impact on the version you choose. are their any known major conflicts? i do not have to many other than to make the shop operate. Quote Link to comment Share on other sites More sharing options...
Guest Posted June 10, 2008 Share Posted June 10, 2008 What version of Office are you using? no need to see the file, you told me what I needed to know. MS Office 2007 (and maybe Open Office) doesn't have the column limit. If you open the file like you have, and resave it, you may loose data. If you see a description wrap down to a second row, that is OK. It means there is a [RETURN] embedded in the description. That version of EP should handle that, and it should not affect the import. I have to say, I am a little surprised that some HTML is causing problems on the import. It may have something to do with country specific settings and your office. I would like see is a small portion of the export that contains the description causing the problem. You can put the file on your web-space and post or PM me the link to it. Thank you for all your help. Indeed, I'm using Office 2003, I guess this is where the problem is coming from. I'll upgrade :) As for the description on a second row, I'll show exactly how it looks like, I'll send you a PM with a link to a part of the ep file I downloaded. This way, you'll see the html problem problem, too. Thank you so so much. Quote Link to comment Share on other sites More sharing options...
zeeshop Posted June 10, 2008 Share Posted June 10, 2008 Hi, I am using EP for more than year now, Recently I Updated with surflot new EP update. All ok, just few things I need some help. When I update products and set in Categories for some reason Images are not showing in Website Categories (i.e Images link to categories. Do i have to add IMAGE column for categories in all cateories as Before I was updating categories and not had any effect on category images. Second if I have to delete Product from Date base I think with this new version I can write "delete" in Status and it will delete product but I tried this and product is not deleting ven it shows in ep that product delete updated. Hope someone guide me to right thread or advise. Regards Thanks Quote Link to comment Share on other sites More sharing options...
jayc2004 Posted June 10, 2008 Share Posted June 10, 2008 Here is a list of the Settings and Info: Settings & Info EP vers: 2.76g-MS2 osCommerce Online Merchant v2.2 RC2a OS: Linux 2.6.22-19_1.BHsmp HTTP: Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.8g DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 DB: MySQL 5.0.45-community-log PHP: 5.2.6 (Zend: 2.2.0) Temp Directory: /home/melsfire/public_html/catalog/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: off Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false When I upload my file back to Easy Populate I get this message at the top of the window: Easy Populate 2.76g-MS2 - Default Language : english(1) Filename: EP2008Jun03-12124.csv Warning: Invalid argument supplied for foreach() in /home/melsfire/public_html/catalog/admin/easypopulate.php on line 1185 I hope this is the information you need, Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.