It's all about the answers!

Ask a question

Batch update thru excel problem


Abhinav Ajmera (2212920) | asked Jul 19 '10, 5:25 a.m.
I am trying to write code for batch update of asset using excel sheet...
Is it possible to get .java file for RAMAsset class from somewhere??
Reason:
I have multiple attributes added in row for one asset. When I am trying to add asset attributes using 'setAssetAttributes
public void setAssetAttributes(AssetAttribute[] customAttributes)' function from RAmClient api... What its doing is its overwriting all the asset attribute one by one, and getting just last attribute mapped correctly.
I have tried to pass AssetAttribute[] array object as well.
as AssetAttribute[] customAttributes=new AssetAttribute;
//get value in customAttributes=<>; (for both name and value)
//and after the loop for columns
newAsset.setAssetAttributes(customAttributes);

but its not working as well.. so i thought if i can get .java file above, than i can see how RAM is implementing it..so i can make sure what to pass.

7 answers



permanent link
Kevin Bauer (34621) | answered Jul 19 '10, 10:37 a.m.
JAZZ DEVELOPER
If these are attributes are modeled on the Asset type you should use getAssetAttribute(String) or getAssetAttributes() find the attribute value you wanted to update and just set the values.

If you wanted to use self defined attributes not modeled in the asset type you can use setAssetAttributes(AssetAttribute[]) but you neeed to set the full list of attribute names and values you want set on the asset.


I am trying to write code for batch update of asset using excel sheet...
Is it possible to get .java file for RAMAsset class from somewhere??
Reason:
I have multiple attributes added in row for one asset. When I am trying to add asset attributes using 'setAssetAttributes
public void setAssetAttributes(AssetAttribute[] customAttributes)' function from RAmClient api... What its doing is its overwriting all the asset attribute one by one, and getting just last attribute mapped correctly.
I have tried to pass AssetAttribute[] array object as well.
as AssetAttribute[] customAttributes=new AssetAttribute;
//get value in customAttributes=<>; (for both name and value)
//and after the loop for columns
newAsset.setAssetAttributes(customAttributes);

but its not working as well.. so i thought if i can get .java file above, than i can see how RAM is implementing it..so i can make sure what to pass.

permanent link
Abhinav Ajmera (2212920) | answered Jul 20 '10, 6:32 a.m.
Yes, these are attributes modeled on the Asset type. Have one question if i use getAssetAttribute(String).

RAMAssetAttribute attribute = session.getAssetAttribute(assetattr_val);
attribute.setValues(new String[] {cellRowVal});//value from excel
session.put(attribute , new NullProgressMonitor());

But this is not working. Log says "You cannot set values on an attribute unless it is obtained from an asset.".

So this can only be achieved by
AssetAttribute attribute = newAsset.getAssetAttribute(assetattr_val);//where RAMxyz newAsset = session.XYZ
attribute.setValues(new String[] {cellRowVal});//value from excel
session.put(newAsset, new NullProgressMonitor());

Now aboove code will only work if asset is available is RAM (so can be extracted). But in my case i have new asset (and bulk upload from Excel) so its not there in RAM yet. Hence can't apply this code... And session.creatAsset than get that againis also not feasible without populating mandatory attribute, for which whole excersize is.

Any suggestion in this??

Thanks in advance

permanent link
Kevin Bauer (34621) | answered Jul 20 '10, 1:52 p.m.
JAZZ DEVELOPER
You first example is trying to modify the Attribute definition which you cannot set a value to.

The second example should work for new or existing assets. The one caveat is you need to set the community and asset type on the new asset before calling getAssetAttribute(String) so that it can load the attribute constraints for the new asset.

Yes, these are attributes modeled on the Asset type. Have one question if i use getAssetAttribute(String).

RAMAssetAttribute attribute = session.getAssetAttribute(assetattr_val);
attribute.setValues(new String[] {cellRowVal});//value from excel
session.put(attribute , new NullProgressMonitor());

But this is not working. Log says "You cannot set values on an attribute unless it is obtained from an asset.".

So this can only be achieved by
AssetAttribute attribute = newAsset.getAssetAttribute(assetattr_val);//where RAMxyz newAsset = session.XYZ
attribute.setValues(new String[] {cellRowVal});//value from excel
session.put(newAsset, new NullProgressMonitor());

Now aboove code will only work if asset is available is RAM (so can be extracted). But in my case i have new asset (and bulk upload from Excel) so its not there in RAM yet. Hence can't apply this code... And session.creatAsset than get that againis also not feasible without populating mandatory attribute, for which whole excersize is.

Any suggestion in this??

Thanks in advance

permanent link
Abhinav Ajmera (2212920) | answered Jul 21 '10, 7:00 a.m.
Thanks a lot. I have successfully achieved it.

But fall into different issue related to authentication. While creating session object, i don't want to get repository url, username, password from excel sheet.

Anyway in my eclipse/rsa tool i will be having repository connection, now how can I extract repository url, username, password from there, to use in my code.

Thanks in Advance.

permanent link
Kevin Bauer (34621) | answered Jul 21 '10, 1:38 p.m.
JAZZ DEVELOPER
So are you saying that your application is an eclipse plugin installed in conjunction with the RAM plugin?

You can than do the following to create a RAMSession without knowing the password...

// Create a connection to Rational Asset Manager
final String URL = "http://ramsrvr.test.com:8080/com.ibm.ram.repository.web.ws.tomcat";
final String USERID = "mylogin";

RepositoryIdentification id = new RepositoryIdentification(null, URL, USERID);

RAMSession session = RichClientCorePlugin.getDefault().createClientSession(id);


or you can get a list off all configured repository connections via...

List<RepositoryIdentification> ids = RichClientCorePlugin.getDefault().getRepositoryIdentifications();


Thanks a lot. I have successfully achieved it.

But fall into different issue related to authentication. While creating session object, i don't want to get repository url, username, password from excel sheet.

Anyway in my eclipse/rsa tool i will be having repository connection, now how can I extract repository url, username, password from there, to use in my code.

Thanks in Advance.

permanent link
Abhinav Ajmera (2212920) | answered Jul 22 '10, 7:04 a.m.
Thanks Again, Achieved this as well.

But got one issue related to previous question. In RAM, I have modeled attributes in such a way that, some of those provide Single Selection Option, some Multiple Selection Option and some as Plain Text. I am successfully able to submit attributes with Single Selection Option, and Plain Text. But attributes with Multiple Selection Option are not getting populated.

FYI... code is
AssetAttribute attribute = newAsset.getAssetAttribute(assetattr_val);//where RAMxyz newAsset = session.XYZ
if (//some code.... cell value contains ",")
attribute.setValues(cellRowMultiVal); //cellRowMultiVal==array of values from excel
else
attribute.setValues(new String[] {cellRowVal});//value from excel
session.put(newAsset, new NullProgressMonitor());

permanent link
Abhinav Ajmera (2212920) | answered Jul 26 '10, 6:43 a.m.
Got it done, Thanks.

Your answer


Register or to post your answer.