Skip to Content
It is currently January 28th, 2012, 1:21 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: May 11th, 2009, 7:32 pm 
Offline
Senior User
Senior User

Joined: October 14th, 2004, 10:15 am
Posts: 174
SAM 4.3.6 is writing the BPMs to a field that doesn't exist. BMP. And part of the sql query is in the xfade field

(i.e. xfade = &bmp=45.21)

Is anybody aware of this problem? It was detected last year and still hasn't been addressed. Is a patch with this fix coming out soon? Please see viewtopic.php?f=20&t=25488 for more details on the problem.

_________________
erdubya
ProjectVIBE Internet Radio
Image


Top
 Profile  
 
PostPosted: May 11th, 2009, 7:37 pm 
Offline
SVS Member
SVS Member
User avatar

Joined: December 20th, 2006, 9:23 pm
Posts: 12213
Location: Show Low, AZ
There are no updates/fixes that I'm aware of, and none that I've heard of from development. You might submit a ticket to the main support department and ask them.

_________________
Andrew Cannon
(SVS) Spacial Volunteer Support

WE DANCE AS ONE: A Celebration In Groove
All That Is GOOD In Dance Music from the
70's, 80's, 90's and Now... plus some of the
best DJs from around the world.
http://www.wda1.com


Top
 Profile  
 
PostPosted: May 11th, 2009, 7:55 pm 
Offline
Cygnus X-1
Cygnus X-1
User avatar

Joined: March 11th, 2003, 1:34 pm
Posts: 9963
Location: Maui, HI
I did something about it with my Data Conditioner tool:
Quote:
SAM is “supposed” to read the TBPM ID3v2.3 field and store the value in the SAM songlist table bpm field. Several user suggest this isn't the case so I've added another section to this task to use the TBPM field and populate into SAM following how it works with a third party DJ tool MixMeister (MM). MM calculates a BPM and stores it in the TBPM field. However, this tool doesn't quite follow the specification as MM stores a decimal number, such as 67.08, instead of an integer.

The ID3v2.3 definition of TBPM is:
The 'BPM' frame contains the number of beats per minute in the main part of the audio. The BPM is an integer and represented as a numerical string.

Rough algorithm:
Select all songs from the SAM songlist table whose BPM value is null or 0.
If the ID3v2.3 TBPM field of the song source file is not blank (null or empty) and is greater than 0 then update the SAM songlist bpm column with the TBPM rounded to the nearest integer and add or replace the bmp (yes, bmp is used in the xfade to store the BPM) portion of the SAM songlist table xfade column with the full TBPM value.

The TBPM field is conditioned using the following rules:
Trim leading and trailing whitespace (spaces, tabs ...).
Convert to a float, if that fails then 0.0f is used.

This is a one-way task; source file to database

A future task may read the SAM songlist table xfade column and if a bmp value exists write it to the SAM songlist table bpm column as well as to the source song file TBPM ID3v2.3 tag.

_________________
- Steve Kunitzer
- SVS (Spacial Volunteer Support) / Forum Administrator

Image
Image


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 12 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group