Chris Hefley
posted this on July 11, 2011 08:52 pm
Leankit Kanban provides capabilities for importing and exporting the work items to and from a Board. These capabilities can be used for the following purposes:
To export Cards, navigate to the Export section of the Board Administration area...

...and select the Export Cards tab.

Exporting the Cards is as simple as clicking the Download File icon.
This will export a comma separated value (CSV) file that can be opened within your preferred spreadsheet application. The format of the export file allows this file to be imported into any other Board with no modifications.
LeanKit Kanban now provides a Import Wizard to simplify the process of importing of Cards into a Board. The Import Wizard process consists of three steps:
In this step, you will select the file that you wish to upload. Any file that you upload will need to be in a comma separated value (CSV) format. After selecting the file, select whether the first row in the file contains Column Headers. If column headers are present, the import process will attempt to match the column headers with the Card attributes during the Field Mapping Step.
In order to simplify the generation of the import files, LeanKit Kanban provides the ability to download a listing of the valid field attributes that can be used within the import file. These values will document the valid Card Types, Board Users, Lanes, and Classes of Services for the Board into which the Cards are being imported.
In this step, the uploaded file has been uploaded to the server and has gone through the initial processing. You will be presented with a listing of all the columns included within the uploaded file, a listing of sample data contained in those files, and will be provided with the ability to select the Card attribute(field) that should map to that column's data. You are also provided with the ability to choose not to user a specific column in the import process. If you included the Column Headers within the uploaded file, the Import Wizard wizard will attempt to match the columns to the appropriate Card attributes. At any point, you may change these mappings before moving to the last step in the process. If no column headers are specified, the columns will be named with a unique ID and you will be 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.
In this final step, the wizard has attempted to do the Card imports. This page will present the user with the results of the import. This includes the number of Card successfully imported and the number of Card that failed to be imported. If there are records that fail to be uploaded, a link will be present that allows you to download a CSV file containing the original records with a column specifying a detailed explanation of why that record failed to upload. This file is in the correct format and can be used to correct the faulty records and re-import them using the Import Wizard.
Import Rejection File Example: