Thanks for the reply William, I wish to print the XML tree format in a text area. Can we do that by some way ? or is there a way to achieve that in IronPython, i am open for both options :) Thanks again for reply. On Wed, Dec 16, 2015 at 9:26 PM, William Dunlap <wdunlap at tibco.com> wrote:> Your code works in TERR under Spotfire, but since Spotfire deals with > rectangular data sets the glue code between them puts your objects in > a data.frame, which is not legal. > > What do you hope to do with the XMLInteralDocument object in Spotfire? > Such objects depend on R internal pointers and don't even survive a > save/load cycle in R. You probably want to a column of data, numeric > or character, from it and send that back to Spotfire. > > Bill Dunlap > TIBCO Software > wdunlap tibco.com > > > On Wed, Dec 16, 2015 at 12:35 AM, Archit Soni <soni.archit1989 at gmail.com> > wrote: > > Yes William i'll see if i can get any help from TIBCommunity, but my code > > worked in RStudio. > > > > On Tue, Dec 15, 2015 at 4:41 PM, William Dunlap <wdunlap at tibco.com> > wrote: > >> > >> It looks like you are calling TERR from Spotfire. The Spotfire/TERR > >> interface > >> can only pass TERR data.frames (eq. to Spotfire tables) back to Spotfire > >> and > >> XMLInternalDocuments cannot be columns of data.frames (in neither TERR > nor > >> R). > >> > >> You should contact TIBCO support and/or participate in the forums at > >> community.tibco.com to see how to solve your problem. > >> > >> > >> Bill Dunlap > >> TIBCO Software > >> wdunlap tibco.com > >> > >> > >> On Tue, Dec 15, 2015 at 5:09 AM, Archit Soni <soni.archit1989 at gmail.com > > > >> wrote: > >> > Hi All, > >> > > >> > I have the code to print XML tree that is working successfully in R > >> > Studio > >> > but is failing when i try to work it out with TERR: > >> > > >> > x<- XML::xmlParse(y) > >> > > >> > y is input (Coming from a row only once) > >> > x is output > >> > > >> > The above code is working in R studio but doesnt work in TERR, please > >> > suggest. > >> > > >> > TIBCO Enterprise Runtime for R returned an error: 'Error in > >> > as.data.frame.default(passed.args[[i]], stringsAsFactors = s : cannot > >> > coerce class '"XMLInternalDocumentXMLAbstractDocument"' into a > >> > data.frame'. > >> > at > >> > > >> > > Spotfire.Dxp.Data.DataFunctions.Executors.LocalFunctionClient.OnExecuting(FunctionClient > >> > funcClient) at > >> > > >> > > Spotfire.Dxp.Data.DataFunctions.Executors.AbstractFunctionClient.d__0.MoveNext() > >> > at > >> > > >> > > Spotfire.Dxp.Data.DataFunctions.Executors.SPlusFunctionExecutor.d__0.MoveNext() > >> > at > >> > > >> > > Spotfire.Dxp.Data.DataFunctions.DataFunctionExecutorService.d__6.MoveNext() > >> > > >> > -- > >> > Regards > >> > Archit > >> > > >> > [[alternative HTML version deleted]] > >> > > >> > ______________________________________________ > >> > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > >> > https://stat.ethz.ch/mailman/listinfo/r-help > >> > PLEASE do read the posting guide > >> > http://www.R-project.org/posting-guide.html > >> > and provide commented, minimal, self-contained, reproducible code. > > > > > > > > > > -- > > Regards > > Archit >-- Regards Archit [[alternative HTML version deleted]]
You can use capture.output(xmlParseOutput) to make a character vector with one string per line of printed R output and send that back to Spotfire for display. You will need to consult with Spotfire experts (at TIBCO support or community.tibco.com) to figure out the best way to display this in Spotfire. You may have to embed it in html to get the formatting right. Bill Dunlap TIBCO Software wdunlap tibco.com On Wed, Dec 16, 2015 at 9:12 AM, Archit Soni <soni.archit1989 at gmail.com> wrote:> Thanks for the reply William, I wish to print the XML tree format in a text > area. > Can we do that by some way ? or is there a way to achieve that in > IronPython, i am open for both options :) > > Thanks again for reply. > > On Wed, Dec 16, 2015 at 9:26 PM, William Dunlap <wdunlap at tibco.com> wrote: >> >> Your code works in TERR under Spotfire, but since Spotfire deals with >> rectangular data sets the glue code between them puts your objects in >> a data.frame, which is not legal. >> >> What do you hope to do with the XMLInteralDocument object in Spotfire? >> Such objects depend on R internal pointers and don't even survive a >> save/load cycle in R. You probably want to a column of data, numeric >> or character, from it and send that back to Spotfire. >> >> Bill Dunlap >> TIBCO Software >> wdunlap tibco.com >> >> >> On Wed, Dec 16, 2015 at 12:35 AM, Archit Soni <soni.archit1989 at gmail.com> >> wrote: >> > Yes William i'll see if i can get any help from TIBCommunity, but my >> > code >> > worked in RStudio. >> > >> > On Tue, Dec 15, 2015 at 4:41 PM, William Dunlap <wdunlap at tibco.com> >> > wrote: >> >> >> >> It looks like you are calling TERR from Spotfire. The Spotfire/TERR >> >> interface >> >> can only pass TERR data.frames (eq. to Spotfire tables) back to >> >> Spotfire >> >> and >> >> XMLInternalDocuments cannot be columns of data.frames (in neither TERR >> >> nor >> >> R). >> >> >> >> You should contact TIBCO support and/or participate in the forums at >> >> community.tibco.com to see how to solve your problem. >> >> >> >> >> >> Bill Dunlap >> >> TIBCO Software >> >> wdunlap tibco.com >> >> >> >> >> >> On Tue, Dec 15, 2015 at 5:09 AM, Archit Soni >> >> <soni.archit1989 at gmail.com> >> >> wrote: >> >> > Hi All, >> >> > >> >> > I have the code to print XML tree that is working successfully in R >> >> > Studio >> >> > but is failing when i try to work it out with TERR: >> >> > >> >> > x<- XML::xmlParse(y) >> >> > >> >> > y is input (Coming from a row only once) >> >> > x is output >> >> > >> >> > The above code is working in R studio but doesnt work in TERR, please >> >> > suggest. >> >> > >> >> > TIBCO Enterprise Runtime for R returned an error: 'Error in >> >> > as.data.frame.default(passed.args[[i]], stringsAsFactors = s : cannot >> >> > coerce class '"XMLInternalDocumentXMLAbstractDocument"' into a >> >> > data.frame'. >> >> > at >> >> > >> >> > >> >> > Spotfire.Dxp.Data.DataFunctions.Executors.LocalFunctionClient.OnExecuting(FunctionClient >> >> > funcClient) at >> >> > >> >> > >> >> > Spotfire.Dxp.Data.DataFunctions.Executors.AbstractFunctionClient.d__0.MoveNext() >> >> > at >> >> > >> >> > >> >> > Spotfire.Dxp.Data.DataFunctions.Executors.SPlusFunctionExecutor.d__0.MoveNext() >> >> > at >> >> > >> >> > >> >> > Spotfire.Dxp.Data.DataFunctions.DataFunctionExecutorService.d__6.MoveNext() >> >> > >> >> > -- >> >> > Regards >> >> > Archit >> >> > >> >> > [[alternative HTML version deleted]] >> >> > >> >> > ______________________________________________ >> >> > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >> >> > https://stat.ethz.ch/mailman/listinfo/r-help >> >> > PLEASE do read the posting guide >> >> > http://www.R-project.org/posting-guide.html >> >> > and provide commented, minimal, self-contained, reproducible code. >> > >> > >> > >> > >> > -- >> > Regards >> > Archit > > > > > -- > Regards > Archit
Thanks a lot William!, worked like a charm when I mapped output to table. Better than nothing i suppose, however I am stuck at error handling now for the case if no rows are selected the table should be empty and when analysis is opened the table should not create any table till "create XML(my custom button)" is clicked. On Wed, Dec 16, 2015 at 11:33 AM, William Dunlap <wdunlap at tibco.com> wrote:> You can use capture.output(xmlParseOutput) to make a character vector with > one string per line of printed R output and send that back to Spotfire > for display. > > You will need to consult with Spotfire experts (at TIBCO support or > community.tibco.com) to figure out the best way to display this in > Spotfire. You may have to embed it > in html to get the formatting right. > > Bill Dunlap > TIBCO Software > wdunlap tibco.com > > > On Wed, Dec 16, 2015 at 9:12 AM, Archit Soni <soni.archit1989 at gmail.com> > wrote: > > Thanks for the reply William, I wish to print the XML tree format in a > text > > area. > > Can we do that by some way ? or is there a way to achieve that in > > IronPython, i am open for both options :) > > > > Thanks again for reply. > > > > On Wed, Dec 16, 2015 at 9:26 PM, William Dunlap <wdunlap at tibco.com> > wrote: > >> > >> Your code works in TERR under Spotfire, but since Spotfire deals with > >> rectangular data sets the glue code between them puts your objects in > >> a data.frame, which is not legal. > >> > >> What do you hope to do with the XMLInteralDocument object in Spotfire? > >> Such objects depend on R internal pointers and don't even survive a > >> save/load cycle in R. You probably want to a column of data, numeric > >> or character, from it and send that back to Spotfire. > >> > >> Bill Dunlap > >> TIBCO Software > >> wdunlap tibco.com > >> > >> > >> On Wed, Dec 16, 2015 at 12:35 AM, Archit Soni < > soni.archit1989 at gmail.com> > >> wrote: > >> > Yes William i'll see if i can get any help from TIBCommunity, but my > >> > code > >> > worked in RStudio. > >> > > >> > On Tue, Dec 15, 2015 at 4:41 PM, William Dunlap <wdunlap at tibco.com> > >> > wrote: > >> >> > >> >> It looks like you are calling TERR from Spotfire. The Spotfire/TERR > >> >> interface > >> >> can only pass TERR data.frames (eq. to Spotfire tables) back to > >> >> Spotfire > >> >> and > >> >> XMLInternalDocuments cannot be columns of data.frames (in neither > TERR > >> >> nor > >> >> R). > >> >> > >> >> You should contact TIBCO support and/or participate in the forums at > >> >> community.tibco.com to see how to solve your problem. > >> >> > >> >> > >> >> Bill Dunlap > >> >> TIBCO Software > >> >> wdunlap tibco.com > >> >> > >> >> > >> >> On Tue, Dec 15, 2015 at 5:09 AM, Archit Soni > >> >> <soni.archit1989 at gmail.com> > >> >> wrote: > >> >> > Hi All, > >> >> > > >> >> > I have the code to print XML tree that is working successfully in R > >> >> > Studio > >> >> > but is failing when i try to work it out with TERR: > >> >> > > >> >> > x<- XML::xmlParse(y) > >> >> > > >> >> > y is input (Coming from a row only once) > >> >> > x is output > >> >> > > >> >> > The above code is working in R studio but doesnt work in TERR, > please > >> >> > suggest. > >> >> > > >> >> > TIBCO Enterprise Runtime for R returned an error: 'Error in > >> >> > as.data.frame.default(passed.args[[i]], stringsAsFactors = s : > cannot > >> >> > coerce class '"XMLInternalDocumentXMLAbstractDocument"' into a > >> >> > data.frame'. > >> >> > at > >> >> > > >> >> > > >> >> > > Spotfire.Dxp.Data.DataFunctions.Executors.LocalFunctionClient.OnExecuting(FunctionClient > >> >> > funcClient) at > >> >> > > >> >> > > >> >> > > Spotfire.Dxp.Data.DataFunctions.Executors.AbstractFunctionClient.d__0.MoveNext() > >> >> > at > >> >> > > >> >> > > >> >> > > Spotfire.Dxp.Data.DataFunctions.Executors.SPlusFunctionExecutor.d__0.MoveNext() > >> >> > at > >> >> > > >> >> > > >> >> > > Spotfire.Dxp.Data.DataFunctions.DataFunctionExecutorService.d__6.MoveNext() > >> >> > > >> >> > -- > >> >> > Regards > >> >> > Archit > >> >> > > >> >> > [[alternative HTML version deleted]] > >> >> > > >> >> > ______________________________________________ > >> >> > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > >> >> > https://stat.ethz.ch/mailman/listinfo/r-help > >> >> > PLEASE do read the posting guide > >> >> > http://www.R-project.org/posting-guide.html > >> >> > and provide commented, minimal, self-contained, reproducible code. > >> > > >> > > >> > > >> > > >> > -- > >> > Regards > >> > Archit > > > > > > > > > > -- > > Regards > > Archit >-- Regards Archit [[alternative HTML version deleted]]