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

[Holger Knublauch]

TBC is based on Eclipse, and going to Help > Install New Software is the 
starting point to add features from 3rd parties. So yes, it should work 
in principle.


Note https://www.quora.com/How-do-I-install-eclipse-for-C-programming 
about concerns related to C# in particular.


Holger


On 25/07/2019 07:54, Simon Opper wrote:

Morning Holger

Cold down here in Sydney ! Bet it's more pleasant up your way this 
morning :)


Thanks for the info. I'll explore that approach. Sounds the trick.

On a somewhat related line of question...

TBC ships with Javascript file editors ... and others ... xml and 
html.  In your graphql starwars example is a good combination of using 
javascript to script some fetch methods for web resources.


If I wanted to do the same type of scripts with another framework, 
e.g. .Net or C# which seem to be the flavour for SharePoint, can these 
editors be integrated with TBC ?  I'm guessing that these are more of 
an eclipse configuration rather than any specific relationship to TBC 
setup ? Is this right ?


Cheers

Simon

On Wednesday, July 24, 2019 at 2:48:49 PM UTC+10, Holger Knublauch wrote:

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/f92487db-a066-41a8-96ad-b31c0c3bb80f%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/a6fe494a-de2f-1e0c-c65a-a4d8d93a48e0%40topquadrant.com.

Re: [topbraid-users] 'closed' attribute for Property Groups for ontology instances

[Holger Knublauch]

The Ontology editor in the current versions uses the "old" SWA-based 
forms, which do not support such openable form sections. tosh:closed 
would only work with the newer forms, used by other asset collection 
types such as Taxonomies.


Having said this, moving forward I would prefer to deprecate and 
eventually remove that option altogether. If people want to define 
properties that should not always be visible, they could move them to 
another sh:NodeShape where the user can switch to. Furthermore, the new 
forms introduce a tabbed mode, where the concept of closed sections is 
kind-of built-in.


Holger


On 24/07/2019 23:28, Eva Ibarra Sicilia wrote:

Dear,
I would like to create a Property Group that would be closed by 
default. This group would groups properties used for instances of an 
ontology. I have created the group and set 'closed true', but I can 
still see the group open by default. What am I doing wrong?

I attach an example TTL file and some pictures.
Thank you!
Eva Ibarra
--
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/bdfe2cf2-31e5-4b5f-a372-86527bc0197d%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/466ecbbb-2f54-dcc6-2202-3f25a2166a7c%40topquadrant.com.

Re: [topbraid-users] SPARQLMotion IterateOnSelect examples

[Holger Knublauch]

If a magic property is not resolving, have you tried renaming its file 
to something like .spin.ttl - this should have the system register all 
SPIN functions and magic properties globally.


Holger


On 25/07/2019 04:25, Jack Hodges wrote:
I was debugging this problem with Steve and we found that the 
IterateOverSelect is not executing because it has two magic property 
calls referenced and they are not being resolved. Their graphs 'are' 
being imported, and everything in them can be seen in the 'query' tab 
in SPARQL MOTION and, even though I use their prefixes in the select 
statement, in the SM query tab they have been converted to their full 
namespaces. Interestingly, they do not resolve from their namespaces 
in that query tab, but if I retype their prefixes they do resolve and 
execute in that tab just fine. So I am confused about this and hope 
that you know what is going on and I might then move forward...I 
should add that all of the graphs that are needed are imported into 
the SM script and resolve in the imported graphs tab in SM.


Jack

On Tuesday, July 23, 2019 at 3:42:18 PM UTC-7, Holger Knublauch wrote:

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 topbrai...@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/b677db84-80cb-467f-86a5-2d53093a588d%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/510f0838-5977-faf7-d1d0-4c0a7b018a90%40topquadrant.com.

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

[Simon Opper]

Morning Holger

Cold down here in Sydney ! Bet it's more pleasant up your way this morning 
:)

Thanks for the info. I'll explore that approach. Sounds the trick.

On a somewhat related line of question...

TBC ships with Javascript file editors ... and others ... xml and html.  In 
your graphql starwars example is a good combination of using javascript to 
script some fetch methods for web resources.

If I wanted to do the same type of scripts with another framework, e.g. 
.Net or C# which seem to be the flavour for SharePoint, can these editors 
be integrated with TBC ?  I'm guessing that these are more of an eclipse 
configuration rather than any specific relationship to TBC setup ? Is this 
right ?

Cheers

Simon

On Wednesday, July 24, 2019 at 2:48:49 PM UTC+10, Holger Knublauch wrote:
>
> 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/f92487db-a066-41a8-96ad-b31c0c3bb80f%40googlegroups.com.

Re: [topbraid-users] SPARQLMotion IterateOnSelect examples

[Jack Hodges]

I was debugging this problem with Steve and we found that the 
IterateOverSelect is not executing because it has two magic property calls 
referenced and they are not being resolved. Their graphs 'are' being 
imported, and everything in them can be seen in the 'query' tab in SPARQL 
MOTION and, even though I use their prefixes in the select statement, in 
the SM query tab they have been converted to their full namespaces. 
Interestingly, they do not resolve from their namespaces in that query tab, 
but if I retype their prefixes they do resolve and execute in that tab just 
fine. So I am confused about this and hope that you know what is going on 
and I might then move forward...I should add that all of the graphs that 
are needed are imported into the SM script and resolve in the imported 
graphs tab in SM.

Jack

On Tuesday, July 23, 2019 at 3:42:18 PM UTC-7, Holger Knublauch wrote:
>
> 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 topbrai...@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/b677db84-80cb-467f-86a5-2d53093a588d%40googlegroups.com.

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

[Jack Hodges]

I replied to the wrong question. I should have replied to the question 
about TBC not finding an SM script anymore. Sorry.

On Tuesday, July 23, 2019 at 3:44:21 PM UTC-7, Holger Knublauch wrote:
>
> 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 topbrai...@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/656415a0-03a2-4460-8c23-9af67df3414c%40googlegroups.com.

[topbraid-users] 'closed' attribute for Property Groups for ontology instances

[Eva Ibarra Sicilia]

Dear,
I would like to create a Property Group that would be closed by default. 
This group would groups properties used for instances of an ontology. I 
have created the group and set 'closed true', but I can still see the group 
open by default. What am I doing wrong? 
I attach an example TTL file and some pictures. 
Thank you!
Eva Ibarra

-- 
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/bdfe2cf2-31e5-4b5f-a372-86527bc0197d%40googlegroups.com.


test_onto.ttl
Description: Binary data

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

[Monika Yadav]

When I am copying the xml file and opening it directly. it is giving me
following error:
a.lang.RuntimeException: org.eclipse.ui.PartInitException: Editor could not
be initialized.
at
org.eclipse.wst.xml.ui.internal.tabletree.XMLMultiPageEditorPart.createPages(XMLMultiPageEditorPart.java:792)
at
org.eclipse.ui.part.MultiPageEditorPart.createPartControl(MultiPageEditorPart.java:363)
at
org.eclipse.ui.internal.e4.compatibility.CompatibilityPart.createPartControl(CompatibilityPart.java:150)
at
org.eclipse.ui.internal.e4.compatibility.CompatibilityEditor.createPartControl(CompatibilityEditor.java:99)
at
org.eclipse.ui.internal.e4.compatibility.CompatibilityPart.create(CompatibilityPart.java:340)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:55)
at
org.eclipse.e4.core.internal.di.InjectorImpl.processAnnotated(InjectorImpl.java:966)
at
org.eclipse.e4.core.internal.di.InjectorImpl.processAnnotated(InjectorImpl.java:931)
at
org.eclipse.e4.core.internal.di.InjectorImpl.inject(InjectorImpl.java:151)
at
org.eclipse.e4.core.internal.di.InjectorImpl.internalMake(InjectorImpl.java:375)
at org.eclipse.e4.core.internal.di.InjectorImpl.make(InjectorImpl.java:294)
at
org.eclipse.e4.core.contexts.ContextInjectionFactory.make(ContextInjectionFactory.java:162)
at
org.eclipse.e4.ui.internal.workbench.ReflectionContributionFactory.createFromBundle(ReflectionContributionFactory.java:105)
at
org.eclipse.e4.ui.internal.workbench.ReflectionContributionFactory.doCreate(ReflectionContributionFactory.java:74)
at
org.eclipse.e4.ui.internal.workbench.ReflectionContributionFactory.create(ReflectionContributionFactory.java:56)
at
org.eclipse.e4.ui.workbench.renderers.swt.ContributedPartRenderer.createWidget(ContributedPartRenderer.java:129)
at
org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createWidget(PartRenderingEngine.java:975)
at
org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:651)
at
org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:757)
at
org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$0(PartRenderingEngine.java:728)
at
org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$2.run(PartRenderingEngine.java:722)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at
org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:706)
at
org.eclipse.e4.ui.internal.workbench.PartServiceImpl$1.handleEvent(PartServiceImpl.java:104)
at
org.eclipse.e4.ui.services.internal.events.UIEventHandler$1.run(UIEventHandler.java:40)
at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:233)
at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:145)
at org.eclipse.swt.widgets.Display.syncExec(Display.java:4821)
at
org.eclipse.e4.ui.internal.workbench.swt.E4Application$1.syncExec(E4Application.java:211)
at
org.eclipse.e4.ui.services.internal.events.UIEventHandler.handleEvent(UIEventHandler.java:36)
at
org.eclipse.equinox.internal.event.EventHandlerWrapper.handleEvent(EventHandlerWrapper.java:201)
at
org.eclipse.equinox.internal.event.EventHandlerTracker.dispatchEvent(EventHandlerTracker.java:197)
at
org.eclipse.equinox.internal.event.EventHandlerTracker.dispatchEvent(EventHandlerTracker.java:1)
at
org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
at
org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148)
at
org.eclipse.equinox.internal.event.EventAdminImpl.dispatchEvent(EventAdminImpl.java:135)
at
org.eclipse.equinox.internal.event.EventAdminImpl.sendEvent(EventAdminImpl.java:78)
at
org.eclipse.equinox.internal.event.EventComponent.sendEvent(EventComponent.java:39)
at
org.eclipse.e4.ui.services.internal.events.EventBroker.send(EventBroker.java:94)
at
org.eclipse.e4.ui.internal.workbench.UIEventPublisher.notifyChanged(UIEventPublisher.java:60)
at
org.eclipse.emf.common.notify.impl.BasicNotifierImpl.eNotify(BasicNotifierImpl.java:374)
at
org.eclipse.e4.ui.model.application.ui.impl.ElementContainerImpl.setSelectedElement(ElementContainerImpl.java:173)
at
org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.showElementInWindow(ModelServiceImpl.java:617)
at
org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.bringToTop(ModelServiceImpl.java:581)
at
org.eclipse.e4.ui.internal.workbench.PartServiceImpl.delegateBringToTop(PartServiceImpl.java:770)
at
org.eclipse.e4.ui.internal.workbench.PartServiceImpl.bringToTop(PartServiceImpl.java:401)
at
org.eclipse.e4.ui.internal.workbench.PartServiceImpl.showPart(PartServiceImpl.java:1214)
at

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

[Holger Knublauch]

Have you tried the following:

1) Copy the .xml file into the TBC workspace
2) Double-click the .xml file to open it with TopBraid

This will translate all XML element types into OWL classes, the 
attributes to RDF properties, and all elements into corresponding RDF 
instances. This approach is called Semantic XML in the documentation, 
and includes the ability to map the instances into an existing ontology.


Holger


On 24/07/2019 16:22, Monika Yadav wrote:

Hey Irene,
Hey Holger,
Actually I want to import xml data to Top Braid.
I want to convert xml to ontology together with its instances.
Steps which i am followings are:
1. converting XML to Excel by simply opening xml file to excel 
2010.e.g My file is test.xml

2. saving excel file as Text(tab delimlited). Now it becomes test.txt
3. Importing test.txt by using top braid:
For this I have made a folder under Top braid.
1. Right Click on that Folder -->> Import-->Top Braid->  Import Tab 
delimited spreadsheet File.

2. browsing test.txt file and changing class name as required.
3. Finish
4. As a result .ttl file get created by taking first column as class 
instances and other column as properties of that class

5. Now I want to import instances to data type properties .
6. In order to copy instances to data type properties we again do 
import -> Import Tab delimited spreadsheet File.

           Now we checked the import to current ontology.
           so, after this m getting error as mentioned earlier and not 
able to add instances of other column.

Suggest me some other way or how to resolve this issue.

or if there is other way to convert xml to ontology with instances .


On Wed, Jul 24, 2019 at 9:38 AM Irene Polikoff > wrote:


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 mailto:mnk.yadav...@gmail.com>> 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
 

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

[Monika Yadav]

Hey Irene,
Hey Holger,
Actually I want to import xml data to Top Braid.
I want to convert xml to ontology together with its instances.
Steps which i am followings are:
1. converting XML to Excel by simply opening xml file to excel 2010.e.g My
file is test.xml
2. saving excel file as Text(tab delimlited). Now it becomes test.txt
3. Importing test.txt by using top braid:
For this I have made a folder under Top braid.
1. Right Click on that Folder -->> Import-->Top Braid->  Import Tab
delimited spreadsheet File.
2. browsing test.txt file and changing class name as required.
3. Finish
4. As a result .ttl file get created by taking first column as class
instances and other column as properties of that class
5. Now I want to import instances to data type properties .
6. In order to copy instances to data type properties we again do import ->
Import Tab delimited spreadsheet File.
   Now we checked the import to current ontology.
   so, after this m getting error as mentioned earlier and not able
to add instances of other column.
Suggest me some other way or how to resolve this issue.

or if there is other way to convert xml to ontology with instances .


On Wed, Jul 24, 2019 at 9:38 AM Irene Polikoff 
wrote:

> 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:
>>>