Forums / Addon Admin Tools / Can EZpopulate generates Product-Music?

Can EZpopulate generates Product-Music?

Views: 856

Results 1 to 8 of 8
18 Oct 2018, 12:24 AM
#1
jfigure_com avatar

jfigure_com

New Zenner

Join Date:
May 2013
Location:
Tokyo, Japan
Posts:
18
Plugin Contributions:
0

Can EZpopulate generates Product-Music?

I installed EZP4 and uploaded a new product. But it comes out as Product-General while all my listings are Product-Music. (I need info like Record Company, Music Genre and Artist instead of Manufacturer.) Updating the existing product seems to be alright but generating a new products causes a problem. Can somebody help?

18 Oct 2018, 7:17 PM
#2
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Can EZpopulate generates Product-Music?

jfigure.com:

I installed EZP4 and uploaded a new product. But it comes out as Product-General while all my listings are Product-Music. (I need info like Record Company, Music Genre and Artist instead of Manufacturer.) Updating the existing product seems to be alright but generating a new products causes a problem. Can somebody help?
The field v_products_type is what controls the product type for the new product. When you export your existing content, you should see a value other than 1 in your download (most likely 2). Further in your import if the field is not included, but the artists name is included, then the products_type is set to 2. That said, there also is a configuration setting in the EP4 configuration group related to enabling products music data if you hadn't found that already.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

19 Oct 2018, 6:20 AM
#3
jfigure_com avatar

jfigure_com

New Zenner

Join Date:
May 2013
Location:
Tokyo, Japan
Posts:
18
Plugin Contributions:
0

Re: Can EZpopulate generates Product-Music?

Thank you for your advice. I created the field, products_type, from admin, exported the data and confirmed the number 2 in the field of my existing products. Still wondering how to create a new music product using EP. Where can I find "the EP4 configuration group related to enabling products music data"? Sorry for asking again.

19 Oct 2018, 9:45 AM
#4
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Can EZpopulate generates Product-Music?

jfigure.com:

Thank you for your advice. I created the field, products_type, from admin, exported the data and confirmed the number 2 in the field of my existing products. Still wondering how to create a new music product using EP. Where can I find "the EP4 configuration group related to enabling products music data"? Sorry for asking again.
Once logged into the admin, goto configuration->Easy Populate V4.
Then in the list is the configuration setting.

Having it enabled will export the other music related fields. It does not need to be enabled to support import. That said, having it enabled makes it easier to understand the fields associated with the music product type.

We are talking about easy populate v4 as provided at: https://www.zen-cart.com/downloads.php?do=file&id=2069
Correct?

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

19 Oct 2018, 7:35 PM
#5
jfigure_com avatar

jfigure_com

New Zenner

Join Date:
May 2013
Location:
Tokyo, Japan
Posts:
18
Plugin Contributions:
0

Re: Can EZpopulate generates Product-Music?

Oh, sorry! My EP was not the latest version. That's why I find that function in the admin. I install the V4 from the link you provided and see what'll happen.

18 Jan 2019, 6:24 AM
#6
jfigure_com avatar

jfigure_com

New Zenner

Join Date:
May 2013
Location:
Tokyo, Japan
Posts:
18
Plugin Contributions:
0

Re: Can EZpopulate generates Product-Music?

I installed Easy Populate V4 and now I can export Product_Music. Thank you.
However, I encountered another problem of importing. After uploading a csv file to Admin/temp folder and I can see the file exists there both from the admin/tool/Easy Populate 4 page and the FTP screen, but clicking the import button results in "ERROR: Import file does not exist:/home/XXX/YYY-com/public_html/zen_new/Admin/temp/ZZZ.csv.
The "Download" button works but the "Import" and "Delete" buttons do not.
I followed your advice to someone who post the same problem before and checked the permission of my temp folder set to 755 and the .htaccess file downloaded from the "htaccess4AdminTempFolder" located there. Also checked the csv file uploaded and downloaded (but not yet imported) and do not find any problem. Can you help me again?
I'm using Mac and doing this in my test site for Zen Cart 1.5.6 (php7.2, MySQL 5.7).

18 Jan 2019, 7:01 PM
#7
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Can EZpopulate generates Product-Music?

jfigure.com:

I installed Easy Populate V4 and now I can export Product_Music. Thank you.
However, I encountered another problem of importing. After uploading a csv file to Admin/temp folder and I can see the file exists there both from the admin/tool/Easy Populate 4 page and the FTP screen, but clicking the import button results in "ERROR: Import file does not exist:/home/XXX/YYY-com/public_html/zen_new/Admin/temp/ZZZ.csv.
The "Download" button works but the "Import" and "Delete" buttons do not.
I followed your advice to someone who post the same problem before and checked the permission of my temp folder set to 755 and the .htaccess file downloaded from the "htaccess4AdminTempFolder" located there. Also checked the csv file uploaded and downloaded (but not yet imported) and do not find any problem. Can you help me again?
I'm using Mac and doing this in my test site for Zen Cart 1.5.6 (php7.2, MySQL 5.7).

I realize that the filename has been obscured for some reason maybe, but the filename itself is important in the process. Could you please provide the replacement of ZZZ or something very similar?

Because the button posts data, it is subject to the ZC sanitization rules applied, I have a feeling that the admin sanitization may have been the cause or not being able to import/delete the file. To address that I may need to add a sanitization rule into the processing or some other method to uniquely identify the file.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

19 Jan 2019, 12:04 AM
#8
jfigure_com avatar

jfigure_com

New Zenner

Join Date:
May 2013
Location:
Tokyo, Japan
Posts:
18
Plugin Contributions:
0

Re: Can EZpopulate generates Product-Music?

Problem solved!
As you said, the point was the csv file name. I use Google Spread Sheet to open, edit and download the csv file. The auto-generated file name by Google Spread Sheet when downloading contained space between, for example, ZZ Z.csv. I renamed it as ZZ_Z.csv and am now able to import/delete.
Thank you very much and have a nice weekend!