search

Excel-projects / Excel-Timesheet

:alarm_clock: This Add-In is used to produce a timesheet file with functionality to import your Google Timeline. The standard timesheet has options for start and end dates, day of week and default start, end and break times. The Google timeline options are start and end dates, UTC selection, daylight savings time parameters and title filter for timeline entries. There is also a right click shortcut to open your Google timeline to the date of the row that is currently selected. The only version is currently in VBA/XML ribbon.
MIT License
31 stars 8 forks source link

Windows 10, Excel 2016 Google Timeline download fail #2

Open aduguid opened 6 years ago

aduguid commented 6 years ago 
Set xmlHttp= New MSXML2.XMLHTTP60 ' works on Windows 7, Excel 2016
'Set xmlHttp= CreateObject("Microsoft.XMLHTTP") ' works on Windows 7, Excel 2016
'Set xmlHttp= CreateObject("MSXML2.XMLHTTP")
'Set xmlHttp= CreateObject("MSXML2.XMLHTTP.6.0")
'Set xmlHttp= CreateObject("MSXML2.serverXMLHTTP")
aduguid commented 5 years ago

Do research for possible answer, if not resolved then create a question on stack overflow.

actionjakson commented 5 years ago

Hi Anthony 1) I by accidentally deleted my google maps timeline history. Before the timeline was deleted from Google I downloaded it as a JSON file from google. Is there a way I can import this file back into the google timeline?

2) I would like to out the google timeline info into an excel spreadsheet so I can figure out the hours I was somewhere much like this app does

https://chrome.google.com/webstore/detail/mileage-timeline-spreadsh/kgmdpfoaldphfmbpnlpkelfbbegnaifc?authuser=0

. But since I may not have the timeline anymore is it possible to do form the JSON file?

How much would the above cost if you can provide the services?

Thank you mark

On Wed, Mar 20, 2019 at 8:39 PM Anthony notifications@github.com wrote:

From the spreadsheet or from Google?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/Excel-projects/Excel-Timesheet/issues/2#issuecomment-475079967, or mute the thread https://github.com/notifications/unsubscribe-auth/AufnOwuWkjVWFFuU-vgmfseQf8ryk7HTks5vYtTegaJpZM4WYv2F .

--

Thank you, Mark

aduguid commented 5 years ago

At this time, Google does not have a feature to allow importing into your timeline. However, I may be able to generate the same type of Excel table for your JSON file. I'll download mine and give it a try. https://support.google.com/maps/answer/6258979?vid=0-2167895081-1476304453401&co=GENIE.Platform%3DAndroid&oco=1

aduguid commented 5 years ago

I found another project I can base this off of. https://github.com/omegastripes/VBA-JSON-parser