Easy Populate 1.2.5.4 support

Can anyone please offer some insight.

I'm still having the same problem and really could use a little (or a lot) of help.

see below+-

Serious:

Can anyone please offer some insight.

I'm still having the same problem and really could use a little (or a lot) of help.

dont use excel. Try using open office.
and dont bother uploading to the /temp folder. Just upload directly from your PC via the ZC admin backend part of EP. Make sure you save it as a .txt too

I had lots of problems with EP when I started. its a massive lerning curve. Oh and check it is installed right. Download a fresh copy and the copy on your server and winmerge. Check the db too.,

Shoe-string budget Ray. Limited to what I have on hand right now.

Serious:

Shoe-string budget Ray. Limited to what I have on hand right now.
Open Office is a FREE open source software package.

Earlier on this thread I suggested a neat trick that seems to assist with the tendency of both Excel AND Openoffice, to write formatting into the eventual TXT file that EP needs to be so squeaky clean.

This is what I do now...

If I have a LARGE number of products (over 1000), I split the spreadsheet into manageable "chunks", of say 300 - 400 products per sheet.

Then I work methodically through each sheet to make sure that the actual data in the sheet is not formatted in any way, other than the standard HTML tags that I manually insert into the text (typically in the product description text, where I may want a bulleted list to render on the browser page.

I look for instances where - for example - spreadsheet-formatted "line breaks" appear in the text. These are often obvious... look at the data in a cell, and if it appears to be in paragraphs, then you can be sure there is a formatted line break there. This must be removed, and in its place a <br /> tag inserted.

SO... a product description that looks like THIS in my spreadsheet...

This is a great product.

It has the following features:-

• It is compact
• It weighs only 1kg
• I comes in various sizes

There are many advantages to using this product as it can do A B and C all at once. Make sure you look at product XYZ as well

Will have ALL the embedded formatting removed, and replaced with...

<b>This is a great product.<b><br /><br />It has the following features:-<ul><li>It is compact</li>It weighs only 1kg</li>I comes in various sizes</li></ul><br /><br />There are many advantages to using this product as it can do A B and C all at once. <em>Make sure you look at product XYZ as well.</em>

Then... when I am SURE that all my data is clean and free of hidden formatting, I open EMERALD EDITOR...

I then go back to Excel (or OpenOffice) and highlight the sheet and <ctrl + c> (copy it).

I then go to Emerald Editor and <ctrl + v> (paste it).

I now have a perfect tab-delimited TXT file...

DivaVocals:

Open Office is a FREE open source software package.

So how much different is it. I'm barely literate on Excel and switching to another program is going to be a drag at best.

And I suppose I should ask....

WHY use Open Office instead of Excel.

I downloaded a copy and it looks a lot like Excel.

And while I'm asking questions, try this one;

I purchased a copy of Ceon Advanced Shipper to allow me to set multiple shipping rates. I've gone through the documentation and it seems fairly straight forwrd, but I still need a way to place a shipping code (Single Character) on either an Excel or O.O tab delimited spreadsheet to be loaded into Easy Populate.

This shipping code is part of my product spread sheets from my vendor. The code designates the shipping cost.

Anyone have any flashes of brilliance?

Easy Populate works easily with Open Office but not excel..

I purchased a copy of Ceon Advanced Shipper
Need to contact developer, Conor, for that..commercial scripts not supported in zencart forums

My question has to do with EP.

but I still need a way to place a shipping code (Single Character) on either an Excel or O.O tab delimited spreadsheet to be loaded into Easy Populate.

Serious:

My question has to do with EP.
I believe it is to do with the way Microsoft products (office, notepad etc) format data. I believe Excel adds additional hidden formatting/stuff which messes things up. (I could be wrong).
There is a way to add additional fields to EP. I have added 'sort odder' to my EP. If you search for my posts within this thread I believe i have linked to the resource which shows you how to do this. But i have a feeling what you are asking for is not accommodated, you may need to beg/pay for this bespoke request.

Wish I could help more, but my php skill set does not appear to be that much higher than yours. I can 'scrape by' on most things already created (simply modifications) but I have to outsource all bespoke work.

Dutchy,
Found the post you referenced and I see where you added *'v_products_sort_order' * and i have seen the thread on how add/edit the column headings.

So what does this change do for you and how are you using it?

Did you have to add 'v_products_sort_order' to your structure in PhpAdmin or was it already there? I don't see it when I view mine.

i dont recall having to make db changes, i think it was all file changes. It allows me to specify the sort order of my products as several hundred products I sell need to be listed differently to the standard ZC alphabetical method. That was not a fun afternoon for me. tried it on four test sites before going live, of course - back up back up back up

Serious:

And I suppose I should ask....
WHY use Open Office instead of Excel.

THREE main reasons:

1. OO allow text long than 256 character to be exported to CSV/TXT, excel will truncate to 256 even if longer
2. OO will correctly encapsulate all fields with your chosen delimiter ... most likely the "", excel does whatever it wants
3. OO will let you chose your character set on export, i.e. UTF-8, ISSO-8559-1, etc.

:cheers:

Hey there, not sure if I missed it, but I uploaded easy populate into my server folder, but its not showing in admin config or tools, or anywhere for that matter.

Deviance x x:

Hey there, not sure if I missed it, but I uploaded easy populate into my server folder, but its not showing in admin config or tools, or anywhere for that matter.

Carefully read the wiki:

http://www.zen-cart.com/wiki/index.php/Easy_Populate

from your brief description, I believe you installed it incorrectly. There have also been recent posts about this very subject, so please page back and look for these.

Ok, Love Easy populate - simple to use! Am currently testing on my local before going live.

However, I'm having a duplicating issue happening and can't seem to find the answer.

I have posted that question in the link below - so that people can find it easier in a search - or they can add in their duplication issues as well (keeping items of the same topic in one location).

I've read through some(a lot) of the items in this thread but can't seem to find an answer. Here's the thread:

http://www.zen-cart.com/forum/showthread.php?t=175392

Any help would be greatly appreciated :bigups:

Hi all,

I thought this issue was mentioned and hopefully resolved in this forum but I couldn't find any related solution.

I'm currently using Zen Cart 1.3.9h and E.P. 1.2.5.4.
I have successfully installed E.P. and been using it for about a month without a problem until yesterday.

I learned that on zencart admin, under category, when I was trying to search an item that I added using E.P., it did not come out. It was my first time searching an item that's added using E.P. So I thought there was a problem or something so I checked the catalog and there was the item I was looking for! Also when I manually searched the item on admin page, there was the item as well.

What could be the problem?

I started manually adding items from yesterday and all manually added items came out just fine when I use search on admin page.

Please help! :)

If any experienced member can help me in my thread :
http://www.zen-cart.com/forum/showthread.php?goto=newpost&t=175689

really thk you for your support