Dear Fellow OC Users,
I have been experiencing a phenomena with OC after upgrading from 3.1.3 to 3.3 - running this on JDK 1.7 and Postgres 9.3 (correct jdbc library included). On data extraction to different formats such as spss and Excel, a couple of issues arise.
On one event, data is shown as say "36.7 36.7" where the value is supposed to be "36.7". This affects selected sites in the OC database.
On another event, data is totally missing for on both extractions for selected sites. This is making data analysis impossible as the analyst cannot tell if data extracted is complete. From the from end the data is seen and on querying the database using SQL query, I can also get the values, but this seems very tedious and binds one users to DBA duties and db querying.
Has anyone bumped into a similar issue at all? Just wondering. What suggestions do you have for tackling this issue?