EasyPopulate 4.0 Support Thread

chrysalid:

Hi,
The values in v_products_model are my model numbers.
An example (the first three items):
DVD-MATR
AAG70100G05
AAG7026005

In that case, you probably have some fields with extra delimiters (e.g. quote marks or commas) that throw your import off. This is read as too many fields, so an empty field ends up in the model position.

Hey, What's the most stable version of Easy Populate with the latest Zencart version? The very latest version seems to give an error that is literally impossible to get around.

The error in question: MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
Important to note: this error show up regardless of whether a "EASYPOPULATE_CONFIG_CUSTOM_FIELDS" column is present or not.

My interest isn't in fixing this error but if you have a fix I'd be very appreciative, but I believe that there isn't a fix, so I just want to know which version to install where I can avoid this issue entirely.

Also related, can you downgrade by just 'overwriting' the version you have installed? I'd rather avoid possible future problems. So if this would cause some sort of issue I was wondering how I can safely uninstall and then reinstall. (aka, what files to remove, and any sql commands I need to activate through Zencart's admin, etc)

Thanks in advance!

Ignore my last post I fixed it and I'm sorry for cluttering this page up and wasting time. :(

Thanks for reading anyway.

How do I go about exporting a product in ZC to EP so I can see the fields and such for template. I am new and have no idea.

Thanks
Mark

Isn't there an "export" link or pulldown right on the front of the EP page in your admin?

No, I do not see an Export Link or Pulldown anywhere. Below is what I have in my EP Admin section. It is in "'s.

"Easy Populate For ZenCart v1.5

Upload EP File

Import from Temp Dir (tempEP/)

Download EP and Froogle Files

Download Complete .csv file to edit (Attributes Not Included)
Download Model/Price/Qty .csv file to edit
Download Model/Price/Qty/Last Modified/Status .csv file to edit
Download Model/Category .csv file to edit
Download Froogle tab-delimited .txt file
Download Model/Attributes .csv file

Create EP and Froogle Files in Temp Dir: tempEP/

Create Complete .csv file in temp dir (Attributes Not Included)
Create Model/Price/Qty .csv file in temp dir
Create Model/Price/Qty/Last Modified/Status .csv file in temp dir
Create Model/Category .csv file in temp dir
Create Froogle tab-delimited .txt file in temp dir
Create Model/Attributes .csv file in temp dir

File
Size
Last Modified
Attributes-EP2012Oct09-2109.csv Attributes-EP2012Oct09-2109.csv 0KB Oct 09 2012 09:29:48 PM
ep_debug_log.txt ep_debug_log.txt 43KB Oct 09 2012 09:24:50 PM
fulfillment-inv-new test 1.csv fulfillment-inv-new test 1.csv 2545KB Oct 08 2012 03:09:02 PM
Full-EP2012Oct09-2109.csv Full-EP2012Oct09-2109.csv 1KB Oct 09 2012 09:14:56 PM
note.txt note.txt 0KB Oct 07 2012 07:05:07 AM
Test 2.csv Test 2.csv 5KB Oct 09 2012 09:24:50 PM"

I am getting a MySql Error 1054 on uploading a sample inventory. What does it mean and what do I do to correct this.

Mark

Those "Create ..." links are probably the Export links. And the exported files will be located in the foldername specified.

Ok thanks. Any idea on the MySQL 1054 Error that I am getting.

Thanks
Mark

The full text of the error message will be critical information.

And someone else will need to respond to that part. I don't use EP, so can't really speak to all its finer details.

firstcapitalfirearms:

No, I do not see an Export Link or Pulldown anywhere. Below is what I have in my EP Admin section. It is in "'s.

You have a different (older) version of EP. The latest version is EP 4. This is what I see.

I am trying to install EP 4 as I guess I had the wrong EP installed the first time. Anyways I have it installed and I am getting the error

"Easy Populate "Uploads Folder" missing!
Your uploads folder is missing. Your configuration indicates that your uploads folder is named temp/, and is located in /home/firstcap/public_html/".

I am trying to locate the temp/ folder on Filezilla and I cannot find it. Am I looking for something different or what do I do to fix this problem. I see in the install.txt that it states to

"Now go to Configuration -> Easy Populate 4 and edit the Uploads Directory. The default directory is "temp/"
This assumes you have a directory "temp" in the root of your website. I highly recommend that you
move your temp directory into your admin, or change the name to something that is obscure for security reasons."

What do I change it to since I cannot even locate the temp/ folder. Any help is greatly appreciated.

Thanks
Mark

firstcapitalfirearms:

I am getting the error

"Easy Populate "Uploads Folder" missing!
Your uploads folder is missing. Your configuration indicates that your uploads folder is named temp/, and is located in /home/firstcap/public_html/".

I think you must create the folder. Just name it "temp" to see if that works. Then you can move/rename it.

VideoStan:

I think you must create the folder. Just name it "temp" to see if that works. Then you can move/rename it.

Thanks it works now.

Yes - that is what has happened.
In the long descriptions, there are commas.
Is there a way I can fix this? Or do I need to replace all commas? (that would be a lot of work!)
Thanks,
Amber

Easy Populate 4 seems to be working great but I'm having a vexing problem. I've successfully imported my products but when I go to edit an individual product, I make a change click on preview, and then don't have the Back, Update, or Cancel buttons on the preview page. I do have the option with products I've uploaded individually; otherwise I would think the problem is elsewhere.

I've compared the query strings from a manually-added product and one from Easy Populate, and there is no difference other than the category and ID of the product.

I've turned on strict debugging and looked in my logs but there are no errors to give me a clue. It seems as if not allowing me to edit the product is set somewhere and I don't know where to fix it.

I'm running on a cPanel VPS with Zen Cart 1.5.1, upgraded from 1.3.9h. Everything else is working just fine.

I've been trying to find a way to 'escape' the comma - and have had no luck. So I just deleted all of the contents in the description.
There are now no comma's anywhere in the csv file.
When I try to import I get "No model field in record. This line was not imported" over and over - no records import.
But I have no idea why...
What now?
Thanks!
Amber

I haven't any trouble with commas as long as they are encapsulated inside quotes. I'd make sure you are using LibreOffice's Spreadsheet program.

If I'm not mistaken, the docs say that one must provide a model name or the import will fail. I just put the product's category name in there. I really don't think it matters what content is in that field so long as it isn't empty. Hope that helps!

chrysalid:

I've been trying to find a way to 'escape' the comma - and have had no luck.

As Hermes says, you don't need to escape commas; just a field with a comma inside it must be enclosed in quote marks. Chad had a post somewhere that related to what character set is used. Something more than the problem I suspected is wrong.

JeeWizz! Since the forum upgrade I never get regular notifications of new posts! Sorry I missed so much activity.

Appreciate the help VideoStan, DocByte!