The Data Import tool allows for basic .xlsx files to be imported and matched with player profiles in the platform. The Kinduct Platform allows for the import of structured exports from many third party technologies / products / wearables and properly formatted Excel spreadsheets.
When uploading data for third party technologies / products / wearables using the custom import option, the data will appear under the same Source/Category name in Reporting. For Custom spreadsheets, historical data or technologies not currently available in the custom import drop-down list, you can upload a properly formatted Excel single spreadsheet.
To import data into the platform:
1. Click the Admin tab, click Data Management and then select Data Import.
The Data Import screen opens:
2. Select a File Type.
For more information on current Kinduct API's go to Integration / API List
A Custom import can be selected, this is outlined in the example below as Strength Test custom import.
3. Select Custom as file type and then enter a Source name.
Remember that your source name will allow you to easily organize your metrics for Reporting and Metrics Management.
Notice below, with the example Source name, "Strength Test"would then show as this metric in Reporting.
NOTE: A custom spreadsheet file for the example above may look something like this:
Remember: The columns must be listed as: A) First Name, B) Last Name, and C) Date, the remaining columns become metrics within the Kinduct Platform. To ensure consistency, make sure you are re-using similar metric names where applicable.
Warning: The import tool will import data from the sheet (or tab) that is displayed the last time the excel was open and saved, NOT necessarily the first sheet or tab in the excel book.
If a player listed in the file is not found, the system will provide the ability to match that player’s record to an existing player or create a new one. This is important for players who might have shortened names or nicknames (such as Dave versus David). The matching only needs to be done once (the matched name will save in the player profile under the “Alias” field). Once this matching is done, the file will need to be re-uploaded.
NOTE: If there are any errors with the import such as a "Missing Users", the following message displays:
Identifying "unknown users" on the new (default) import tool: