export to csv

[Stephen Collier]

is it possible to export my B2 tracks to an Excel spreadsheet, or similar?

[Peter Lowham]

Hi Stephen,

Yes, this is possible to do using the B2 database file, named 'b2db'.

1. Plug a USB stick into USB C port. (a small capacity stick will be fine as the file that you are transferring is quite small; under 1MB usually)

2. If necessary, format the USB stick to 'FAT32'; 'Main Menu' --> 'Settings' --> 'Maintenance' --> 'Format USB C)

3. Still in the 'Maintenance' menu, select 'b2db to USB C' option. (this copies the 'b2db' file to the USB stick)

4. Remove USB stick and plug into your PC/Mac.

The B2 database file 'b2db' will now be on the USB stick.  The structure of the file is very simple and I have extracted the first 60-odd lines from my file.

If you look at this, you can see the structure (anything from '#' onwards are my comments)

You can import this directly into Excel or other suitable application.

Version 3                                                  #Ignore this line

1467 Albums 6005 mirror                        #Ignore this line

Van Morrison/Keep Me Singing               #ArtistName/AlbumName of first album

13 tracks                                                  #Count of tracks in the album

13 - Caledonia Swing.flac                        #Start of track names in the album

03 - Keep Me Singing.flac                       # etc...

02 - Everytime I See A River.flac

05 - Memory Lane.flac

07 - Holy Guardian Angel.flac

09 - In Tiburon.flac

10 - Look Behind The Hill.flac

12 - Too Late.flac

01 - Let It Rhyme.flac

04 - Out In The Cold Again.flac

11 - Going Down To Bangor.flac

08 - Share Your Love With Me.flac

06 - The Pen Is Mightier Than The Sword.flac

Van Morrison/Astral Weeks  Live at the Hollywood Bowl     #Start of second album

10 tracks

02 - Beside You.flac

06 - Cyprus Avenue - You Came Walking Down.flac

04 - Sweet Thing.flac

05 - The Way Young Lovers Do.flac

07 - Ballerina - Move On Up.flac

09 - Listen to the Lion - The Lion Speaks.flac

08 - Madame George.flac

10 - Common One.flac

01 - Astral Weeks - I Believe I've Transcended.flac

03 - Slim Slow Slider - I Start Breaking Down.flac

Van Morrison/The Philosopher's Stone - Disc 1       #Start of third album

15 tracks

02 - Ordinary People.flac

03 - Wonderful Remark.flac

05 - Laughing in the Wind.flac

06 - Madame Joy.flac

07 - Contemplation Rose.flac

08 - Don't Worry About Tomorrow.flac

09 - Try for Sleep.flac

10 - Lover's Prayer.flac

11 - Drumshanbo Hustle.flac

12 - Twilight Zone.flac

13 - Foggy Mountain Top.flac

14 - Naked in the Jungle.flac

15 - There There Child.flac

01 - Really Don't Know.flac

04 - Not Supposed to Break Down.flac

Van Morrison/Too Long In Exile

15 tracks

03 - Lonely Avenue.flac

04 - Ball & Chain.flac

05 - In the Forest.flac

06 - Till We Get The Healing Done.flac

07 - Gloria.flac

08 - Good Morning Little Schoolgirl.flac

09 - Wasted Years.flac

10 - The Lonesome Road.flac

12 - Close Enough For Jazz.flac

13 - Before The World Was Made.flac

14 - I'll Take Care Of You.flac

15 - Instrumental Tell Me What You Want.flac

11 - Moody's Mood For Love.flac

01 - Too Long In Exile.flac

02 - Big Time Operators.flac

Regards,

Peter.