Mailing List Archive: Bricolage: users

Publish media asset and update external database

Index | Next | Previous | View Threaded

chris.schults at pccsea

Dec 3, 2008, 11:40 AM

Post #1 of 11 (4041 views)
Permalink

Publish media asset and update external database

When you publish a media asset, in my case an image, is it possible to
also insert the asset's metadata (alt text, title, width, height, etc)
to an external database?

If so, how? :o)

Chris

bret at pectopah

Dec 3, 2008, 11:50 AM

Post #2 of 11 (3946 views)
Permalink

Re: Publish media asset and update external database [In reply to]

Hi Chris,

I think it would be pretty easy if that media asset were going along for
the ride with a story. You could just have the story template look at
the metadata and talk to the external db.

But media assets don't have templates of their own, so I'm not sure how
to do this in the absence of a story.

Hope this helps,

Bret

On Wed, 2008-12-03 at 11:40 -0800, Schults, Chris wrote:
> When you publish a media asset, in my case an image, is it possible to
> also insert the asset's metadata (alt text, title, width, height, etc)
> to an external database?
>
> If so, how? :o)
>
> Chris
>
--
Bret Dawson
Producer
Pectopah Productions Inc.
(416) 895-7635
bret [at] pectopah
www.pectopah.com

chris.schults at pccsea

Dec 3, 2008, 12:49 PM

Post #3 of 11 (3958 views)
Permalink

RE: Publish media asset and update external database [In reply to]

> I think it would be pretty easy if that media asset were going along
for
> the ride with a story. You could just have the story template look at
> the metadata and talk to the external db.

Thanks Bret. However, in my case, these images will not necessarily be
part of a story. I'd like to use Bricolage to manage these images, but
they will be primarily used by an application that needs to know the
image metadata, which resides in a MySQL database.

> But media assets don't have templates of their own, so I'm not sure
how
> to do this in the absence of a story.

Me too. I suppose I could create a special story whose template does
what I need, and then create a cron job that triggers a republish of
that story when my target images are published. Was hoping there was
another way.

Chris

simonw at digitalcraftsmen

Dec 3, 2008, 4:17 PM

Post #4 of 11 (3940 views)
Permalink

Re: Publish media asset and update external database [In reply to]

Bret Dawson wrote:
> But media assets don't have templates of their own, so I'm not sure how
> to do this in the absence of a story.

There's actually no good reason why Media shouldn't have templates and
we've actually done this for one of our clients.

Paul keeps promising to craft a patch to allow this in v2 but although
it's a relatively simple change it needs proper docs and probably some
tests to enable it. Unfortunately we've lacked the tuits to make that
happen.

We were talking about it just the other day as we'd like to get it in
before the feature freeze.

He's on site wrangling Bricolage tomorrow but I'll see what we can put
together in the next week or so.

S.

--
Digital Craftsmen Ltd
Exmouth House, 3 Pine Street, London. EC1R 0JH
t 020 7183 1410 f 020 7099 5140 m 07951 758698
w http://www.digitalcraftsmen.net/

chris.schults at pccsea

Dec 3, 2008, 4:26 PM

Post #5 of 11 (3942 views)
Permalink

RE: Publish media asset and update external database [In reply to]

> There's actually no good reason why Media shouldn't have templates and
> we've actually done this for one of our clients.
>
> Paul keeps promising to craft a patch to allow this in v2 but although
> it's a relatively simple change it needs proper docs and probably some
> tests to enable it. Unfortunately we've lacked the tuits to make that
> happen.

> He's on site wrangling Bricolage tomorrow but I'll see what we can put
> together in the next week or so.

Thanks Simon. Any chance this could be applied to v1, specifically
1.10.3?

Chris

phillip at communitybandwidth

Dec 3, 2008, 4:45 PM

Post #6 of 11 (3962 views)
Permalink

Re: Publish media asset and update external database [In reply to]

On 3-Dec-08, at 7:17 PM, Simon Wilcox wrote:

> Bret Dawson wrote:
>> But media assets don't have templates of their own, so I'm not sure
>> how
>> to do this in the absence of a story.
>
> There's actually no good reason why Media shouldn't have templates
> and we've actually done this for one of our clients.

Media templates +1

--
Phillip Smith,
Simplifier of Technology
Community Bandwidth
http://www.communitybandwidth.ca

john at grumpet

Dec 3, 2008, 4:51 PM

Post #7 of 11 (3950 views)
Permalink

Re: Publish media asset and update external database [In reply to]

couldn't you use an Action for this?
http://bricolage.cc/docs/current/api/?Bric::Dist::Action

Schults, Chris wrote:
>> I think it would be pretty easy if that media asset were going along
>>
> for
>
>> the ride with a story. You could just have the story template look at
>> the metadata and talk to the external db.
>>
>
> Thanks Bret. However, in my case, these images will not necessarily be
> part of a story. I'd like to use Bricolage to manage these images, but
> they will be primarily used by an application that needs to know the
> image metadata, which resides in a MySQL database.
>
>
>> But media assets don't have templates of their own, so I'm not sure
>>
> how
>
>> to do this in the absence of a story.
>>
>
> Me too. I suppose I could create a special story whose template does
> what I need, and then create a cron job that triggers a republish of
> that story when my target images are published. Was hoping there was
> another way.
>
> Chris
>
>

zdravko.balorda at siix

Dec 3, 2008, 11:22 PM

Post #8 of 11 (3947 views)
Permalink

Re: Publish media asset and update external database [In reply to]

>> Thanks Bret. However, in my case, these images will not necessarily be
>> part of a story. I'd like to use Bricolage to manage these images, but
>> they will be primarily used by an application that needs to know the
>> image metadata, which resides in a MySQL database.

Well, in this case media could be handled by some type of "dummy" cover
story which never gets published, but can tie some clever template to
manage the media.

Zdravko

david at kineticode

Dec 4, 2008, 12:06 AM

Post #9 of 11 (3955 views)
Permalink

Re: Publish media asset and update external database [In reply to]

On Dec 4, 2008, at 1:51 AM, John Greene wrote:

> couldn't you use an Action for this?
> http://bricolage.cc/docs/current/api/?Bric::Dist::Action

Yes, although templates would obviously be easier for people to use.

Best,

David

paulo at digitalcraftsmen

Dec 4, 2008, 1:49 AM

Post #10 of 11 (3940 views)
Permalink

RE: Publish media asset and update external database [In reply to]

Hi Chris,

It can't go into the released 1.10 branch since it's too big a
change and I haven't been able to test it outside of the boundaries
we used it in. When I get to the office tomorrow I can send you the
diff I have for 1.10.2 I believe, which would be enough for you to
put it in your version. Are you using the Mason Burner ?

I'm planning on adding it to V2 and then getting people to help me
test it properly in there.

regards,

Paul

chris.schults at pccsea

Dec 4, 2008, 10:00 AM

Post #11 of 11 (3948 views)
Permalink

RE: Publish media asset and update external database [In reply to]

> It can't go into the released 1.10 branch since it's too big a
> change and I haven't been able to test it outside of the boundaries
> we used it in. When I get to the office tomorrow I can send you the
> diff I have for 1.10.2 I believe, which would be enough for you to
> put it in your version. Are you using the Mason Burner ?

Thanks Paul. Yes, I'm using the Mason burner.

Chris

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads