DBF to XLS to ProppFrexx

[rayorayorayo]

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

[radio42]

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

[rayorayorayo]

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:

[radio42]

No, as CSV is not a supported playlist.
Have you tried to connect directly to your database from within ProppFrexx as suggested?

[rayorayorayo]

I do not know what to enter in the field "Connect String"

Untitled.jpg (14.99 KiB) Viewed 7042 times

[radio42]

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;

[rayorayorayo]

The database is dBASE.
I've replaced the path in "Data Source" but received this message when using the "Test"

Untitled.jpg (9.42 KiB) Viewed 7039 times

[radio42]

Have you replaced the DataSource with the path to your dbf folder (not including the filename!) ?

[rayorayorayo]

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

[radio42]

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?