Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate Doesnt Work..


Guest

Recommended Posts

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...