Sign In:     

Forum: General Discussion

Topic: Database Question

This topic is old and might contain outdated or incorrect information.



The database file holds all the info for genre, tracks and so on, can that file be loaded into a database program like access and edit out what you don't need or correct field content?

Then save that edit back to vdj database?

Thanks

Joey....
 
Posted Wed 02 Sep 09 @ 6:54 am
The database is an XML file, so you can edit it directly with a text editor....

In theory you can also import the file in various database systems (access, sqlite e.t.c.) but you would have to define the database schema by yourself...
 
Thanks for the reply.

Rather then going into the xml file to edit, it seems to me it would be easier to import the file content in a columned defind field order so the data within the fields would be more easily understood and can be sorted for spotting errors and omissions more quickly within that field.

Also another great advantage is the ability to globally change data within a field in seconds if needed insted of editing for hours.

If there is a way to do this, I would appreciate the advise.

Thank you

Joey....
 
JoeyKJ wrote :
Thanks for the reply.

Rather then going into the xml file to edit, it seems to me it would be easier to import the file content in a columned defind field order so the data within the fields would be more easily understood and can be sorted for spotting errors and omissions more quickly within that field.

Also another great advantage is the ability to globally change data within a field in seconds if needed insted of editing for hours.

If there is a way to do this, I would appreciate the advise.

Thank you

Joey....


Right now their is no easy way to do this.. but its been asked for..
Hopefully one day we will get it!
 
Any chance you could let us have the DTD file?

Roy
 
That's a very good idea, that would be the biggest challenge me everything else I could manage.

Can anyone help with this? Please....

Thank You

Joey...
 
Does anyone have schema or dtd for the database file? This is getting interesting...
 
I feel a community project coming on here...

The one thing that really bugs me is the ordering of Virtual Folders... Only being able to "Move Up" and "Move Down" is ridiculous
in this day and age of "drag and drop"...

I thnk a standalone tool that could manage your database and history playlists without having to start VDJ has a lot of merits... Especially if there is good ID3 tagging - including writing.

Plus, you might want to manage your DB from an external HDD on a machine where VDJ is not installed...
 
thanks for that ..... someone else finally said what i've said a few times previously .......

when you have over a hundred fav, filter , virtual folders you need the drag n drop .........
 
Access database program works independently from VDJ.

VDJ works independently from Access database program.

VDJ works from it's Database for all file information incuding cue points, and other variables.

Any edits done this way would not compromise you're file links, Including File location which is very importand and as an added benefit file name changes can just be pasted to the field data with no missing Links in VDJ after you finished you're edits.

So you can see this would be the best of both worlds for all.


Hope someone can provide the field template from VDJ for import?

Joey......
 
It's not that hard to get the db schema out of the XML file... But you need to write some code to handle it.
I have developed an application that reads the XML file database, and it writes the changes back to the ID3 tags.
In order to do so I had to "study" the XML file itself to get the schema out. It took me 5 minutes to understand the schema and 2 hours to write a code that can handle it... I am a novice programmer, so someone that's really good should do this in 30 minutes.
Anyway, the point is that you need "something" (call it a black box) that will convert the data between VDJ and Access. They can't talk directly even if you can define the schema of the database...

Out of topic:
I can "TRY" to create an application that will manipulate the XML database. In such a case, what would you like this app to do?
 
PhantomDeejay wrote :
It's not that hard to get the db schema out of the XML file... But you need to write some code to handle it.
I have developed an application that reads the XML file database, and it writes the changes back to the ID3 tags.
In order to do so I had to "study" the XML file itself to get the schema out. It took me 5 minutes to understand the schema and 2 hours to write a code that can handle it... I am a novice programmer, so someone that's really good should do this in 30 minutes.
Anyway, the point is that you need "something" (call it a black box) that will convert the data between VDJ and Access. They can't talk directly even if you can define the schema of the database...

Out of topic:
I can "TRY" to create an application that will manipulate the XML database. In such a case, what would you like this app to do?


Don't know if this is all in the database or how vdj saves it but here is a list of what I would like to see:

(1) Read VDJ info to id3 tags for .mp3 audio, .mp4 audio & video, .mpg video (Artist, title, mix version, bpm, genre, year, month, key, dvd tilte or dvd series) and write the info back to VDJ database.
(2) To be able to nest virtual folders just like your windows tree. This would make it really easy for each dj to set up his folders the way they want to while keeping the master folders in windows set.
(3) Don't know if this is possible but have a cues each Dj sets show when played from his virtual folder only. I.e. if I have 3 cue points set for Pitbull-Hotel Room when I play it from my virtual folder only my cues will show and when Dj B sets his 3 cue points they don't over write mine and they his will only show when played from his virtual folder......I'm tired of the other Djs overwriting my cue points, I had to fire one the other day because even after being told several dozen times he just could not understand DO NOT overwrite cue points.
 
PhantomDeejay wrote :
It's not that hard to get the db schema out of the XML file... But you need to write some code to handle it.
I have developed an application that reads the XML file database, and it writes the changes back to the ID3 tags.
In order to do so I had to "study" the XML file itself to get the schema out. It took me 5 minutes to understand the schema and 2 hours to write a code that can handle it... I am a novice programmer, so someone that's really good should do this in 30 minutes.
Anyway, the point is that you need "something" (call it a black box) that will convert the data between VDJ and Access. They can't talk directly even if you can define the schema of the database...

Out of topic:
I can "TRY" to create an application that will manipulate the XML database. In such a case, what would you like this app to do?



Hi PhantomDeejay

Thanks for asking;

Well create a tamplate by field order that will organize the relative data.

Example:In Access

Disc # ! Track # ! Title Name ! Artist ! Album ! Genre ! BPM ! Comment ! Path & File Name ! < Field Names Add XML Field
--------------------------------------------------------------------------------------------------------------------------------------------------------
123 ! 01 ! You Can Do It ! Yes You Can ! Try It Man ! RnB ! 75.5 ! Good Song.! C:\iTunes\Yes You Ca..! < Field Data XML Song Info
456 ! 02 ! Well I Will Try ! Yes Yuo Can ! Try It Man ! RnB ! 60.6 ! Slow Song..! C:\iTunes\Yes You Ca..! < Field Data XML (Database)


Note: The field Disc #
Will be needed for Karaoke files since they are organized primarily by Disc. #

Thank You

Joey....
 


(Old topics and forums are automatically closed)