Extensions Blog Press Contribute Support FAQ Videos Changelog About Contact English Dark mode
Chrome extensions you can't live without!
Extensions Blog Press Contribute Support FAQ Videos About Contact

Does this tool 'open' or peak at files to see that date+time changed - weird results.

I turned on (enable) Checker Plus for Google Driver again in the past few days. Tried it many months ago but had weird results and didn't want to pursue at the time.


Two weird things:

a) I get some notifications that on files that I've opened but not changed (ie. revisions doesn't show any). As well I don't have the option on to notify me of my own files. Even having checked these off they would pop up again in the notification.

b) I have some google sheets that use a function for calculating km (miles). Ever since using the tool it says I hit a limit of number of times accessed that service (ie. there is a limit of how many you can use per day). My chk+ was defaults to checking every 5 minutes. [eg: Error - Exception: Service invoked too many times for one day: route. (line 8).]



function DrivingMeters(origin, destination) {

 // var lock = LockService.getScriptLock();

 // lock.waitLock(2000);

 Utilities.sleep(1000);

 var directions = Maps.newDirectionFinder()

 .setOrigin(origin)

 .setDestination(destination)

 .getDirections();

 return directions.routes[0].legs[0].distance.value;

}


function DrivingMiles(origin, destination) {

  return DrivingMeters(origin, destination)/1609.344;

}

Comments

  • edited May 22

    a) You probably have different accounts and it's probably different than the one you are browsing in your google drive or you can be access shared folders, this would then give you notifications because it's a different user.


    b) This should be unrelated to my extension - and that code is not related to my extension either.

  • Thanks. I'd really love to use this extension and figure this out.

    Does the tool have issues if the folders are shared in general?

    a) The notifications all say 'me'. Again I have the option off that says: show my own modifications. As well when I look at one of those files there are no revisisions (using the menu option to see or name revisions) - clued me it wasn't really modified IMO. I am not logged into multiple google accounts. I do have multiple Chrome windows open and they have various tabs. These would be in folders that are shared with my spouse.

    b) I know the code is not your extension BUT I was wondering if the API or whatever method you used triggers that code to run ... ie. as if I manually opened that file then it would run.


  • So I examined that code and did not determine anything related to files, just map api etc. therefore I don't think it's relevant, however, now that you mention you are using other code/scripts/software perhaps that is what is causing the "modifications" of these files?

  • Thanks for the reply!


    Re: Does the tool have issues if the folders are shared in general?

    Is there an issue if there are multiple Chrome windows open?

    Again, it says "me" is doing a "last modified" and I have that option off. Why would "me" get notifications then?


    Re: however, now that you mention you are using other code/scripts/software perhaps that is what is causing the "modifications" of these files?

    I think there is some confusion. I have that code mentioned in the Google sheets - Extensions - Apps Script area. From cells in the google sheet it references it (ie. drivingmiles(cell-1, cell-2).


    Is the API or method you look for "modifications" triggering files to "appear" to be modified? (ie. by "me"?




  • ok let's go back to some basic testing, does the issue happen when you open google documents or just google spreadsheets?

  • Re: ok let's go back to some basic testing, does the issue happen when you open google documents or just google spreadsheets?


    Sorry that we got off track. Simpler than that ... in that if I don't open document I get notifications that they were "last modified" within the past hour. They may have been open early this day. ie. several hours ago.


    To me they are just bogus annoying notifications that do not represent when those documents were "last modified". Heck the several hours ago that I did touch them they likely showed up with Checker Plus for Google Drive and I would have hit the check marks to get ride of the notifications. Then they show up again and again with a *recent "last modified".


    Hope that helps.

  • Another possibility is that backup software that might be triggering things, but regardless you could just disable the notification in the extension.

  • Re: Another possibility is that backup software that might be triggering things

    I'm confused. What backup software are you talking about?


    Re: but regardless you could just disable the notification in the extension.

    I'm confused as isn't that the point of the check to notify you when files actually change and are modified?


    I was off doing other things unrelated to Google drive documents.


    1) See below where Checker Plus for Google Drive says the OR road trip was

    ** Last Modified ** at 8:44 PM tonight.


    2) The actually Google Drive recent list says the same OR road trip was

    last changed/modified/updated at 10:08 AM this morning.


    KEY QUESTION:

    What is the extensions looking at to determine a modified date and TIME?!?


    Thanks!



  • I'm currently not getting any other reports of this, this is why I'm assuming it's a local interference issue. The extension is simply pulling the modifiedTime field from the file: https://developers.google.com/drive/api/v3/reference/files

  • Thank you for your patience with me. Thanks! Thank you for pointing me to that Google API metadata info (ala. like right-clicking on a column header in the Win 10 File Explorer lets you check box what addl cols you want to see). I've always been very surprised that Google doesn't natively expose / show more of that to end-users. Even when you click on the (i) details icon for a file or folder the resulting details are very limited.


    Not sure if there is an opportunity for someone to have a chrome extension or something else to show all the meta data for a given file (or set of them) and export it or insert it in a Google sheet??? I've searched without luck for something easy to user for end-users.


    Do you know of any that would let me see all the metadata for one of the files I see giving notifications??? I did find a related GitHub tool "Create a SQLite database containing metadata from Google Drive"

    https://github.com/simonw/google-drive-to-sqlite


    I understand your point that if other users are not reporting this/these oddities that it must be something unique. I'm trying to figure it out as I would really like to use your extension and just be notified when files are changed instead of notifications that appear 'bogus' to me (realizing you are getting Googles metadata so to your program it looks like a modification/change).


    I clicked on the (i) details icon for that file and it shows a 'Modified' time of "9:00 PM" which doesn't match either time/date in my previous images (ie. Checker Plus shows "8:44:28 PM" or Google listing 10:08 AM opened by me)



  • FYI, I have no idea if something changed on your end or my end but it seems to be working accurately now. Thanks for your interaction.

  • I appreciated your help and made a donation / contributions today.

This website uses cookies to ensure you get the best experience on our website. More info
Got it!