software

Download 1.2.2

Retro8LogAnalyser

A free Filemaker 10 based log analysis program for Retrospect 8 Log Data.

Features:

Converts Retrospect log data into a relational database allowing for analysis of your backups.
Add log data by copy/paste from Retrospect's Show Log command.
Summarized view of all your backup Activities, with summaries and running totals of the amount of data copied, errors, duration and performance.
Export/Print the data to futz with it in Excel (or whatever)
Charting of your Activity data throughput, with projected plotting into the future.
Perty lookin.

New in Version 1.2.2 (Sep 29, 2010)

Made more compatible with Retrospect 8.2 Log format, especially date time parsing.
Compiled as a Filemaker 11 Runtime. Source Code still works with Filemaker 10.
Charting: Integrated the Date display on the main chart webviewer so you don't have to syncro-scroll the graph with the date labels.
Executive Events List View: Added a Summary Only view, with a percentage of Total summary calculation, to allow you to more easily figure out which Machines are eating up what amounts of data.
Created an Applescript Applet to automate the process of getting Log Data from Retrospect to the Filemaker Database. Cron the launching of "Automate Import Runtime.app" to make it super automatic. May not work if you have a locked screensaver running on your machine. Source Code provided as a .scpt file, in case you want to make modifications.
Other minor bug fixes and enhancements.

New in Version 1.2.1 (Jan 15, 2010)

Baked the System Settings (US) into the Filemaker "File Options" to always use the File Settings. Having a non-US Format selected in the International System Preferences should no longer affect the ability to parse the data.
Machine Charting: Added MB/day calculation which averages the number of MB per day (except for the first backup) consumed by the Machine.
Machine Charting: Added small chart to list view.
Other minor bug fixes and enhancements.

New in Version 1.2 (Dec 4 2009)

Charting: Added Machine Charting. Allows you to chart the growth of backups over time for each machine, by Media Set and Date Range.
Charting: Option-Click "Generate" button to automatically update the chart to the current date and move the ceiling if necessary. Shift-Click to Generate charts for a found set of records with the same parameters. Option-Shift-Click to update a Found Set of Charts.
Charting: Improvements allow for proper printing of charts
Added List Views for Exec Events and Charts.
Improvements in automatic log line deduplication; a dialog now shows you where the log line processing will start after deduplicating.
Other minor bug fixes and enhancements.

New in Version 1.1 (Nov 26 2009)

No longer any need to worry if you're pasting in duplicate log lines. Keeps track of the timestamp of the last log entry processed. The next time you paste in log lines, it automatically deletes any log lines previous to that timestamp.
Implemented an "Import from Older Copy..." script. Will allow easier upgrading to versions after 1.1 without losing data. NOTE: This will not work for data from Version 1.0!
Other minor bug fixes and enhancements.

Download

Retro8LogAnalyser 1.2.2 Filemaker Runtime (65.3MB, zip archive) -- download this if you don't have Filemaker 10 or 11.
Retro8LogAnalyser 1.2.2 Source Database w Regex Plugin (4.6MB, zip archive) -- fully unlocked and modifiable FM10/11 database file.

Bundled with and requires DJT's free Regex plugin.

Note: Source Database file requires Filemaker Pro 10. Also requires installation of DJT's free Regex plugin in Filemaker's "Extensions" subfolder.

Note: Uses the Consolas font from Microsoft for mono text. Read this article to find out how to download it for Mac if you don't have it.

Cost

It's free.

License & Warranty

Use, modify & distribute as you see fit. Free for personal or commercial use. If redistributed, must remain free to use.

Comes with no warranty, nor claims to accuracy, though I'm using it myself to gauge my backups, and I think it's pretty accurate.

Quick HOWTO: Importing from older version

Launch the new version of Retro8LogAnalyser.
Pull down the Scripts menu and choose the "Import from an Older Copy of Retro8LogAnalyser" command.
You will be prompted to locate the old data file. When you select the old data file, Retro8LogAnalyser will handle importing all your data from the old version to the new version.

Quick HOWTO: 1st Time

In Retrospect 8, go to the Preferences screen and enter a value into the "Show up to x lines in the operations log" that ensures you will get enough data back as far as you want. The default 500 lines doesn't get much data.
In Retrospect 8, select the "Show Log" command. Select as much data as you want. Copy to clipboard.
Launch Retro8LogAnalyser. Click the "Add Log Data" button. Paste your clipboard into the provided field. Click Continue. Wait for it to process. (Can take a few minutes for large sets of data, ie: 20,000 lines. Shouldn't take too long for smaller incremental sets of data).
When it's done, you should see the Activities List screen, populated with records.
- Use the Blue Arrow button to open and close Activities.
- Use the gray arrow buttons to see related activity data.
- Use the big rectangular buttons at the top in the Nav Bar to navigate between tables without going to related information.
Use all of Filemaker's built in functions to search for and modify your data as you like.
Charting Media Sets:
1. Click on the Chart button at the top, click on the Media Sets tab.
2. Create a new record
3. Choose a Media Set from the MediaSet menu, enter the Media Set Capacity in GB, and the date range you want to see charted
4. Click the "Generate Chart" button
5. To see projected growth, tick the Project Growth checkbox and Generate the chart again
Charting Machines:
1. Go to the Machines tab of the Chart screen.
2. Create a new record.
3. Choose a machine from the popup menu.
4. Fill in the Start and End dates, and choose a Media Set from which you want the chart data pulled
5. Click the "Generate Chart" button
6. To generate charts for all your machines at once, with the same settings, simply duplicate the current record, selecting the name of the machine you want charted after you duplicate. When you have a set of records, Shift-Option-Click the Generate Charts button to update all charts in the found set of records.
Tooltips: Most buttons have tooltips. Hover over a button to get an explanation of what it does.

Quick HOWTO The next time you want to add data

In Retrospect, modify the Preferences to reduce the number of lines displayed in the Log window.
Select the "Show Log" command. Select ALL.
Launch Retro8LogAnalyser, click the "Add Log Data" button and Paste.

Note: If you experience proplems with the data import/parsing, use BBEdit to Zap Gremlins from the Log data before pasting it into Filemaker. For some reason, there's ASCII 12's in Retrospect's log data, and Filemaker may choke on other wierd ASCII.

Screenshots

If you appreciate Retro8LogAnalyser, link to my photoblog (preferably somewhere Google will index it).

CS1ToCR2 - Add GPS to your RAW Files

Version 1.1 - Download (Filemaker 10 Runtime Binary, Mac OS X 10.4,10.5 - DMG 29.7MB)
Requires installation of Phil Harvey's free ExifTool application.

New in version 1.1: supports Amod AGL3080 GPS Data Logger .nmea files

CS1ToCR2 is Filemaker Pro-based application, designed to read GPS log files from the Sony GPS-CS1 device and match them up to RAW (CR2) image files captured on the Canon SLRs, on a Mac OS X computer.

The Sony GPS-CS1 captures GPS data in a modified version of the NMEA GPS format. This data is captured to log files and retrieved from the GPS-CS1 onto your local hard drive. Being a bit of a map geek, I was excited enough to buy the GPS-CS1, but I didn't do my homework. The GPS-CS1 does ship with a utility that will automatically match the data to JPEG images. Sadly there is no way for that utility to write the data to Canon RAW files, which is how I shoot. To boot, Sony's program only runs on Windows.

When I found this out, I decided to write my own program to do the matching and I found Phil Harvey's excellent ExifTool command line application would do the actual heavy lifting of reading and writing the EXIF data. Since I only program in Filemaker Pro, that's what I've used to write this app.

CS1ToCR2 is freeware. Use and distribute freely. If you like it, please link to my site if you can (I'm trying to build some traffic).

The runtime DMG comes with everything you need (except the ExifTool application).

Any questions, email me.

Source Code - Download Source (Filemaker Pro 8.5/9 database file - ZIP 84kb)
The source code Filemaker Pro database is free to use and modify. It's simply the standalone Filemaker database file and will work with Filemaker Pro 8.5 or 9 as long as you also have your own copy of the Troi File and Troi Dialog plugins.

To modify the source database file, you'll need Filemaker Pro Advanced 8.5 (there are some Filemaker 9 enhancements, so 9 is better). The master account is "admin", no password. You'll need to choose the Standard Filemaker Pro Menu Layout from the Tools menu (Filemaker Pro Advanced only).

Screenshots:

Some icon artwork provided by www.studiomx.eu.

Software