Nightscout on Google Cloud

[DaNitroo]

Hello.
First I would like to introduce myself and thank you. My name is Daniel and i`m from Germany and my son has had type 1 diabetes for 6 weeks. You have really created something great with your community! It is incredible how you help people with this and thanks to you great inventors and programmers you have really made our lives much safer! Thanks a lot for this!

I followed this great guide https://navid200.github.io/xDrip/docs/Nightscout/GoogleCloud.html. Everything (freedns, google cloud, VM, Nightscout install, Nightscout setting up) works great and my nightscout is now running in the google cloud. many many thanks for that!!
2 questions stayed with me despite the great instructions (sorry, but this is the first time in my life that I have to do with computers. I usually repair cars):

My first question: I backed up the MongoDB via point 6-2 and then downloaded it to my PC via the terminal. That worked fine. But I would be interested to know where I actually download this data or where is this data stored. In the google cloud? In the nightscout variable "database_size" i still have to specify the size of the database and i don't know where i can find it?

My second question: I have just created a MongoDB but I have not yet entered it in the variables at nightscout and now I see that my nightscout has been running for 2 days without MongoDB and the data seems to be saving all. Do I actually need the MongoDB?

[Navid200]

Hi,

When you follow the guide to set up Nightscout on Google Cloud, your database is set up for you through the installation process.
You don't need to sign up for MongoDB.

If you use Nightscout on Google Cloud for a while, and you need to delete it, you should backup the database so that you don't lose your data because the database is on the virtual machine.
So, that's the reason for this page: https://navid200.github.io/xDrip/docs/Nightscout/DatabaseBackup.html

If you have made such a backup and now have created a new machine and would like to restore such a backup into it, you use this page:
https://navid200.github.io/xDrip/docs/Nightscout/DatabaseRestore.html

If you have been using Nightscout on a different platform, that is still functional, and now have set up Nightscout on Google Cloud, and you want to transfer your database content to this setup, you can use this:
https://navid200.github.io/xDrip/docs/Nightscout/NS_Transfer.html

If you were using Heroku and now have set up Nightscout on Google Cloud and you want to transfer your database content to this, you may be able to use this: https://navid200.github.io/xDrip/docs/Nightscout/HerokuGone.html

Please let me know if I misunderstood your questions.

[Navid200]

I am going to export my xDrip data into a csv file and find a way to import it into Nightscout.
Then, I will let you know how.

[Navid200]

@DaNitroo Open a terminal and exit the menu.
In Linux, type mongo shell
Later on after you are done, you can type exit to exit mongo shell.

Now, in mongo shell, type show dbs
You will see this:

You can see that we have called Nightscout just Nightscout.

now, type use Nightsocut.
Now, type show collections. And that shows you this.

So, you should be able to access MongoDB on your machine.

[DaNitroo]

I can open a terminal and do exact what you tell me. When I enter "use nightscout" it shows "switched to db nightscout". What had I to do next to output an csv file?

It would be so great if I you can show me, how I can download a csv. Then I would change my Dexcom csv to the same formatting and upload it back to Nightscout. Then I would have all my data in there forever :-)

[DaNitroo]

I just saw that I had a translation error. but when I type show collections I don't see any. do they have to be created somewhere first?

[Navid200]

No, they are created by Nightscout.

The only difference between Nightscout on Google Cloud and Heroku or any other platform is that we have changed the AUTH_DEFAULT_ROLES variable from readable to denied.
You can change that back to readable if you want. Then, your cost for the month may become $1. You can change it back after you are done with your transfer.

It is a misunderstanding to think that there is something special about Nightscout on Google Cloud that makes it different other than that single variable, which you can change if you like.
I have gone into detail about that here: https://navid200.github.io/xDrip/docs/Nightscout/Auth_Default_Roles.html

Transferring data from Clarity to Nightscout is a question for the Nightscout team. We are not the Nightscout team. We are the xDrip team.
I personally have no experience with Clarity and cannot help you. That's why I tagged others.
But, the best place to ask this question would be in a Nightscout forum. This is one example:
https://www.facebook.com/groups/cgminthecloud
And I strongly advise against focusing on Nightscout on Google Cloud because many can easily get confused and think that only we may know how to do it.

[DaNitroo]

ok, i understand that
Can you tell me where I can find the MongoDB URI in my Google Cloud VM?
Then I found the solution to my problems

[DaNitroo]

felix has diabetes since 14.11.2022. Since that day we have the Dexcom G7 and all data in Dexcom Clarity. I have been using XDrip & Watchdrip & nightscout since 12/15/22 and from then on I have all the data thanks to your instructions on google.

If I can't import for the first few weeks, then I just don't do it.

anyway thanks a lot for your help!!!

[Navid200]

If you have the data from Clarity to Railway, I told you how you can get that data into your Nightscout on Google Cloud Nightscout.
Doing that will just bring that data in without disturbing the existing data that you say is from 12/15/22.

I don't mean to drag this on. I just am not sure we are communicating correctly with each other. I don't understand what the problem is.
But, if you are happy, that's all I care about.

There will be other people who will find this thread. If anyone else needs to transfer data from Clarity to Nightscout on Google Cloud, the option is there.

[DaNitroo]

The problem is that I can't get my Clarity.csv data to railway.

I can access the database and generally also import and export csv files. But unfortunately the Clarity.csv and the csv data that Nightscout saves are so different that the Clarity.csv cannot simply be inserted as I had imagined.

[Navid200]

OK I had misunderstood. I thought you succeeded in getting the data to Railway. Now I understand.
Thanks for clarifying.

[DaNitroo]

That will have been my fault. I always enter the text into the google translator and sometimes it doesn't come out what I wanted to say :-)

Thanks again anyway

[DaNitroo]

unfortunately they are totally different and have completely different definitions and a different structure

Dexcom:

NS:

[DaNitroo]

Now i still have a bit of hope to find a solution for my problem. But I don't know if I should ask this in the discussion here, or should I open a new discussion for it?

I found out that the data I'm missing in my nightscout in the Coogle Cloud is all in Xdrip on my son's phone. I was able to make a backup there and import it into xdrip and now have all the data since my son has in my xdrip.

Now the question is, how do I get all this CGm data to nightscout? Nightscout has only shown me the data since December 15th. but in Xdrip I see that we already had data 3 weeks before. I have already tried the backfill function of Xdrip. I get the message that the export was successful, but I still can't see the data in Nightscout.

I would be very happy about an idea.

[Navid200]

I don't understand why you want to upload to Nightscout from two different phones.
Why can you not just send a back-fill request from your son's xDrip?

[DaNitroo]

I just wanted to grab my phone so his could be left next to him while he slept.

Well I got it and tried what you said.

It really seems to work and the system status shows me that there are still 30230 files to be exported to Nightscout :-)

I'm curious, it should be ready in a few minutes :-)

[DaNitroo]

I can hardly believe it but it worked! :-)

Xdrip used this method to import all the data from my son's cell phone to Nightscout and then I activated the new Google Cloud backup in xDrip on both cell phones. Now the data is hopefully safe forever :-)

That actually makes an additional Nightscout backup superfluous, or am I missing something?

Thank you again!!!

[Navid200]

I'm glad you are happy.

I don't follow. How can I use your method to automatically keep my repository protected against accidental deletion of the virtual machine?
My data goes back over 4 years. I don't have all of that in my current phone. But, I have data in Nightscout from different phones I have carried over the past 4 years.

[DaNitroo]

Luckily I had all the data in xDrip in one cell phone in my son's cell phone. With the function in xDrip, with which you can now syncronize xDrip with Google Drive, I can hopefully never lose data again. To be on the safe side, I save them as you showed me by downloading the Nightscout backup file - better safe than sorry :-)