wasson65 Posted December 23, 2002 Share Posted December 23, 2002 EP 2.3 in in the contribs section now. You can get it here: http://www.oscommerce.com/community/contributions,500 EasyPopulate lets you populate and update your store with Excel or any other data source that can create tab delimited files. Tim Quote Link to comment Share on other sites More sharing options...
blueline Posted December 23, 2002 Share Posted December 23, 2002 Damn Tim. Do you ever take a break? Just kidding. Thanks for the great contribution. -Chris Quote Chris Sullivan Link to comment Share on other sites More sharing options...
dreamscape Posted December 23, 2002 Share Posted December 23, 2002 tim, I am still running easy populate v2.1 without a single problem... any reason I should switch to v2.3 (like new features)? Quote The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
wasson65 Posted December 23, 2002 Author Share Posted December 23, 2002 tim, I am still running easy populate v2.1 without a single problem... any reason I should switch to v2.3 (like new features)? If you're not running the Multiple Prices per Product or the Header Controller contribs, and are not having problems with multi-language, then it's not a "must have" release. There is one feature that might be worth switching for, and that is the variable file layouts. For example, you can get a file with just the model numbers, quantity, and price for updating just those things without the clutter of all the other columns. There are 3 defined file layouts, the "Complete", which is like the existing EP, the Model/Quantity, which I described above, and the Mode;l/category file, which lists the product model and the categories it appears in. You can also create your own file formats if you are interested. Tim Quote Link to comment Share on other sites More sharing options...
Clement Posted December 23, 2002 Share Posted December 23, 2002 Ok. In my only one language (id 4 ) config v 2.3 has some lang problem. The previous problem with empty cells at product price column is go one. But now, the product name and product description are empty in the downloaded file. There is correct inserted the lang_id in the v_products_name_4 and v_products_description_4 column header but the content cells are empty. Thank you for your work, Quote Link to comment Share on other sites More sharing options...
wasson65 Posted December 23, 2002 Author Share Posted December 23, 2002 Ok. In my only one language (id 4 ) config v 2.3 has some lang problem. The previous problem with empty cells at product price column is go one. But now, the product name and product description are empty in the downloaded file. There is correct inserted the lang_id in the v_products_name_4 and v_products_description_4 column header but the content cells are empty. Thank you for your work, OK, Will test some to see if I can duplicate it. Tim Quote Link to comment Share on other sites More sharing options...
Clement Posted December 23, 2002 Share Posted December 23, 2002 I sugest you to look more in line 256-283 . while ($row){ // if the filelayout says we need a products_name, get it if (isset($filelayout['v_products_name_1'])){ // for each language, get the description and set the vals $l=1; foreach ($langcode as $key => $lang){ $sql2 = "SELECT * FROM products_description WHERE products_id = " . $row['v_products_id'] . " AND language_id = '" . $langcode[$l]['id'] . "' "; $result2 = tep_db_query($sql2); $row2 = tep_db_fetch_array($result2); // Need to report from ......_name_1 not ..._name_0 $row['v_products_name_' . $l] = $row2['products_name']; $row['v_products_description_' . $l] = $row2['products_description']; // support for Linda's Header Controller 2.0 here if(isset($filelayout['v_products_head_title_tag_1'])){ $row['v_products_head_title_tag_' . $l] = $row2['products_head_title_tag']; $row['v_products_head_desc_tag_' . $l] = $row2['products_head_desc_tag']; $row['v_products_head_keywords_tag_' . $l] = $row2['products_head_keywords_tag']; } // end support for Header Controller 2.0 $l++; } } I have a feeling that the condition for v_products_name_1 and the declaration for $l=1 isn't good there. I repeat. Is just a feeling.. Thanks, Quote Link to comment Share on other sites More sharing options...
MrTT Posted December 24, 2002 Share Posted December 24, 2002 If i download a complete tab delimited file and upload the same file without any modifications i get the following message: Easy Populate 2.3 - Default Language : English(1) File uploaded. Temporary filename: C:WINDOWSphp6.tmp User filename: EP1040687952.txt Size: 62512 | MG200MMS | matrox/mg2 | Matrox G20 | Reinforcin | Matrox G20 | Unterst?tz | Matrox G20 | Reinforcin | 299.99 | 23.00 | 2002-08-31 | 32 | Matrox | Graphics C | Hardware | | | | | | Taxable Go | Updated | MG400-32MB | matrox/mg4 | Matrox G40 | Dramatical | Matrox G40 | Neu! Matro | Matrox G40 | Dramatical | 499.99 | 23.00 | 2002-08-31 | 32 | Matrox | Graphics C | Hardware | | | | | | Taxable Go | Updated | MSIMPRO | microsoft/ | Microsoft | Every elem | Microsoft | Die Intell | Microsoft | Every elem | 49.99 | 7.00 | 2002-08-31 | 2 | Warner | Mice | Hardware | | | | | | Taxable Go | Updated | DVD-RPMK | dvd/replac | The Replac | Regional C | Die Ersatz | Originalti | The Replac | Regional C | 42 | 23.00 | 2002-08-31 | 13 | Microsoft | Action | DVD Movies | | | | | | Taxable Go | Updated | DVD-BLDRND | dvd/blade_ | Blade Runn | Regional C | Blade Runn | Regional C | Blade Runn | Regional C | 35.99 | 7.00 | 2002-08-31 | 17 | Warner | Science Fi | DVD Movies | | | | | | Taxable Go | Updated | DVD-MATR | dvd/the_ma | The Matrix | Regional C | Matrix | Originalti | The Matrix | Regional C | 39.99 | 7.00 | 2002-08-31 | 10 | Warner | Action | DVD Movies | | | | | | Taxable Go | Updated | DVD-YGEM | dvd/youve_ | You've | Regional C | e-m@il f?r | Original: | You've | Regional C | 34.99 | 7.00 | 2002-08-31 | 10 | Warner | Comedy | DVD Movies | | | | | | Taxable Go | Updated | DVD-ABUG | dvd/a_bugs | A Bug's | Regional C | Das Gro?e | Originalti | A Bug's | Regional C | 35.99 | 7.00 | 2002-08-31 | 10 | Warner | Cartoons | DVD Movies | | | | | | Taxable Go | Updated | DVD-UNSG | dvd/under_ | Under Sieg | Regional C | Alarmstufe | Originalti | Under Sieg | Regional C | 29.99 | 7.00 | 2002-08-31 | 10 | Warner | Action | DVD Movies | | | | | | Taxable Go | Updated | DVD-UNSG2 | dvd/under_ | Under Sieg | Regional C | Alarmstufe | Originalti | Under Sieg | Regional C | 29.99 | 7.00 | 2002-08-31 | 10 | Warner | Action | DVD Movies | | | | | | Taxable Go | Updated | DVD-FDBL | dvd/fire_d | Fire Down | Regional C | Fire Down | Regional C | Fire Down | Regional C | 29.99 | 7.00 | 2002-08-31 | 10 | Warner | Action | DVD Movies | | | | | | Taxable Go | Updated | DVD-DHWV | dvd/die_ha | Die Hard W | Regional C | Stirb Lang | Originalti | Die Hard W | Regional C | 39.99 | 7.00 | 2002-08-31 | 10 | Fox | Action | DVD Movies | | | | | | Taxable Go | Updated | DVD-LTWP | dvd/lethal | Lethal Wea | Regional C | Zwei stahl | Originalti | Lethal Wea | Regional C | 34.99 | 7.00 | 2002-08-31 | 10 | Warner | Action | DVD Movies | | | | | | Taxable Go | Updated | DVD-REDC | dvd/red_co | Red Corner | Regional C | Labyrinth | Originalti | Red Corner | Regional C | 32 | 7.00 | 2002-08-31 | 10 | Warner | Drama | DVD Movies | | | | | | Taxable Go | Updated | DVD-FRAN | dvd/franti | Frantic | Regional C | Frantic | Originalti | Frantic | Regional C | 35 | 7.00 | 2002-08-31 | 10 | Warner | Thriller | DVD Movies | | | | | | Taxable Go | Updated | DVD-CUFI | dvd/courag | Courage Un | Regional C | Mut Zur Wa | Originalti | Courage Un | Regional C | 38.99 | 7.00 | 2002-08-31 | 10 | Fox | Drama | DVD Movies | | | | | | Taxable Go | Updated | DVD-SPEED | dvd/speed. | Speed | Regional C | Speed | Originalti | Speed | Regional C | 39.99 | 7.00 | 2002-08-31 | 10 | Fox | Action | DVD Movies | | | | | | Taxable Go | Updated | DVD-SPEED2 | dvd/speed_ | Speed 2: C | Regional C | Speed 2: C | Originalti | Speed 2: C | Regional C | 42 | 7.00 | 2002-08-31 | 10 | Fox | Action | DVD Movies | | | | | | Taxable Go | Updated | DVD-TSAB | dvd/theres | There's | Regional C | Verr?ckt n | Originalti | There's | Regional C | 49.99 | 7.00 | 2002-08-31 | 10 | Fox | Comedy | DVD Movies | | | | | | Taxable Go | Updated | DVD-BELOVE | dvd/belove | Beloved | Regional C | Menschenki | Originalti | Beloved | Regional C | 54.99 | 7.00 | 2002-08-31 | 10 | Warner | Drama | DVD Movies | | | | | | Taxable Go | Updated | PC-SWAT3 | sierra/swa | SWAT 3: Cl | Windows 95 | SWAT 3: El | KEINE KOMP | SWAT 3: Cl | Windows 95 | 79.99 | 7.00 | 2002-08-31 | 16 | Sierra | Simulation | Software | | | | | | Taxable Go | Updated | PC-UNTM | gt_interac | Unreal Tou | From the c | Unreal Tou | 2341: Die | Unreal Tou | From the c | 89.99 | 7.00 | 2002-08-31 | 13 | GT Interac | Action | Software | | | | | | Taxable Go | Updated | PC-TWOF | gt_interac | The Wheel | The world | The Wheel | "Wheel | The Wheel | The world | 99.99 | 10.00 | 2002-08-31 | 16 | GT Interac | Strategy | Software | | | | | | Taxable Go | Updated | PC-DISC | gt_interac | Disciples: | A new age | Disciples: | Rundenbasi | Disciples: | A new age | 90 | 8.00 | 2002-08-31 | 17 | GT Interac | Strategy | Software | | | | | | Taxable Go | Updated | MSINTKB | microsoft/ | Microsoft | The Intern | Microsoft | Microsoft | Microsoft | The Intern | 69.99 | 8.00 | 2002-08-31 | 16 | Microsoft | Keyboards | Hardware | | | | | | Taxable Go | Updated | MSIMEXP | microsoft/ | Microsoft | Microsoft | Microsof I | Die Intell | Microsoft | Microsoft | 64.95 | 8.00 | 2002-08-31 | 10 | Microsoft | Mice | Hardware | | | | | | Taxable Go | Updated | HPLJ1100XI | hewlett_pa | Hewlett Pa | HP has alw | Hewlett-Pa | HP LaserJe | Hewlett Pa | HP has alw | 499.99 | 45.00 | 2002-08-31 | 8 | Hewlett Pa | Printers | Hardware | | | | | | Taxable Go | Updated | GIFT10 | manufactur | Gift Vouch | e-Gift Vou | | | | | 10 | 0.00 | 2002-08-31 | 0 | | Gift Vouch | | | | | | | None | Updated | | | | | | | | | | | | | | | | | | | | | | No products_model field in record. This line was not imported Upload complete Could someone please help!!! Quote Link to comment Share on other sites More sharing options...
Clement Posted December 24, 2002 Share Posted December 24, 2002 I don't see any problem there. All your products was updated. If you want to talk about the message: | | | | | | | | | | | | | | | | | | | | | | No products_model field in record. This line was not imported from the end of the results you need to know there isn't any problem. Always the last line is empty and this message appear. Good luck! Quote Link to comment Share on other sites More sharing options...
clarion em Posted December 24, 2002 Share Posted December 24, 2002 I hope someone can help with a problem I am having with Easypopulate (latest versions V2.2 or V2.3) products upload. Although I can Upload test products - They don't appear under the sub categories or categories. However the categories under which the new products have been added do appear in admin/catalog to allow me to edit them. I know the products are added because I started with 27 products and after adding 2 more products using Easypopulate v2.3 the catalog database reports 29. I am using snapshop of 18/12/2002. I have searched the forum for a few days but I have yet to home in on it. I get same results when using V2.2 as well. any help would be appreciated thanks Quote It stops to be work if you are enjoying it Link to comment Share on other sites More sharing options...
Guest Posted December 24, 2002 Share Posted December 24, 2002 Hey bud, just wanted to thank you for the great contrib. Quote Link to comment Share on other sites More sharing options...
Guest Posted December 24, 2002 Share Posted December 24, 2002 Can the Easypopulate be modified to enable multiple sub-categories to be uploaded? I have a need to upload products that are 3-5 tiers deep and Easypopulate currently does not support this. Just a thought. Andrew Quote Link to comment Share on other sites More sharing options...
networkdad Posted December 24, 2002 Share Posted December 24, 2002 sweet! The header controller is now in there. I've been using 2.1 happily, but i must try this new release now. Thanks! Quote Link to comment Share on other sites More sharing options...
MrTT Posted December 24, 2002 Share Posted December 24, 2002 I don't see any problem there. All your products was updated. If you want to talk about the message: | | | | | | | | | | | | | | | | | | | | | | No products_model field in record. This line was not imported from the end of the results you need to know there isn't any problem. Always the last line is empty and this message appear. Good luck! Yes this is true but if i then modify the downloaded file and insert a new product i don't see it in my catalog afterwards! Quote Link to comment Share on other sites More sharing options...
rhytha Posted December 24, 2002 Share Posted December 24, 2002 hi guys iam not able to get my products and prices modified. i just edited some prices in downloaded txt file using excel xp. the admin screen is showing uploaded sucessfullyy, but the price change is not refelcted in the database. i can pm the file if any one is intrested. thanx in advance Quote Link to comment Share on other sites More sharing options...
Guest Posted December 26, 2002 Share Posted December 26, 2002 Hi, Would it be better for newbie, like me :lol: , to put an example Excel file with the EP distribution? The Excel fiel will have just enouhgt data for demonastration purpose only. So we will know how to structure our excel file when using the EP2.3. Thanks for your effort! Stonez Quote Link to comment Share on other sites More sharing options...
wasson65 Posted December 26, 2002 Author Share Posted December 26, 2002 Hi,Would it be better for newbie, like me :lol: , to put an example Excel file with the EP distribution? The Excel fiel will have just enouhgt data for demonastration purpose only. So we will know how to structure our excel file when using the EP2.3. Thanks for your effort! Stonez Sorry to have been away for a day or two, I've missed the postings on this thread. I'll try to catch up with them today. The simplest way to get a demo file is to simply install EP, then download the .txt file from easypopulate. Then you'll see all the headers along with your data. Quote Link to comment Share on other sites More sharing options...
wasson65 Posted December 26, 2002 Author Share Posted December 26, 2002 hi guys iam not able to get my products and prices modified. i just edited some prices in downloaded txt file using excel xp. the admin screen is showing uploaded sucessfullyy, but the price change is not refelcted in the database. i can pm the file if any one is intrested. thanx in advance Please send me the file you have modified at [email protected]. I'll take a look and try importing it into my dev store. Tim Quote Link to comment Share on other sites More sharing options...
wasson65 Posted December 26, 2002 Author Share Posted December 26, 2002 I don't see any problem there. All your products was updated. If you want to talk about the message: | | | | | | | | | | | | | | | | | | | | | | No products_model field in record. This line was not imported from the end of the results you need to know there isn't any problem. Always the last line is empty and this message appear. Good luck! Please send me your modified file and I'll take a look at it to see what's wrong. [email protected] Tim Yes this is true but if i then modify the downloaded file and insert a new product i don't see it in my catalog afterwards! Quote Link to comment Share on other sites More sharing options...
wasson65 Posted December 26, 2002 Author Share Posted December 26, 2002 Can the Easypopulate be modified to enable multiple sub-categories to be uploaded? I have a need to upload products that are 3-5 tiers deep and Easypopulate currently does not support this. Just a thought. Andrew EP has supported multi-level categories for quite a while now. It can handle up to 6 levels of category/subcategory. The multi-category info is in the new docs I wrote. Tim Quote Link to comment Share on other sites More sharing options...
wasson65 Posted December 26, 2002 Author Share Posted December 26, 2002 Hey bud, just wanted to thank you for the great contrib. My pleasure, glad you like it! Tim Quote Link to comment Share on other sites More sharing options...
wasson65 Posted December 26, 2002 Author Share Posted December 26, 2002 Ok. In my only one language (id 4 ) config v 2.3 has some lang problem. The previous problem with empty cells at product price column is go one. But now, the product name and product description are empty in the downloaded file. There is correct inserted the lang_id in the v_products_name_4 and v_products_description_4 column header but the content cells are empty. Thank you for your work, Good news, I was able to duplicate this and have it fixed and released as version 2.31. You were right, those lines were the root of the problem. If you can try 2.31 and let me know, I'd appreciate that. Thanks, Tim Quote Link to comment Share on other sites More sharing options...
wasson65 Posted December 26, 2002 Author Share Posted December 26, 2002 I hope someone can help with a problem I am having with Easypopulate (latest versions V2.2 or V2.3) products upload. Although I can Upload test products - They don't appear under the sub categories or categories. However the categories under which the new products have been added do appear in admin/catalog to allow me to edit them. I know the products are added because I started with 27 products and after adding 2 more products using Easypopulate v2.3 the catalog database reports 29. I am using snapshop of 18/12/2002. I have searched the forum for a few days but I have yet to home in on it. I get same results when using V2.2 as well. any help would be appreciated thanks I'd guess you are listing the categories from high-level to low-level. v_product_category_name_1 is the LOWEST level subcategory. v_product_category_name_2 is the next HIGHER level category. and so on. This should be covered in the docs for 2.2 on up. Please check those, and if this is indeed the problem you are having, let me know. I should add something to the troubleshooting section of the docs to cover this. Tim Quote Link to comment Share on other sites More sharing options...
wasson65 Posted December 26, 2002 Author Share Posted December 26, 2002 Damn Tim. Do you ever take a break? Just kidding. Thanks for the great contribution. -Chris Actually, I took all Christmas day off. An entire day of no computers. Very strange. Need... more... bits..... Must... have.... input....... 8-) Quote Link to comment Share on other sites More sharing options...
Guest Posted December 27, 2002 Share Posted December 27, 2002 "wasson65: Sorry to have been away for a day or two, I've missed the postings on this thread. I'll try to catch up with them today. The simplest way to get a demo file is to simply install EP, then download the .txt file from easypopulate. Then you'll see all the headers along with your data. Thanks for your reply! I installed and download the files and added few lines of products! It works! Perfect! Thanks! :D :D Just a thought... It would be great if I can remove products from the DB by telling EP2.3 that this is a fresh upload. Then when upload with EP2.3 it can just erase all data contained in the DB first and then fresh install all the products in the .cvs file. Can this be done easily? :roll: If it's not, that's ok! this is good enough to save me lot of time... :wink: Or if there is other way to achive this with EP2.3? Stonez 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.