EP Problem in 2.5 - Any Ideas??

[cindyt2009]

I am using easy populate to import my database....I have set the extra product fields up under catalog as well as in easypopulate.php. when i go to import the file, it says that:

Filename: EP_Split1.csv
1146 - Table 'comstoc3_beta.TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FI ELDS' doesn't exist

SELECT products_extra_fields_value FROM TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS WHERE (products_id ='1') AND (products_extra_fields_id ='1')

Obviously, that table is not in the database file, but shouldn't it there if the Extra Product Field is available in the 2.5 version - or am I missing something.

Also - what happened to the english.php file in catalog/includes/language/...

Some of the osc add-ons require this file to add info....


Please advise....
Thanks,
C

p.s. i love all the extras in this version....saves a lot of time adding the code to the older versions...thanks. **ALSO posted in Announcement section - sorry**

[michael_s]

You are missing this: Products Extra Fields is not installed in osCmax 2.5. Extra Product Fields is installed. They are two completely different mods.

Extra Product Fields
Products Extra Fields

I am guessing that EP works with Products Extra Fields, but osCmax has Extra Product Fields installed.

Next, for future language compatibility issues, we have modified the language file structure slightly. english.php has been renamed core.php and moved into the languages/english directory.

This has been done for all the master language files as well, renaming them to core.php and putting them in their respective language subdirectories. This makes all the languages modular in one directory and allows for easier language pack development.

[cindyt2009]

Thank you....i will go and find the headers for Extra Product Fields to add in the EP data file...
Thanks for the info on the core.php/english.php as well.

[cindyt2009]

Followup on Extra Product Fields to work with EP....

I have read the directions for EP to turn on the EPF in EP. It says to create a new file with the following headers:

'v_products_model' The model number for the product. You must add this to each line and all v_products_model must be unique.
'v_products_extra_fields_name' Case sensitive name of the extra Field. Must be exactly the same as the name of the extra field in the admin area.
'v_products_extra_fields_id' This is the tricky one, it is the extra fields ID. You will probably need to use PHPMyAdmin to find out what it is.
'v_products_extra_fields_value' The value you want for the extra field.

I have done that and my header for that file is as follows:
v_products_model v_products_extra_fields_name v_products_extra_fields_id v_products_extra_fields_value

I went into PHPAdmin and found that my epf_id was 1 making my first line read as follows (with header):

v_products_model v_products_extra_fields_name v_products_extra_fields_id v_products_extra_fields_value AV442 UPC 1 766183304421

When I upload the file into EP, I get the following error:


1146 - Table 'comstoc3_beta.TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FI ELDS' doesn't exist

SELECT products_extra_fields_value FROM TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS WHERE (products_id ='1') AND (products_extra_fields_id ='1')

[TEP STOP]

Can you give me an idea of what I am doing (or not doing) correctly? Are my headers wrong? Format? I am at a loss and would appreciate the help, advice and/or direction.

Thanks in advance,
Cindy

[michael_s]

Did you actually add the Products Extra Fields mod? Did you add the table and the database_tables.php constant for the new table? It looks like you haven't added the mod Products Extra Fields yet. The clue is that you have a constant being displayed in the error:

TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS

This means you have not defined the constant in database_tables.php. Once defined, the php code will replace the constant name with its defined name and will be able to locate it in the database if the table is there. Most likely if you haven't defined it there, you probably haven't created the actual table in your database either.

Remember, osCmax does not have Products Extra Fields installed, it has Extra Product Fields. A totally different mod that uses a different table in the database and is not compatible with Easypopulate.

It will not work until you install the Products Extra Fields mod fully.

[cindyt2009]

I did not add the Product Extra field contrib at all. Since Extra Product Fields was already incorporated in the new version, I just used that one.

That's what I was thinking too...that the EP "thinks" I am using Product Extra Fields and not Extra Product Fields....(the EP instructions states Extra Product Fields) and now you are saying it is not Extra Product Fields is NOT compatible with EP? If that is the case, why would it be included in the instructions? The EP directions seem to state to create a new file and upload that one and it would add those fields to the DB....

In the EP directions - it shows to use those specific headings for the export/import file but it seems that those are wrong since there are no database files that are even in the sql....

If I knew or had an example of an actual header line (1st line for the export file) then perhaps I can use that. I looked at my actual db file and it is using things like 'epf_id', epf_value' etc....when I tried importing that file, it gave me another error message that said that the product_image_description was not valid....something also needed for Product Extra Fields....

any suggestions or is Extra Product fields simply not compatible with EP? Do you know if PEF is compatible? I think I tried that one and I could not get it to work properly in one of the lower versions of OscMax.

Thoughts?

C

[michael_s]

I did not add the Product Extra field contrib at all.

That is why it isn't working for you. You need to install that mod if you want to use it with easypopulate, or you need to modify easypopulate to insert into the database tables that osCmax uses for its extra product fields.

This is not just a matter of changing the header line, you will need to hack up easypopulate.php to insert the data into the correct osCmax tables.

[cindyt2009]

So, just so I am understanding - the Extra Product Field mod that is already incorporated into OscMax 2.5 is only to 'add' fields to the product info on both admin & catalog sides - making visible etc. if desired. It is not however compatible with EP as far as importing and exporting data in like the basic EP file?

I guess that part was a bit confusing since the 'extra field' option is configurable in EP....like SPPC and multi-images, etc.

Thanks for clearing it up for me...I appreciate it...

[michael_s]

Correct.

The mod that easypopulate is compatible with is Products Extra Fields and is NOT installed in osCmax 2.5.

The mod installed in osCmax 2.5 is Extra Product Fields, and is completely different than the one that easypopulate is compatible with.

We will eventually get around to updating Easypopulate to work with Extra Product Fields, but it is currently a low priority.

[ridexbuilder]

Notice that multi-images in EP is also not compatible with 'Max. EP is a generic contribution with many options that are not necessarily appropriate to use.