Introducing "Indigo Database Report" beta

Posted on
Sun Mar 12, 2006 7:26 am
macpro offline
User avatar
Posts: 765
Joined: Dec 29, 2005
Location: Third byte on the right

Introducing "Indigo Database Report" beta

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.

Download
You can download Indigo Database Report here.

Enjoy!

[edit] The beta has been replaced by the 1.0 version! [/edit]
Last edited by macpro on Mon Apr 03, 2006 6:58 am, edited 1 time in total.

Posted on
Sun Mar 12, 2006 10:12 am
Otis offline
Posts: 210
Joined: Jan 24, 2006

(No subject)

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?

Posted on
Sun Mar 12, 2006 10:20 am
macpro offline
User avatar
Posts: 765
Joined: Dec 29, 2005
Location: Third byte on the right

(No subject)

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.

Posted on
Sun Mar 12, 2006 10:28 am
gernith offline
Posts: 16
Joined: Feb 06, 2005
Location: NH

works for me!

Handy info, all in one place.

Posted on
Sun Mar 12, 2006 11:57 am
Otis offline
Posts: 210
Joined: Jan 24, 2006

(No subject)

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.

Posted on
Sun Mar 12, 2006 11:59 am
macpro offline
User avatar
Posts: 765
Joined: Dec 29, 2005
Location: Third byte on the right

(No subject)

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.

Posted on
Sun Mar 12, 2006 12:39 pm
macpro offline
User avatar
Posts: 765
Joined: Dec 29, 2005
Location: Third byte on the right

(No subject)

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.

Posted on
Mon Mar 13, 2006 10:39 am
matt (support) offline
Site Admin
User avatar
Posts: 21411
Joined: Jan 27, 2003
Location: Texas

(No subject)

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)!

Regards,
Matt

Posted on
Sat Mar 18, 2006 12:14 am
macpro offline
User avatar
Posts: 765
Joined: Dec 29, 2005
Location: Third byte on the right

(No subject)

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.

Posted on
Sat Mar 18, 2006 9:25 pm
HighwayStar offline
Posts: 82
Joined: Sep 07, 2005
Location: NY

(No subject)

Works great for me (database <100k). Very nice, great tool. Nice work ! Thanks for posting it.

Ken

Posted on
Sun Apr 02, 2006 5:19 pm
macpro offline
User avatar
Posts: 765
Joined: Dec 29, 2005
Location: Third byte on the right

(No subject)

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.

Posted on
Mon May 22, 2006 9:08 am
JERRY SKY offline
Posts: 1
Joined: May 22, 2006

(No subject)

I am a low tech person and have been using Indigo for a few weeks successfuly.
I DOWNLOADED THE INDIGO DATABASE REPORT AND WENT THROUGH THE STEPS OUTLINED.......
A POP UP WINDOW CAME UP WHICH READS:

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?

Posted on
Mon May 22, 2006 9:49 am
macpro offline
User avatar
Posts: 765
Joined: Dec 29, 2005
Location: Third byte on the right

(No subject)

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?

Posted on
Wed May 24, 2006 12:31 pm
macpro offline
User avatar
Posts: 765
Joined: Dec 29, 2005
Location: Third byte on the right

(No subject)

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.

Posted on
Wed May 24, 2006 2:39 pm
macpro offline
User avatar
Posts: 765
Joined: Dec 29, 2005
Location: Third byte on the right

(No subject)

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:

Image

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.

Who is online

Users browsing this forum: No registered users and 0 guests