This article explains how to export your player database from Pianola to Jeff Smith. Before you do so , it's vital that you backup your existing Jeff Smith database in case you need to revert to it later.



To backup your existing Jeff Smith records, go to Player Database > Player Management and click 'Export to Pianola'


Export from Pianola

Login to Pianola and go to Admin > Members > Export

Choose the 'Export to Jeff Smith' option.

Pianola will not export any records where:


  • The national number (EBU, ABF, SBU) is not unique
  • The local number is missing or not unique
  • The name is incomplete
  • The player is marked as having passed away

You can view the records that will not be exported and the reasons why. It's important to check that all the records you want to export are i going to be included.

Pianola will mark people as visitors in Jeff Smith if they:


  • Have a the membership category of Visitor; or
  • They have left the club

Check the box to confirm you have backed up your existing data and then click 'Export'.


Import to Jeff Smith

Click 'Import player list from PIanola'. Choose the file you just downloaded from Pianola.

Click back on the 'Player database' tab in Jeff Smith and check your player database is populated with the records you expected.