You are here:  » Additional indexed fields

Support Forum



Additional indexed fields

Submitted by marco@flapper on Mon, 2011-12-05 10:33 in

I looked at http://www.pricetapestry.com/node/3094 and this creates and additional field under Field Mapping.

But what a extra field under Optional Index Fields?

I'm using 12.10B and using the mod for search filters. I want to have an additional field to use with the search filters.

Submitted by support on Mon, 2011-12-05 11:47

Hi Marco,

Additional filters can be added against any field in the feed, it doesn't have to be one that appears on Feed Registration Step 2 under Optional Index Fields; but just to clarify, did you want to be able to enter a custom value (like you can with Category and Brand) as an alternative to selecting a field from the feed?

Cheers,
David.
--
PriceTapestry.com

Submitted by marco@flapper on Mon, 2011-12-05 11:53

Yes, preferably I wanted to be able to add a custom value for feeds that don't have a value for this field in the feed.

Submitted by support on Mon, 2011-12-05 11:57

Hi Marco,

If you could first implement the new field normally as per the thread, and then if you could email me your

includes/admin.php
admin/feeds_register_step2.php

..i'll work out the changes for you (it's straight forward but lots of small changes so not easy to document in the forum...)

Cheers,
David.
--
PriceTapestry.com

Submitted by marco@flapper on Thu, 2011-12-08 08:44

Thanks for your help. It is working now.

Submitted by marco@flapper on Fri, 2011-12-16 15:16

Hi,
Can it be that the database tool isn't working when I implement additional index fields?

I copied a previous PT installation which I modified with one extra additional indexed field. Then I used the database tool (restore) to import the feeds but nothing gets imported. The backup is also from the modified PT installation with one extra additional indexed field.

When I drop the database tables and don't do a restore with the database tool I can import feeds on the new PT installation.

Submitted by support on Fri, 2011-12-16 16:02

Hi Marco,

That is correct, but this is fixed in the latest distribution - if you extract the latest admin/database_tool.php that will include custom fields.

Cheers,
David.
--
PriceTapestry.com

Submitted by marco@flapper on Mon, 2011-12-19 08:53

It is not working completely.

I replaced the database_tool.php and ran the import via a cron job.

The error disappeared but the other feeds are still not imported.

As had allready imported some feeds manually I dropped the tables and ran setup again and created the additional field via the dbmod.php.

I ran the import again but now nothing gets imported. So I did the backup with the database tool again. The first time I only checked Feed registration and category and product mapping. Now I checked all.

The import nows goes partially. I still have feeds that are not imported. No error message in cron message just:
importing feed.xml...[0/0]
importing feed.xml...[done]

I tried to manually import one of the feeds but it doesn't import. I tried it also manually at the original site and there it does import.

PS:
The original error message was:

importing za_zx.xml...[0/0]PHP Warning: preg_replace() [function.preg-replace]: Delimiter must not be alphanumeric or backslash in /home/liefje/public_html/includes/filter.php on line 401

Submitted by support on Mon, 2011-12-19 09:14

Hi Marco,

Apologies for the inconvenience; I know your site has been modified quite considerably but it shouldn't be far off.

Please could you re-run the Restore process but with database debug mode enabled by changing line 6 in config.advanced.php as follows;

  $config_databaseDebugMode = TRUE;

Thanks,

David.
--
PriceTapestry.com

Submitted by marco@flapper on Mon, 2011-12-19 11:04

I enabled database debug mode and did the restore with the database tool.

Imported via the cron job but got no cron message. Also tried to manually import one feed, but zero products get imported (and no error messages).

I removed all the global filters and then I could import the feed manually. But the filters shouldn't be the problem as they work at the original site with the same feed?

I also notice the manually imported feeds doesn't show in the admin page (not even zero products imported) but they do show on the site.

Submitted by support on Mon, 2011-12-19 11:35

Hi Marco,

It does sound like the database may be in an inconsistent state - could you drop me an email with the installation URL and any username/password required for /admin/ and I'll check it out with you right away..

Cheers,
David.
--
PriceTapestry.com

Submitted by marco@flapper on Tue, 2011-12-20 10:19

Thanks it works