Page 1 of 4

Introducing "Indigo Database Report" beta

PostPosted: Sun Mar 12, 2006 7:26 am
by macpro
What is Indigo Datase Report?
We all know and love Indigo. But it misses one feature: getting a list of all details that we have stored in our database.
Until I found a topic on this forum where Matt wrote that the Indigo database uses a XML structure. That's when I came to the idea that it should be easy to convert this XML to a readable format.
I was wrong. It was not that easy.
But I had a lot of fun making this report, so here it is.

How to use Indigo Database Report
When the installer completes, you'll find the Indigo Database Report in you Applications folder.

After opening Indigo Database Report, use the "Browse" button to select your Indigo database file.
Click the "Show the report" button to generate a report based upon your Indigo database.
This report will be saved on your desktop in a file called "IndigoDatabaseReport.html".
The report will automatically open in your default web browser.

Why is this a beta release?
This is the first release of Indigo Database Report that is made available to the Indigo community.
So there might still be some errors and/or ommisions which I didn't see during testing.
Please report your feedback on the Indigo Forum.

A big thank you to...
Matt Bendiksen who provided a lot of info which helped me very much in decoding and interpreting the Indigo database.
Without his help, you would not be looking at Indigo Database Reporting.

You can download Indigo Database Report here.


[edit] The beta has been replaced by the 1.0 version! [/edit]

PostPosted: Sun Mar 12, 2006 10:12 am
by Otis
Great idea! Thanks.

Unfortunately, when I try to run it, after specifytng the database file, the program hangs, displaying "Loading Indigo Database Report . . ." and the Safari Activity window reports:

file:///Library/Application%20Support/Indigo%20Database%20Report/js/lib.js no permission to read file

Lib.js indeed shows "No Access" in its Get Info window, and I can't change its permissions. The next file in that folder, scrolldivtoanchor.js, has Read only access and I can open it in TextMate.

Also, I can't open ReadMe.html in Safari, although a readme file is displayed in the installer. Safari says:

No file exists at the address “/private/tmp/dmg.wzS6lF/ReadMe.html”.

Any ideas?

PostPosted: Sun Mar 12, 2006 10:20 am
by macpro
That's strange.
I've tried installing on different Macs and didn't run into the problems you are describing.
Although I do see the lib.js file has different permissions.

The Readme.html opens without a problem.

I'll try to make a new installer package with better permissions.

works for me!

PostPosted: Sun Mar 12, 2006 10:28 am
by gernith
Handy info, all in one place.

PostPosted: Sun Mar 12, 2006 11:57 am
by Otis
Maybe it was just an installation glitch, but I installed and ran the package without a problem. I didn't find a link to the new package, so I downloaded again from the original link. Not sure if that's the new package or the original one, but it works now.

Also, I did repair permissions between the two attempts (which did not fix the lib.js permission, but perhaps fixed something else that allowed the installation to work).

Still can't open the Readme.html file in Safari, though.

Thanks for the help. The report will save a lot of time.

PostPosted: Sun Mar 12, 2006 11:59 am
by macpro
I was able to reproduce the readme error that Otis described on another Mac.
A new DMG file is availble at the same location, which should not have this problem anymore.

PostPosted: Sun Mar 12, 2006 12:39 pm
by macpro
Google is my friend!
The problem with the readme files seems to be a bug in Safari.

I found a description here:
This is a bug in the way Safari handles Disk Images when you have the "Automatically open safe files after downloading" option enabled. Unmount the disk image in the Finder and manually mount it again (by double-clicking the *.dmg file in the Finder) and things should be fine.

That is also why I thought I solved the problem by making a new disk image. I disabled the "Automatically open safe files after downloading" on the Mac I used for testing after downloading the image the first time.

PostPosted: Mon Mar 13, 2006 10:39 am
by matt (support)
Awesome job on this! It works great and really fills a gap in Indigo functionality -- being able to easily browse and print your entire database. Kudos (and thanks)!


PostPosted: Sat Mar 18, 2006 12:14 am
by macpro
I've got about 25 downloads of Indigo Database Report since releasing this beta.
But this topic has been very quiet the last days.
Is it all working that well?
Or did you trash it after the first attempt failed?

I'm really interested in your findings, so I can polish IDR to get to the 1.0 version.

If there are Indigo users with databases over 350 KB in size, please let me know how IDR works for you, because the report gets a bit large.

PostPosted: Sat Mar 18, 2006 9:25 pm
by HighwayStar
Works great for me (database <100k). Very nice, great tool. Nice work ! Thanks for posting it.


PostPosted: Sun Apr 02, 2006 5:19 pm
by macpro
Thanks to all of you who provided feedback.
I've released the 1.0 version today.
Please go to the Indigo Database Report website to download this new version.

PostPosted: Mon May 22, 2006 9:08 am
I am a low tech person and have been using Indigo for a few weeks successfuly.

File "MACINTOSH HD: USERS: my name: Documents: INDIGO USER DATA:SAMPLE HOUSE- indiDB" doesn't understand the ^^ event SeTIxsIT^^ message (-1708)

what is this all about?
How do I print my database?

PostPosted: Mon May 22, 2006 9:49 am
by macpro
Hi Jerry,

I haven't seen this message before, so I'll need a bit more info.
What version of Indigo and Mac OS X are you using?
What browser (with version) are you using?
Did you get any errors during the installation of IDR?
When does the pop up window with the message appear?

PostPosted: Wed May 24, 2006 12:31 pm
by macpro
Matt was so kind to test IDR on an intel Mac, as I do not have one at the moment.
He was able to reproduce the error and identified the component that is producing the error.

As it is a third party component, I have no immediate solution for this problem. So here's the official statement:

unfortunately, Indigo Database Report is not compatible with intel Macs.

I'll do my best to get it fixed as soon as possible, but cannot give a time frame at this moment.

PostPosted: Wed May 24, 2006 2:39 pm
by macpro
The good news is that I have a work arround to get Indigo Database Report running on intel Macs!

Thanks to Mark Alldrit from Late Night software for providing the work arround.
Thanks to Matt for testing and providing the screendump.

And here's the magic trick:

Select the Indigo Database Report application in the Finder and open the Info window.
It should look something like this:


Enable the "Open using Rosetta" checkbox and close the window.

That's it!


There's also a new version of Indigo Database Report available which no longer is a Universal Binary and therefore also works on intel Macs.