It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×7,450
×1,279
×17
×16
×1
×1

question asked: Sep 23 '22, 10:20 a.m.
question was seen: 461 times
last updated: Sep 23 '22, 3:30 p.m.

Related questions

Work item command line import fails

0
Alfred Miranda (43●4●15) | asked Sep 23 '22, 10:20 a.m.

 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.
    1. Tried changing the format ( comma to semi column)
    2. 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!

Accepted answer

0
permanent link
Alfred Miranda (43●4●15) | answered Sep 23 '22, 3:30 p.m.

 I have given wrong input in the wcl command. I realized and resolved the issue by myself

Ralph Schoon selected this answer as the correct answer

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.