A view Questions

[Frank1977]

Hello,

I'm new to the Proppfrexx Onair.
I'm working by a local radio station and where looking for a new radio automation software.
I was playing with the demo and I had questions about our little system by the radio.

1: Where use a mysql database server how can I creat this in Proppfrexx, We have 1 onair 24/7 and 1 playout for working
in the studio and 1 for planning the week.

2: How can I program the week by our little local radio it's always the same for every week?.

3: Where use I Relay kaart Adlink 7250 http://www.circuitspecialists.com/pci-7250.html to a Sonifex
rb ss10 http://www.sonifex.co.uk/redbox/rbss10_ld.shtml

to switch the outputs in our software is this possible in proppfrexx?

I see i lot of gpio cards but i was hoping to work with 7250, Where also use this card for faderstart in our studio.

I hope this is possible in proppfrexx it's looking very good.

Greetings, Frank

[radio42]

Hi Frank,

1) ProppFrexx typically doesn't use any MySQL-Server as all its configuration options are file based in XML format.
You might however use a MySQL Server to keep/reference your audio files as a media library (see the User Manual for details), but that is also typically not needed, as it offers no real benefit and mostly just complicates the maintenance process.
Instead ProppFrexx offers it own stand-alone 'Media Library Server' which might be used in a larger setup as a central repository for all your audio files.

So please explain for what you are needing or wanting to use a MySQL Server?

Working with Media Libraries is explained here:
viewtopic.php?f=9&t=11


2) ProppFrexx has a build in Scheduler, you can find more details here:
viewtopic.php?f=9&t=10


3) Currently we do not support the mentioned interfaces out-of-the-box - but I might take a look at them - may be something can be arranged.
On the PCI-7250 page you provided all download links are not working and that card only seems to support up to Windows NT?!
Not sure for what you need a direct Sonifex interface within ProppFrexx.
Note, that ProppFrexx has a very extensive routing and mixer section internally, which typically makes such boards dispensable.
But with a quick look I also couldn't find any info about remotely controlling the Sonifex.
Do you have any info about the interface they are using?
Else something needs to be coded


Also note, that you can find a lot of Tutorial Videos here:
viewtopic.php?f=5&t=1018

[Frank1977]

HI Bernd,

Thanks fort the quick reply,

1: I never saw the media libary server, I gonna check this. If this is it for us!.
But we have now I database of 32.000 Music tracks, How can I put this in Proppfrexx is this possible with a import tool?
A back up of the database server, Maybe?

2: Scheduler: I gonna look at this, Thanks for the link!.

3: We only work with the PCI 7250 on windows 7 here a link for more information and drivers. http://www.adlinktech.com/PD/web/PD_detail.php?pid=21 This card is the most used in the netherlands!.

About the Sonifex RB ss10 we didn't switch the sonifex, But the Adlink PCI 7250 swith the sonifex. Maybe this a feature for Proppfrexx to import to work with the PCI 7250.

greetings , Frank

[radio42]

1: what Database is it? Created with which tool?
Please see the User Manual or here:
viewtopic.php?f=9&t=41

The MLS is explained here: viewtopic.php?f=9&t=1014

All other dutch user tell me, that the Vellemen is most used, guess the one you are using is always most used
Note, that we have a local partner in the Netherlands, which is "Per Cramer" (p.cramer@ropesolutions.nl) you might get in contact with him regarding these interface...

Regarding using a database based media library:
In the Media Library Management dialog you'll find an "Add Database" button!
The user manual contains a SQL section describing the required table layout - plus take a look to a file called 'SQL.txt' contained in the installation folder.
So you can now even create multiple database views based on one central database table to create your different media libraries.
However, in such case you must maintain your DB table yourself.
ProppFrexx always uses a simple ODBC connector.

The SQL statement (as given in the User Manual) defines the table structure which might be used to load DB based playlists resp. to lookup DB based meta data. You might actually use any ODBC driver to load the content of such database table(s) as a playlist (media or cartwall library). Each table therefore represents one media library.
Note, that for existing database table you might also create a related VIEW!

The only mandatory column is LOCATION, all other columns might be defaulted or can be NULL or doesn’t even have to exist (whatever column is present will however be evaluated)!
See the User Manual for detailed column hints.

Connect String: The connect string can either be an ODBC data source name (DSN) or any valid ODBC driver connect string. Eg.:
"DSN=dsnname"
or
"Driver={Microsoft ODBC for Oracle};Server=ORACLE10i;Persist Security Info=False;Trusted_Connection=Yes"
or
"Driver={MySQL ODBC 5.2 UNICODE Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;"

Consult your system admin for providing you with a valid ODBC connect string...

[Frank1977]

Hi Bernd,

I sent an email to Per about the PCI 7250, Maybe Per already contact you about this feature.

I have 3 questions about the database.

1) I have installed on my pc mysql 5.6 community server where I have imported the backup.
Everything is running correctly now (see below pic), but the tracks are 0.
Is there something wrong with the connection?

2) What is the setting about my table view of database ?, How can I set it right to view the right tables?

3) In the settings of proppfrexx there is a line called metadata/Tag database. Is this also working
with mysql or is this standalone mapping?

Greetings Frank

[Frank1977]

Hi bernd,

This is the pic i'm talking about

[radio42]

As said, you find the view in Appendix of the User Manual!
There is also a file called SQL.txt being installed to your ProppFrexx installation folder.

The connection looks okay so far. Are you sure that your table/view contains any rows?

Does the view actually contains at least a LOCATION column?
and does that LOCATION column contain the file names of the physical audio files?
What happens, if you click on the Test button in the Edit Database Library dialog?

The MetaData/TAG database can also be used.
But the same applies to what I said in my previous posts.
Without knowing what and why you exactly need a DB it's hard to give you a good advice.
As normally meta data is today kept in the physical audio file.
So I am still not sure why you would need a DB.
Also Imdon't know how your DB table is structured today, so I can not say if that is even compatible with ProppFrexx.
More info is as such needed!

[Frank1977]

Hi Bernd,

Let me explain al lot to you sorry for no information.

1) The database looks like (see pic below) DB onairdb. I don't know if this information is enough.

2) I don't know if I need a DB. We have an export CVS (see pic) from a dalet station with 30.000 titles with location of the soundfile.
The information in the csv file (see pic) is what you are looking at! The dalet map is where all the files are stored in (see next message)

3) Is this simple to import to Proppfrexx?
The rest of all the soundfiles (MP3,Mp2,m4a,wav) are stored in maps that are easy to work with in proppfrexx.

I hope you have enough information! let me know

greetings frank

[Frank1977]

This is where all the soundfiles of dalet are stored.

[radio42]

I don't know the onairdb.
Do you happen to have a full database export to take a look at.

From the CSV export I can basically see, that an import should in general be possible. But the cvs export also seems incorrect, e.g. When looking to the line starting with "100 days; 100 nights..." there is a ; too much in that line, probably because the Title already contains one.
All the other table names etc. tell me much.

From which system does this data come from.
The CSV export also doesn't contain much meta data...so have you tried to just create a folder based media lib using your main folder containing all your tracks?
If yes, what meta data are you missing which is contained in the onairdb?

Btw, what file format is the .snd files?