ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Unable to import Roadmap Items from a csv file
Article ID: 198695
Clarity PPM SaaS
When importing Roadmap Items from a CSV file with following steps:
Log in to the Clarity PPMNew User Experience.
In the main menu, click Roadmaps.
Open a roadmap and select a scenario.
Click Item Actions, Import from CSV.
Download the PPM_ROADMAP_CSV_IMPORT_TEMPLATE.csv file.
Open the CSV file with Excel,
Add column name(first row), API Attribute ID(second row) and value(third row) for the custom attribute which uses static lookup in the Roadmap Item.
Use the Save As option to save your file as a CSV file with the .csv file extension.
Verify that you have opened a roadmap and selected a scenario.
Click Import CSV.
Select the CSV file from your local PC or network server and click Import CSV.
Are there any mistakes to create CSV file?
Release : 15.X
Component : CA PPM SAAS APPLICATION
The importing Roadmap Items from a CSV file feature can accept the date format "yyyy-mm-dd" only. However, the date format in the CSV file after saving from Microsoft Excel becomes "dd/mm/yyyy" or "yyyy/mm/dd". Then the date format should be changed after saving from Microsoft Excel.
If using lookup value to import the custom attribute which uses lookup also cause this problem, this should be used lookup ID when importing.