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 <[email protected] <mailto:[email protected]>> 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 <[email protected]
    <mailto:[email protected]>> 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
    <[email protected] <mailto:[email protected]>> 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
        [email protected]
        <mailto:[email protected]> 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
        [email protected]
        <mailto:[email protected]>.
        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
        [email protected]
        <mailto:[email protected]>.
        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 [email protected]
    <mailto:[email protected]>.
    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 [email protected]
    <mailto:[email protected]>.
    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 [email protected] <mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/CAAauOwXOyqnXuwt98Nu0FT%2B1Rq0ALuBmQPAM7nmLzb7H30EG7Q%40mail.gmail.com <https://groups.google.com/d/msgid/topbraid-users/CAAauOwXOyqnXuwt98Nu0FT%2B1Rq0ALuBmQPAM7nmLzb7H30EG7Q%40mail.gmail.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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/96e2c7a1-a9dd-69cb-0e3c-ae2bdf72ad5c%40topquadrant.com.

Reply via email to