(Utility) OpenOffice Calc Template to EXPORT to MMD Files

English Scripts
1

This is an experimental port of my Excel VBA Template to OOorg.

It should work if you open it in Calc and then File, Templates >, Save.

Same instructions apply as for the Excel version; and it’s similarly not very heavy on error-checking code.

Please let me know if you find any bugs.

PS: This initial version contains a single ‘dummy’ populated row, with its values in MILLISECONDS. This is purely for demonstration, to allow you to ‘play’ with the spreadsheet and run the code to check it out, without needing to add data. I chose mS for the ‘sample’ for Mike’s benefit, so he can see how it works with StationPlaylist (mS) data. Note that the template formats ‘time’ cells as M:SS.000, which is the most ‘friendly’ format for most users: this means that values in milliseconds look ‘strange’ (often 0:00.000 is displayed) unless you change the Format of the Duration column and ALL Cue Point columns (to #).

PPS: The next version will add a Track column, to reflect the mAirList V2.2.2 change (Track number is now imported—if present—from ID3 tags on initial import/play, and stored in the MMD as a Name/Value pair of tags in the block).

[Attachment removed: updated version 1.1 is in a post below!]

BFN
CAD

2

OK folks: here is V1.1 of the OpenOffice version of the Export MMD Files template.

This now includes a Track column to support the new mAirList V2.2.2 feature which will import the ID3v2 Track value (if present).

Like V1.0, the template contains one sample row containing ‘dummy’ info. with all time values expressed in MILLISECONDS. You can use this to get a ‘feel’ for how it all works.

Note that if you want to use values in m:ss.ttt format, you MUST include minutes (or the macro will crash). For example, if a Ramp is at 17.404 seconds and you use m:ss.ttt, you MUST write this as the string 0:17.404 and NOT as 17.404.

I see that there were three downloads of the previous version. I’d recommend that you download this new one to replace V1.0. I’d also appreciate it if the downloaders could let me know that it’s working properly on their PCs!

BFN
CAD

Export MMD Contents OTS V1.1.zip (20.8 KB)