Content Library Steering Committee

 View Only
  • 1.  some Google Drive Activity API progress

    Posted 04-04-2024 10:34

    Long story short, I finally have working code that will tap into Google Drive and pull activities (who did something with a file/folder) but it doesn't seem to include Shared Drives. The documentation suggests that it should, so does my steve.iwanowski@90minds.com have rights to our 90 MINDS RESOURCE LIBRARY?  

    I still need to refine the filters, make the output human-readable, limit and automate the authorization process, and research ways of generating a post inside Higher Logic but after two weeks of hitting really dumb brick walls, we're back in the game.



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------


  • 2.  RE: some Google Drive Activity API progress

    Posted 07-31-2024 17:27
    Edited by Steve Iwanowski 07-31-2024 17:47

    I've got this mostly working, but I think the next piece is to show the full folder/file paths. I wrapped the filenames in braces [] since they were so long and I was having trouble reading them.  Anyone have any suggestions on what they'd like to see (more or less detail, etc)?  Here's what currently spits out when you run the script:

    Since Monday, July 1, 2024 1:00:00 AM...
    The following files were created:
            [testFile.txt]
            [Sage100Payroll2.24.2.exe]
            [Sage1002023Update4.exe]
            [Sage1002024Update1.exe]
            [StarShip_Sage100Patch.zip]
            [A_Guide_to_the_Sage_100_ERP_Native_SData_Provider (1).pdf]

    The following files were edited:
            [HRMS update installs Crystal runtime 13.34 (Sage 100 is 13.30) and breaks Sage 100 Crystal with error 200.  The usual Sage 100 KB fix does not help]
            [Read Me First: About 90 Minds Content Library]
            [Sage 100 BOI (LEGACY BOI): Unable to establish a connection to MAS | Error 400: Error doing work: Invalid MAS HOME FOLDER | List of companies blank in source company setup screen]
            [Upgrade Sage 100 Premium to Same SQL Instance]

    The following files were renamed:
            File [A_Guide_to_the_Sage_100_ERP_Native_SData_Provider (1).pdf] was renamed to [A_Guide_to_the_Sage_100_ERP_Native_SData_Provider.pdf]

    The following files were moved:
            File [StarShip_Sage100Patch.zip] was moved to [VTechnologies] from [General Inbox].

    The following files were deleted:
            testFile.txt



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 3.  RE: some Google Drive Activity API progress

    Posted 07-31-2024 19:50

    I think Created and Edited are the two that would add the most value. I'm not sure if moved or deleted is as helpful since if you move large groups of files the list could be difficult to review.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------



  • 4.  RE: some Google Drive Activity API progress

    Posted 07-31-2024 21:50

    That's fair, and I'll probably change the terminology from created/edited to added/updated.



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 5.  RE: some Google Drive Activity API progress

    Posted 08-01-2024 09:16

    looks good



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 6.  RE: some Google Drive Activity API progress

    Posted 08-01-2024 09:19

    Actually what about also including the folder path for where the file resides?  For example, where do i go exactly to get StarShip_Sage100Patch.zip?



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 7.  RE: some Google Drive Activity API progress

    Posted 08-01-2024 09:25

    Adding Folder Paths is next, and then I might try to group by individual Files instead of by Actions to see how that looks. 



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 8.  RE: some Google Drive Activity API progress

    Posted 08-08-2024 14:33

    I've added Folder Paths and am experimenting with date/time stamps (see the Updated section in the screenshot below).  Do you think we'd want to see each time a file is updated, or just the last time?

    I almost want to encourage shorter file names, too. :)



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 9.  RE: some Google Drive Activity API progress

    Posted 08-08-2024 14:34

    And if anyone has strong opinions on how this is displayed, just let me know.  I'm more of a 'make it work' type vs 'make it pretty'.



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 10.  RE: some Google Drive Activity API progress

    Posted 08-09-2024 08:25

    I'd say just the last time a file was updated, not every time.



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------