Wikipedia:Reference desk/Archives/Computing/2018 April 2

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.

April 2

Translator

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)

@119.30.35.242: but there IS a "Google Translate" app available and it even works off-line; I think if you go here in Android you'll see a download link. Or search for "Google Translate" in the Play Store. I hope I have not misunderstood your needs. Hayttom (talk) 10:38, 2 April 2018 (UTC)

To expand Hayttom's answer, once you download Google Translate, it has the options to download dictionaries. If you download the dictionary for say, both Spanish and German, then you can translated between Spanish and German (and vice-versa) off-line. Both the app and the dictionaries can be downloaded over WiFi, if that's cheaper for you. LongHairedFop (talk) 10:33, 7 April 2018 (UTC)

Do you mean you wand a program for MS-Windows, which is like Google Translate, with an off-line dictionary? LongHairedFop (talk) 18:16, 8 April 2018 (UTC)

LongHairedFop: Yes please. Do you guys know anything good and reliable? 37.111.233.212 (talk) 14:51, 9 April 2018 (UTC)

Parse a Google Drive directory page into a Google Sheet

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)

If you're worried about trusting an add-on that you can't see the internals of, you could do similar yourself in Google Apps Script, or find an example online (that you could look at the code for to satisfy yourself it wasn't going to cause any harm) and modify that. For a minimal example, see below. davidprior ^t/_c 23:41, 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()]
   }
 }

Thanks, @Davidprior: clearly you could, but I don't think I could. Hayttom (talk) 17:29, 3 April 2018 (UTC)

Engineers tuning an OS for a specific laptop

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)

Mysterious key on Microsoft All-In-One Media Keyboard

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)

Mysterious key from my Microsoft All-In-One Media Keyboard

Thanks so much for all your help!

L33th4x0r (talk) 19:56, 2 April 2018 (UTC)

It means share media. Source: Microsoft --Hofhof (talk) 20:59, 2 April 2018 (UTC)

Thanks Hofhof for all your help! L33th4x0r (talk) 13:48, 4 April 2018 (UTC)

Resolved