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 <ir...@topquadrant.com> 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 <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 <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 >> <https://groups.google.com/d/msgid/topbraid-users/526e5115-37d4-4adc-8453-d650cb84ae15%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> >> -- >> 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 >> <https://groups.google.com/d/msgid/topbraid-users/12136f12-3efc-8f43-b7fc-c5e0231cf744%40topquadrant.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > Regards: > Monika Yadav > Assistant Professor > M.Tech (Computer Science) > > > > -- > 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/CAAauOwVq8cHBO9Ff%3DQaermQZLd0a_Pf2J0t76NE63zz3gcYz6g%40mail.gmail.com > <https://groups.google.com/d/msgid/topbraid-users/CAAauOwVq8cHBO9Ff%3DQaermQZLd0a_Pf2J0t76NE63zz3gcYz6g%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > <Drug10000.txt> > > > -- > 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/11B86FDE-F572-47EB-B03F-67AE2FFE6876%40topquadrant.com > <https://groups.google.com/d/msgid/topbraid-users/11B86FDE-F572-47EB-B03F-67AE2FFE6876%40topquadrant.com?utm_medium=email&utm_source=footer> > . > -- Regards: Monika Yadav Assistant Professor M.Tech (Computer Science) -- 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/CAAauOwXOyqnXuwt98Nu0FT%2B1Rq0ALuBmQPAM7nmLzb7H30EG7Q%40mail.gmail.com.