Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Bricolage: users

Updating story_keyword table

 

 

Bricolage users RSS feed   Index | Next | Previous | View Threaded


chris.schults at pccsea

Apr 29, 2009, 5:36 PM

Post #1 of 3 (807 views)
Permalink
Updating story_keyword table

I've imported new keywords via bric_soap (create).
I exported keyword IDs from database.
I exported relevant story IDs from database.
I'm ready to import a list of mapped story_id's and keyword_id's
directly into the story_keyword table.

Any reason not to? Is there a better way? Note: there about 150 stories
and about the same number of keywords involved.

Chris

--------------------------------

Chris Schults
Web Developer
PCC Natural Markets
206-547-1222 x104
chris.schults [at] pccsea
http://www.pccnaturalmarkets.com

Sign up for PCC Fresh, a monthly newsletter filled with seasonal
recipes, exciting new products, and more:
http://www.pccnaturalmarkets.com/enews


david at kineticode

Apr 29, 2009, 6:05 PM

Post #2 of 3 (735 views)
Permalink
Re: Updating story_keyword table [In reply to]

On Apr 29, 2009, at 5:36 PM, Schults, Chris wrote:

> I've imported new keywords via bric_soap (create).
> I exported keyword IDs from database.
> I exported relevant story IDs from database.
> I'm ready to import a list of mapped story_id's and keyword_id's
> directly into the story_keyword table.
>
> Any reason not to? Is there a better way? Note: there about 150
> stories
> and about the same number of keywords involved.

WTF? Why aren't story keywords versioned! Looks like story_keyword
uses story_id, but it *should* be using story_instance_id. I guess no
one ever noticed, must not have been a big deal.

Anyway, I suggest you try it with one story and make sure that the
keywords appear in that story in the UI (or a SOAP export).

Best,

David


chris.schults at pccsea

Apr 30, 2009, 10:51 AM

Post #3 of 3 (726 views)
Permalink
RE: Updating story_keyword table [In reply to]

> Anyway, I suggest you try it with one story and make sure that the
> keywords appear in that story in the UI (or a SOAP export).

All worked fine (after I de-duped the list).

> WTF? Why aren't story keywords versioned! Looks like story_keyword
> uses story_id, but it *should* be using story_instance_id. I guess no
> one ever noticed, must not have been a big deal.

BTW, we're still using 1.10.3, in case that makes a difference.

Chris

--------------------------------

Chris Schults
Web Developer
PCC Natural Markets
206-547-1222 x104
chris.schults [at] pccsea
http://www.pccnaturalmarkets.com

Sign up for PCC Fresh, a monthly newsletter filled with seasonal
recipes, exciting new products, and more:
http://www.pccnaturalmarkets.com/enews

Bricolage users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.