LeanKit provides the ability to import work items into a board to create cards. You can also export cards from the board into a file for use with other types of tools.
Several options become possible with this functionality:
- Import work items from external systems into a Leankit Board.
- Import cards from other boards within LeanKit.
- Export work item data for use with other systems outside LeanKit.
- Export cards for importing into other boards within LeanKit.
Accessing the Import/Export tools
To access the import and export tools, open the Board Settings by clicking the gear icon in the upper right of the window and selecting Board Settings. Once in Board Settings click the Import/Export tab on the left.
LeanKit’s import wizard walks you through the process of importing of cards into a board via comma separated value (.csv) files in three steps:
1. Choose the file to import
Start by clicking Choose File. This opens a standard file selection dialog. Navigate to your .csv file and select it. The file must be in a comma separated value (.csv) format. If the file’s first row contains the column header values, check the First row contains column headers? checkbox; import wizard will attempt to match the column headers with the card attributes in the next step.
You can also Download Valid Card Attributes for this board (.csv) for lists of the valid card types, board users, lanes, and classes of service to use when creating your import files.
2. Map Fields
The file will be uploaded to the server and import wizard will go through the initial processing. On the left you'll see a listing of all the columns included within the uploaded file, a listing of sample data contained in those files, and you'll have with the ability to select the card attribute (field) that should map to that column's data. You will also have the ability to exclude a specific column from being imported.
If you include the column headers within the uploaded file, import wizard makes guesses as to which fields can be mapped to specific card properties, but you can modify this to your your specific needs. If no column headers are specified, the columns are named with a unique ID and you are responsible for mapping the columns to the applicable card attributes. Once you feel comfortable with the column/attribute mappings, click the Next button to process the file and import the cards.
3. View Results
Once import wizard attempts to import the data in the .csv file as cards, this page shows the results of the import. This includes the number of cards successfully imported and the number of cards that failed to be imported.
If there are records that were not uploaded, you'll have a link to download a .csv file containing the original records with detailed explanations of why each record failed to upload.
This file is in the correct format and can be used to correct any faulty records and re-import them using the Import Wizard:
We’ve added a basic import template to this article to help you get started with importing cards into LeanKit. Take a look at the following file to see what an example of a .csv file should look like.
There’s no need make your spreadsheet look just like ours. Remember, you can always map your column headers to whatever LeanKit card property you’d like.
Just follow the directions within the file and get some practice importing cards into your own LeanKit board.
Download the template here.
Exporting the cards is as simple as clicking the Download button.
This exports a comma separated value (.csv) file that you can open within your preferred spreadsheet application. You can use this file to import these cards into a different LeanKit board. You may have to manipulate some of the data to match lane titles, card types, etc... that differ between the exporting board and the importing board, or you can choose to exclude those columns from the import.
Downloading a .csv file of the cards from a board is useful as an example when preparing a .csv file for import into that same board. Along with the valid attributes file for the board, this should allow you to create .csv files that will import without error.
Note: Import does not support special characters.