Zen Cart Logo
Forums / Addon Admin Tools / EasyPopulate 4.0 Support Thread

EasyPopulate 4.0 Support Thread

Sticky

Views: 733,331

Results 761 to 780 of 3,671
1 Dec 2012, 2:15 PM
#761
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

EasyPopulate 4.0 Support Thread

tidusbg:

Here is the code I'm trying to load.

v_products_model,v_categories_name_1,v_categories_name_2,v_categories_name_3,v_categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7
100,Електротехника1,Категория1,,,,,
200,Електро1,Категрия2,,,,,



This looks like a partial data file from an earlier version of EP. This will not work with EP4.

What you REALLY need to do is FIRST enter a couple products normally through the zencart admin. Create a couple categories and sub-categories, and if you have more than one language, also be sure to enter the language names of the categories for these additional languages.

Once you have a couple categories and products, do a full export.

You will now have the correct column mappings. 

Also, be sure to use OpenOffice to export your CSV file. 

When in OpenOffice you:

1) select File -> Save as 
2) select Text (CSV) from File Type
3) put check in "Edit filter settings" check box
4) click save (a new window will pop open)
5) click Keep Current Format ( new window titled Export Text File will open )
6) Under Field Options select Unicode UTF-8 for character set, Comma for Field Delimiter and Double Quote for Text Delimiter
7) click ok.

You are making this MUCH harder on yourself by doing it any other way.

After you have done this, zip your file and attach it to your next post.

-chadd
2 Dec 2012, 1:21 PM
#762
tidusbg avatar

tidusbg

New Zenner

Join Date:
Nov 2012
Posts:
2
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

chadderuski:

This looks like a partial data file from an earlier version of EP. This will not work with EP4.

What you REALLY need to do is FIRST enter a couple products normally through the zencart admin. Create a couple categories and sub-categories, and if you have more than one language, also be sure to enter the language names of the categories for these additional languages.

Once you have a couple categories and products, do a full export.

You will now have the correct column mappings.

Also, be sure to use OpenOffice to export your CSV file.

When in OpenOffice you:

  1. select File -> Save as
  2. select Text (CSV) from File Type
  3. put check in "Edit filter settings" check box
  4. click save (a new window will pop open)
  5. click Keep Current Format ( new window titled Export Text File will open )
  6. Under Field Options select Unicode UTF-8 for character set, Comma for Field Delimiter and Double Quote for Text Delimiter
  7. click ok.

You are making this MUCH harder on yourself by doing it any other way.

After you have done this, zip your file and attach it to your next post.

-chadd

Thank you very, very much.:smile:
Now everything is fine. I'm just not inflicted products correctly.
And when I import files I was in another language (ENG).
Thank you very, very much.:smile:

3 Dec 2012, 8:48 PM
#763
barricades avatar

barricades

Inactive

Join Date:
May 2007
Posts:
150
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Hey there,

I'm trying out this newer version of easy-pop having been a fan of the old one. Works great, thanks, but when I bulk uploaded a bunch of products all went well for most products but some ended up in the wrong category.

The products which ended up in the wrong place were all down towards the bottom in the spreadsheet. It starts to go awry when the first product in the category Guinness Merchandise^Guinness Magnets & key rings

After the first product in that category, products end up getting placed in the same category as the product listed before. I reckon it's something to do with the ampersand. In the file downloaded by easypop the ampersand appears as & whereas in my admin the ampersand is &

Firstly, is this the cause of my problem and second, is there anyway to make it so that & is used instead of &

thanks for all the hard work :)

3 Dec 2012, 9:57 PM
#764
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

barricades:

Hey there,

I'm trying out this newer version of easy-pop having been a fan of the old one. Works great, thanks, but when I bulk uploaded a bunch of products all went well for most products but some ended up in the wrong category.

The products which ended up in the wrong place were all down towards the bottom in the spreadsheet. It starts to go awry when the first product in the category Guinness Merchandise^Guinness Magnets & key rings

After the first product in that category, products end up getting placed in the same category as the product listed before. I reckon it's something to do with the ampersand. In the file downloaded by easypop the ampersand appears as & whereas in my admin the ampersand is &

Firstly, is this the cause of my problem and second, is there anyway to make it so that & is used instead of &

thanks for all the hard work :)

Hi Barricades!

Go to Configuration -> Easy Populate 4

What do you have set for "Convert Curly Quotes, etc."

Try it with html equivalants ( I can't remember off the top of my head if I'm convertion the ampersand ... )

-chadd

4 Dec 2012, 9:19 PM
#765
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

barricades:

Hey there,

I'm trying out this newer version of easy-pop having been a fan of the old one. Works great, thanks, but when I bulk uploaded a bunch of products all went well for most products but some ended up in the wrong category.

The products which ended up in the wrong place were all down towards the bottom in the spreadsheet. It starts to go awry when the first product in the category Guinness Merchandise^Guinness Magnets & key rings

After the first product in that category, products end up getting placed in the same category as the product listed before. I reckon it's something to do with the ampersand. In the file downloaded by easypop the ampersand appears as & whereas in my admin the ampersand is &

Firstly, is this the cause of my problem and second, is there anyway to make it so that & is used instead of &

thanks for all the hard work :)

Okay, looked into this a bit more. The ampersand does not get converted anywhere in EP4. So if your Zencart categories use & you will need to use that in your spread sheet. The reason you get a different category is because string comparison of & and & are completely different.

-chadd

5 Dec 2012, 3:59 PM
#766
mystic_jewels avatar

mystic_jewels

New Zenner

Join Date:
Apr 2010
Location:
North West England
Posts:
11
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Hi,

I'm a noob to using Easy Populate myself, after moving web hosts they have just installed it for me to get used too.

I have edited the heading ensuring I have v_model_number (sku, product code) inserted as a heading along with only some of the other headings. As all of them are not a requirement for my store.

My Headings:
v_products_model v_products_name_1 v_products_name_2 v_products_description_1 v_products_description_2 v_unit of sale v_products_price_GBP v_products_price_EURO v_products_weight_kg v_clothing_size v_date_added

Anyway, to cut a long story short I have created a mini version of the stock report and if it's not the error:

No model field in record. This line was not imported

It's the error:

'Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer'.

Does anyone please know why the errors are happening for my circumstances. Also after clearing up files from my database I have gone and deleted the sample template file provided by EP. Does anyone have a spare copy of this I can look at? It may be all I need!

Kind Regards
Duncan Oates

5 Dec 2012, 4:24 PM
#767
videostan avatar

videostan

New Zenner

Join Date:
Jan 2009
Posts:
32
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Mystic_Jewels:

I have gone and deleted the sample template file provided by EP. Does anyone have a spare copy of this I can look at? It may be all I need!

Chadd recommends that you add a few products through admin, including all categories and languages. Then download that and use that as your model.

Are you sure that you have installed this version of EP4?

From Chadd in a post on the previous page:

When you navigate to Tools > Easy Populate 4 you should have "Easy Populate 4.0.22 - Beta 6-10-2012"
for your page title...

5 Dec 2012, 4:37 PM
#768
mystic_jewels avatar

mystic_jewels

New Zenner

Join Date:
Apr 2010
Location:
North West England
Posts:
11
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Hiya,

Thanks for response.

Just says "Easy Populate For ZenCart v1.5.x"

5 Dec 2012, 4:52 PM
#769
videostan avatar

videostan

New Zenner

Join Date:
Jan 2009
Posts:
32
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Mystic_Jewels:

Just says "Easy Populate For ZenCart v1.5.x"

This is not Chadd's version of EP4. I did not like the previous versions that had spun off of Phazei's work, but have not tried the version you have installed. Chadd's version works very well for me.

EP4 is not in the official plugins yet, and can be found in the link at post 1 of this thread.

14 Dec 2012, 6:25 AM
#770
nuganics avatar

nuganics

New Zenner

Join Date:
Dec 2008
Posts:
65
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

I am using https://github.com/chaddro/EasyPopulate-4.0 on Zen Cart 1.5.1 and in in Config I have "Upload File Date Format" = d-m-y but for the special start and end date I have to use YYYY-MM-DD because if I use d-m-y the specials start and end in the 60's :) No big deal but thought I'd mention it encase anyone else is having issues.

Cheers
Tim
BioStim Pty

14 Dec 2012, 6:20 PM
#771
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

nuganics:

I am using https://github.com/chaddro/EasyPopulate-4.0 on Zen Cart 1.5.1 and in in Config I have "Upload File Date Format" = d-m-y but for the special start and end date I have to use YYYY-MM-DD because if I use d-m-y the specials start and end in the 60's :) No big deal but thought I'd mention it encase anyone else is having issues.

Cheers
Tim
BioStim Pty

Hi Tim,

yeah, I need to look at this code again more closely before posting a new update.

thanks,
chadd

21 Dec 2012, 10:51 PM
#772
liamv avatar

liamv

New Zenner

Join Date:
Feb 2010
Posts:
73
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Error message ERROR: Import file does not exist:/var/www/html/temp/R

I am getting the above error message when I try to import a CSV file that I have uploade to Zencart.

When I look the CSV file that I am trying to import is in the var/www/html/temp folder.

I am a newbie to EZ populate - I have been using it for about a week to download categories clean up the data and then reload it back up to my zencart site and this has been working very well.

Yester day I created a new CSV file with 1300 items in it by downloading a CSV file from the site, opening it with Microsoft Xcel, populating it with the new products and categories and saving in xlsx format. I have then reopened the file with LibreOffice and saved it as a CSV file.

I have split the file up into several smaller files on my local PC and then tried uploading files and importing files with a few number of models and sometimes this works and sometimes I just get the error message above.

Can anyone help?

Please ask me what futher details you need to provide me with meaningful support.

25 Dec 2012, 6:27 AM
#773
karlh626 avatar

karlh626

New Zenner

Join Date:
Mar 2008
Posts:
5
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

After uploading the files, When I click on Tools - Easy Populate 4 I am taking to a blank screen.

I have tried downloading the latest version from GitHub and uploading the files again to make sure files are complete and do not have errors.

I am using ZenCart 1.51

When I try to access the Easy Populate 4 option, I get the following log entries:

[25-Dec-2012 05:58:47 UTC] PHP Notice: Use of undefined constant EASYPOPULATE_4_CONFIG_TEMP_DIR - assumed 'EASYPOPULATE_4_CONFIG_TEMP_DIR' in /home/<admin dir>/easypopulate_4.php on line 79
[25-Dec-2012 05:58:47 UTC] PHP Notice: Undefined index: epinstaller in /home/<admin dir>/easypopulate_4.php on line 79
[25-Dec-2012 05:58:47 UTC] PHP Notice: Undefined index: epinstaller in /home/<admin dir>/easypopulate_4.php on line 84
[25-Dec-2012 05:58:47 UTC] PHP Notice: Undefined index: epinstaller in /home/<admin dir>/easypopulate_4.php on line 90
[25-Dec-2012 05:58:47 UTC] PHP Notice: Use of undefined constant EASYPOPULATE_4_CONFIG_CUSTOM_FIELDS - assumed 'EASYPOPULATE_4_CONFIG_CUSTOM_FIELDS' in /home/<admin dir>/easypopulate_4.php on line 109
[25-Dec-2012 05:58:47 UTC] PHP Notice: Use of undefined constant EASYPOPULATE_4_CONFIG_CUSTOM_FIELDS - assumed 'EASYPOPULATE_4_CONFIG_CUSTOM_FIELDS' in /home/<admin dir>/easypopulate_4.php on line 110
[25-Dec-2012 05:58:47 UTC] PHP Fatal error: Call to undefined function mb_internal_encoding() in /home/<admin dir>/easypopulate_4.php on line 139

I am not sure what to look for next.
Thank you in advance.

28 Dec 2012, 9:46 PM
#774
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

karlh626:

After uploading the files, When I click on Tools - Easy Populate 4 I am taking to a blank screen.

I have tried downloading the latest version from GitHub and uploading the files again to make sure files are complete and do not have errors.

I am using ZenCart 1.51

When I try to access the Easy Populate 4 option, I get the following log entries:

[25-Dec-2012 05:58:47 UTC] PHP Notice: Use of undefined constant EASYPOPULATE_4_CONFIG_TEMP_DIR - assumed 'EASYPOPULATE_4_CONFIG_TEMP_DIR' in /home/<admin dir>/easypopulate_4.php on line 79
[25-Dec-2012 05:58:47 UTC] PHP Notice: Undefined index: epinstaller in /home/<admin dir>/easypopulate_4.php on line 79
[25-Dec-2012 05:58:47 UTC] PHP Notice: Undefined index: epinstaller in /home/<admin dir>/easypopulate_4.php on line 84
[25-Dec-2012 05:58:47 UTC] PHP Notice: Undefined index: epinstaller in /home/<admin dir>/easypopulate_4.php on line 90
[25-Dec-2012 05:58:47 UTC] PHP Notice: Use of undefined constant EASYPOPULATE_4_CONFIG_CUSTOM_FIELDS - assumed 'EASYPOPULATE_4_CONFIG_CUSTOM_FIELDS' in /home/<admin dir>/easypopulate_4.php on line 109
[25-Dec-2012 05:58:47 UTC] PHP Notice: Use of undefined constant EASYPOPULATE_4_CONFIG_CUSTOM_FIELDS - assumed 'EASYPOPULATE_4_CONFIG_CUSTOM_FIELDS' in /home/<admin dir>/easypopulate_4.php on line 110
[25-Dec-2012 05:58:47 UTC] PHP Fatal error: Call to undefined function mb_internal_encoding() in /home/<admin dir>/easypopulate_4.php on line 139

I am not sure what to look for next.
Thank you in advance.

What version of PHP are you using? You can find this by logging into your admin and go to Tools -> Server Version/Info.

I think you are on an old version of php. You should have 5.3 or newer...

-chadd

28 Dec 2012, 9:48 PM
#775
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Liamv:

Error message ERROR: Import file does not exist:/var/www/html/temp/R

I am getting the above error message when I try to import a CSV file that I have uploade to Zencart.

When I look the CSV file that I am trying to import is in the var/www/html/temp folder.

I am a newbie to EZ populate - I have been using it for about a week to download categories clean up the data and then reload it back up to my zencart site and this has been working very well.

Yester day I created a new CSV file with 1300 items in it by downloading a CSV file from the site, opening it with Microsoft Xcel, populating it with the new products and categories and saving in xlsx format. I have then reopened the file with LibreOffice and saved it as a CSV file.

I have split the file up into several smaller files on my local PC and then tried uploading files and importing files with a few number of models and sometimes this works and sometimes I just get the error message above.

Can anyone help?

Please ask me what futher details you need to provide me with meaningful support.

Can you verify which version of EasyPopulate you are using? When you go to Tools -> EasyPopulate 4, it should have

Easy Populate 4.0.22 - Beta 6-10-2012

at the top, which is my latest version.

-chadd

28 Dec 2012, 10:19 PM
#776
karlh626 avatar

karlh626

New Zenner

Join Date:
Mar 2008
Posts:
5
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Thanks for your reply...

The version of PHP on the server in question is 5.3.13
MySQL version is 5.1.66
When I got to Admin -> Tools and click on Easy Populate 4, I just get a blank page.

The file easypopulate_4.php contained in the admin directory contains this line at the top:
// $Id: easypopulate_4.php, v4.0.21 06-01-2012 chadderuski $

I did also try creating a new fresh install of ZenCart and tried installing EasyPopulate 4 from git hub a few days ago and got the same blank screen when I click on Easy Populate 4 on the Tools menu.

ZenCart 1.5.1 does work without any issues that I am aware of.

chadderuski:

Can you verify which version of EasyPopulate you are using? When you go to Tools -> EasyPopulate 4, it should have

Easy Populate 4.0.22 - Beta 6-10-2012

at the top, which is my latest version.

-chadd

28 Dec 2012, 10:26 PM
#777
karlh626 avatar

karlh626

New Zenner

Join Date:
Mar 2008
Posts:
5
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

If there is a newer version than what is on GitHub, please let me know so I can download that to try.

31 Dec 2012, 2:32 AM
#778
serious avatar

serious

Totally Zenned

Join Date:
Feb 2011
Posts:
686
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

zc1.50

I'm trying to put together a CVS file to upload to Nextag and one of the things I need is the url for all of my products....that's over 5k urls

Is there a way to have all of my product page URL's with a full EP Download?

2 Jan 2013, 2:39 PM
#779
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Serious:

zc1.50

I'm trying to put together a CVS file to upload to Nextag and one of the things I need is the url for all of my products....that's over 5k urls

Is there a way to have all of my product page URL's with a full EP Download?

Hi Serious,

No, this is not built into EP4 at this time. I'll have to see if it can be added. I have a couple of requests for this now.

In the mean time you should be able to use Numinix's google merchant feeder and pull the url's from the xml data.

-chadd

3 Jan 2013, 3:02 AM
#780
hasher avatar

hasher

New Zenner

Join Date:
Sep 2011
Posts:
77
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Hi chadderuski

Just wondering if it is possible to add products with a download link . Or should I say a directory and file name and type . Mostly I work with PDF downloads . Which header names of columns would I be looking for . Or is it restricted to those column names in the export file.

Thanks Paul