Guest Posted February 2, 2006 Share Posted February 2, 2006 Hi, I've tried Easy Populate and everything seems to be setup correctly except when I try to download The Complete tab-delimited .txt file to edit the page always times out, and if I download just the Model / Price / Quantity ( All I want to do is change the weights on all products) then it looks like this, ;4.95;0;EOREOR;2.99;0;EOREOR ;2.99;0;EOREOR ;0.25;0;EOREOR ;0.25;0;EOREOR ;0.65;-1;EOREOR ;0.3;-1;EOREOR ;0.4;0;EOREOR ;0.45;0;EOREOR ;0.65;0;EOREOR I cannot open the .txt file with excel either...I've tried renaming but with no luck. Can anyone else get this to work or is it a dud contrib? Quote Link to comment Share on other sites More sharing options...
madstarr Posted February 2, 2006 Share Posted February 2, 2006 Hi, I've tried Easy Populate and everything seems to be setup correctly except when I try to download The Complete tab-delimited .txt file to edit the page always times out, and if I download just the Model / Price / Quantity ( All I want to do is change the weights on all products) then it looks like this, I cannot open the .txt file with excel either...I've tried renaming but with no luck. Can anyone else get this to work or is it a dud contrib? I am a newbie and I installed Easy Populate 2.76b last week and it works wonderfully. After a few small issues were resolved. I would suggest reading the document at http://www.oscommerce.com/community/contri...y+Populate+2.78 called Importing Using Easy Populate. It is a instruction manual to some of the quirks that are common with Easy Populate. As to opening a downloaded .txt file in excel. I dont know if this is the only way to make it work. But, I changed the field separator in the easypopulate.php file to be tab by commenting out the other field separators. This is at about line 79: $separator = "\t"; // tab is default //$separator = ","; // comma //$separator = ";"; // semi-colon //$separator = "~"; // tilde //$separator = "-"; // dash //$separator = "*"; // splat Then just open excel and open the .txt file. You do not have to rename it. Depending on the version of excel, you will be prompted with a text import wizard. In which you will chose "Delimited" as the data type. And "tab" as the delimiter. I set the text qualifier to "none" and it opens perfectly. Hope this helps Quote Link to comment Share on other sites More sharing options...
Guest Posted February 2, 2006 Share Posted February 2, 2006 Hi, I've tried Easy Populate and everything seems to be setup correctly except when I try to download The Complete tab-delimited .txt file to edit the page always times out, and if I download just the Model / Price / Quantity ( All I want to do is change the weights on all products) then it looks like this, I cannot open the .txt file with excel either...I've tried renaming but with no luck. Can anyone else get this to work or is it a dud contrib? Hi, thankyou for replying. I will take your advice and see how I get on, Thanks again, Pete 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.