Product Extra Fields for text, pdfs and flash

[emilio]

i installed the module in my test site but i don't know how to add the product id in the product_extra_fields table through excel with phpmyadmin and than import again in the database
Could someone explain me please how to do that ?



thank you

[gjh42]

You're not going to affect the "product id" with an extra field - that is set automatically when the product is created, and you should not try to change it. If you mean the product's model number, that is something you can input when creating/editing the product, but not subject to the extra fields in this mod.

You will have to explain in more detail what number you are talking about, and Delia will have to be the one to answer, as I don't know the code for this mod.

[emilio]

right ..i mean when Delia says

If you are installing this into a cart that already has products, you will have to populate the new table with every product id in order for the products to be visible. This is not hard to do with excel and phpmyadmin. If you have access to your database, export the file to excel, add the fields and import it back in.

When i try to upload a file into the description the product disappears due to Product Master Category: ID# that is missing

how does i do that in practice ?

[ellivir]

I got enough of dealing HTMLarea and installed FCKeditor. All went fine with the installation itself and the new editor appears when making a new product on the standard text areas but in the "Extra Text Field" it comes just as plain text, no editor at all.

What shall I do?

[emilio]

I got enough of dealing HTMLarea and installed FCKeditor. All went fine with the installation itself and the new editor appears when making a new product on the standard text areas but in the "Extra Text Field" it comes just as plain text, no editor at all.

What shall I do?

personally i prefer tiny mce on zen ..anyway have you activated it in the admin and under the products /category ?
Personally it's a week that i'm waiting a reply from delia about her "easy" phpmyadmin product id modify.
Maybe i'm retarded but i didn't understand

[lat9]

@emilio: Here's what I did to get the product_extra_fields on products that were in my catalog before I applied the PEF add-on:

NOTE: Backup your database before you do this stuff (in case it goes wrong).

Start phpMyAdmin. If you've installed PEF correctly, you'll see a product_extra_fields table within your zen-cart database.

If that's there, go to your product table and write down the products_id values for all the products that you want to have the extra fields. Now, click on the product_extra_fields table name on the left-side of the display. Up at the top of the screen, click the Insert tab and you're presented with an entry screen to create a new entry in the PEF table.

For each of the products_id values that you want to have the extra fields: enter the products_id number in the products_id Value element of the form, enter   in the extra_field Value element of the form, and keep the Null checkbox checked for all other elements. Click "Go"; that will add an element in the PEF table for that products_id.

Note: If you have a bunch of products_id's to add, make sure to look at the bottom of the page and select "Insert another new row" as the action to take after the current row is added.

It's cumbersome, but it worked for me!

[emilio]

@emilio: Here's what I did to get the product_extra_fields on products that were in my catalog before I applied the PEF add-on:

NOTE: Backup your database before you do this stuff (in case it goes wrong).

Start phpMyAdmin. If you've installed PEF correctly, you'll see a product_extra_fields table within your zen-cart database.

If that's there, go to your product table and write down the products_id values for all the products that you want to have the extra fields. Now, click on the product_extra_fields table name on the left-side of the display. Up at the top of the screen, click the Insert tab and you're presented with an entry screen to create a new entry in the PEF table.

For each of the products_id values that you want to have the extra fields: enter the products_id number in the products_id Value element of the form, enter   in the extra_field Value element of the form, and keep the Null checkbox checked for all other elements. Click "Go"; that will add an element in the PEF table for that products_id.

Note: If you have a bunch of products_id's to add, make sure to look at the bottom of the page and select "Insert another new row" as the action to take after the current row is added.

It's cumbersome, but it worked for me!

thank you buddy for the help.
is very difficult to have support here in zen-cart
i started with zen about 6 7 years ago but now i'm moving to joomla + vm because of this .... poor support especially international (...)
It's a pity because zen was a milestone in ecommerce ....
People needs to be more in collaboration and take off the nerd coder behaviour ..using simple words ...thinking that everyone can give his support.

thanks again

Emilio

[lat9]

There's (at a minimum) an extra empty <li> generated when a product is created after the product_extra_fields add-on is installed. The problem is that the default value for the extra_field element is &nbsp; (which is not an empty string).

What I did to correct this was to take the code at line 37 in \includes\modules\pages\product_info\main_page_vars_product_type.php:

  $extra_field  = $files->fields['extra_field'];

and expand it to:

  $extra_field  = $files->fields['extra_field'];
  if (!empty($extra_field) && $extra_field == ' ') $extra_field = '';

That makes empty($extra_field) to be true for the processing in the product_info display.

[delia]

Sorry about being awol, guys! Been under the weather.

First of all, the absolute best way to create the correct fields and rows after installing this is to do it via excel. lat9 is right about the way he did his cart. However, some folks may find that to be cumbersome and may not even work for others. You need to create a row for every product you have not just the ones you think you need this on.

First, export the product_extra_fields table via phpmyadmin. Choose excel csv as the type of export and you may need to experiment to see which opens correctly in your version of excel but the csv works for me. Be sure not to leave NULL in the blank for filler for empty space.

Open that file in excel. Fill in the product id numbers for every product (type 1,2,3,4,5 - select and draw the column down to easily create your product id numbers). Save the file as csv and import in phymyadmin. Put a comma in Fields terminated by where it defaults to semicolon. Be sure to check the box to replace the table data.

I am aware that copying and deleting the product does not work correctly and will be fixing once I get a chance to do that.

[ellivir]

personally i prefer tiny mce on zen ..anyway have you activated it in the admin and under the products /category ?
Personally it's a week that i'm waiting a reply from delia about her "easy" phpmyadmin product id modify.
Maybe i'm retarded but i didn't understand

So, the editor DOES APPEAR with the normal product description area but not with the extra field that this Delia's contribution adds into product information.
Editor is activated but just doesn't appear for the extra field, for other places it comes visible.

Elli