search

protegeproject / cellfie-plugin

Protégé plugin for creating OWL ontologies from spreadsheets
104 stars 27 forks source link

dataTime datatype converted to string in importing excel file to protege using Celfie Plugin, #61

Open Rawrversio opened 8 years ago

Rawrversio commented 8 years ago

I am working on Protege 5.0 with the plugin Celfie. I have imported an excel sheet which has a column Start_Time (datatype dateTime). When i import the excel sheet into protege, it converts the rows from dateTime format to a string or some other data type. I want to use that column for a data property having the data type DateTime. 3/5/2008 9:29 AM is converted to 39503.01..... I need suggestions on how to convert it back to Datetime format in Protege .

johardi commented 8 years ago

Hi Rawrversio, you can follow the steps from the discussion in the Protege-user mailing list here: http://protege-project.136.n4.nabble.com/Celfie-plugin-DateTime-format-issue-after-import-td4665423.html

Let me know if that works well for you too.

csnyulas commented 8 years ago

Duplicate of #59