Wikipedia:Reference desk/Computing
of the Wikipedia reference desk.
Main page: Help searching Wikipedia
How can I get my question answered?
- Select the section of the desk that best fits the general topic of your question (see the navigation column to the right).
- Post your question to only one section, providing a short header that gives the topic of your question.
- Type '~~~~' (that is, four tilde characters) at the end – this signs and dates your contribution so we know who wrote what and when.
- Don't post personal contact information – it will be removed. Any answers will be provided here.
- Please be as specific as possible, and include all relevant context – the usefulness of answers may depend on the context.
- Note:
- We don't answer (and may remove) questions that require medical diagnosis or legal advice.
- We don't answer requests for opinions, predictions or debate.
- We don't do your homework for you, though we'll help you past the stuck point.
- We don't conduct original research or provide a free source of ideas, but we'll help you find information you need.
How do I answer a question?
Main page: Wikipedia:Reference desk/Guidelines
- The best answers address the question directly, and back up facts with wikilinks and links to sources. Do not edit others' comments and do not give any medical or legal advice.
September 19
Plotting GPS locations of pictures in a Wikimedia category
I would like to look at a Google Maps display of London, England, with the locations highlighted for each photo in this category of photos on Wikimedia. I am assuming the photos all have their geotags intact. Is there an easy way to do this? Thanks in advance - Tarcil (talk) 16:30, 19 September 2018 (UTC)
- Tarcil, I suggest to use the Permanently protected Template:GeoGroup. It takes coodinates of articles in this category to G maps, OSM, or any avail, but the coords of the article only, not the mentioned coords in an article. Else we have the Wikipedia:Graphics Lab/Map workshop to get maps as a picture, if needed. --Hans Haase (有问题吗) 07:16, 21 September 2018 (UTC)
September 24
Freemake Video Converter: When was Logo added?
Hi,
According to Wikipedia, Freemake Video Converter, version 4.0.4.0 was the first to have a watermark logo at the end of videos lasting 5 mins or over.
Well, I tried an earlier version, 4.0.3.4 and this ALSO HAS the Watermark Logo!
My goal is to find the version produced immediately BEFORE the watermark Logo first appeared, ie, one which DOES NOT have the watermark Logo?
As I say, Wikipedia believed version 4.0.4.0 was the first time the Watermark Logo was introduced, but it clearly was not! Does anyone know the true answer to this, please?
Thank you. — Preceding unsigned comment added by 79.64.87.212 (talk) 06:53, 24 September 2018 (UTC)
- I suggest you discuss this at Talk:Freemake Video Converter.--Shantavira|feed me 08:29, 24 September 2018 (UTC)
How much Software documentation is in English?
In a work environment, how often do people still write docs about requirements, architecture, and so on (that is, everything besides comments) in languages other that English? --83.39.58.105 (talk) 19:29, 24 September 2018 (UTC)
- You can read this discussion from 2011. Ruslik_Zero 20:43, 24 September 2018 (UTC)
September 26
What was/is port 2381 compaq-https used for?
What was/is port 2381 compaq-https used for? Just curious in how this differs from the standard https protocol or whether it is some higher-level protocol bridged over https. -- Q Chris (talk) 10:14, 26 September 2018 (UTC)
- https://dfarq.homeip.net/port-2381/ A server system management console from HP (which would also cover a Compaq connection). Andy Dingley (talk) 10:25, 26 September 2018 (UTC)
Pals Tamil dictionary font
I am using Pals Tamil e-Dictionary (old version) in windows 10. But the font was not properly installed. So I couldn't type the words. How can I install the font or find the name of the font? Please help thank you.2402:4000:2083:D9F:4C50:A12B:D4EB:AC14 (talk) 15:56, 26 September 2018 (UTC)
Cache on i5 and i7
Looking at typical Sandy Bridge i5 (4 cores) and i7 (4 cores hyperthreaded), both have 64KB of L1 cache per core and 256KB of L2 cache per core. The i5 has 6MB of L3 cache shared and the i7 has 8MB of L3 cache, shared. How does this affect hyperthreading on the i7? The two threads on a core have to share its L1 and L2 caches whereas the i5 core gets all of it. And if you are running 8 threads on the i7, you have only 1MB of L3 cache per thread on the i7 versus 1.5MB per thread on the i5. Bubba73 You talkin' to me? 20:51, 26 September 2018 (UTC)
September 27
So there's 2 types of 0's and 1's?
Can anyone provide feedback on there being 2 types of 0's and 1's in the motherboard. The 2 types being:
Spinning hard disks use magnetic orientation to encode 0/1 patterns.
And.
Solid state drives and DRAM use electric charge (or no charge) to encode 0/1 patterns.
So you have to have a device that can interpret both types? I'm looking into how the motherboard translates machine language. Thanks. 12.239.13.143 (talk) 00:34, 27 September 2018 (UTC).
- Actually there may be many more ways to encode 0's or 1's. They could be due to a voltage transition, or could be coded by a change in magnetism, multiple voltage levels, or even more complex codings. Mostly these differences will be handled by hardware or microcode in the device. A number of standards are used so that a device can send the data on the motherboard to the device, CPU or memory in a way that every thing can cope with. The hardware will convert from the internal code to the standard as used on the bus. see for example PCI Express, I²C, or USB. Graeme Bartlett (talk) 05:58, 27 September 2018 (UTC)
- Note that nearly all consumer SSDs released in the past 4? or more years use Multi-level cell, generally triple in the past year or so, meaning that more than one bit is stored in a cell via multiple voltage levels. While still very rare, some computers generally fancy servers may have devices with 3D XPoint which uses resistance. Some computers still have Optical disc drives. While often only used for data accessed temporarily or moved around (including backups), people sometimes may regularly use live CD/DVDs for their OS. While both CDs and DVDs (and most other Optical discs) are generally described to use pits and lands, in reality it's a little more complicated than that. Pressed discs do involve basically stamping pits onto the disc (see Compact Disc manufacturing), although the surface next to the reflective side (not the side you can touch as sometimes believed). But recordable discs (CD-R, DVD-R, DVD+R etc) generally involve changing the properties of a dye layer. Rewritable discs (CD-RW, DVD-RW, DVD+RW, DVD-RAM) use a phase-change material. But these are basically all read in the same way, sensing how a laser is reflected back. (Writing recordable and re-writeables also occurs using very similar operations.) Nil Einne (talk) 16:07, 27 September 2018 (UTC)
- It's not clear whether the OP is asking about different methods of storage or encoding. One method of encoding (NRZI) is that a 1 (or 0) is chosen to represent only the change from one state to the other, rather than the actual data bit value. The reading device must decode this in order to pass it along. Akld guy (talk) 21:05, 27 September 2018 (UTC)
ARM Cortex R52
Does anyone actually make an ARM Cortex R52[1] chip that I can buy? The only thing I could find is the NXP S32S24[2] but that one is preproduction. --Guy Macon (talk) 22:07, 27 September 2018 (UTC)
- This suggests STMicroelectronics have provided samples of their platform to one customer [3]. This source suggests the codename Stellar and sampling this year but not sure if this means more widely than that one customer [4]. (I think the second source is using one of those weird American dates which puts the month then the day then the year so it's dated before the first.) So select people can obtain them, possibly more later. I'm guessing if you had access to those sort of resources you wouldn't be asking here though. Nil Einne (talk) 22:42, 27 September 2018 (UTC)
- This is for a side project. The sad part is that if I told them that I do consulting for Mattel (true, but I am not on a Mattel project right now) and that I needed this for a Mattel project (a complete lie; we use much lower cost microcontrollers) they would fall over themselves assisting me. Damn these inconvenient ethics! :) --Guy Macon (talk) 02:28, 28 September 2018 (UTC)
Importing csv into OpenOffice dbase
Hi there. I'm trying to import records from csv to dbase (OpenOffice). I'm trying to follow instructions here:
https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=23260 (search for "This type of connection can be created if you follow this steps:")
It works fine if I use his csv:
ID,FirstName,Name,DOB 1,John,White,1960-01-23 2,Elisabeth,Smith,1972-11-10 3,Eric,Long,1987-04-07
But not if I use mine:
ID,Name,Status1,Status2,Phone 9018,linda,0,1,123123123123 9019,jenny,0,1,123123123123 9020,luke,0,1,123123123123 9021,mark,0,1,123123123123
How do I modify his line:
CREATE TEXT TABLE "Names" ("ID" INTEGER PRIMARY KEY, "FirstName" VARCHAR(20), "Name" VARCHAR(20), "DOB" DATE);
...so that it will work for my csv?
Many thanks for any help you can offer.
Anna Frodesiak (talk) 22:23, 27 September 2018 (UTC)
Never mind. I finally figured it out. Thanks anyhow. :) Anna Frodesiak (talk) 01:03, 28 September 2018 (UTC)
- (ec) I was about to suggest:
CREATE TEXT TABLE "Names" ("ID" INTEGER PRIMARY KEY, "Name" VARCHAR(20), "Status1" BOOLEAN, "Status1" BOOLEAN, "Phone" VARCHAR(20));
- This assumes that the status values are booleans (0/1 = false/true) and treats the phone number as text. Glad you figured it out. -- Tom N talk/contrib 01:14, 28 September 2018 (UTC)
- Hi Tom. Actually, I didn't figure it out after all. I did get my stuff into the dbase, but now I cannot make the primary key stick and cannot add new entries to the table. Is there no way to do this? It's driving me nuts. Anna Frodesiak (talk) 07:14, 28 September 2018 (UTC)
- As the ID colmn is a primary key, its unique per line/record and required. First enter a not existing number in the ID field, then follow the other fields. --Hans Haase (有问题吗) 20:29, 29 September 2018 (UTC)
- Hi Hans Haase. Thank you kindly. Actually, I was looking for a way to take the records from a csv and add them all at once to the dbase. For some odd reason, that does not seem possible. Anyhow, I've added them by hand. Thank you both anyway. :) Anna Frodesiak (talk) 20:59, 29 September 2018 (UTC)
- Hi, a primary key resets by reorganizing/recompressing the data base or drop and recreate the table. Base is a bit difficulty to handle. When taking calc to import and transfer the table from CSV? Success? --Hans Haase (有问题吗) 21:03, 29 September 2018 (UTC)
- Hi Hans Haase. Thank you kindly. Actually, I was looking for a way to take the records from a csv and add them all at once to the dbase. For some odd reason, that does not seem possible. Anyhow, I've added them by hand. Thank you both anyway. :) Anna Frodesiak (talk) 20:59, 29 September 2018 (UTC)
- Hi Hans Haase. I think I understand about primary keys. I just figured, as long as that column in csv is full of unique numbers, importing into dbase ought to be doable. Strange that it isn't. Also, there doesn't seem to be any way to even copy paste columns of data into an existing table. But all that doesn't matter now. I've done it all manually. Best, Anna Frodesiak (talk) 21:29, 29 September 2018 (UTC)
I figured it out for anyone in the future having trouble with this:
You don't need to save the spreadsheet in csv. You just need to highlight the columns in the spreadsheet, then in dbase/tables, right click on the empty space in the tables pane and click paste. That will make a table out of the spreadsheet column. If you allow it to make a primary key, then it becomes a usable table you can add to. Anna Frodesiak (talk) 06:49, 30 September 2018 (UTC)
September 28
Stockfish vs Houdini etc
I realize that computers can improve and also have fluctuations in their chess ratings, like humans do, but why is Stockfish in the mid 3200s rating and houdini is at 3400, since stockfish is so dominant? That's a huge difference in rating points.144.35.114.45 (talk) 01:18, 28 September 2018 (UTC)
- Your numbers are wrong.
- --Guy Macon (talk) 11:27, 30 September 2018 (UTC)
September 29
Transparent PNG images in MS Paint
In Microsoft Paint, how do I make a PNG that has a transparent background? In addition to the transparent background, there will be two foreground colours, used to draw a shape that is to be outlined in black and filled in white.
In the "Colors" menu, the "Edit colors..." option allows me to set colours using either hue/saturation/luminance (these are not compatible with the HSL values described here), or decimal RGB values, but there is no option to set the opacity/alpha value. --Redrose64 🌹 (talk) 18:36, 29 September 2018 (UTC)
- Does this help? Ruslik_Zero 20:57, 29 September 2018 (UTC)
How close are we to Full immersion/ deep dive vr?
WIll it happen within out lifetimes?
By uisng nervegear, nanobots, mind uploading, Neuralink maybe?
And if we get full dive vr will it be limited to gaming?
Or is it just all fantasy? — Preceding unsigned comment added by 60.241.172.251 (talk) 23:14, 29 September 2018 (UTC)
- See the top of the page: We don't answer requests for predictions. Including predicting the length of your life. --76.69.47.223 (talk) 02:33, 1 October 2018 (UTC)
September 30
fatal error cannot set display mode serious sam 3
Hello there, I have been trying to play in my updated system. My specs are: Processor: Core 2 Quad, Graphics card (driver updated): Nvidia GTX 650, Direct X11, Ram 4 GB and OS Windows 7 64 BIT. Each time I tried to run the game as administrator I get that message. I tried searching google for answer but no solution yet. Here's my log file:
-------- START OF LOG --------
|
How can I solve this. Thanks in advance.103.231.162.134 (talk) 22:13, 30 September 2018 (UTC)
You search term suggests to me you've missed what seems to be the key takeaway from the log 'Failed to load dynamic module "D3DCompiler_43.dll"'. This error suggest to me a possible problem with DirectX and sure enough a simple search finds plenty of results where the same is suggested e.g. [8] [9] [10] (I wouldn't suggest you remove random DirectX 9 DLLs but it does support my conclusion). I suggest running the web DirectX installer [11]. If that doesn't work, you can see if anything here helps. [12]
Note that as attested by some of the forum threads, it's possible Serious Sam 3 may come with it's own DX redist. The trouble with relying on this is it could corrupted somehow, and it also could have problems with your current drivers if it's outdated. So running the web installer is likely the best choice. (And don't be confused by the dates. Since it's a webinstaller the content it retrieves is not directly affected by the date it was released.) On that note, although this seems to be a DirectX problem it is also possible it's a driver problem so make absolutely you have the latest drivers. Preferably from Nvidia although I admit the age of the game and card suggests the Windows Update ones are probably fine as well.
Note as also attested by some of the threads, you could try running this in DirectX 9 mode if the game supports it. However assuming the problem is a corrupted or outdated DirectX install, you're only masking the problem. (BTW if searches for the specific game don't find anything, it's often helpful to look at info for other games if it's a fairly specific error. Especially if they use a related engine.)
P.S. I probably should mention that while I still suggest you use the web installer, if SS3 does come with a redist and it's corrupt, this isn't a good sign either since it's possible other files could be corrupt. If this is a Steam variant, I would also suggest an integrity check [13]. Most games also have a 'first time run' mode where they run any installers etc. Unfortunately getting this to repeat is not so easy. You can look for any redists etc in the game's directory but you could still miss stuff [14] [15].
- Thank you for your detailed response. I tried almost everything you mentioned but none worked. After installing the game I didn't find any steam file. I separately downloaded steam software but did not workout. I downloaded the game from torrent website. Some people claimed it run perfectly, some had same problem like mine. I am thinking to download gold edition of SS3. I Will check that out.103.231.162.134 (talk) 22:47, 1 October 2018 (UTC)