Merging daily databases into a rolling master

[Derrek Horn]

Is there an easy way to merge each days notes into a rolling master? By taking notes on a fresh database daily, and saving a daily backup, and then merging all five days at the end of the week into a weekly rolling master, I can then only have to open up a large document when it's needed to find previous shots. Is there an easy way to do this? I have tried some various ways but it will only input the slate field, leaving all the camera notes out (see attached file for reference). Any help on this? Other than that this has been a very nice change - I have added a few more fields that I feel have made it more complete (some of which were suggested) so it's well done. 

I am using and trying to merge in FMP13 by the way. 

Thanks,

Derrek

[Sam Richards]

It should work if you do the CSV export daily, and import the CSV into the master. The major downside is that it wont merge in the photos, although that could be possible to manage too.

Let us know if that works...

Sam.

--
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.

[Derrek Horn]

Sam,

Thanks for the response. A friend of mine figured it out - import the slates table via the full layout first - unlinking the unique id only, then import the takes table via the export layout. 

That got everything including photos. 

Thanks though. 

Sent from my iPhone

You received this message because you are subscribed to a topic in the Google Groups "ves-tech-camera-reports" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/ves-tech-camera-reports/MWvVT9OCofw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to ves-tech-camera-r...@googlegroups.com.

[Derrek Horn]

Sam, (or anyone out there)

I'm back! for some reason the CSV import won't import a file with the same report ID. I'm hoping to see if there's an easy fix for this, like a copy paste script, so that when I merge into a new "clean" database, or a rolling master with all the previous notes, that the script will automatically give the incoming reports new ID's, and not carry over their original one?

Thank you,

Derrek

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

[Alistair Jamieson]

That would be handy indeed.

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.

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

--

Alistair Jamieson

ahgja...@gmail.com

Aus Mob. +61 405 285 279

Skype: Alistair Jamieson (Adelaide, South Australia)