Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[ralphberner]

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

[sraymond]

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-

[ralphberner]

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.

[sraymond]

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.  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-

[JimH]

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

[sraymond]

Jim,

It'll be done by Christmas...

Scott-

[ralphberner]

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.

[sraymond]

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

[ralphberner]

Hello

My e-mail is ralphberner@yahoo.com