Re: [topbraid-users] Invoking a PowerShell script in TQ Maestro or EDG

[Holger Knublauch]

Hi Simon,


On 24/07/2019 13:30, Simon Opper wrote:

Hi folks

I have a PowerShell script that pulls terms from a sharepoint site term store 
and dumps them to a csv. It would be great to invoke this or better sync it in 
some way with TQM and or EDG. E.g. invoke the script, then import the csv to a 
new or existing taxonomy.

The end game would be to also sync in a 2 way fashion, using an export of a 
central EDG taxonomy back to sharepoint via the sharepoint serializer already 
provided in EDG. But this is bound to be more complex and not my immediate 
priority.

Does anyone know if invoking a shell script would be possible within the 
environment?


there is a SPARQL function smf:exec that can be used to trigger external 
programs and scripts. You could call it from an SWP script that is 
either triggered by a UI button (e.g. teamwork:ManagePlugin) or on a 
regular basis through a scheduler:ScheduledJob. Open teamwork.ui.ttlx to 
peek into these resources.


Maybe that helps?

Holger




Or suggestions on the best way to orchestrate if not entirely within TQ?

A set of ANT scripts would be my first guess based on prior experience.

Many thanks

Simon



--
You received this message because you are subscribed to the Google Groups "TopBraid 
Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to topbraid-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/bfa184a1-7b41-0647-eb19-a481ca3b660b%40topquadrant.com.

Re: [topbraid-users] Help in importing instances to classes in Top Braid Composer

[Irene Polikoff]

Monica,

Please provide a detailed step by step description of what you are doing, the 
kind of error you are getting and what you expect the result to be. It is not 
clear, for example, what you mean by the “second step”.

I see that you have attached a file and it looks like your data is not really 
tabular but rather contain a hierarchy of some sort. None of the spreadsheet 
import options in TBC directly supported building a hierarchy. Hierarchical 
imports are supported in TopBraid EDG. 

> On Jul 23, 2019, at 4:39 AM, Monika Yadav  wrote:
> 
> I saving excel file as Text (Tab delimited). PFA for file  i am importing. I 
> am able to import this file to top braid. But after importing second step 
> which will include importing to current ontology giving me error.
> 
> 
> On Tue, Jul 23, 2019 at 1:28 PM Holger Knublauch  > wrote:
> Hi Monika,
> 
> it seems that you have opened an Excel file while the wizard expects a 
> Tab-Separated Values (.tsv) file. Could you export to .tsv from Excel and try 
> again?
> 
> If this doesn't help, please provide details of your choices in the wizard 
> and (unless private) an example file that you are trying to load.
> 
> Holger
> 
> 
> 
> On 23/07/2019 17:16, Monika Yadav wrote:
>> Hey Irene,
>> I have imported the instance from excel but while doing importing to current 
>> ontology 
>> An unexpected error has occured.
>> 
>> If you believe this is due to an issue with TopBraid Composer, then please 
>> consider to report the problem to composersupp...@topquadrant.com 
>>  and ideally include an export of 
>> the Error Log View (Window > Show View > Error Log).
>> 
>> On: Jul 19, 2019 1:31:34 PM
>> 
>> Reason:
>> org.topbraid.spin.sparqlmotion.modules.SMException: Failed to convert 
>> spreadsheet
>> 
>> at 
>> org.topbraid.spreadsheets.module.ConvertSpreadsheetToRDFModule.createGraph(ConvertSpreadsheetToRDFModule.java:119)
>> 
>> at 
>> org.topbraid.spin.sparqlmotion.modules.AbstractSMModule.getRDFOutput(AbstractSMModule.java:921)
>> 
>> at 
>> org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.executeModule(ExecutionEngineImpl.java:172)
>> 
>> at 
>> org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.execute(ExecutionEngineImpl.java:118)
>> 
>> at 
>> org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard.runImport(ImportSpreadsheetWizard.java:183)
>> 
>> at 
>> org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard.access$0(ImportSpreadsheetWizard.java:147)
>> 
>> at 
>> org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard$1.execute(ImportSpreadsheetWizard.java:106)
>> 
>> at org.topbraid.core.change.ChangeOperation.execute(ChangeOperation.java:105)
>> 
>> at 
>> org.eclipse.core.commands.operations.DefaultOperationHistory.execute(DefaultOperationHistory.java:488)
>> 
>> at 
>> org.topbraid.core.change.AbstractChangeEngine.execute(AbstractChangeEngine.java:288)
>> 
>> at 
>> org.topbraidcomposer.core.change.TBCChangeEngine.access$0(TBCChangeEngine.java:1)
>> 
>> at 
>> org.topbraidcomposer.core.change.TBCChangeEngine$2.run(TBCChangeEngine.java:159)
>> 
>> at 
>> org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
>> 
>> Caused by: java.lang.Exception
>> 
>> at 
>> org.topbraid.spreadsheets.util.SpreadsheetUtil.isSpreadsheetEmpty(SpreadsheetUtil.java:848)
>> 
>> at 
>> org.topbraid.spreadsheets.mapper.AbstractMapEngine.runReally(AbstractMapEngine.java:154)
>> 
>> at 
>> org.topbraid.spreadsheets.mapper.AbstractMapEngine.run(AbstractMapEngine.java:149)
>> 
>> at 
>> org.topbraid.spreadsheets.module.ConvertSpreadsheetToRDFModule.createGraph(ConvertSpreadsheetToRDFModule.java:116)
>> 
>> ... 12 more
>> 
>> On Friday, 19 July 2019 10:53:06 UTC+5:30, Monika Yadav wrote:
>> Hello Sir,
>> I have data in xml format.
>>   I wanted to convert xml to .ttl format in top braid.
>>  I am able to import from XSD to  .ttl. But instances of class does not 
>> copied by converting from xsd to .ttl because xsd only have structure file. 
>> Now please suggest me some way how to import instances to claases in .ttl 
>> file in top braid. I have tried the option of " Import from spreadsheet tab 
>> delimlited file"  .but again it has impoeted 675 instances of one class only 
>> I have 8 classes and this option is not copying imstances of other classes. 
>> Please help me out
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "TopBraid Suite Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to topbraid-users+unsubscr...@googlegroups.com 
>> .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/topbraid-users/526e5115-37d4-4adc-8453-d650cb84ae15%40googlegroups.com
>>  
>> 

[topbraid-users] Invoking a PowerShell script in TQ Maestro or EDG

[Simon Opper]

Hi folks

I have a PowerShell script that pulls terms from a sharepoint site term store 
and dumps them to a csv. It would be great to invoke this or better sync it in 
some way with TQM and or EDG. E.g. invoke the script, then import the csv to a 
new or existing taxonomy. 

The end game would be to also sync in a 2 way fashion, using an export of a 
central EDG taxonomy back to sharepoint via the sharepoint serializer already 
provided in EDG. But this is bound to be more complex and not my immediate 
priority.

Does anyone know if invoking a shell script would be possible within the 
environment?

Or suggestions on the best way to orchestrate if not entirely within TQ? 

A set of ANT scripts would be my first guess based on prior experience.

Many thanks

Simon

-- 
You received this message because you are subscribed to the Google Groups 
"TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to topbraid-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/c45502f2-7341-42f9-875c-c5e54e5b148a%40googlegroups.com.

Re: [topbraid-users] .project file disappeared, can I copy and edit one and still have the project work?

[Holger Knublauch]

Hi Jack,

I am not seeing a possible connection between .project files and 
executing SPARQLMotion scripts, but whatever the relation was I am glad 
you seem to have been able to proceed.


Holger


On 24/07/2019 05:42, Jack Hodges wrote:
I found out why this happened. If you have a SPARQL MOTION script 
InsertOverSelect and you add a connection from its sm:body to 
anything, then whatever you point it to is part of the sm:body. In my 
case, everything was downstream of that task, including the return, so 
TBC no longer saw the script.


On Monday, June 17, 2019 at 4:53:52 PM UTC-7, Holger Knublauch wrote:

Hi Jack,

I am not aware of situations where the .project file would
automagically disappear. You can "restore" them using

File > Import > General > Projects from Folder or Archive

or yes, create a new project and copy/move the files over.

Holger


On 18/06/2019 7:13 am, Jack Hodges wrote:

I am not sure what happened. I am running an older version of
TBCME at home and brought my workspace to work (newer version)
and 2 projects won't open because they have no .project files (I
am wondering how that happened). I checked permissions on other
projects that are open, copied and edited their .project files,
and tried to open the projects but it didn't work. Then I tried
refreshing the system and also relaunching Composer and still it
didn't work (couldn't open the projects).

I suppose that I can create a new project and copy the files over
but I'd like to know why this is happening.

Jack
-- 
You received this message because you are subscribed to the

Google Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to topbrai...@googlegroups.com .
To view this discussion on the web visit

https://groups.google.com/d/msgid/topbraid-users/66e8bce2-f7bc-4ac0-b311-d7c42bb9fef3%40googlegroups.com

.
For more options, visit https://groups.google.com/d/optout
.


--
You received this message because you are subscribed to the Google 
Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to topbraid-users+unsubscr...@googlegroups.com 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/09529a1d-6059-4c0e-9166-540f66cdd3d2%40googlegroups.com 
.


--
You received this message because you are subscribed to the Google Groups "TopBraid 
Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to topbraid-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/5c70bf96-f74d-e081-8bc4-f33db29b07da%40topquadrant.com.

Re: [topbraid-users] SPARQLMotion IterateOnSelect examples

[Holger Knublauch]

I am attaching a script that looks as in the screenshot:

You need to make sure that the PerformUpdate specifies the target 
graphs, using the GRAPH keyword. Otherwise it doesn't know where the 
triples shall go.


The Merge step is just there as a dummy placeholder for some module that 
handles the result graph.


Depending on your setup, SWP might be a better choice for such 
SPARQL-based transformation scripts.


HTH
Holger


On 24/07/2019 05:40, Jack Hodges wrote:
I have a question. Does anyone have an example of an IterateOverSelect 
that has a body that performs an insert on the results of the 
IterateOverSelect variables?


My Intent: execute a IterateOnSelect SELECT that produces multiple 
rows of several bindings, use body of IterateOnSelect to INSERT each row


sml:selectQuery:

SELECT ?a ?b ?c
WHERE {
    something related to input argument .
}

sm:body:

INSERT {
    qname, label, and properties of qname
}
WHERE {
   something using ?a, ?b, and ?c
   create unique qname and labels
}


sm:next:

Do something with the items that were inserted by the sm:body

But the IterateOverSelect never seems to get executed (at least, I 
cannot see it binding ?a, ?b, or ?c and no insertions are performed.


The SPARQL MOTION library reference has no examples.

Thank you...

Jack
--
You received this message because you are subscribed to the Google 
Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to topbraid-users+unsubscr...@googlegroups.com 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/87db2c97-5c2a-4b2e-8723-8e543e0ad221%40googlegroups.com 
.


--
You received this message because you are subscribed to the Google Groups "TopBraid 
Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to topbraid-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/00944167-65ac-dab2-8c38-5b396d2d24cd%40topquadrant.com.
# baseURI: http://example.org/iterateOverInsert
# imports: http://topbraid.org/sparqlmotionfunctions
# imports: http://topbraid.org/sparqlmotionlib-tb
# prefix: iterateOverInsert

@prefix iterateOverInsert:  .
@prefix owl:  .
@prefix rdf:  .
@prefix rdfs:  .
@prefix sm:  .
@prefix sml:  .
@prefix sp:  .
@prefix spin:  .
@prefix xsd:  .


  a owl:Ontology ;
  owl:imports  ;
  owl:imports  ;
  owl:versionInfo "Created with TopBraid Composer" ;
.

  a sml:ImportRDFFromWorkspace ;
  sm:next iterateOverInsert:IterateOverSelect_1 ;
  sml:baseURI "http://topbraid.org/examples/kennedys; ;
  rdfs:label "Import kennedys.ttl" ;
.
iterateOverInsert:IterateOverSelect_1
  a sml:IterateOverSelect ;
  sm:body iterateOverInsert:PerformUpdate_1 ;
  sm:next iterateOverInsert:Merge_1 ;
  sm:nodeX 454 ;
  sm:nodeY 182 ;
  sml:selectQuery [
  a sp:Select ;
  sp:where (
  [
sp:object owl:Class ;
sp:predicate rdf:type ;
sp:subject [
sp:varName "class" ;
  ] ;
  ]
) ;
] ;
  rdfs:label "Iterate over select 1" ;
.
iterateOverInsert:Merge_1
  a sml:Merge ;
  sm:nodeX 881 ;
  sm:nodeY 221 ;
  rdfs:label "Merge 1" ;
.
iterateOverInsert:PerformUpdate_1
  a sml:PerformUpdate ;
  sm:nodeX 518 ;
  sm:nodeY 319 ;
  sml:updateQuery [
  a sp:Modify ;
  sp:insertPattern (
  [
a sp:NamedGraph ;
sp:elements (
[
  sp:object "Comment added" ;
  sp:predicate rdfs:comment ;
  sp:subject [
  sp:varName "class" ;
] ;
]
  ) ;
sp:graphNameNode  ;
  ]
) ;
  sp:where () ;
] ;
  rdfs:label "Perform update 1" ;
.

Re: [topbraid-users] .project file disappeared, can I copy and edit one and still have the project work?

[Jack Hodges]

I found out why this happened. If you have a SPARQL MOTION script 
InsertOverSelect and you add a connection from its sm:body to anything, 
then whatever you point it to is part of the sm:body. In my case, 
everything was downstream of that task, including the return, so TBC no 
longer saw the script.

On Monday, June 17, 2019 at 4:53:52 PM UTC-7, Holger Knublauch wrote:
>
> Hi Jack,
>
> I am not aware of situations where the .project file would automagically 
> disappear. You can "restore" them using
>
> File > Import > General > Projects from Folder or Archive
> or yes, create a new project and copy/move the files over.
>
> Holger
>
>
> On 18/06/2019 7:13 am, Jack Hodges wrote:
>
> I am not sure what happened. I am running an older version of TBCME at 
> home and brought my workspace to work (newer version) and 2 projects won't 
> open because they have no .project files (I am wondering how that 
> happened). I checked permissions on other projects that are open, copied 
> and edited their .project files, and tried to open the projects but it 
> didn't work. Then I tried refreshing the system and also relaunching 
> Composer and still it didn't work (couldn't open the projects). 
>
> I suppose that I can create a new project and copy the files over but I'd 
> like to know why this is happening.
>
> Jack
> -- 
> You received this message because you are subscribed to the Google Groups 
> "TopBraid Suite Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to topbrai...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/topbraid-users/66e8bce2-f7bc-4ac0-b311-d7c42bb9fef3%40googlegroups.com
>  
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to topbraid-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/09529a1d-6059-4c0e-9166-540f66cdd3d2%40googlegroups.com.

[topbraid-users] SPARQLMotion IterateOnSelect examples

[Jack Hodges]

I have a question. Does anyone have an example of an IterateOverSelect that 
has a body that performs an insert on the results of the IterateOverSelect 
variables?

My Intent: execute a IterateOnSelect SELECT that produces multiple rows of 
several bindings, use body of IterateOnSelect to INSERT each row

sml:selectQuery:

SELECT ?a ?b ?c
WHERE {
something related to input argument .
}

sm:body:

INSERT {
qname, label, and properties of qname
}
WHERE {
   something using ?a, ?b, and ?c
   create unique qname and labels
}


sm:next:

Do something with the items that were inserted by the sm:body

But the IterateOverSelect never seems to get executed (at least, I cannot 
see it binding ?a, ?b, or ?c and no insertions are performed.

The SPARQL MOTION library reference has no examples.

Thank you...

Jack

-- 
You received this message because you are subscribed to the Google Groups 
"TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to topbraid-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/87db2c97-5c2a-4b2e-8723-8e543e0ad221%40googlegroups.com.

Re: [topbraid-users] Re: Help in importing instances to classes in Top Braid Composer

[Holger Knublauch]

This error depends on the chosen target ontology. Furthermore, the rows 
in the file that you have attached don't look correct - they have plenty 
of line breaks instead of tabs.


Holger


On 23/07/2019 18:39, Monika Yadav wrote:
I saving excel file as Text (Tab delimited). PFA for file  i am 
importing. I am able to import this file to top braid. But after 
importing second step which will include importing to current ontology 
giving me error.



On Tue, Jul 23, 2019 at 1:28 PM Holger Knublauch 
mailto:hol...@topquadrant.com>> wrote:


Hi Monika,

it seems that you have opened an Excel file while the wizard
expects a Tab-Separated Values (.tsv) file. Could you export to
.tsv from Excel and try again?

If this doesn't help, please provide details of your choices in
the wizard and (unless private) an example file that you are
trying to load.

Holger


On 23/07/2019 17:16, Monika Yadav wrote:

Hey Irene,
I have imported the instance from excel but while doing importing
to current ontology
An unexpected error has occured.

If you believe this is due to an issue with TopBraid Composer,
then please consider to report the problem to
composersupp...@topquadrant.com
 and ideally include an
export of the Error Log View (Window > Show View > Error Log).

On: Jul 19, 2019 1:31:34 PM

Reason:
org.topbraid.spin.sparqlmotion.modules.SMException: Failed to
convert spreadsheet

at

org.topbraid.spreadsheets.module.ConvertSpreadsheetToRDFModule.createGraph(ConvertSpreadsheetToRDFModule.java:119)

at

org.topbraid.spin.sparqlmotion.modules.AbstractSMModule.getRDFOutput(AbstractSMModule.java:921)

at

org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.executeModule(ExecutionEngineImpl.java:172)

at

org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.execute(ExecutionEngineImpl.java:118)

at

org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard.runImport(ImportSpreadsheetWizard.java:183)

at

org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard.access$0(ImportSpreadsheetWizard.java:147)

at

org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard$1.execute(ImportSpreadsheetWizard.java:106)

at
org.topbraid.core.change.ChangeOperation.execute(ChangeOperation.java:105)

at

org.eclipse.core.commands.operations.DefaultOperationHistory.execute(DefaultOperationHistory.java:488)

at

org.topbraid.core.change.AbstractChangeEngine.execute(AbstractChangeEngine.java:288)

at

org.topbraidcomposer.core.change.TBCChangeEngine.access$0(TBCChangeEngine.java:1)

at

org.topbraidcomposer.core.change.TBCChangeEngine$2.run(TBCChangeEngine.java:159)

at

org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)

Caused by: java.lang.Exception

at

org.topbraid.spreadsheets.util.SpreadsheetUtil.isSpreadsheetEmpty(SpreadsheetUtil.java:848)

at

org.topbraid.spreadsheets.mapper.AbstractMapEngine.runReally(AbstractMapEngine.java:154)

at

org.topbraid.spreadsheets.mapper.AbstractMapEngine.run(AbstractMapEngine.java:149)

at

org.topbraid.spreadsheets.module.ConvertSpreadsheetToRDFModule.createGraph(ConvertSpreadsheetToRDFModule.java:116)

... 12 more

On Friday, 19 July 2019 10:53:06 UTC+5:30, Monika Yadav wrote:

Hello Sir,
I have data in xml format.
  I wanted to convert xml to .ttl format in top braid.
 I am able to import from XSD to  .ttl. But instances of
class does not copied by converting from xsd to .ttl because
xsd only have structure file. Now please suggest me some way
how to import instances to claases in .ttl file in top braid.
I have tried the option of " Import from spreadsheet tab
delimlited file"  .but again it has impoeted 675 instances of
one class only I have 8 classes and this option is not
copying imstances of other classes. Please help me out

-- 
You received this message because you are subscribed to the

Google Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to topbraid-users+unsubscr...@googlegroups.com
.
To view this discussion on the web visit

https://groups.google.com/d/msgid/topbraid-users/526e5115-37d4-4adc-8453-d650cb84ae15%40googlegroups.com

.
-- 
You received this message because you are subscribed to the Google

Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to 

Re: [topbraid-users] Re: Help in importing instances to classes in Top Braid Composer

[Holger Knublauch]

Hi Monika,

it seems that you have opened an Excel file while the wizard expects a 
Tab-Separated Values (.tsv) file. Could you export to .tsv from Excel 
and try again?


If this doesn't help, please provide details of your choices in the 
wizard and (unless private) an example file that you are trying to load.


Holger


On 23/07/2019 17:16, Monika Yadav wrote:

Hey Irene,
I have imported the instance from excel but while doing importing to 
current ontology

An unexpected error has occured.

If you believe this is due to an issue with TopBraid Composer, then 
please consider to report the problem to 
composersupp...@topquadrant.com 
 and ideally include an export 
of the Error Log View (Window > Show View > Error Log).


On: Jul 19, 2019 1:31:34 PM

Reason:
org.topbraid.spin.sparqlmotion.modules.SMException: Failed to convert 
spreadsheet


at 
org.topbraid.spreadsheets.module.ConvertSpreadsheetToRDFModule.createGraph(ConvertSpreadsheetToRDFModule.java:119)


at 
org.topbraid.spin.sparqlmotion.modules.AbstractSMModule.getRDFOutput(AbstractSMModule.java:921)


at 
org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.executeModule(ExecutionEngineImpl.java:172)


at 
org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.execute(ExecutionEngineImpl.java:118)


at 
org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard.runImport(ImportSpreadsheetWizard.java:183)


at 
org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard.access$0(ImportSpreadsheetWizard.java:147)


at 
org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard$1.execute(ImportSpreadsheetWizard.java:106)


at 
org.topbraid.core.change.ChangeOperation.execute(ChangeOperation.java:105)


at 
org.eclipse.core.commands.operations.DefaultOperationHistory.execute(DefaultOperationHistory.java:488)


at 
org.topbraid.core.change.AbstractChangeEngine.execute(AbstractChangeEngine.java:288)


at 
org.topbraidcomposer.core.change.TBCChangeEngine.access$0(TBCChangeEngine.java:1)


at 
org.topbraidcomposer.core.change.TBCChangeEngine$2.run(TBCChangeEngine.java:159)


at 
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)


Caused by: java.lang.Exception

at 
org.topbraid.spreadsheets.util.SpreadsheetUtil.isSpreadsheetEmpty(SpreadsheetUtil.java:848)


at 
org.topbraid.spreadsheets.mapper.AbstractMapEngine.runReally(AbstractMapEngine.java:154)


at 
org.topbraid.spreadsheets.mapper.AbstractMapEngine.run(AbstractMapEngine.java:149)


at 
org.topbraid.spreadsheets.module.ConvertSpreadsheetToRDFModule.createGraph(ConvertSpreadsheetToRDFModule.java:116)


... 12 more

On Friday, 19 July 2019 10:53:06 UTC+5:30, Monika Yadav wrote:

Hello Sir,
I have data in xml format.
  I wanted to convert xml to .ttl format in top braid.
 I am able to import from XSD to  .ttl. But instances of class
does not copied by converting from xsd to .ttl because xsd only
have structure file. Now please suggest me some way how to import
instances to claases in .ttl file in top braid. I have tried the
option of " Import from spreadsheet tab delimlited file"  .but
again it has impoeted 675 instances of one class only I have 8
classes and this option is not copying imstances of other classes.
Please help me out

--
You received this message because you are subscribed to the Google 
Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to topbraid-users+unsubscr...@googlegroups.com 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/526e5115-37d4-4adc-8453-d650cb84ae15%40googlegroups.com 
.


--
You received this message because you are subscribed to the Google Groups "TopBraid 
Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to topbraid-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/12136f12-3efc-8f43-b7fc-c5e0231cf744%40topquadrant.com.

Re: [topbraid-users] Help in importing instances to classes in Top Braid Composer

[Monika Yadav]

Hey Irene,
I have imported the
An unexpected error has occured.

If you believe this is due to an issue with TopBraid Composer, then please
consider to report the problem to composersupp...@topquadrant.com and
ideally include an export of the Error Log View (Window > Show View > Error
Log).

On: Jul 19, 2019 1:31:34 PM

Reason:
org.topbraid.spin.sparqlmotion.modules.SMException: Failed to convert
spreadsheet

at
org.topbraid.spreadsheets.module.ConvertSpreadsheetToRDFModule.createGraph(ConvertSpreadsheetToRDFModule.java:119)

at
org.topbraid.spin.sparqlmotion.modules.AbstractSMModule.getRDFOutput(AbstractSMModule.java:921)

at
org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.executeModule(ExecutionEngineImpl.java:172)

at
org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.execute(ExecutionEngineImpl.java:118)

at
org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard.runImport(ImportSpreadsheetWizard.java:183)

at
org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard.access$0(ImportSpreadsheetWizard.java:147)

at
org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard$1.execute(ImportSpreadsheetWizard.java:106)

at
org.topbraid.core.change.ChangeOperation.execute(ChangeOperation.java:105)

at
org.eclipse.core.commands.operations.DefaultOperationHistory.execute(DefaultOperationHistory.java:488)

at
org.topbraid.core.change.AbstractChangeEngine.execute(AbstractChangeEngine.java:288)

at
org.topbraidcomposer.core.change.TBCChangeEngine.access$0(TBCChangeEngine.java:1)

at
org.topbraidcomposer.core.change.TBCChangeEngine$2.run(TBCChangeEngine.java:159)

at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)

Caused by: java.lang.Exception

at
org.topbraid.spreadsheets.util.SpreadsheetUtil.isSpreadsheetEmpty(SpreadsheetUtil.java:848)

at
org.topbraid.spreadsheets.mapper.AbstractMapEngine.runReally(AbstractMapEngine.java:154)

at
org.topbraid.spreadsheets.mapper.AbstractMapEngine.run(AbstractMapEngine.java:149)

at
org.topbraid.spreadsheets.module.ConvertSpreadsheetToRDFModule.createGraph(ConvertSpreadsheetToRDFModule.java:116)

... 12 more


On Fri, Jul 19, 2019 at 11:25 AM Irene Polikoff 
wrote:

> Monica,
>
> These page describes the process for importing XML when you have a
> corresponding XSD https://topbraidcomposer.org/html/Import_XSD.htm.
> Alternatively, you can simply open XML file by double clicking - as
> described here https://topbraidcomposer.org/html/XMap.htm.
>
> Spreadsheet import will always create instances of one class. For example,
> if each row contains information about a Person including Organizations
> they work for and Countries they were born in, you can import all
> information as properties of a Person. Then, once in RDF, run some
> transformations to create instances of Organization and Country. The
> simplest way to do transformation is to select a class and then select
> “Extract class” in the Resource menu. This will open a dialog that would
> let you create instances of another, related class and move some of the
> data to these instances. Other ways to transform data include using SPARQL
> and SPINMap.
>
> There are several different spreadsheet importers. The one you are
> referring to is documented here
> https://topbraidcomposer.org/html/Import_Spreadsheets.htm. Alternatively,
> you could import the same spreadsheet multiple times creating different
> mappings. For an overview of different spreadsheet import capabilities,
> take a look at
> https://www.topquadrant.com/download/using-topbraid-to-work-with-spreadsheet-data/?wpdmdl=15930=5d31588dcb5ba1563515021
> .
>
>
>
> On Jul 19, 2019, at 1:21 AM, Monika Yadav  wrote:
>
> Hello Sir,
> I have data in xml format.
>   I wanted to convert xml to .ttl format in top braid.
>  I am able to import from XSD to  .ttl. But instances of class does not
> copied by converting from xsd to .ttl because xsd only have structure file.
> Now please suggest me some way how to import instances to claases in .ttl
> file in top braid. I have tried the option of " Import from spreadsheet tab
> delimlited file"  .but again it has impoeted 675 instances of one class
> only I have 8 classes and this option is not copying imstances of other
> classes. Please help me out
>
> --
> You received this message because you are subscribed to the Google Groups
> "TopBraid Suite Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to topbraid-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/topbraid-users/4cde453b-a462-40f3-ae40-59c311513f47%40googlegroups.com
> 
> .
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "TopBraid Suite Users" group.
> To unsubscribe from this group and stop 

[topbraid-users] Re: Help in importing instances to classes in Top Braid Composer

[Monika Yadav]

Hey Irene,
I have imported the instance from excel but while doing importing to 
current ontology 
An unexpected error has occured.

If you believe this is due to an issue with TopBraid Composer, then please 
consider to report the problem to composersupp...@topquadrant.com and 
ideally include an export of the Error Log View (Window > Show View > Error 
Log).

On: Jul 19, 2019 1:31:34 PM

Reason:
org.topbraid.spin.sparqlmotion.modules.SMException: Failed to convert 
spreadsheet

at org.topbraid.spreadsheets.module.ConvertSpreadsheetToRDFModule.
createGraph(ConvertSpreadsheetToRDFModule.java:119)

at org.topbraid.spin.sparqlmotion.modules.AbstractSMModule.getRDFOutput(
AbstractSMModule.java:921)

at org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.
executeModule(ExecutionEngineImpl.java:172)

at org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.execute(
ExecutionEngineImpl.java:118)

at org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard.
runImport(ImportSpreadsheetWizard.java:183)

at org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard.
access$0(ImportSpreadsheetWizard.java:147)

at org.topbraidcomposer.spreadsheets.wizard.ImportSpreadsheetWizard$1.
execute(ImportSpreadsheetWizard.java:106)

at org.topbraid.core.change.ChangeOperation.execute(
ChangeOperation.java:105)

at org.eclipse.core.commands.operations.DefaultOperationHistory.execute(
DefaultOperationHistory.java:488)

at org.topbraid.core.change.AbstractChangeEngine.execute(
AbstractChangeEngine.java:288)

at org.topbraidcomposer.core.change.TBCChangeEngine.access$
0(TBCChangeEngine.java:1)

at org.topbraidcomposer.core.change.TBCChangeEngine$2.run(
TBCChangeEngine.java:159)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(
ModalContext.java:119)

Caused by: java.lang.Exception

at org.topbraid.spreadsheets.util.SpreadsheetUtil.isSpreadsheetEmpty(
SpreadsheetUtil.java:848)

at org.topbraid.spreadsheets.mapper.AbstractMapEngine.
runReally(AbstractMapEngine.java:154)

at org.topbraid.spreadsheets.mapper.AbstractMapEngine.run(
AbstractMapEngine.java:149)

at org.topbraid.spreadsheets.module.ConvertSpreadsheetToRDFModule.
createGraph(ConvertSpreadsheetToRDFModule.java:116)

... 12 more

On Friday, 19 July 2019 10:53:06 UTC+5:30, Monika Yadav wrote:
>
> Hello Sir,
> I have data in xml format.
>   I wanted to convert xml to .ttl format in top braid.
>  I am able to import from XSD to  .ttl. But instances of class does not 
> copied by converting from xsd to .ttl because xsd only have structure file. 
> Now please suggest me some way how to import instances to claases in .ttl 
> file in top braid. I have tried the option of " Import from spreadsheet tab 
> delimlited file"  .but again it has impoeted 675 instances of one class 
> only I have 8 classes and this option is not copying imstances of other 
> classes. Please help me out
>

-- 
You received this message because you are subscribed to the Google Groups 
"TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to topbraid-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/526e5115-37d4-4adc-8453-d650cb84ae15%40googlegroups.com.