problem with archived events...

-madmax- · Post by **-madmax-** » Thu Mar 02, 2006 8:12 pm

hi,

is there a way to move archived events to another cam ?

i know that sound odd, but here is the problem...

i have some setup where i added a second camera to overlook a special area...at one point there where events which i archived, but later i decided that that camera isn't nessary and removed the camera and stopped the capturing etc...

now i have 6 id's which have no events (all got deleted) expect those archives....

maybe we could add a "pool" for events (archives) which are not bound to a id ?

any thoughts ?

rene'

Post by **zoneminder** » Fri Mar 03, 2006 4:44 pm

There is no easy way to do it. However if you are happy with accessing the database directly then you can try the following in mysql

Code: Select all

mysql> update Events set MonitorId = <new cam id> where MonitorId = <old cam id>;

then move the event directories from events/<old cam id> to events/<new cam id>.

I would make sure you back up your events and DB before you try this though, and shut ZM down so zmaudit doesn't come along half way through and delete them.

-madmax- · Post by **-madmax-** » Sat Mar 04, 2006 3:12 am

ah, ok

i going to try that!

is there a way to add this to some wishlist for a future version ?

i mean i think it help to have a way of moving events from one camera id to another...

thanks,
rene

Post by **zoneminder** » Tue Mar 07, 2006 11:15 pm

I will add it to the wishlist, though you are the first person ever to ask

jameswilson · Post by **jameswilson** » Tue Mar 07, 2006 11:18 pm

Im personally not sure about this one, as i think the amount of time it will actually be used will massivly be out weighed by the writing of it. And as i t can be done manually i think it can be way down the list.

But then its a feature of little use to me so i would say move it down the list lol wouldnt I!!

Is this of use to anyone else? or would a script be a better way to go

-madmax- · Post by **-madmax-** » Fri Mar 17, 2006 10:51 pm

hmm, not sure why this would be little use...

don#t get me wrong you guys develop the stuff, but i'm not sure if you use it that much..eg. like me hahaha

i have 8 servers running and the way its working is this...

i need a stable setup, so install newest build of zoneminder on a server setup a few test camera and see for a few weeks how stable this is...then i roll the machine out and use more cam's which are all capture secuirty feeds etc..and sure enough there are events i would like to archive but not just export....so when a camera location isnt used anymore i move the camera to a new location then i need to rename the cam and now i have those old events under the new setup...very difficult to find them later....

i think it would be great if you could move archived events to a pool of events ...maybe even called archive pool or one of course could just create on cam which holds all the old events from other cams if it would be possible to move them from one cam to another...

just my 5 cents...

jameswilson · Post by **jameswilson** » Fri Mar 17, 2006 10:56 pm

im just wondering about the interface to change these things. I dont think its to hard to modify the data as all you need to edit is the monitor number from the old one to the new one.

-madmax- is this something you would regularly use then?

-madmax- · Post by **-madmax-** » Sat Mar 18, 2006 6:55 pm

hi james,

i have on each of those 8 servers running at least 3 "dead" cams which hold archived events...

and because want them to be viewable to my security guys i didn't delete them...

i guess the way i switch cams around makes that kinda problem more obvious for me then for other people...

hey, i even would een make a big hardware donation e.g. motherboard,cpu, ram or whatever is needed to get a feature inside the webinterface to move archived events from one cam to another!