Search code examples
javartc

Import .csv to RTC using JAVA


I am working on IBM RTC and I need to import a .csv file to RTC using JAVA. Is there a way to do this? If yes, can someone help me with the same.


Solution

  • Parsing CSV data is something that you definitely do not want to implement yourself, there are plenty of libraries for that (see here).

    RTC offers a wide range of APIs that can be used with, see:

    1. rsjazz.wordpress.com or
    2. jazz.net

    In that sense: you can write Java code that reads CSV data, and RTC has a rich API that allows you push "content" into the system.

    But a word of warning: I used that java API some years ago to manipulate information within our RTC instance. That was a very painful experience. I found the APIs to be badly documented and extremely hard to use. It took me several days to come to working code that would make just a few small updates to our stories/tasks.

    Maybe things have improved since then, but be prepared for, as said ... a painful experience.

    EDIT, regarding your comment on "other options":

    Well, I dont see them: you want to push data you have in CSV into your RTC instance. So, if you still want to do that, you have to use that means that are available to you! And don't let my words discourage you. A) it was some time back when I did my programming with RTC, so maybe their APIs are better structured and more intuitive today. B) there is some documentation out there (for example here). And I think everybody can register at jazz.net; so when you have further, specific questions, you might find "better" answers there!

    All I wanted to say was: I know that other products such as jenkins or sonarqube have great APIs; and you work with that, all nice, easy, fun. You get things working with RTC, too. Just the path there, maybe isnt that nice and easy.

    My personal recommendation: start with the RTC part first. Meaning: just try to write a small programm that authenticates against the server; and then push some example data into the system. If that works nicely for you; then spend the time on pulling / transforming the real data that you have in mind!