Reindexing data that has been altered through SQL queries to the database

[William Beaufoy]

I'm migrating a custom PHP/ MySQL system to RS. I'm trying to use RS functions to insert all the files with the proper metadata, but may need to run some manual sql queries on the database once everything is done.

I'm not quite clear about the functioning of reindex.php, would this be effective in remapping the keywords if say, all instances of one piece of metadata were changed to another via SQL query?

[Tom Gleason]

reindex.php indexes keywords for all fields, so you may want to look
at reindex_field.php to reindex a specific field.

> --
> You received this message because you are subscribed to the Google Groups
> "ResourceSpace" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to resourcespac...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>



--
Tom Gleason

Colorhythm LLC
http://www.colorhythm.com

Main Office: +1 415-399-9921
Fax: +1 253-399-9928
Mobile: +1 347-537-8465

tgle...@colorhythm.com

[Tom Gleason]

function update_field($resource,$field,$value)
is the best function to use for a migration

On Tue, Jun 11, 2013 at 3:34 PM, William Beaufoy
<william...@gmail.com> wrote:

[William Beaufoy]

Thanks. So am I right that reindex_field.php works by using the values in resource_data to replace the old keyword information.

I am using update_field for the migration, so hopefully won't be necessary.