Computing desk | ||
---|---|---|
< April 1 | << Mar | April | May >> | April 3 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
I'm unable to find something similar to "Google Translate" translator available for android phones as an app, an off-line dictionary for PC. Could you help me please. 119.30.35.242 (talk) 09:17, 2 April 2018 (UTC)
I am trying to automatically parse a Google Drive directory page into a Google Sheet. (I don't want to include the actual URL here, but I hope readers can understand that it is a familiar type of page containing columns of Google Drive file names, Owner names, 'Last Modified', and File size (which always seems to show '-').)
I thought IMPORTHTML would work, but the data does not seem to be a real HTML table or list.
IMPORTDATA doesn't work as my URL is not a table. Similarly IMPORTRANGE would need my URL to be a Google Sheet.
Can what I need to do be done? Hayttom (talk) 10:15, 2 April 2018 (UTC)
UPDATE
A friend showed me the 'Extract Drive Links' Google Sheets ad-on. It's very un-endorsed by Google, and you have to agree that you're risking your life / data before you can use it, but it does what I need.
I'll leave this here for a day or so, then mark my question 'resolved' if there are no better contributions. Hayttom (talk) 14:56, 2 April 2018 (UTC)
function folderContentsToGsheets(folderId) { //setup variables var folder=DriveApp.getFolderById(folderId) var folderList='File/Folder','Name','Owner','Last Modified','File Size' var myEmail=Session.getActiveUser().getEmail() //step through each subfolder var subfolders=folder.getFolders() while (subfolders.hasNext()) { folderList.push(fileOrFolderToRecord("folder",subfolders.next())) } //step through each file var files=folder.getFiles() while(files.hasNext()) { folderList.push(fileOrFolderToRecord("file",files.next())) } //copy to a new spreadsheet var title="Contents of folder "+folderId var spreadsheet=SpreadsheetApp.create(title) spreadsheet.getSheets()[0].getRange(1, 1,folderList.length,folderList[0].length).setValues(folderList) //sent myself a link to the spreadsheet GmailApp.sendEmail(myEmail,title,spreadsheet.getUrl()) //function used to return the 4 key details shown in the web view of drive, plus an additional // one (passed straight from the params) for whether it's a file or folder) function fileOrFolderToRecord(fileOrFolder,object) { var owner=object.getOwner() if (owner.getEmail()==myEmail) { var ownerName="me" } else { var ownerName = owner.getName( } return [fileOrFolder, object.getName(), ownerName, object.getLastUpdated(), object.getSize()] } }
Besides the obvious mention of Macs, does any company tune an OS to a specific hardware? Or is an autonomous setting and configuration program all you can get from an OS installation? Does this make any difference in terms of stability, speed and so on? Hofhof (talk) 19:16, 2 April 2018 (UTC)
Dear Wikipedians:
Shown here is a mysterious key from my Microsoft All-In-One Media Keyboard. I don't recognize the logogram other than it being similar to Ubuntu's logo (but not quite Ubuntu's logo). I am wondering what this key does. (Of course I'm aware what the F6 key does, my question is what the function represented by the logogram does)
Thanks so much for all your help!
L33th4x0r (talk) 19:56, 2 April 2018 (UTC)