If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Admin Tools / Easy Populate 1.2.5.4 support

Easy Populate 1.2.5.4 support

Started by langer on 9 May 2006, 9:44 PM · Views: 1,303,111

Results 441 to 460 of 3,834
10 Dec 2006, 12:51 PM
#441
bradlawson avatar

bradlawson

New Zenner

Join Date:
Oct 2005
Posts:
71
Plugin Contributions:
0

Easy Populate 1.2.5.4 support

Ok, i am a little confused. Now Easy Populate Reg. is still free, but the feature packed advance is not, right? Wasn't easy populate reg. in the download section before, why is it not now? I read a pervious post by langer, and i guess there is a problem with the new easy populate reg for 1.3.6, is that why you can't download it?

Thanks

Brad

10 Dec 2006, 3:51 PM
#442
oeginc avatar

oeginc

New Zenner

Join Date:
Nov 2006
Posts:
7
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

bradlawson:

Ok, i am a little confused. Now Easy Populate Reg. is still free, but the feature packed advance is not, right? Wasn't easy populate reg. in the download section before, why is it not now? I read a pervious post by langer, and i guess there is a problem with the new easy populate reg for 1.3.6, is that why you can't download it?

Thanks

Brad

That's correct, and I have fixed a few of the problems in the "free" version of Easy Populate and uploaded it to here, but ZenCart appears to be taking their sweet time approving downloads, as of this moment it's been 7 days and still no word.

Maybe I'll just have to setup a download section on one of my websites somewhere.

10 Dec 2006, 4:12 PM
#443
steveorg avatar

steveorg

New Zenner

Join Date:
Oct 2006
Location:
The Wrong Coast
Posts:
22
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

schoolboy:

milkyway:

I'd highly recommend the greek restaurant Nestos Estiatorio in New City
The Viet Nam Restaurant, 304 North Main Street, Spring Valley, NY 10977
Turkois Grill, on Saddle River Road in Airmont
Greek Village, Rt 303/ Livingston St. in Northvale NJ
Originally Posted by milkyway
Hi langer and all,
I have some problem here, I have an excel file containing datas of few hundred products. I tried to re-arrange them in EZ-populate format.
I face difficulties when it comes to product's description, because ZenCart use HTML format, while the description I have in hand is in plain text format. So when I upload them it will not displayed corcetly, because of no HTML tags such as <p>, <br /> to arrange them.
So it would be a huge task to edit the description one by one, do you have any idea how I can import the excel into ZenCart without having to edit the description into HTML?
Thanks
milkywayI had a similar issue - with nearly 3000 products. I (partially) resolved it as follows...

As I wanted double line breaks after each sentence in the product description, I decided to use the "friendliness" that exists between MS WORD and MS EXCEL.

I highlighted the entire "Product Description" column in Excel, then Copied to clipboard.

I then Pasted the column into MS Word. I now had a single column "table" of all the product descriptions.

Then I converted TABLE to TEXT, with breaks selected as paragraphs (not tabs).

Doing "Search & Replace" I replaced all instances of ^p (paragraph) with $$$ . (This is just a unique string that I can easily find later to "reconvert" $$$ to ^p .)

Now I have a massive paragraph of sentences, broken at various intervals by $$$.

Then I did a "Search & Replace" for "fullstop + spacebar" (. ) - ie: the end of each sentence - and replaced it with .<br /><br /> (fullstop + tag + tag).

Now I had all my sentences properly tagged with the double <br /> html.

Then i did a search & replace for $$$, turning them back into ^p.

Finally, I highlighted all text and did a TEXT TO TABLE, with PARAGRAPH as the line break.

Before copying and pasting back into Excel, I created another column in Excel NEXT TO the original Product Description column.

I PASTE the altered column into this new column, and alongside is the original text. I can quickly do a random sampling to see if the text in both columns matches up. Check the first, last and several middle records. If they match up, you're pretty safe that your new column is identical to your old column, but now you have the <br /><br /> tags in place.

Delete the old column, remembering to shift its EP header over to the new column first.

You can achieve the same results with the following Excel VBA procedure. It replaces all paragraph and line breaks in the column headed by v_products_description_1.```
Sub InsertBR()
Application.ScreenUpdating = False
Cells.Find(What:="v_products_description_1", After:=ActiveCell, LookIn:= _
xlValues, LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
Range(Selection, Selection.End(xlDown)).Select
For Each cl In Selection.SpecialCells(xlCellTypeConstants, 23)
cl.Replace What:=Chr(13), Replacement:="<br /><br />", SearchOrder:=xlByColumns
cl.Replace What:=Chr(10), Replacement:="<br /><br />", SearchOrder:=xlByColumns
Next cl
ActiveCell.Select
Application.ScreenUpdating = True
End Sub

 
Usage note: To work correctly, all records must have a description. Otherwise, the code will stop at the first blank description.
 
Steve
11 Dec 2006, 10:48 AM
#444
bradlawson avatar

bradlawson

New Zenner

Join Date:
Oct 2005
Posts:
71
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Just post the new verison some where and put the link on the fourm.

Thanks

Brad

11 Dec 2006, 2:22 PM
#445
jvoce avatar

jvoce

New Zenner

Join Date:
Jul 2006
Location:
Toronto, ON
Posts:
87
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I'm starting out with easy populate and I'm already having an error. All I've done so far is complete the installation.

When I click on the easy populate button under Tools Easy Populate screen comes up but it as has this message below:

Import Data from file in temp/

Warning: dir(../temp/) [function.dir]: failed to open dir: Invalid argument in .../admin/easypopulate.php on line 695

Fatal error: Call to a member function read () on a non-object in ...\admin\easypopulate.php on lin 697

What does this mean, and what can I do to fix it?

11 Dec 2006, 4:25 PM
#446
jvoce avatar

jvoce

New Zenner

Join Date:
Jul 2006
Location:
Toronto, ON
Posts:
87
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I'm starting out with easy populate and I'm already having an error. All I've done so far is complete the installation.

When I click on the easy populate button under Tools Easy Populate screen comes up but it as has this message below:

Import Data from file in temp/

Warning: dir(../temp/) [function.dir]: failed to open dir: Invalid argument in .../admin/easypopulate.php on line 695

Fatal error: Call to a member function read () on a non-object in ...\admin\easypopulate.php on lin 697

What does this mean, and what can I do to fix it?

11 Dec 2006, 4:40 PM
#447
jvoce avatar

jvoce

New Zenner

Join Date:
Jul 2006
Location:
Toronto, ON
Posts:
87
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I'm starting out with easy populate and I'm already having an error. All I've done so far is complete the installation.

When I click on the easy populate button under Tools Easy Populate screen comes up but it as has this message below:

Import Data from file in temp/

Warning: dir(../temp/) [function.dir]: failed to open dir: Invalid argument in .../admin/easypopulate.php on line 695

Fatal error: Call to a member function read () on a non-object in ...\admin\easypopulate.php on lin 697

What does this mean, and what can I do to fix it?

12 Dec 2006, 10:21 AM
#448
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

jvoce, what version are you using?

12 Dec 2006, 2:10 PM
#449
oeginc avatar

oeginc

New Zenner

Join Date:
Nov 2006
Posts:
7
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

jvoce:

I'm starting out with easy populate and I'm already having an error. All I've done so far is complete the installation.

When I click on the easy populate button under Tools Easy Populate screen comes up but it as has this message below:

Import Data from file in temp/

Warning: dir(../temp/) [function.dir]: failed to open dir: Invalid argument in .../admin/easypopulate.php on line 695

Fatal error: Call to a member function read () on a non-object in ...\admin\easypopulate.php on lin 697

What does this mean, and what can I do to fix it?

It sounds like you don't have a directory called 'temp' in your cart directory... That's where easy populate stores files that it creates on the server. The default installation comes with some sample EP files in that directory (Attributes-EP*.txt, Category-EP*.txt, Froogle-EP*.txt, Full-EP*.txt, PriceQty-EP*.txt and there is a blank index.html file as well).

12 Dec 2006, 2:20 PM
#450
jvoce avatar

jvoce

New Zenner

Join Date:
Jul 2006
Location:
Toronto, ON
Posts:
87
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Zen-Cart Verison: 1.3.6
Easy Populate: ep_v2_75_zen-cart_1_2.zip

I just noticed that you're website says it has problems with it. I'll try the other version.

Hopefully that should work?

12 Dec 2006, 8:05 PM
#451
jvoce avatar

jvoce

New Zenner

Join Date:
Jul 2006
Location:
Toronto, ON
Posts:
87
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I've downloaded your version, and so far it looks like it's working. We have to try and tweek the excel file that comes out from one of our own computer programs to place the items properly in the file.

We are looking forward to the day that more flexability is given for attributes matching unique model numbers.

Thank you, and Merry Christmas.

13 Dec 2006, 8:03 PM
#452
hbtrading avatar

hbtrading

New Zenner

Join Date:
Jan 2006
Posts:
82
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

oeginc:

That's correct, and I have fixed a few of the problems in the "free" version of Easy Populate and uploaded it to here, but ZenCart appears to be taking their sweet time approving downloads, as of this moment it's been 7 days and still no word.

Maybe I'll just have to setup a download section on one of my websites somewhere.

Hey if youd like me to help out with hosting the new file I would be more than glad to...let me know.

Watches
Powered by Zen Cart

14 Dec 2006, 12:14 AM
#453
naturalolive avatar

naturalolive

New Zenner

Join Date:
Aug 2006
Posts:
19
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

ericpeng:

I am usign Canada Post Shipping Module.
Anyone know how to add dimensions(L x W x H) & weight to Easy Populate ??

Thanks

Did anyone solve this issue. I am trying to achieve the same thing. ie download lx w x h that have been input into the canada post mod fields

15 Dec 2006, 1:40 PM
#454
jvoce avatar

jvoce

New Zenner

Join Date:
Jul 2006
Location:
Toronto, ON
Posts:
87
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi All!

I'm trying to master ep in Excel for easy uploading and downloading of all our products. It's working great for uploading, love it. I don't quite have downloading completely understood.

Whenever I download the list and open it in Excel the first zero in any ISBN goes missing. I know this is an Excel thing, but I'm wondering if there's anyway I can set the download not to do this, instead of just placing another character in front of each number.

If anyone has ideas please pass them on. Thanks.

15 Dec 2006, 6:08 PM
#455
denliv avatar

denliv

Zen Follower

Join Date:
Jul 2004
Posts:
103
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I'm no Excel pro, but once you have the data in the spreadsheet (or a blank sheet with all the necessary fields) set the field to text as opposed to numeric. Once set clear everything but the header row & use this as template for importing your data.
Dennis

17 Dec 2006, 7:32 PM
#456
kopythat05 avatar

kopythat05

New Zenner

Join Date:
Dec 2006
Posts:
3
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

i am trying to use EP, bt i am trying to figure out how to do the proper dump.........seems like when i do my dump, everything is CSV, and I am wondering if it is possible to have each value in their own column...........i have tried every possible dump and just cant seem to figure it out.......I am looking to add about 10,000 products to my store, and to enter each in a CSV format is just too long of a process.....

Can anyone assist me with this process...

Any advice would be greatly appreciated

Kopy

17 Dec 2006, 8:30 PM
#457
denliv avatar

denliv

Zen Follower

Join Date:
Jul 2004
Posts:
103
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

When you download the dump it should be a text file. If you import it into Excel & define tab as the separator (I define all fields as text so leading 0's and dates aren't messed with by Excel) everything should be in it's own column. What are you trying to open it with?

Personally I prefer Microsoft Access. I can massage my data better.

Dennis

18 Dec 2006, 8:54 PM
#458
jvoce avatar

jvoce

New Zenner

Join Date:
Jul 2006
Location:
Toronto, ON
Posts:
87
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Is it possible to enter in a sort number field?

19 Dec 2006, 6:47 AM
#459
andjules avatar

andjules

New Zenner

Join Date:
Nov 2006
Posts:
5
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I've checked and checked, but somehow on my latest import, I've got some inconsistent results with regards to subcategorization:
In two main categories, there are only subcategory folders, NO products at the top level, as the zen cart designers intended (or so I am led to believe).
In 4 other main categories, the subcategories are visible on the catalog admin page, BUT all the subcategorized products HAVE ALSO been linked to their parent categories (so that clicking into the parent category will display all products from all subcategories). I actually like the second behaviour, but
a) I've read that I'll be in danger of a flaky store if I try to have parent categories contain BOTH products and subcategories;
b) I can't get the stubborn main categories to behave the same way, even using the multiple categories link manager.

Anyone have any advice on how to get all parent categories to behave the same way, without manually re-linking each product one at a time????

20 Dec 2006, 2:55 PM
#460
jvoce avatar

jvoce

New Zenner

Join Date:
Jul 2006
Location:
Toronto, ON
Posts:
87
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I'm trying to add a field for sort order, yet I'm not having much luck. Could someone point me in the right direction please?