The MyPetanque website offers you a number of functions. Some are only accessible if you have Joined MyPetanque and have an Account (or Profile). Others do not require you to have an Account. If you have any questions about the site that are not answered below, please contact us.
There are 3 options when downloading a Player.csv file. You may select a download that is alphabetically ordered by State and Club, or a download that is alphabetically ordered by Player name. The 3rd version adds in the latest player ranking details. Any of these 3 files can be used to Import into Sport, and they both give the same result. However, the State/Club ordering keeps the Player list together for the one Club, and may be simpler to use as a check by clubs. The 3rd version may be useful if you are considering using Seeding Teams – say for the first Round of a Swiss system event.
As these are csv files (csv = comma-separated-variable), they are very simple text files and can readily be opened in Notepad. You can also set your computer up to open csv files automatically in Excel. If you use Excel to view a Player.csv file then the actual separator is not a comma (,), but a semi-colon (;) – this is to make these csv files compatible with the way the Sport scoring program is set up. In this case to view every field in a distinct column within Excel (if that what you wish, but it’s not critical that you do) takes a bit of fiddling as normally Excel is set up to have a comma as the separator between fields.
To use the ‘;’ as the separator in Excel (and this will change the way Excel displays all .csv file, please note) is to change one of the options for Windows in the Control Panel. This varies slightly for different versions of Windows, but for Windows 8 and 10 the process is as follows:
The Sport program itself is also a very clear way of listing players and licence detasils for your club. Just Import the Player.CSV file and then click on Players in the left-hand panel, then select you Club from the list.