Hi Joel, Thanks for the spreadsheet. I am still having trouble with this data source. Actually, I think its making me a bit crazy. It seems like its working, but it still doesn't do anything. Even with the *.xlsx that you provided. I have tried quite a few tests to narrow down the issue. With the csv version of the datasource, using the example csv file in the template directory every thing works, the datapoints are even created if they don't exist. The file is renamed with the Imported_ prefix. As expected. I even tried to purposely use an invalid date format in the csv. This causes errors in the logging console.
"12/10/2014 7:09" is too short at org.joda.time.format.DateTimeFormatter.parseDateTime(DateTimeFormatter.java:873) at MultiColumnCsvImporter.importRow(MultiColumnCsvImporter.java:33)
Great, I figured this could help me diagnose problems within the excel version. However there's nothing in the logging console, even if I put garbage in the *.xlsx. Just that the datasource started. So at least I know the datasource is running. It stops, initializes and restarts if I make changes. But outside of that its not doing anything and I don't know where else to dig.
I even tried to manually create some of the datapoints from your spreadsheet in case there was a problem creating them automatically. They still remain with no data.
I deleted all the 'Data File' datasources, restarted the instance, Re-created only the excel data file source. Same behavior each time. It just basically doesn't do anything. Each time I use the test button to determine the file is found.
I am running mango core 2.5.0 and I Am running version 1.0.8 of the datafile module.
Is there somewhere else I can dig to diagnose this issue? Is there anything in 2.5.2 that might fix this issue? Or am I just crazy?
Thanks for your support