Work item command line import fails
Hello All,
We are trying to import workitems along with attachments from a csv file using workitem command line (WCL) with reference commands given in the below link.
Import fails when trying to import the csv to CCM application. The error message is as below. We also tried below given methods to resolve the issue but didn't succeeded. Any help on this issue is much appreciated.
- Tried changing the format ( comma to semi column)
- Tried adding a column with name com.ibm.js.oldid and for each workitem tried numbering com.ibm.js.oldid.1 and by only "1"
Command used to import : Tried to below 2 given ways
wcl -importworkitems repository="https://localhost:9443/ccm" user="admin" password="admin@123" projectArea="Project (Change Management)" importFile="E:/RTCWCL/WCL/report2.csv" /skipEmailNotification /ignoreErrors /importdebug /forcelinkcreation /enforceSizeLimits /importmultipass /ignoreemptycolumnvalues /suppressIgnoredAttributeWarnings [mappingFile="E:/RTCWCL/WCL/mapping.xml"] [encoding="UTF-8"] [timestampFormat="MMM d, yyyy hh:mm a"] [delimiter=","]
and
wcl -importworkitems /enforceSizeLimits /importmultipass /ignoreErrors repository="https://localhost:9443/ccm" user="admin" password="admin@123" projectArea="Project (Change Management)" importFile="E:/RTCWCL/WCL/importing.csv"
Error Message:
No attributes or columns found for row 9. Check the import file format or delimiter. Delimiter is ';'
Multi Pass import requires column with work item ID's nanmed com.ibm.js.oldid
com.ibm.js.team.workitem.commandline.framework.WorkItemCommandLineException: Multi Pass import requires column with work item ID's nanmed com.ibm.js.oldid
at com.ibm.js.team.workitem.commandline.commands.ImportWorkItemsCommand.updateCreateWorkItem(ImportWorkItemsCommand.java:476)
at com.ibm.js.team.workitem.commandline.commands.ImportWorkItemsCommand.performImport(ImportWorkItemsCommand.java:416)
at com.ibm.js.team.workitem.commandline.commands.ImportWorkItemsCommand.importItems(ImportWorkItemsCommand.java:369)
at com.ibm.js.team.workitem.commandline.commands.ImportWorkItemsCommand.process(ImportWorkItemsCommand.java:319)
at com.ibm.js.team.workitem.commandline.framework.AbstractTeamRepositoryCommand.execute(AbstractTeamRepositoryCommand.java:89)
at com.ibm.js.team.workitem.commandline.WorkitemCommandLine.runCommands(WorkitemCommandLine.java:301)
at com.ibm.js.team.workitem.commandline.WorkitemCommandLine.run(WorkitemCommandLine.java:235)
at com.ibm.js.team.workitem.commandline.WorkitemCommandLine.main(WorkitemCommandLine.java:187)
Import finished.
Failed!