Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RTC CSV import - Conditional mapping using if-else

Questions
Tags
Users
Badges
harshal Wable
(17●3●15) May 04 '15, 8:16 a.m.
I am performing a CSV import in RTC,in which I need to do mapping if certain condition in the source file is met . I am using a mapping file for CSV import . Can we use if-else condition in mapping file.

0 votes

4 answers
6,490 views
0 votes

4 answers

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.6k●3●36●49) May 04 '15, 8:29 a.m.
I am not aware of this capability. The mapping file is an XML file and this does not support conditions as far as I can tell.

0 votes

Comments
harshal Wable
May 04 '15, 8:47 a.m.
Can xslt be used instead of xml?

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER May 04 '15, 8:49 a.m.
I have never seen the ability to configure an XSLT in the import, so I think no. You can not use an XSLT file, because the mapping is read by the importer in the required format and than the mapping data read is used internally during the import.

Permanent link
harshal Wable
(17●3●15) May 04 '15, 9:34 a.m.
okay , so it can be achieved in RTC ? Do we need any script if yes ..how and where to execute it ?

0 votes

Comments
harshal Wable
May 04 '15, 9:35 a.m.
Okay .So how can we achieve it. Do we need a script to write , if yes .. how and where it needs to be executed

Permanent link
Karthik Krishnan
(909●19●130●170) May 05 '15, 4:55 a.m.
What you could do:
- create a XSLT with the necessary business conditions
- Transform the existing CSV with this XSLT 
- Create 1-1 Mapping and import


0 votes

Comments
harshal Wable
May 05 '15, 7:05 a.m.
Step 1 is fine . I have have a doubt for step 2 and 3 . Shall I give XSLT file as an input in custom data mapping field ? I mean am not not sure where wld XSLT wld be used while imporing ?

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER May 05 '15, 7:13 a.m.
As I said above, there is no place to do so in the wizard. You would have to run XSLT manually on your CSV file and create new CSV file(s) with the correct data, that you can then import.

Permanent link
Uma venkata Lekkala
(52●8●19) May 07 '15, 4:34 p.m.
 Why cannot you condition/process your data as per the business condition using macros prior to importing?

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,144

Question asked: May 04 '15, 8:16 a.m.

Question was seen: 6,490 times

Last updated: May 07 '15, 4:34 p.m.

Confirmation Cancel Confirm