Time format is not exported correctly

  • Asked
  • Active
  • Viewed 1806 times
0

Hi guys,

I have encountered an issue with the time format when I export the data from openforis desktop to .csv or .xslx. Whenever the time recorded in openforis is e.g. 14:05 or 09:08, it skipps the zeros and exports it as 14:5, respectively 9:8 - which is something that R cannot deal with very well. for any times without zeros, this does not happen. The attribute format is set as "time" in the survey designer. Does anybody know how to avoid this issue?

version openforis desktop: 4.0.20

Cheers, Michael

asked

mizehnder 21●3 accept rate: 0%

1

Accepted answer

Dear Michael,
If you are talking about exporting the data with the option "Include composite attributes merged column" selected, we will fix this problem very soon with the next release of Collect.
Many thanks,
Open Foris Team

permanent link

answered

Stefano (OF) ♦♦ 5.7k●1●1●9 accept rate: 19%

1

Accepted answer

Hi!

This is indeed what I am talking about. Glad to hear that you are already working on it!

cheers, Michael

permanent link

answered

mizehnder 21●3 accept rate: 0%

Your answer

Insert an image

Say what the image shows, for people who can't see it.
At least 50 characters

Powered by the Open Foris edition of OSQA Content licensed under CC BY-SA 3.0

This Q&A software is free and open source (GPL). Any organisation can run it for its own community: get the code and instructions at github.com/openforis/osqa.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.