Re: Database changes that may be helpful for you

[Sam Richards]

This is terrific work, I've lost immediate access to filemaker, which I'm trying to rectify, so that I can review this before putting this on the website.

Thanks again for the work!

Sam.

On Tue, Jan 22, 2019 at 4:31 PM Devin Breese <dbr...@gmail.com> wrote:

Hi Everyone,

This database has been excellent to use, many thanks. After using it on several shows I've made a few changes to it that reflect my needs. I figured I would share in case it helps someone else?

-There is now a "Shot Dupe" button that copies info from the last take of the current slate into the first take of a new slate, and adds a "-" to the end of the slate name as a temporary placeholder. 99% of the time when the slate changes this is what I want to do. This will save a lot of time and redundant data entry. It was my biggest gripe with the database when moving fast on set or working with scripty's that like to change the slate letter.

-The Multi Camera layouts now have a "Shot Dupe Multi" button that will do the same thing as "Shot Dupe" but duplicate every camera for the current slate.

-Changing the camera letter will fire off a script that writes that info into the camera letter field for each take of the current slate. This should prevent seeing the wrong camera letter on a take when switching into multi cam view

-Added a sync scene view button to the multi cam Ipad layout, so you can get to it either from full multi cam or Ipad multi cam view.

I'm not a scripting wizard so user beware but I think I've hammered the bugs out of it, everything seems to be working properly.

I'm attaching a blank version of the database with my above changes.

Stay frosty,

Devin

- show quoted text -

--
You received this message because you are subscribed to the Google Groups "ves-tech-camera-reports" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ves-tech-camera-r...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jordan Soles]

Sam I would be happy to check it out if you don’t have time...those features sound super useful. 

Jordan 

[Sam Richards]

That would be great!

Sam.

[Jordan Soles]

Hi Sam,

Great, I’ll sit down with one of our live action crew this week to go over the changes...I’ll take a peek at the code myself after that to ensure it’s fairly generalized. 

Thanks!

Jordan

[D Breese]

Hi guys,

I tried to delete my original post and sent it to Sam privately because there was a minor glitch I found that I've had trouble ironing out. The Ipad multi camera view will sometimes show the wrong serial number for the lens. The loop I created in the 'Shot dupe multi' button script is doing it somehow I think. It can be ignored, the info is correct in the database it's just not being displayed properly there.

Please, give my code a once over I'm sure there are better ways to script what I've done. The new buttons do save a lot of time, and should be part of the next revision of the database IMO.

Thanks all!

D

[Randy Little]

I have a question that I have never asked since first learning about this so many years ago.  I was surprised to see that camera tilt is a field but camera roll is not a field.  This seems like kind of a big omit. 

To unsubscribe from this group and stop receiving emails from it, send an email to ves-tech-camera-reports+unsub...@googlegroups.com.

[Sam Richards]

Sorry, this is super late. Camera roll is there. You may see it as "Tk Roll" in the spec, since its something that is per take.

Sam.

To unsubscribe from this group and stop receiving emails from it, send an email to ves-tech-camera-r...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "ves-tech-camera-reports" group.

To unsubscribe from this group and stop receiving emails from it, send an email to ves-tech-camera-r...@googlegroups.com.

[Randy Little]

Its not odd that Tilt and roll are not next to each other? I seldom ever have a tilt with no roll.  

Randy S. Little
http://www.rslittle.com/

http://www.imdb.me/randylittle

[Randy Little]

I think we are talking different things.  Why is there no place to put the degree of camera roll ie dutch.  This seems like a huge oversight but it seems VES has given up on this like everything else it ever does.

On Sat, May 4, 2019 at 9:22 PM Sam Richards <sam.ri...@taurich.org> wrote:

--

[Rob Bredow]

Camera roll is available per take. As Sam noted in May, it’s called “Tk Roll”.

Rob

To view this discussion on the web visit https://groups.google.com/d/msgid/ves-tech-camera-reports/CAOoogNgXzB7fFLXphdYtGydHLh12m909H85p5oyXZCagW2_YPQ%40mail.gmail.com.

[Randy Little]

tkroll is film roll. 

Tk Roll

--

string

What is the film-roll, can be applied to digital too.

Required

  Which seems weird since probably not changing film/card roll number per take.  
Might make sense to change that and move away from calling Camera Roll Camera dutch  since I'm not even sure they use the term on the Union test any longer and no cameras call it that in their menu systems and since the cameras are all standardized now on Camera Roll. Doesn't it make sense that we do the same thing? When a 2nd AC writes the data down they put Camera Roll.  Well they usually put T=x R=x H=x.  but again this whole project seems to have been abandoned. But if people are still working on it. We should be using the same terms as the cameras meta data in most common use cameras. IE Arri and Red. (probably BMD as well) since they are all using the same terms.  

Randy S. Little
http://www.rslittle.com/

http://www.imdb.me/randylittle

To view this discussion on the web visit https://groups.google.com/d/msgid/ves-tech-camera-reports/CAMjQ_%3D-3XWyJcqgOS8vOJ-VEYUTd7d5C%2BGv1sOfAYKO8vaRagg%40mail.gmail.com.

[Rob Bredow]

I think that documentation line is incorrect. As you point out, roll by take doesn't make sense.

Rob

To view this discussion on the web visit https://groups.google.com/d/msgid/ves-tech-camera-reports/CAOoogNj-uyQNApL%2Bhkmipj60TvoCj5sa3j7xLrEa9xyxhXUdqw%40mail.gmail.com.

[D Breese]

It's rare but camera reloads can happen in the middle of a shot. Camera roll per take hasn't ever bothered me. Also, in my experience the camera practically never has significant dutch on it. When it does as a workaround why not just write that in the notes?

From a matchmovers perspective, and I've matched thousands of shots, these numbers are great for a start but the CG camera is going to be adjusted regardless until the frame matches up. If you know you have to get clinical for some reason, write it down. Otherwise if the camera has one degree of dutch on it, no big deal.

To view this discussion on the web visit https://groups.google.com/d/msgid/ves-tech-camera-reports/CAMjQ_%3D80by1-tTnve-tGfb3%2Bi%3D2HzkSSFGSoDkYe%3DkC%2B5igucA%40mail.gmail.com.

[Randy Little]

Rob then you have redundant data in tkroll and Camera Dutch start and end.  

Breeze if a reload happens during a take any script supe I have ever worked with bumps the slate and the 2nd AC starts a new cam report.  I just did 3 years of all kinds of dutched rolling crazy crane VFX shots.  By that measure why take tilt either?  Or height?  Why not just scrap the whole report since if camera is doing their job it's all in the meta data per frame and on their cam reports.  I have done plenty of cam tracking with zero data.  So why bother with this at all?  Right cause it all helps at many levels and saves man hours later.  If this is supposed to be a standard shouldn't it correspond to the data fields all the cameras are using?

To view this discussion on the web visit https://groups.google.com/d/msgid/ves-tech-camera-reports/CAJ%3DFJW5Nt3%3DR9E9NQzADfdtnM46tKrOuOxKbXL5A14haiGjBmg%40mail.gmail.com.

[D Breese]

That's cool Randy. You can always edit the database yourself so it works better for you. Share it with the rest of us here when you do.

To view this discussion on the web visit https://groups.google.com/d/msgid/ves-tech-camera-reports/CAOoogNi%3Dye53LK_r%3DasVo4B_LEWULbpCDETfnTbu1O8%3Dsqb9FA%40mail.gmail.com.

[Randy Little]

This is supposed to be A spec. I can alter FileMaker all day long but then it’s not a standard spec which was the point of this creation correct?  That’s why there is a page with a released 1.1 spec with all the legal data fields.  

To view this discussion on the web visit https://groups.google.com/d/msgid/ves-tech-camera-reports/CAJ%3DFJW60znhNUX67P8KqKiaQrrtB53Q8Wr%3Dn-TBkb%2BqVmczdfA%40mail.gmail.com.