# \[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:** 6
**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\ **Post date:** [February 6, 2024, 5:18pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/101 "2024-02-06T17:18:49Z")
The field ‘spreadsheet-id’ is empty ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/b/e/be8f34e1ec369ec5ea2afb277f705690bddf3eff.png) You can find this in the URL of your spreadsheet between two slashes (long string of characters) ---
**Author:** ![Tirrazo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tirrazo/32/55444_2.png) [@Tirrazo](https://community.homey.app/u/Tirrazo)\ **Post date:** [February 6, 2024, 5:20pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/102 "2024-02-06T17:20:19Z")
I have tried to insert it there, still get the same message. On the video the logging is working perfectly without the ID (it seems) ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/5/7/5746441ad2370abb17dc2782151290e3f5cdef93.jpeg) Inserted some of my ID as an example, has the full ID in my flow, still get the same message though: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/7/6757ae00c562a71bb775dbdc8cd042429b2e3829.png) ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/7/c78c641683d02a348b02a6e0a2582cf08d1f2809.png) ---
**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\ **Post date:** [February 6, 2024, 5:31pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/103 "2024-02-06T17:31:49Z")
![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/3/8/38c727223a1d44ee04caf015f1952d995d18e5b4.png) This works for me. The SpreadSheet-ID in this example is stored in a variable. P.S. your spreadsheet-id looks a bit short. ---
**Author:** ![Tirrazo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tirrazo/32/55444_2.png) [@Tirrazo](https://community.homey.app/u/Tirrazo)\ **Post date:** [February 6, 2024, 6:40pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/104 "2024-02-06T18:40:03Z")
Here is the full sheet-id and spreadsheet saved as a variable: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/e/6ec866ef4705d151a40841a041cf029fef87fb5f.png) Is it possible by this error to determine whether this is regarding the app, the flowcard or the sheet? Tried to run it without anything. I have to fill in everything except the spreadsheet-id by some reason. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/5/d/5da5f017db25313fb6e683d0350268f5c9524776.png) The app: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/5/d/5dd015e6c1b51d67a6b2e836204038e1a3cd2ac6.png) ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/3/c/3c48839bc3679c4fd401716c79d5f4fba566a263.png) What should I actually use the JSON file for other than writing the credentials in the app and store it on my computer? ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/1/0/1084885d9d1972a2a3c32070491a57d88c80a036.png) ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/9/09479d7d3e3294626a8c7b6dccf0570b58692564.png) The file contains: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/5/855cc9780b420e3e2dc1241977ffa7d947fb9047.png) Finding a lot of info at wiki.bwa.no, but it seems there are some screenshots/examples missing 😮 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/3/d39015e3cb0dac076b6657f583f55a826fbd2a06.png) ---
**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\ **Post date:** [February 6, 2024, 7:16pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/105 "2024-02-06T19:16:23Z")
@bwa can you answer this please? ---
**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 6, 2024, 7:36pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/106 "2024-02-06T19:36:00Z")
Yea, I have had some issues with my server. Working on it. ---
**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 6, 2024, 7:40pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/107 "2024-02-06T19:40:36Z")
See this page, it’s not broken It shows how you app would look like when it’s configured [https://wiki.bwa.no/display/HEL/4.+Configure+the+Easy+Logger+App](https://wiki.bwa.no/display/HEL/4.+Configure+the+Easy+Logger+App) ---
**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 6, 2024, 7:41pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/108 "2024-02-06T19:41:42Z")
Just send a diag after you have called, I would probably see what’s wrong in the diag ---
**Author:** ![Tirrazo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tirrazo/32/55444_2.png) [@Tirrazo](https://community.homey.app/u/Tirrazo)\ **Post date:** [February 6, 2024, 8:57pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/109 "2024-02-06T20:57:23Z")
It seems like my browser didn’t show some of the photos, I saw it now. So every line has to be for themselves with colon, comma, quotation marks and the distance between? The key there is so long that It doesn’t seem to fit in one line. What you mean about call? Like a diagnostic report? ---
**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\ **Post date:** [February 7, 2024, 12:01am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/110 "2024-02-07T00:01:20Z")
> [@Tirrazo](#): > > every line has to be for themselves with No, copy/paste the whole bunch including the curled brackets, that is called the ‘json’, don’t change anything in there. ---
**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 7, 2024, 6:13am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/111 "2024-02-07T06:13:47Z")
> What you mean about call? Like a diagnostic report? Yes, send a diag report Still working on fixing the documentation ---
**Author:** ![Tirrazo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tirrazo/32/55444_2.png) [@Tirrazo](https://community.homey.app/u/Tirrazo)\ **Post date:** [February 7, 2024, 9:07am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/112 "2024-02-07T09:07:45Z")
Can I ask how you open the JSON file to get this? I open it in Excel and when I copy/paste into the logger app, the result looks different than bwa shows. Do you need to have a flow connected to the app somehow to make this work? I am just testing directly with a flowcard. ---
**Author:** ![Tirrazo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tirrazo/32/55444_2.png) [@Tirrazo](https://community.homey.app/u/Tirrazo)\ **Post date:** [February 7, 2024, 9:19am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/113 "2024-02-07T09:19:04Z")
I sent you a diag report now, hope you can see something from it ---
**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 7, 2024, 9:36am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/114 "2024-02-07T09:36:18Z")
[EasyLoggerApp] Credentials file were invalid, could not parse the content SyntaxError: Unexpected token h in JSON at position 0 So it’s the credential json that is wrong ---
**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\ **Post date:** [February 7, 2024, 11:44am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/115 "2024-02-07T11:44:26Z")
> [@Tirrazo](#): > > I open it in Excel Open in a text editor and copy from there, it must start with { and end with } ---
**Author:** ![Tirrazo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tirrazo/32/55444_2.png) [@Tirrazo](https://community.homey.app/u/Tirrazo)\ **Post date:** [February 7, 2024, 1:22pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/116 "2024-02-07T13:22:23Z")
This helped me. The text editor opens this as a code. When I pasted that, it now works 🙂 Thanks all for the help! I think this app can be a great tool for handling a lot of data systematically and maybe make a dashboard like Rune did. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/2/6/26f3a3fef9c3e334e4e872bcd851e1aa78179c00.png) I tested to tag my doorlock when it is “locked” and this seems to work. But I get this little check mark at the end, why is that happening? ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/d/6d9331b55428e95273979f1dd0bce9b98248bf1f.png) I use text, tag, tag ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/1/5/1542d91f18b7ab96d03f7c6773159607ac492c54.png) ---
**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\ **Post date:** [February 7, 2024, 1:45pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/117 "2024-02-07T13:45:00Z")
> [@Tirrazo](#): > > check mark at the end That is your second tag, it shows True or False with this Checkmark, don’t know why. Remark: these card always add a Date/Time column to your data, you can avoid this by adding @NoDate| in front of your data ( I use ; as delimiter, where you use | ): ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/a/6a577ed95bf4854b705aeac6eecc753b441d78c0.png) You can make two flows, one with text ‘OPEN’ an one with text ‘CLOSED’ and use the one, depending on the Boolean (check-mark) ---
**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 7, 2024, 8:18pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/118 "2024-02-07T20:18:46Z")
Just create a variable,and set it to ‘Yes’ or ‘No’, and use it in the logger ---
**Author:** ![Tirrazo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tirrazo/32/55444_2.png) [@Tirrazo](https://community.homey.app/u/Tirrazo)\ **Post date:** [February 11, 2024, 9:58am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/119 "2024-02-11T09:58:25Z")
I can see that Homey hasn’t been able to send any logging to the spreadsheet since yesterday. When I manually test a card, it says there is a network request failure. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/4/b/4bda094a65481799d60efcf23253851d32af5794.png) Since Homey is DHCP and it might get a new IP after restart, is this a problem? Testet to restart the app, then it works again. Don’t really know what was the problem that caused this. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/2/82d81727d2fab40d84440e478560dd12af54bd13.png) ---
**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, 2024, 10:10am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/120 "2024-02-11T10:10:43Z")
you can send a diag and I will look at it [Previous page](https://community.homey.app/t/app-pro-homey-easy-logger/76021.md?page=5) [Next page](https://community.homey.app/t/app-pro-homey-easy-logger/76021.md?page=7)