I want to import from another system via CSV, but then do updates. How do I do this?
![]()
I want to import from another system via CSV, but then do updates (say once a week) through additional CSV imports. So I would do a second CSV import, and select "Update Matched Workitem", but then how do I match the work items? The second time through, the import file has an external ID (which I save in the work item on initial import), but it has no idea of the RTC ID to map this to.
Is doing something like this (a weekly import/update of work items from an external source) possible? |
3 answers
![]()
rediscovered the csv extract url, from
https://jazz.net/forum/questions/131393/how-to-display-a-formatted-query-result-in-a-rtc-dashboard-external-content-widget#131413 little windows batch script set COOKIES=.\cookies.txt set USER=select userid set PASSWORD= make pwd set HOST=rtc repo url & port (https://server:port) set QUERY_UUID=_GjVlsE-mEeSfnK2WDtTMxQ get from web view of download query to csv curl -k -c %cookies% "%host%/jts/authenticated/identity" >nul curl -k -L -b %COOKIES% -c %COOKIES% -d j_username=%USER% -d j_password=%PASSWORD% %host%/jts/authenticated/j_security_check >nul curl -k -L -b %COOKIES% -H "Accept: application/xml" "%host%/ccm/resource/itemOid/com.ibm.team.workitem.query.QueryDescriptor/%QUERY_UUID%?_mediaType=text/csv" |
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.