# \[App\]\[Pro\] Homey Easy Logger **URL:** \ **Category:** Apps\ **Tags:** tools\ **Created:** [February 4, 2023, 9:22pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021 "2023-02-04T21:22:25Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 4, 2023, 9:22pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/1 "2023-02-04T21:22:26Z")
The community thread for [Easy Logger App for Homey | Homey](https://homey.app/a/no.bwa.easy-logger/) Homepage with instructions and a lot of tips : [Homey Easy Logger Home - Homey Easy Logger - Confluence](https://wiki.bwa.no/x/HwD4D) NEW: v1.7.0 is released. It uses luxon as time and date library, and should handle summer time conversions automatically. But it has a updated timeformat. read more in the documentation : [5. Configure timestamp format - Homey Easy Logger - Confluence](https://wiki.bwa.no/x/AwB9DQ) NEW: v1.8.0 is released into test, with fire and forget support : [Easy Logger | Homey](https://homey.app/no-no/app/no.bwa.easy-logger/Easy-Logger/test/). NEW: v1.8.2 is released. Option to adjust intervalCap setting. read more in the documentation : [11. Fire and forget - Homey Easy Logger - Confluence](https://wiki.bwa.no/x/U4CwDQ) Other features to be aware of : - **v1.9.0:** new Feature: Queue Monitoring. Read about it in [13. Queue Monitoring](https://wiki.bwa.no/display/HEL/13.+Queue+Monitoring) - **v1.9.4:** new Feature: [14. Option to retry on HTTP 404](https://wiki.bwa.no/display/HEL/14.+Option+to+retry+on+HTTP+404) - **v1.9.5:** new Feature: [15. @Processed](https://wiki.bwa.no/display/HEL/15.+@Processed) read more in the documentation : [11. Fire and forget - Homey Easy Logger - Confluence](https://wiki.bwa.no/x/U4CwDQ) ---
**Author:** ![Addie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/addie/32/44878_2.png) [@Addie](https://community.homey.app/u/Addie)\ **Post date:** [February 9, 2023, 12:37pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/2 "2023-02-09T12:37:00Z")
Hi, after creating the sheet etc which seems ( or not) went well i am not sure how to find the error in a flow. How do I register a flowcard? the error is: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/4/a4aea0eb4ccdc99004e1be587868bf9fd4402c9c.png) I created an error report would you please direct me in the right direction to solve this. 89bc62fc-7239-463b-a9bf-9358ece88ca3 Regards, Ad ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 9, 2023, 12:40pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/3 "2023-02-09T12:40:11Z")
You need to check the contents in the json file [err] 2023-02-09 12:21:31 [EasyLoggerApp] Credentials file were invalid, could not parse the content SyntaxError: Unexpected token h in JSON at position 1908 [https://wiki.bwa.no/display/HEL/4.+Configure+the+Easy+Logger+App](https://wiki.bwa.no/display/HEL/4.+Configure+the+Easy+Logger+App) Use the Developer Tool is you can, to paste data in the settings dialog [https://tools.developer.homey.app/tools/app-settings](https://tools.developer.homey.app/tools/app-settings) ---
**Author:** ![Addie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/addie/32/44878_2.png) [@Addie](https://community.homey.app/u/Addie)\ **Post date:** [February 9, 2023, 1:50pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/4 "2023-02-09T13:50:25Z")
BWA, Thanks, copy and paste was wrong as I did it on the phone. Up and running thanks!! Now try to find the right way of using. ---
**Author:** ![Addie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/addie/32/44878_2.png) [@Addie](https://community.homey.app/u/Addie)\ **Post date:** [February 9, 2023, 3:49pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/5 "2023-02-09T15:49:44Z")
@bwa In the date/time field the are the letters “kl.” what does that mean? ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 9, 2023, 4:10pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/6 "2023-02-09T16:10:27Z")
It’s a norwegian format for the hour. I will provide a better format soon ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 9, 2023, 4:37pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/7 "2023-02-09T16:37:33Z")
@Addie Can you try the v1.5.0 currently only available as a test version [Easy Logger | Homey](https://homey.app/no-no/app/no.bwa.easy-logger/Easy-Logger/test/) It should use a more generic dateformat ---
**Author:** ![Addie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/addie/32/44878_2.png) [@Addie](https://community.homey.app/u/Addie)\ **Post date:** [February 9, 2023, 4:50pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/8 "2023-02-09T16:50:41Z")
the kl is gone. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/1/f/1fc01f473cbfc470a68eceaaeea4b5afb5218a75.png) The version is 1.5 ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 9, 2023, 5:28pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/9 "2023-02-09T17:28:17Z")
@Addie Can you put your own timestamp format to that cell/column to verify this is a valid timestamp. Maybe do a duration calculation to see if it works ---
**Author:** ![Addie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/addie/32/44878_2.png) [@Addie](https://community.homey.app/u/Addie)\ **Post date:** [February 9, 2023, 5:46pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/10 "2023-02-09T17:46:18Z")
As I am not very good at google sheets but: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/b/e/be0054ea3e894cff25951877e2f3d169a2540c3c.png) When I go to “format” it sugest to use the “/” and the “:” ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/e/a/ea589524a4e8bdfd86ed658f67d863abfd9d112e.png) This might me depending on the language or area settings as well. ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 9, 2023, 7:29pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/11 "2023-02-09T19:29:35Z")
@Addie Try this formula **=YEAR(P10)** where P10 is a cell with date created by EasyLogger. If the year component is correct, the date is parsed the way it should be. ---
**Author:** ![Addie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/addie/32/44878_2.png) [@Addie](https://community.homey.app/u/Addie)\ **Post date:** [February 10, 2023, 7:24am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/12 "2023-02-10T07:24:27Z")
@bwa ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/4/e/4edff6c3443e88f9fb4aa8af79d83ad4867f923f.png) The formule is: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/1/b/1b16e41094f8bf815ccd69fc016cb8630b76095a.png) The error is that A67 is e text field and not a number. Would it be possible to change the seperator to the “/” and the “:” or to have this as a variable in the settings menu? ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 10, 2023, 7:39am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/13 "2023-02-10T07:39:58Z")
@Addie I guess it migth be because I’m not putting zeros in front. Wait for the v1.5.1 … ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 10, 2023, 9:04pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/14 "2023-02-10T21:04:09Z")
@Addie You can try v1.5.1 from test and see if it solves your timestamp > **[Easy Logger](https://homey.app/no-no/app/no.bwa.easy-logger/Easy-Logger/test/)** > > Logging and Data Collection Done Easy with Google API's ---
**Author:** ![Addie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/addie/32/44878_2.png) [@Addie](https://community.homey.app/u/Addie)\ **Post date:** [February 11, 2023, 6:49am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/15 "2023-02-11T06:49:15Z")
@bwa The zero’s are there but this did not solve the issue. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/f/9/f9dbbf860cdf7606d29432f3510675d2c76f9e07.png) My assumption is that it is the separator in date and time. In your samples on the website: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/4/6453a1c9fa63c3fdbfe14f2ff7eef656d6663288.png) The date/time field are on the right side of the cell, mine are on the left side. When I format to date/time with the other separator in mine sheet it moves to the right as well. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/4/04911dc407f9bc0aa530a6c6fc48f029531d2d3f.png) When I change the sheet ( file \>\> settings to “Norway Norwegian Nynorsk”) it solve the problem and even added the KL to it. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/4/3/43ffaa506b66c9cc19081b0ecdcb95f4d8d99ddb.png) So it appears that depending on the (language) setting in the sheet you need to change separator. Hope this helps. ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 11, 2023, 3:03pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/16 "2023-02-11T15:03:07Z")
@Addie Thanks for the input. I will povide a custom timestampformatter in v1.6.0 so U can set the matching format, typical dd/MM/YYYY hh:MM:ss ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 13, 2023, 7:50pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/17 "2023-02-13T19:50:14Z")
@Addie You can try v1.6.0 and see if it this fits > **[Easy Logger](https://homey.app/no-no/app/no.bwa.easy-logger/Easy-Logger/test/)** > > Logging and Data Collection Done Easy with Google API's [https://wiki.bwa.no/display/HEL/5.+Configure+timestamp+format](https://wiki.bwa.no/display/HEL/5.+Configure+timestamp+format) ---
**Author:** ![Addie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/addie/32/44878_2.png) [@Addie](https://community.homey.app/u/Addie)\ **Post date:** [February 13, 2023, 8:40pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/18 "2023-02-13T20:40:30Z")
Yep, it’s working fine: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/e/ae9a77185f4c24155d5a8119889e2a9099ac32a1.png) this is the Dutch format. DD-MM-YYYY For the American you need to change the MM/DD/YYYY ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/9/6989216d829ca4ef28de3a8a59281a69610c78e9.png) Both seem to work fine! YEAR(A404) gives 2023 where A404 is the date filed in the sample 👍 Thanks ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 13, 2023, 9:11pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/19 "2023-02-13T21:11:36Z")
Good to hear. Moving it to prod in a day or two if nothing else issues occurs ---
**Author:** ![DirkG](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/dirkg/32/118897_2.png) [@DirkG](https://community.homey.app/u/DirkG)\ **Post date:** [February 23, 2023, 12:12pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/20 "2023-02-23T12:12:54Z")
Is it possible to add “at row-nbr” to the action card “Append multicell items”? I would like to be able to fill such a table with values. With the beginning of a new month, I would then select a new column and simply fill in the values one below the other: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/f/0/f06e8b0178d97d6a0a4059fa8d515770a2e79d9f.png) [Next page](https://community.homey.app/t/app-pro-homey-easy-logger/76021.md?page=2)