Excel Import

in blueprint new artifacts can also be created with an excel import it is important to note that you cannot undo an import from excel unwanted artifacts would have to be deleted from within blueprint to create new artifacts with an excel import select the location for your new imported artifacts by selecting the parent folder or artifact you cannot import new artifacts into a collection, baseline or review you also must have appropriate editing permissions for the location you have selected for your artifacts click the more button in the main toolbar and select import from excel select the excel file that you want to import into blueprint excel spreadsheet format each artifact you want to import must be in its own row in the spreadsheet for example the following columns can be included in the excel spreadsheet column name required or optional description valid value hierarchy optional you can use the hierarchy column to specify the relative outline level at which each artifact will be imported when no hierarchy is specified (no hierarchy column in the excel spreadsheet), all artifacts are imported at the same level the plus sign (+) must appear in the appropriate column depending on the desired hierarchy only one row can have a plus sign (+) in the hierarchy column name required defines the name of the artifact specify the text that you want to import as the name of the artifact artifact type required defines the artifact type this value must be an artifact type that exists in the project to which you are importing description optional defines the content for the description field artifact properties optional values for artifact properties values provided in the excel file must match the acceptable value type for each property for any user and group property, the excel import will import the value as a user by default if both the user and group have the same value for example, if you have both a user and a group called "admin" in the instance, you need to specify the value as "group\ admin" in the excel to import the value as a group validation rules configured for each artifact type in blueprint will be enforced artifacts defined in the source file that don't meet the validation rules will not be imported in this case, the user will be presented with an error message that provides the details of the validation errors validation errors for a subset of the artifacts defined in the spreadsheet will not fail the whole excel import job artifacts that pass the validation rules will be successfully imported sample excel spreadsheets the following examples will help guide you in the creation of your own excel import file simple import sample provides a basic template with only system properties name artifact type description user story one user story this is user story one user story two user story this is user story two user story three user story this is user story three complex import sample provides an example with hierarchy columns, custom artifact types and custom properties keep in mind the hierarchy column and blank columns to the right of it are optional the location of the plus (+) symbols indicate the hierarchy level the values in the artifact type column are custom values you will have to overwrite them with values that match your system configuration the column names used to represent property names are also custom values you will have to overwrite them with values that match your system configuration hierarchy name artifact type description + credit card process improvements process improvement + rejection notice business rule we do a good job at notifying customers when their credit card is approved we need to improve and ensure our standard operating procedure (sop) is met and customers are notified within 2 business days when their credit card application is rejected + process timing report process improvement as part of the business analysis, collect the average time to carry out each step in the credit card management process + identify tasks for improvement process improvement + reduce manual tasks process improvement identify any steps in the credit card management process that are purely manual (not supported by any bank technology) + identify non enterprise tasks process improvement identify any steps in the credit card management process that still utilize the mainframe