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.
Backup
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.