INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: ralphberner on December 15, 2003, 11:32:12 pm

Title: Database querries and access / A few questions
Post by: ralphberner on December 15, 2003, 11:32:12 pm

How can i do different kind of querries from the database.

I want to create a list of all albums with artist and comment for example.

Is it possible to access the dtabase with any database tools, "ms access" for example?

Is it possible to export the database to any common database format?

Thanks for any hint

Title: Re:Database querries and access / A few questions
Post by: sraymond on December 16, 2003, 01:20:26 am

You can export the database as an XML document conforming to JRiver's MPL schema.  You can then import the XML document into MS Access using a simple XSLT I've developed.  All this can be done quasi-automatically by using scott_r's MC XML Export plugin.

Let me know if you need help.

Scott-

Title: Re:Database querries and access / A few questions
Post by: ralphberner on December 16, 2003, 09:57:02 am

Thanks for the hints. This should help.
But i can't find the scott_r's MC XML Export Plugin ... at least not in the plugin download area.

Title: Re:Database querries and access / A few questions
Post by: sraymond on December 16, 2003, 10:28:05 am

Quote from: ralphberner on December 16, 2003, 09:57:02 am

Thanks for the hints. This should help.
But i can't find the scott_r's MC XML Export Plugin ... at least not in the plugin download area.

Sorry...  I forgot to mention that it can be found here:  http://yabb.jriver.com/interact/index.php?board=5;action=display;threadid=16966 (http://yabb.jriver.com/interact/index.php?board=5;action=display;threadid=16966).  It's technically still in beta, but it's pretty solid.

If you're unfamiliar with XML, I have a primer that I'm currently working on (almost done).  Give me your email address and I'll send it to you.

Scott-

Title: Re:Database querries and access / A few questions
Post by: JimH on December 16, 2003, 11:27:48 am

Scott,
Please post the primer here.  If you'll e-mail it to me (jimh @ jriver.com), I'll put it on our server.

Thanks for doing it.

Jim

Title: Re:Database querries and access / A few questions
Post by: sraymond on December 16, 2003, 12:04:15 pm

Jim,

It'll be done by Christmas...

Scott-

Title: Re:Database querries and access / A few questions
Post by: ralphberner on December 17, 2003, 11:00:41 pm

I got the Plugin. The export went fine. Thx

But what is a XSLT ? Do i need that ?

I imported the file into ms access and got the row of the albums only.

Title: Re:Database querries and access / A few questions
Post by: sraymond on December 18, 2003, 12:25:08 am

Quote from: ralphberner on December 17, 2003, 11:00:41 pm

I got the Plugin. The export went fine. Thx

But what is a XSLT ? Do i need that ?

I imported the file into ms access and got the row of the albums only.

Create a text document called MC2Access.xsl containing the following text:

Code: [Select]

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/MPL">
   <dataroot>
   <xsl:for-each select="Item">
      <Item>
      <xsl:for-each select="Field">
         <xsl:element name="{translate(@Name,' #()','_N')}">
            <xsl:value-of select="."/>
         </xsl:element>
      </xsl:for-each>
      </Item>
   </xsl:for-each>
   </dataroot>
</xsl:template>
</xsl:stylesheet>
This is an XSLT.  Use it with MCXMLExport, and the result can be opened with Access directly.  See the thread http://yabb.jriver.com/interact/index.php?board=3;action=display;threadid=9580;start=msg114183#msg114183 (http://yabb.jriver.com/interact/index.php?board=3;action=display;threadid=9580;start=msg114183#msg114183) for some discussion - Scott_r has done just about everything discussed there.

Again, if you give me your e-mail address, I'll send you an draft of an XML primer.  You will find it useful - and maybe you'd be willing to give me some feedback.

Scott-

Title: Re:Database querries and access / A few questions
Post by: ralphberner on December 18, 2003, 01:48:05 am

Hello

My e-mail is ralphberner@yahoo.com