Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

EasyPopulate 2.3 Released


wasson65

Recommended Posts

  • Replies 86
  • Created
  • Last Reply

Top Posters In This Topic

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

Link to comment
Share on other sites

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,

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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,

Link to comment
Share on other sites

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!!!

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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

It stops to be work if you are enjoying it

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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-)

Link to comment
Share on other sites

"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

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...