Wikipedia:Reference desk/Archives/Computing/2020 February 19
| Computing desk | ||
|---|---|---|
| < February 18 | << Jan | February | Mar >> | February 20 > |
| Welcome to the Wikipedia Computing Reference Desk Archives |
|---|
| The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
February 19[edit]
Best peripherals for osu![edit]
I have heard a graphics tablet is the best peripheral for the music software osu! but they are really expensive so is there a cheaper alternative for osu! that works just as well or better then a graphics tablet — Preceding unsigned comment added by 71.241.214.63 (talk) 01:00, 19 February 2020 (UTC)
- I found graphics tablets for $60-$120.00 so, no, get a graphics tablet. Elizium23 (talk) 05:03, 19 February 2020 (UTC)
How does Windows 10 Quick Access work?[edit]
Specifically, how does it decide what files and folders to list in the "recent files" and "recent folders" lists? It regularly fails to list files that I've opened recently (and need to open again), while listing others that I accessed less recently. Iapetus (talk) 09:55, 19 February 2020 (UTC)
- Is it working from saves to those files, as opposed to opening them for read? I think some programs can also opt-out of this. Andy Dingley (talk) 15:40, 19 February 2020 (UTC)
Single quotes in filenames and bash[edit]
In bash, what's the proper way to get for file in *.webm; do echo "ffmpeg -i '$file' -c:a copy '${file%.webm}.ogg'"; done | xjobs -j 64 to stop choking on filenames that contain a single quote? 100.2.177.74 (talk) 16:59, 19 February 2020 (UTC)
- I don't know if there is a proper way, but you could try this:
for file in *.webm; do ffile=`echo $file | sed 's/./\\\&/g'`; echo "ffmpeg -i $ffile -c:a copy '${file%.webm}.ogg'"; done | xjobs -j 64
- I can't try this out myself; I don't know what xjobs does. Note that I have left out the single quotes surrounding $ffile. --Lambiam 21:30, 19 February 2020 (UTC)
- Maybe the occurrence of
'${file%.webm}.ogg'also needs to be replaced by${ffile%.webm}.ogg. --Lambiam 21:44, 19 February 2020 (UTC)- First of all, we can simplify this by stripping some of the quotes.
for file in *.webm; do echo ffmpeg -i "$file" -c:a copy "${file%.webm}.ogg"; done | xjobs -j 64 - However, this does not work for all filenames (particularly those with a space), because the echo gets in your way. I think the way to perfectly solve this is to have the shell open the files and pass them using /dev/fd. Because it's clear that you are trying to build some command lines to be evaluated ultimately by xjobs and honestly, that's a quoting nightmare that you can't get right when you're relying on the shell and echo like this. The other thing would be to bring this into perl or python where you'd make short work of the regexps and string massaging. Elizium23 (talk) 22:24, 19 February 2020 (UTC)
- Here we go, I knew there should be a way to do it in modern bash.
for file in *.webm; do ogg="${file%.webm}.ogg"; echo ffmpeg -i "${file@Q}" -c:a copy "${ogg@Q}"; done | xjobs -j 64- I tested this on files with spaces, files with single quotes, and various other things. The "@Q" parameter tells bash to quote the argument with proper escaping so that it can be re-used somewhere else. (You may be able to dispense with most of the double quotes.) Elizium23 (talk) 23:49, 19 February 2020 (UTC)
- Yes thanks! That's exactly what I was looking for. Also, xjobs is a SMP-focused fork of xargs, I'd forgotten it's not standard, sorry. 100.2.177.74 (talk) 21:26, 20 February 2020 (UTC)
- First of all, we can simplify this by stripping some of the quotes.
Office 2019 PowerView in Excel, use Microsoft example database - OlympicMedals[edit]
Hi, We are trying to get the image source linked into our example database for Educational purpose.
We tried to use other image source and it is working no problem. With wikimedia.org images it still don't show up.
The database as been done by Microsoft (https://support.office.com/en-us/article/tutorial-import-data-into-excel-and-create-a-data-model-4b4e5ab4-60ee-465e-8195-09ebba060bf0) a while ago for education. They have linked images like those list here:
The Excel Software is connecting to wikimedia server to dynamicaly download the thumbnail to show it in the PowerView Report.
Do you have any ideas if Wikimedia is bloking the image download for other client except Web Browser?. — Preceding unsigned comment added by Pouellette2 (talk • contribs) 17:20, 19 February 2020 (UTC)
- Asked and answered at Wikipedia:Help_desk#Image_sharing_with_third_party_software_(PowerView_Excel_2019_or_O365)_Office_2019_PowerView_in_Excel,_Link_image_from_WikiMedia.org. Please do not ask the same question in multiple places. TigraanClick here to contact me 09:25, 20 February 2020 (UTC)