Wikipedia:Reference desk/Archives/Computing/2018 April 2
| 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. |
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)

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)
Content Disclaimer
Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.
- The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
- There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
- It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
- Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
- Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.