Author Topic: DVDProfiler2Access Transformer  (Read 2711 times)

Offline DJ Doena

  • Administrator
  • Mega Heavy Poster
  • *****
  • Posts: 6719
  • Country: de
  • Battle Troll
    • View Profile
    • My Blog
DVDProfiler2Access Transformer
« on: September 08, 2007, 01:55:36 AM »
I am a bit of a statistics freak myself. Unfortunatley DCDProfiler has only limited abilities in that regard.

Thus, I wrote me a program that takes the collection.xml in imports it into an Access database. After importing in Access I can do any kind of query that the data will provide (including Pivot tables).

If anyone else is interested: Download

What you need is an installed Microsoft .NET Framework 2.0.

If the application crashes for some reason, please let me know.
Karsten

Abraham Lincoln once said The trouble with quotes from the internet is that you never know if they're genuine.

my Blog | my DVD Profiler Tools


RossRoy

  • Guest
Re: DVDProfiler2Access Transformer
« Reply #1 on: September 08, 2007, 02:53:18 AM »
Just tried. Worked wonders. Now I just need to find my Access install disc  ;)


Offline Tom

  • Mega Heavy Poster
  • *******
  • Posts: 6271
  • Country: de
    • View Profile
    • Cinematic Collection Viewer
Re: DVDProfiler2Access Transformer
« Reply #2 on: September 08, 2007, 10:38:39 PM »
Sounds like my CCViewer. It also uses an Access database. And you do not have to have Access installed. It also includes a SQL Query window (Tools->SQL Queries).



Offline DJ Doena

  • Administrator
  • Mega Heavy Poster
  • *****
  • Posts: 6719
  • Country: de
  • Battle Troll
    • View Profile
    • My Blog
Re: DVDProfiler2Access Transformer
« Reply #3 on: September 09, 2007, 11:21:01 AM »
Just tried. Worked wonders. Now I just need to find my Access install disc  ;)
It should also work if you take Excel and use the "Pivot table" function to connect to the Access database.
Karsten

Abraham Lincoln once said The trouble with quotes from the internet is that you never know if they're genuine.

my Blog | my DVD Profiler Tools


Offline DJ Doena

  • Administrator
  • Mega Heavy Poster
  • *****
  • Posts: 6719
  • Country: de
  • Battle Troll
    • View Profile
    • My Blog
Re: DVDProfiler2Access Transformer
« Reply #4 on: September 10, 2007, 11:18:18 AM »
Additionally, here is the source code if anyone is interested.
Karsten

Abraham Lincoln once said The trouble with quotes from the internet is that you never know if they're genuine.

my Blog | my DVD Profiler Tools