IronPython in Spotfire - Session 1 (Pages and Document Properties)

[@nehasharma-oy4jt]

this is one of the most useful and informative video on spotfire IP.

[@Prashant_SA]

Excellent👏 you made it look so easy
Please make more such videos 😊

[@ironpythoninspotfire2502]

Thank you, I will

[@siddharthkudgunti8546]

Thank you so much for this session its was really helpful and got a basic understanding of Iron Python. Please make the session, eagerly waiting for it.

[@mohankalyankothamasu630]

Awesome video Aman. Thank you so much :) waiting for 2nd video eagerly. It was really very very helpful. U r dng a great job. Kudos

[@priyadagur6995]

It was very helpful session, thank you very much

[@srujanareddy8244]

Thank you for a very informative session on filters. can you also throw light on marked rows retrieval, filtered rows selections and Indexset().
can you also brief out on various kinds of return types for object methods. Awaiting for few more videos.

[@nilanjansaha4494]

Loved the video Aman..Waiting for your Session 2 !

[@ironpythoninspotfire2502]

Thank you for your feedback, Nilanjan, will upload the next session soon.

[@aamirsohail166]

Thank you. Please make a detail video on how to use python data function into Spotfire.

[@dhanu098765]

Thanks Aman

[@bhaskary4726]

Excellent 👌👌

[@athiraramesh2110]

Nice video Aman, well explained👍

[@ironpythoninspotfire2502]

Thank you Athira. :)

[@nareshreddy2351]

Excellent 👌👍

[@arkapravadutta8319]

Hi Aman,
First of all, really nice video. Thanks for making it.
Question :
I have to scale a couple of studies. A basic skeleton has been made which has some LSH data tables so everytime a new study has to be integrated into the skeleton we have to manually navigate to all those tables for that specific study and replace them.
My question is can it be done automated via ironpython. I want to create a script that can automatically replace those data tables by going into the respective path that I can feed in as a parameter

[@ironpythoninspotfire2502]

Hi, Arka! You can loop through the library items and keep replacing the information links(IL) with the ILs in the library. You need to specify the path to the folder where the ILs are saved.
Assuming you have folder named after the study "ABCD123" and the ILs are saved to this folder. The ILs are named as
IL_DEMO
IL_AE
IL_SAE and so on. Also, the data tables in the Spotfire dxp are named after their corresponding ILs, like, IL_DEMO, IL_AE,
IL_SAE and so on.

[@ironpythoninspotfire2502]

from Spotfire.Dxp.Framework.Library import *
from Spotfire.Dxp.Data import *
from Spotfire.Dxp.Data.Import import *
service=Application.GetService[LibraryManager]()
items=service.Search("IL_",LibraryItemRetrievalOption.IncludePath)
for val in items:
if val.Path.find("ABCD123")>=0 and val.ItemType==LibraryItemType.InformationLink:
ids=InformationLinkDataDataSource(val)
if Application.Document.Data.Tables.TryGetValue(val.Title)[1] is None:
Application.Document.Data.Tables.Add(val.Title,ids)
else:
Application.Document.Data.Tables[val.Title].ReplaceData(ids)

[@mohankalyankothamasu630]

Planning to do 2nd one?

[@jkumar2289]

Any plan to do more videos ?