DBF to XLS to ProppFrexx
- rayorayorayo
- Posts: 10
- Joined: 22 Mar 2017 18:59
DBF to XLS to ProppFrexx
I'm trying to use a database of my old playout.
That program used the DBF format.
My approach was to open the database file in Excel and delete all the columns with information that was not of my interest.
Leaving only the location field, artist, title and ramp (the old playout wrote this value in milliseconds).
Is there any way to open this file in ProppFrexx and read these fields for each song?
I attached an image of what the table looks like ... Regards
That program used the DBF format.
My approach was to open the database file in Excel and delete all the columns with information that was not of my interest.
Leaving only the location field, artist, title and ramp (the old playout wrote this value in milliseconds).
Is there any way to open this file in ProppFrexx and read these fields for each song?
I attached an image of what the table looks like ... Regards
Re: DBF to XLS to ProppFrexx
Yes, You might try to open it as a databases media library and then save it as a .pfp playlist file.
ProppFrexx supports certain .dbf files. However there is no guarantee, that all fields are imported or that your dbf is supported. Also try an Odbc driver to access your database.
In the installation folder you will find a sql.txt file containing a description of supported column names.
Also see here:
viewtopic.php?f=9&t=1049
ProppFrexx supports certain .dbf files. However there is no guarantee, that all fields are imported or that your dbf is supported. Also try an Odbc driver to access your database.
In the installation folder you will find a sql.txt file containing a description of supported column names.
Also see here:
viewtopic.php?f=9&t=1049
Bernd - radio42
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
- rayorayorayo
- Posts: 10
- Joined: 22 Mar 2017 18:59
Re: DBF to XLS to ProppFrexx
My knowledge of databases is very limited ... but I managed to convert the ramp time to seconds as specified in the file with the ProppFrexx playlist format.
Is it possible to export the table to a CSV file and import it as a playlist?
Now the CSV file looks like this attachement:
Is it possible to export the table to a CSV file and import it as a playlist?
Now the CSV file looks like this attachement:
Re: DBF to XLS to ProppFrexx
No, as CSV is not a supported playlist.
Have you tried to connect directly to your database from within ProppFrexx as suggested?
Have you tried to connect directly to your database from within ProppFrexx as suggested?
Bernd - radio42
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
- rayorayorayo
- Posts: 10
- Joined: 22 Mar 2017 18:59
Re: DBF to XLS to ProppFrexx
I do not know what to enter in the field "Connect String"
Re: DBF to XLS to ProppFrexx
That's the problem
I would need to know what database it is.
Is it a dBASE or MS Access database? Or any other?
You might try this one:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\;Extended Properties=dBASE IV;
I would need to know what database it is.
Is it a dBASE or MS Access database? Or any other?
You might try this one:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\;Extended Properties=dBASE IV;
Bernd - radio42
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
- rayorayorayo
- Posts: 10
- Joined: 22 Mar 2017 18:59
Re: DBF to XLS to ProppFrexx
The database is dBASE.
I've replaced the path in "Data Source" but received this message when using the "Test"
I've replaced the path in "Data Source" but received this message when using the "Test"
Re: DBF to XLS to ProppFrexx
Have you replaced the DataSource with the path to your dbf folder (not including the filename!) ?
Bernd - radio42
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
- rayorayorayo
- Posts: 10
- Joined: 22 Mar 2017 18:59
Re: DBF to XLS to ProppFrexx
Yes, and I still get the same message.
I guess I will have to use the option to create a library in folder mode and indicate the ramp time one song at a time
It would really help to import files in CSV format in the future
I guess I will have to use the option to create a library in folder mode and indicate the ramp time one song at a time
It would really help to import files in CSV format in the future
Re: DBF to XLS to ProppFrexx
Please send me your .dbf file (e.g. via WeTransfer) to take a look at...
CSV is not any standard format it is just defining, that columns are separated by a certain character, but it does not define anything else, e.g. the order, meaning and content of the columns etc. So it is not possible to provide a generic CSV importer - and I am already providing around 15 different playlist formats and older legacy automation systems (like Carmen, DRS2000, Jazzler, RadioHost etc.), unfortunately most of them always use very proprietary formats (e.g. dBase is a format from the '90s).
From which system does your .dbf file come from?
CSV is not any standard format it is just defining, that columns are separated by a certain character, but it does not define anything else, e.g. the order, meaning and content of the columns etc. So it is not possible to provide a generic CSV importer - and I am already providing around 15 different playlist formats and older legacy automation systems (like Carmen, DRS2000, Jazzler, RadioHost etc.), unfortunately most of them always use very proprietary formats (e.g. dBase is a format from the '90s).
From which system does your .dbf file come from?
Bernd - radio42
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution