jackrabbit Posted August 29, 2005 Share Posted August 29, 2005 Hi, I have an EP problem. My database is so large (about 1000 products plus variants) that when I EP it and attempt to open using Excel, it actually has more columns than Excel caters for? any suggestions ? nick sydney <{POST_SNAPBACK}> That is so funny! I swear I was just about to post the same issue! I will try and find that Quattro Pro that Mibble mentioned, but if anyone has anyother suggestions please let me know. Quote Link to comment Share on other sites More sharing options...
AllTheAbove Posted August 29, 2005 Share Posted August 29, 2005 Hi.. I'm still looking for an answer for my question above. Just to paraphrase.. When adding attributes and options, how do I get EP to see the same ones as a single option and not multiple. Example.. T-shirts come in S, M, L and in White, Blue, Black. I want it to show each option as a single instance instead of 3 small (one for each color) or 3 white (one for each size). Do I need a different contrib for this? Also, say I have T-shirts that come in colors but I also have candles. I would like the attribute of White to show only once and not twice (once for t-shirts and once for candles). Is this possible? Thanks Lori Quote Link to comment Share on other sites More sharing options...
Guest Posted August 30, 2005 Share Posted August 30, 2005 Paul, Thanks again for your help. I've tried it out now and it works well. Steve <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
simplyclesha Posted August 30, 2005 Share Posted August 30, 2005 'Scented Mother's Candle'to 'Scented Mother\'s Candle' <{POST_SNAPBACK}> Thanks John, everything uploaded! :thumbsup: :D Quote Thanks! Clesha Link to comment Share on other sites More sharing options...
cruise Posted August 30, 2005 Share Posted August 30, 2005 Hi All... I can Dowload to Local and to Temp Directory fine, but having problems uploading... I can only ever get the 1st record updated - the rest are ignored .... even when I upload a file I've just downloaded (without editing)... doen't matter whether it is a full or partial download/upload - same problem Data file is : v_products_model v_categories_name_1 v_categories_name_2 v_categories_name_3 EOREOR CARWC001 Threads Caron Collection Watercolours EOREOR CARWC002 Threads Caron Collection Watercolours EOREOR CARWL Threads Caron Collection EOREOR CARWF Threads Caron Collection EOREOR CARIS Threads Caron Collection EOREOR CARRA Threads Caron Collection EOREOR CARWC000 Threads Caron Collection Watercolours EOREOR DMC151 Threads DMC Stranded Cotton EOREOR DMC150 Threads DMC Stranded Cotton EOREOR DMCECRU Threads DMC Stranded Cotton EOREOR DMCBLANC Threads DMC Stranded Cotton EOREOR DMCB5200 Threads DMC Stranded Cotton EOREOR Output looks like : File uploaded. Temporary filename: /tmp/phpjwqOig User filename: EP2005Aug23-0012.txt Size: 617 | CARWC001 | Threads | Caron Coll | Watercolou Updated | CARWC002 | CARWL Thr | CARWF Thr | CARIS Thr | CARRA Thr | CARWC000 | DMC151 Th | DMC150 Th | DMCECRU T | DMCBLANC | DMCB5200 | all records have EOREOR fields If I delete the 1st record (not header)... the second record (now 1st) loads successfully but all remaining are again ignored. After Upload file is still in temp directory... I've scoured the Thread and have found a number of similar problems - all seem to be related to DOCUMENT_Root and tempdir settings and the differences between local and Server environments - but haven't come across any explanations or resolutions.... Have tried just about all combinations for these setting I can think of .. using Easy Populate 2.76-MS2 & osCommerce 2.2-MS2 Any Suggestions ?? Andy :'( <{POST_SNAPBACK}> Did you solve the problem? I have the same. On my localhost (testing site) is everything OK, but when I upload the site easypopulate is not uploading correctly. Thanks Quote Link to comment Share on other sites More sharing options...
simplyclesha Posted August 30, 2005 Share Posted August 30, 2005 Hi John. Isn't there a way to modify the file to add sppc and header tags? I can't find the post. Quote Thanks! Clesha Link to comment Share on other sites More sharing options...
redrum Posted August 31, 2005 Share Posted August 31, 2005 When I downoad a complete tab-delimited .txt file the file contain the same products several times. On my last attempt each product was listed 13 times. Can anyone give me a hint of how to solve this? // Fredrik Quote Link to comment Share on other sites More sharing options...
Guest Posted August 31, 2005 Share Posted August 31, 2005 this problem is because of php5, the answer is a few pages back Did you solve the problem? I have the same. On my localhost (testing site) is everything OK, but when I upload the site easypopulate is not uploading correctly. Thanks <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
Guest Posted August 31, 2005 Share Posted August 31, 2005 the same as adding extra fields, header tags is commented out Hi John. Isn't there a way to modify the file to add sppc and header tags? I can't find the post. <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
Z3RatuL Posted August 31, 2005 Share Posted August 31, 2005 I have a weird problem when I try t upload some products. I made a 50 products test file to see if easypopulate works... I upload the csv file without splitting cause it's only 50 products and when it ends it says everything went smooth but when I check to see if the products are there, there's only the last product! Here's an example of easypopulate's output: File uploaded. Temporary filename: /tmp/phpFm2dcf User filename: spectra.csv Size: 9090 | History | History-1 | test1 | test1 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active !New Product! | History | History-2 | test2 | test2 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-3 | test3 | test3 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-4 | test4 | test4 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-5 | test5 | test5 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-6 | test6 | test6 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-7 | test7 | test7 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-8 | test8 | test8 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated | History | History-9 | test9 | test9 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated .... until it reaches the end (50th product) | | | | | | | | | | | | | | | | No products_model field in record. This line was not imported Quote There's a diference between living & BEING ALIVE! Link to comment Share on other sites More sharing options...
Guest Posted August 31, 2005 Share Posted August 31, 2005 (edited) doesnt look like you have the product models listed correctly, they must be different from each other Edited August 31, 2005 by Mibble Quote Link to comment Share on other sites More sharing options...
Z3RatuL Posted August 31, 2005 Share Posted August 31, 2005 WOW that's an awesome QUICK answer! Thanks man it solved the problem. I'm so dumb afterall... :D Quote There's a diference between living & BEING ALIVE! Link to comment Share on other sites More sharing options...
redrum Posted August 31, 2005 Share Posted August 31, 2005 When I downoad a complete tab-delimited .txt file the file contain the same products several times. On my last attempt each product was listed 13 times. Can anyone give me a hint of how to solve this? // Fredrik <{POST_SNAPBACK}> I went thru the file once again, and it turned out that I made some msistakes and left out some code when I added the code for the Extra Image contrib. // Fredrik Quote Link to comment Share on other sites More sharing options...
redrum Posted August 31, 2005 Share Posted August 31, 2005 I have added some code to update the extra images for the extra image contribution. Below are the two sections that update and insert the extra images ### ////////// Check to see if there this product has extra images - JFJ ### if ( isset($v_products_extra_image) ){ $query = " INSERT INTO ".TABLE_PRODUCTS_EXTRA_IMAGES." (products_id, products_extra_image, products_extra_popup_image) VALUES ( '" . $v_products_id . "', '" . $v_products_extra_image . "', '" . $v_products_extra_popup_image . "' )"; } $result = tep_db_query($query); ### /////////////// ### /////////////////// Do we have extra images? JFJ ### if ( isset($v_products_extra_image) ){ // Check to see if this product already have an extra image $result = tep_db_query("SELECT products_id FROM ".TABLE_PRODUCTS_EXTRA_IMAGES." WHERE (products_id = '". $v_products_id . "')"); if (tep_db_num_rows($result) == 0) { // nope, there comes the new extra image $result = tep_db_query($sql); $sql = "INSERT INTO ".TABLE_PRODUCTS_EXTRA_IMAGES." (products_id, products_extra_image, products_extra_popup_image) VALUES ( '" . $v_products_id . "', '" . $v_products_extra_image . "', '" . $v_products_extra_popup_image . "' )"; } else { // already has an image, then we just uptate it $sql = "UPDATE ".TABLE_PRODUCTS_EXTRA_IMAGES." SET products_id='$v_products_id', products_extra_image='" . $v_products_extra_image . "', products_extra_popup_image='" . $v_products_extra_popup_image . "' WHERE products_id = '$v_products_id'"; } $result = tep_db_query($sql); } ###//////////////////// This code insert or update the extra images. But heres the problem; If the section for "Extra Image" is empty in the .txt-file it insert a blank section in the database. How do I make EP skip the insert, if there no extra image to insert? // Fredrik Quote Link to comment Share on other sites More sharing options...
maria071 Posted September 1, 2005 Share Posted September 1, 2005 OK I have tried to make this work but everytime I upload a file it says that it's in tmp/xyz now when i go to move it there is no such file or dir as tmp/xyz. I have made a temp dir in catalog and chmod it to 777. Can you please help OH and DOCUMENT_ROOT is the server path to the store. Quote Link to comment Share on other sites More sharing options...
Guest Posted September 1, 2005 Share Posted September 1, 2005 so your path is /catalog/temp for the temp file in the ep file? Quote Link to comment Share on other sites More sharing options...
maria071 Posted September 1, 2005 Share Posted September 1, 2005 so your path is /catalog/temp for the temp file in the ep file? <{POST_SNAPBACK}> Yep it is and the temp file is chmod 777. I can upload the file and it gives me no errors now but there is no data imported. Thank you for your reply. Quote Link to comment Share on other sites More sharing options...
whimsicalities Posted September 1, 2005 Share Posted September 1, 2005 I am having trouble importing data into Easy Populate. I can download and edit files in tab deliniated format but not import them. I don't get error messages, just no data. I am running oscommerce in localhost mode on a Windows XP machine. My catalog is located at D:\Program Files\Apache Group\Apache2\htdocs\catalog, and I have created a temp directory as required under catalog. I think from what I have read in the posts that my problems are likely to be associated with tempdir and document root settings in configure.php., but I just can't get it right. If anyone is able to assist with specific configure.php line entries I would be very grateful. Many thanks, Michael Quote Link to comment Share on other sites More sharing options...
maria071 Posted September 1, 2005 Share Posted September 1, 2005 Well I am soooooooooooo pleased to say that I think I just figured it all out. The problem was that I was saving the database as a tab delimited file as I thought I was supposed to BUT if you look at the examples clearly the data is semicolon demilited SO i opened my text file and copied a tabed space and pasted into find and then in replace put a semicolon and bingo it actaully imported and gave me the same looking info everyone else sees. Quote Link to comment Share on other sites More sharing options...
axyr Posted September 1, 2005 Share Posted September 1, 2005 Ok I have a problem my site contains about 1200 different products with about 100 different categories. The problem I have is the category images. I need the abilty to add the path to the subcategory and category images to my spreadsheet, otherwise i will have to manually edit the categories to set the images. Since I will be uploading my list 2 or 3 times a week that creates alot of mindless boring work. Is there anyway to do this or has anyone done this? Quote Link to comment Share on other sites More sharing options...
Guest Posted September 1, 2005 Share Posted September 1, 2005 that means you have an older version, you should change it back to tab deelimited, someone had changed it and it has been messing people up all over the place. read thru the ep file as the docs state, you will find the spot to change it. Well I am soooooooooooo pleased to say that I think I just figured it all out. The problem was that I was saving the database as a tab delimited file as I thought I was supposed to BUT if you look at the examples clearly the data is semicolon demilited SO i opened my text file and copied a tabed space and pasted into find and then in replace put a semicolon and bingo it actaully imported and gave me the same looking info everyone else sees. <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
Guest Posted September 1, 2005 Share Posted September 1, 2005 DOCUMENT_ROOT needs to be $DOCUMENT_ROOT check for tab delimited versus semicolon, make sure set to tab delimited in the ep file. I am having trouble importing data into Easy Populate. I can download and edit files in tab deliniated format but not import them. I don't get error messages, just no data. I am running oscommerce in localhost mode on a Windows XP machine. My catalog is located at D:\Program Files\Apache Group\Apache2\htdocs\catalog, and I have created a temp directory as required under catalog. I think from what I have read in the posts that my problems are likely to be associated with tempdir and document root settings in configure.php., but I just can't get it right. If anyone is able to assist with specific configure.php line entries I would be very grateful. Many thanks, Michael <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
simplyclesha Posted September 4, 2005 Share Posted September 4, 2005 (edited) the same as adding extra fields, header tags is commented out <{POST_SNAPBACK}> Hi John. I've been trying to figure out how to uncomment the header tags and I'm at a loss (i'm still learning php). I need to be able to add SPPC & Header tags to my spreadsheet so I can upload. When I downloaded the database, there were no fields for either although they're installed on the server. From the manual I know I need to add this to my spreadsheet: 'v_products_head_title_tag_N' 'v_products_head_desc_tag_N' v_products_head_keywords_N' and 'v_customer_price_N' 'v_customer_group_id_N' What I can't figure out is how to make the header tags & SPPC uncommented without screwing up my database. I found this in easypopulate.php and when I removed the // I got a parse error. // support for Linda's Header Controller 2.0 here if(isset($filelayout['v_products_head_title_tag_' . $lid])){ $row['v_products_head_title_tag_' . $lid] = $row2['products_head_title_tag']; $row['v_products_head_desc_tag_' . $lid] = $row2['products_head_desc_tag']; $row['v_products_head_keywords_tag_' . $lid] = $row2['products_head_keywords_tag']; } // end support for Header Controller 2.0 Am I even close to being on the right track? Edited September 4, 2005 by simplyclesha Quote Thanks! Clesha Link to comment Share on other sites More sharing options...
Guest Posted September 4, 2005 Share Posted September 4, 2005 yes you are, the parse error is probably because a semicolon would now e out of place, something along those lines. Quote Link to comment Share on other sites More sharing options...
FormerLurker Posted September 5, 2005 Share Posted September 5, 2005 John, Thanks -- but I'm not sure what you mean. The fields are obviously in the database, but they don't appear in the EP-generated delimited file. I see in easypopulate.php where the field names are set up (lines 214-227). Is it a simple matter of adding the new fields to this list, or is there something more to it when you say "programmed in." Thanks. easypopulate will recognize these fields if they are programmed in. i use the attribute options contribution <{POST_SNAPBACK}> 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.