I am using Protege and I want to import data from an Excel-sheet (currently using Celfie plugin for this purpose). I’ve three classes (i.e. Consumer, Energy, Date) and I want to populate them from an Excel-sheet. As far it is concerned with creating Individuals of these classes, I’ve done by using the following rules.
For Consumer Class:
Individual: @H* Types: Consumer Facts: SMID @H* (SMID is Smart Meter ID and it is a DataProperty) (Starting Column: H, Ending Column: H, Starting Row: 2, Ending Row: 6)
For Energy Class:
Individual: @** Types: Energy Facts: EnergyInWatt @** (EnergyInWatt is DataProperty) (Starting Column: A, Ending Column: G, Starting Row: 2, Ending Column: 6)
For Date Class:
Individual: @** Types: date Facts: ConsumedOn @** (ConsumedOn is DataProperty) (Starting Column: A, Ending Column: G, Starting Row: 1, Ending Row: 1)
Now, I want to create relationships among them as I’ve created ObjectProperties such as
Consumer consumes Energy Energy isConsumedOn Date
Where, consumes and isConsumedOn are ObjectProperties.
Note: The Excel-sheet is attached here.