Content deleted Content added

Inline

Revision as of 13:03, 28 June 2013

Welcome to the computing section
of the Wikipedia reference desk.

skip to bottom

Select a section:

Shortcut

WP:RD/C

Want a faster answer?

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.

Ready? Ask a new question!

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.

June 23

What is THE strongest, most protective phone case for the Samsung Galaxy Victory?

Best Buy didn't have one by Otterbox. I looked at Otterbox's website, and couldn't find any case intended for the Galaxy Victory either.

Sadly, Otterbox was the only case I have ever trusted to protect my phone in any fall / shock-inducing event. I have one on my old phone - the Xperia Play.

Is there a case for the Galaxy Victory that is at least as tough as, if not tougher than the Otterbox? Thanks. --70.179.161.230 (talk) 05:18, 23 June 2013 (UTC)[reply]

This page deals with your exact problem, and includes an e-mail from Otterbox on the matter. I found this case which has got pretty good reviews compared to others. You should probably wait for a user who has personal experience, though. Good Luck! --Yellow1996 (talk) 17:41, 23 June 2013 (UTC)[reply]

June 24

Sandisk USB drive needs to be formatted?

I bought a SanDisk Cruzer USB drive and used it on my MacBook for a few days with no problems.

When I inserted it into my friend's Toshiba laptop running Windows 7 Home, I received a message that I need to format the drive before I can use it.

I removed it and reinserted it into my MacBook. Finder gave me an error message that the disk I inserted was not readable by the computer.

Disk Utility seems to think it is a Firebird 64MB drive.

Some Googling revealed that this sometimes happens to brand new Cruzer drives which were sold unformatted. However, I had already been using the drive for a few days with no problems. Perhaps it could be a difference between Windows and Mac filesystems (such as Windows trying to read the drive as an NTFS drive)?

How do I fix my SanDisk Cruzer USB drive and get my data back? — Preceding unsigned comment added by 121.7.178.163 (talk) 13:10, 24 June 2013 (UTC)[reply]

I discovered some very helpful suggestions on this page. Looks like there is a lot of freeware that can do exactly what you want; though there are other things to try as well. As for getting your drive back up and running, you'll probably have to format it, but try some of those methods in the link first. (also, I think for most of them you'll need to put it into a windows computer...) Good luck! --Yellow1996 (talk) 16:01, 24 June 2013 (UTC)[reply]

Samsung Galaxy Appeal

How many megapixels does this version of SG have? It doesn't show it at the back Miss Bono ^(zootalk) 17:31, 24 June 2013 (UTC)[reply]

It has a 3 megapixel camera. Read the full specs here. --Yellow1996 (talk) 18:19, 24 June 2013 (UTC)[reply]

THanks! Miss Bono ^(zootalk) 12:03, 25 June 2013 (UTC)[reply]

Programming a bot to create city articles with census data for the Sorani Kurdish Wikipedia

Is anyone on here experienced in programming bots to create articles (like Rambot creating articles on the English Wikipedia on US cities back in 2003)?

A user from the Sorani Kurdish Wikipedia wants a bot to create articles on Iraqi cities in Sorani Kurdish. I found census data at http://cosit.gov.iq/pdf/2011/pop_no_2008.pdf (Archive) that has information on Iraqi cities. Would anyone know how to write a bot to automatically generate articles with this data?

Thanks WhisperToMe (talk) 17:59, 24 June 2013 (UTC)[reply]

Look at WP:BOTREQ. You can request a bot there, or follow the links to learn how to build your own. RudolfRed (talk) 04:52, 25 June 2013 (UTC)[reply]

Thank you! I filed a BOTREQ WhisperToMe (talk) 02:24, 26 June 2013 (UTC)[reply]

Double USB on external Hard drive...?

A couple of days ago I discovered a 20GB (Toshiba) external hard drive in a junk pile (I'm not making this up!) And, sure enough, it works great. However, there's something odd I noticed about the USB cable - namely, it is a wire that branches off into two USB plugs! One of them has a thinner wire, and when plugged into my laptop does nothing except activate the green light on the front of the drive. The other plug's branch is a thicker wire, and when that one is plugged in I can hear the drive's inner mechanisms and my laptop recognizes it and I can remove/add files etc. One of the folders said it was modified in 1999 so I think it is an old drive; also the outer casing makes it very clear that it is using USB 2.0, which makes me think I might be right as to the age of it. So my question is: why the double USB wire? Has anyone seen something similar before? Thanks! --Yellow1996 (talk) 21:59, 24 June 2013 (UTC)[reply]

I've seen that before. The second one is supposed to give the drive extra power so that it doesn't overload the usb port, so its power demand is spread over two. 82.44.76.14 (talk) 22:22, 24 June 2013 (UTC)[reply]

Okay - makes sense; I had suspected it had something to do with power but wasn't sure because "one had ought to be enough!" ;) I'll have them both plugged in from now on (since I don't really ever have more than one device plugged into USB at once.) Thanks! --Yellow1996 (talk) 15:54, 25 June 2013 (UTC)[reply]

June 25

Is there a cable modem + wireless router that'll stay running in a power outage?

I appreciate that my laptop will still run, but in a power outage, I'm out an internet connection.

Is there any modem + wireless router that'll have some sort of battery backup? Any kind of mechanism that'll keep it running when the power's out? Hopefully. Thanks. --70.179.161.230 (talk) 02:46, 25 June 2013 (UTC)[reply]

Look at getting a UPS to keep your modem running. Of course, that only helps if the cable company's equipment also does not lose power. RudolfRed (talk) 04:51, 25 June 2013 (UTC)[reply]

Here's an article outlining uninterruptible power supply use. --Yellow1996 (talk) 15:58, 25 June 2013 (UTC)[reply]

If all else fails, you can get cheap 12 volt to 110v inverters for in-car applications in most stores that sell car parts (WalMart has them here in the USA) - you can charge a car battery and use that to power your modem/router for a L-O-N-G time. This is a good general solution because you can also power things like desk lamps, peripherals like printers and so forth. If you need more battery life - wire up multiple car batteries in parallel. Don't forget to recharge them once in a while.

Of course it's possible that the cable will go out at the same time as your power.

SteveBaker (talk) 13:50, 27 June 2013 (UTC)[reply]

Converting Currency to Text in Excel without losing formatting

Hi there,

I've got a bit of a conundrum. I've got an enormous excel sheet with lots of columns, many of which are formatted as currency. So essentially, the actual data that's in the fields is "7", "8.5", etc. However, the way they display in Excel is "£7.00", "£8.50", etc.

The trouble is, when I try and merge them into Word (2010 - same version of Excel), it loses all the formatting - and so my figures will display as "7" or "8.5" (or indeed "5.125") rather than "£7.00", "£8.50" or "£5.13"). I've attempted to use the "Confirm file format conversion on open" options on Word but they're not working for me.

Is there a way I can convert the Currency columns to Text columns without losing the currency formatting, and then import them directly as text into Word?

thanks

Seal Boxer (talk) 12:25, 25 June 2013 (UTC)[reply]

This is discussed in a Microsoft knowledgebase article here, and also here, which explains how you can use formatting codes in the merge fields to control how the amounts appear. Alternatively you could use the formula =TEXT(amount,"£#,##0.00") (in the spreadsheet) to convert the values to text in the right format first. AndrewWTaylor (talk) 13:34, 25 June 2013 (UTC)[reply]

Calculating text length tin SVG

I'm writing a program that puts out an xml file containing SVG. It contains variable text and I have to check if the text fits in a certain space (think of a box) or not. Googeling, I can see many people asking questions about that but haven't seen an answer (just workarounds). 77.3.170.153 (talk) 15:03, 25 June 2013 (UTC)[reply]

I don't think it is possible to do that using the SVG file alone, if that's what you're asking for. You can't calculate the width without knowing the detailed structure of the font, and that information is not included within an SVG file, at least not by default. What programming environment are you working in? Looie496 (talk) 15:12, 25 June 2013 (UTC)[reply]

Currently I'm using perl (module SVG), but I won't necessarily stick to that. And I need to calculate the text length when the SVG is still incomplete. With SVG there seems to be somthing like getComputedTextLength, but I need this beforehand, not in the final SVG file. 77.3.170.153 (talk) 15:59, 25 June 2013 (UTC)[reply]

As Looie496 says, text doesn't really have dimensions in abstract - those dimensions only exist in the context of a concrete font in a real render. To do this kind of thing you need an offscreen rendering context (whether that's a Cairo context, a browser widget, an invocation of imagemagick, or whatever) into which you do a temporary render of the text, and from which you can then extract the size of the resulting objects. Naturally if you're doing this a bunch, you want to try to keep that context around for a bit so you can reuse it, as much of the cost of this is generating the context in the first place. And I'm sure you're aware that the SVG you generate might not render with those dimensions on someone else's system (e.g. in someone else's browser), particularly if they don't have exactly that font. -- Finlay McWalterჷTalk 16:17, 25 June 2013 (UTC)[reply]

(ec) As I am the one generating the SVG I do have some control on which fonts should be used by a client rendering the picture. OK, I can have a half-baked file sent to another program to check the length, but this is not exactly what I have in mind. Ideally, the generating program (perl, or whatsoever) should have a function that returns the bonding-box for a given font and text. 77.3.170.153 (talk) 16:34, 25 June 2013 (UTC)[reply]

Of course one way around this is to use a fixed-width font, if that's possible. Or to use the maximum character width for the font. Looie496 (talk) 16:28, 25 June 2013 (UTC)[reply]

Unfortunately I need some astrological symbols and I'm pretty sure they are not part of any widespread fixed width font. 77.3.170.153 (talk) 16:34, 25 June 2013 (UTC)[reply]

Fixed width (monospace) only fixes the size of characters with respect to others in that same font (at that size). Rendering the same string on my machine with Cairo produces the following sizes for all the monospaced fonts:

      Andale Mono (129.0, 15.0)
      Webdings (108.0, 13.0)
      DejaVu Sans Mono (130.0, 15.0)
      TlwgMono (131.0, 13.0)
      PixelCarnageMonoTT (118.0, 11.0)
      Liberation Mono (130.0, 15.0)
      Courier 10 Pitch (130.0, 12.000000000000002)
      Nimbus Mono L (131.0, 13.0)
      Consolas (119.0, 14.000000000000002)
      Inconsolata (108.0, 13.0)
      Tlwg Typo (131.0, 13.0)
      Courier New (131.0, 13.0)
      FreeMono (131.0, 13.0)
      Ubuntu Mono (109.0, 15.0)
      Monospace (130.0, 15.0)

...which shows the folly of relying too closely on these kind of metrics when one wants to know how something will render on someone else's machine. For example, if the OP were to decide to use Consolas and lay things out accordingly, if someone viewed it on a machine without Consolas, which instead substituted Ubuntu Mono, the resulting text object would be 20% wider than they'd anticipated. -- Finlay McWalterჷTalk 17:45, 25 June 2013 (UTC)[reply]

For Cairo (which has a php binding), here's a simple program that does it (I wrote it in Python, but it's just a matter of syntax changes to make it php):

#!/usr/bin/python                                                                                                   
import cairo

surface = cairo.ImageSurface(cairo.FORMAT_RGB24, 1000, 300)
context = cairo.Context(surface)

context.select_font_face("Georgia")
context.set_font_size(20)

xbearing, ybearing, width, height, xadvance, yadvance = context.text_extents("hello there")
print width, height

-- Finlay McWalterჷTalk 16:38, 25 June 2013 (UTC)[reply]

Thanks to you and curse on Murphy, I have seen and used many languages, but python and php are one of the few I haven't used before. I guess and hope cairo is available for perl and/or java, too. I'll have a google and a try. Thanks again. 77.3.170.153 (talk) 16:45, 25 June 2013 (UTC)[reply]

Ah, what a nice day today, there actualy is such a module for perl: http://search.cpan.org/~xaoc/Cairo-1.103/lib/Cairo.pm So I thanky you again and calll ths question resolved (don't know how to produce this nice button here). I'm happy. 77.3.170.153 (talk) 16:54, 25 June 2013 (UTC)[reply]

If you wanted to do it in Java, you can use Java2D instead of Cairo:

import java.awt.*;
import java.awt.geom.Rectangle2D;
import java.awt.image.BufferedImage;

public class measure{
    public static void main(String [] args){
        BufferedImage im = new BufferedImage(1000, 300, BufferedImage.TYPE_INT_RGB);
        Graphics2D context = (Graphics2D)im.getGraphics();
        FontMetrics metrics = context.getFontMetrics(new Font("Georgia", Font.PLAIN, 20));

        Rectangle2D dims = metrics.getStringBounds("hello there", context);
        System.out.println("width:" + dims.getWidth() + " height:" + dims.getHeight());
    }
}

-- Finlay McWalterჷTalk 17:21, 25 June 2013 (UTC)[reply]

Regrettably, no. I need the SVG output. A rasterized image won't do. 77.3.170.153 (talk) 18:10, 25 June 2013 (UTC)[reply]

You can still do Java2D for the measurement (with all the caveats I've already harped-on about) and emit an SVG by another means. But the nice thing about Cairo is it can render to an SVG context (see the 2nd example here). -- Finlay McWalterჷTalk 20:08, 25 June 2013 (UTC)[reply]

June 26

Copying large files from PS3 HDD?

I've downloaded a couple large videos from the Playstation Store (the PS4 announcement video, 6GB, and the E3 Press Conference, 5GB). Like all game videos from the Playstation Store, they are just plain h264 movies without DRM. But Playstation 3 only seems to support FAT32 for USB attached external drives. And I get an error when trying to copy these files because I assume they are larger than the 4GB file size limit on FAT32 volumes. Are there other ways to get files off the PS3? Perhaps through the ethernet port? --Navstar (talk) 01:00, 26 June 2013 (UTC)[reply]

People have been asking this question for years on Sony forums and other various sites. The only method suggested that hasn't been confirmed yet (but seems worth trying IHMO) is using the PS3's built in browser to upload the file onto a file hosting site like Mediafire or Rapidshare (I reccomend Mediafire) and then you can download the file onto your PC from the site. I think that could work; you could try that. --Yellow1996 (talk) 16:03, 26 June 2013 (UTC)[reply]

Unless you have fast upstream broadband, it would be faster to run an http file-upload server on the target machine, such as this one. (Edit to add: or this one, which has no GUI but doesn't even need to be installed.) -- BenRG 01:02, 27 June 2013 (UTC)

I pointed my PS3 browser to Dropbox. When I go to upload a file, the PS3 only lets me browse the Photo directory on its internal drive. There doesn't seem to be a way to browse other directories on the local drive. And unless I can choose that file, it doesn't matter if I use Dropbox or a HTTP upload server on my home computer. --Navstar (talk) 03:12, 27 June 2013 (UTC)[reply]

I installed Ubuntu on my HP laptop.

After installing it on my Laptop I really did not like it as much as the Windows it came with out of the factory, I wish to re-install Windows how would I do this because I can barely read the activation code on the bottom, how do I reinstall windows again? — Preceding unsigned comment added by 76.16.47.115 (talk) 04:51, 26 June 2013 (UTC)[reply]

If you have the original media (or a set of recovery disks) you will not need the activation code. I've just done a reinstall on a hp 6730b and a 6710b and neither required a code.196.214.78.114 (talk) 06:45, 26 June 2013 (UTC)[reply]

Ubuntu is like windows, in so much, that the first time you encounter it there is a steep learning curve before you get the hang of it. Linux is Not Windows However, preserver for no more than the 'same time' that it took you to learn windows and you will find Ubuntu (or Mint or any other the other popular Linux distribution) way easier to use and maintain than windows. Then, in a year or two's time you'll be posting here to ask “why don’t more people use Linux? It's a breeze.” It may only be that you have come across windows first, and so a better operating system now seems strange. Had it been the other way about, you would not even give windows (with all the hoops it requires you to jump though) a first let, alone second look. --Aspro (talk) 14:36, 26 June 2013 (UTC)[reply]

I dont have the disc so how could I do it? — Preceding unsigned comment added by 76.16.47.115 (talk) 07:00, 27 June 2013 (UTC)[reply]

Did your laptop come with a 'legitimate' installation of windows on it or did you buy a Grey Market laptop.--Aspro (talk) 12:11, 27 June 2013 (UTC)[reply]

It may have a recovery partition, although you may have wiped that out when installing Ubuntu. HP Support also used to sell replacement discs for $12, if I remember right. 209.131.76.183 (talk) 12:23, 27 June 2013 (UTC)[reply]

On demand web graphics

Can people suggest software that is good at creating on-demand graphics for web servers. In my particular application, we have large data files and we are looking for ways to extract and plot small subsets of that data in response to user requests submitted via a web interface. What existing software packages are good at such applications? The web interface itself will probably be PHP, but we can of course call other programs to generate the images as needed. Dragons flight (talk) 05:40, 26 June 2013 (UTC)[reply]

For general drawing, people use ImageMagick (libmagick), cairo, and GD. To do mathematical and statistical diagrams and plots there's things like matplotlib, GNU Octave, and gnuplot. There are also lots of charting libraries (which produce histograms, pie charts, and the like) such as pChart. -- Finlay McWalterჷTalk 10:38, 26 June 2013 (UTC)[reply]

There's another option you may consider: doing the plotting client side (in the web browser). There are several JavaScript charting libraries (which render to a Canvas element, or in some cases do things like pie charts and histograms with CSS). That way, rather than generate a PNG or SVG server side and send that, you can send the data (e.g. as JSON or XML) and render it in the browser. That can lower the amount of data you have to move on the network, but the big gain is you can make the render responsive and interactive - so the user can select what data to view, zoom around, turn labels on and off, etc. The downside of that is that it depends on the user having a newer browser. -- Finlay McWalterჷTalk 12:44, 26 June 2013 (UTC)[reply]

I think this depends to a great degree on the format of your data files and the types of information you want extracted. If they are spreadsheets or can easily be turned into spreadsheets, you might find that the easiest solution is to write macros for a spreadsheet program. Looie496 (talk) 14:49, 26 June 2013 (UTC)[reply]

Recommender system in wikipedia

Hi ! I am currently working on recommender systems and someone mentioned to me that wikipedia had one and I can't find any mention of such thing though. Am I just blind and wikipedia does recommend articles to users depending on what they have already read ?

From what I understand, the "See also" section is filled out by users right ? Or is there any kind of system that recommends the articles which need to be in that "See also" section ? Thanks for your help ! Fperrotti (talk) 06:58, 26 June 2013 (UTC)[reply]

There's just the links in the articles. Wikipedia doesn't set a curriculum, so it's up to individual readers to set their own course through the articles. Sometimes the category links will lead you other places, and sometimes the portals on the page will have subject suggestions. Wikipedia content is sometimes linked from external things (like Wikibooks) which do set a curriculum, but the authors of a specific Wikipedia article can't know why someone came to read it, and so can't recommend where you'd go from there. The "see also" section certainly isn't a recommendation list, although it is sometimes misused as one - it should be links that are relevant to the article but that can't easily be worked into the article's text (where they'd have context) - an example of good practice is Extreme points of North America, which see-alsos other extreme-points articles. -- Finlay McWalterჷTalk 10:31, 26 June 2013 (UTC)[reply]

Wikipedia has an article about Recommender system about the subject, it doesn't operate one. Wikipedia also has articles on subjects like singular value decomposition which I'm surprised that article doesn't seem to link to but you do sometimes have to click around a bit on the links in an article to see what meat if any there is in Wikipedia about a topic. Dmcq (talk) 11:43, 26 June 2013 (UTC)[reply]

SuggestBot suggests pages that may be of interest to an editor based on their edit history - so it's a bit like a recommender system. But I don't think anything in Wikipedia logs pages that you have looked at (as opposed to actually editing them) so it can't make recommendations based on what you have read. Gandalf61 (talk) 12:07, 26 June 2013 (UTC)[reply]

An important point about Wikipedia is how it is structurally different from sites like Amazon and Facebook. Those deliver a personalised web experience; most visitors have an account and most of those are signed into it most of the time. That account means Amazon and Facebook know who their visitors are and deliver custom content based on their preferences, actions, and history. In contrast Wikipedia serves almost everyone the same content, with only a statistically negligible number (signed in editors) getting any kind of custom content. Amazon's and Facebook's value all lies in that individualised experience, but it comes at a massive cost to them. Wikimedia makes very effective use of cache (web cache and memcached), meaning it can serve the whole site with 1000 servers or so (I can't find an up-to-date number; it was 300 in 2008), but Amazon and Facebook both have a number of gigantic datacentres - Facebook spends half a billion US dollars a year on servers (ref). To properly support visitor-specific content over the whole visitor base at Wikipedia would mean abandoning that massively cache efficient architecture and adopting an Amazon-like architecture. So, handwaving the numbers a bit, implementing a recommender system at Wikipedia's massive scale might cost upwards of $200 million US. Donate here!!

-- Finlay McWalterჷTalk 14:22, 26 June 2013 (UTC)[reply]

Wikipedia does provide an implementation of an expert-system that recommends other articles: Special:Book has a "suggest a page" feature. This is implemented by the MediaWiki Collection extension and is not very well documented. A little bit of tutorial information is provided at Wikipedia Help for Books. Nimur (talk) 21:27, 26 June 2013 (UTC)[reply]

Maybe the OP is thinking of the suggestions Wikipedia makes as you start to fill the search box in. For example, if I type in "m", it suggests Mollusca and Mexico and if I add an "a" afterwards, it switches to Marriage and Major League Baseball. Somehow, those articles are being recommended to me, though I'm not sure how (number of hits, perhaps?). Matt Deres (talk) 16:43, 27 June 2013 (UTC)[reply]

Gmail

Hi. When I created my Gmail account, I entered my real name in the registration form. The problem is that Gmail uses this real name as sender in the e-mails that I send to other people. How can I set Gmail to use an alternative name as sender instead? I can't find this option in Settings. Please don't tell me to create another account because I like my current account name. Thank you. --41.129.46.55 (talk) 15:23, 26 June 2013 (UTC)[reply]

Follow this tutorial (with pictures!) --Yellow1996 (talk) 15:53, 26 June 2013 (UTC)[reply]

It works! Thank you very much. You are wonderful. --41.129.46.55 (talk) 16:51, 26 June 2013 (UTC)[reply]

No problem! I'm glad it worked out for you! :) --Yellow1996 (talk) 18:44, 26 June 2013 (UTC)[reply]

Where can I find the Matlab Psychophysics toolbox?

I'm looking for the Psychtoolbox-3, but www.psychtoolbox.org is down. Does anyone know where it might be elsewhere located? Thanks in advance! --Rajah (talk) 16:02, 26 June 2013 (UTC)[reply]

You can find the source code at https://github.com/Psychtoolbox-3/Psychtoolbox-3, but you would need some sophistication in order to use it. You can find an older version with a Matlab download script at http://code.google.com/p/psychtoolbox-3/, but I don't guarantee that it will work for you. Looie496 (talk) 16:23, 26 June 2013 (UTC)[reply]

Just as a side note, psychtoolbox.org works fine for me. There's a really useful site I know called downforeveryoneorjustme which allows you to check if a site is down for everyone, or just you. --Yellow1996 (talk) 18:49, 26 June 2013 (UTC)[reply]

It works now. Earlier it was showing an invalid https security certificate. Looie496 (talk) 21:51, 26 June 2013 (UTC)[reply]

Excel: mixing time and currency

Hi. I'm trying to use Excel to do timesheet work. It's a mix of cells relating to time and money.

I have managed to get it Excel calculate, based on a start and finish time how many hours and minutes have elapsed, so for example, 09:45 and 10:15 in columns A and B renders 00:30 in column C.

So far, so good, but when I try to get Excel to combine column C with column D (rate per hour) I get nothing but gibberish in column E, which should be the chargeable amount, based on time and rate.

Can someone give me a formula for column E that will work? Thanks in advance. --Dweller (talk) 21:39, 26 June 2013 (UTC)[reply]

try =C1*24*D1 but make sure the cell D is formatted as general format - excel might try to convert it to a datetime format which isn't correct. --_nonsense ferret 22:37, 26 June 2013 (UTC)[reply]

Terrific, thanks that worked, even when I formatted D as currency. --Dweller (talk) 08:31, 27 June 2013 (UTC)[reply]

Help setting up website

I recently set up a new internet forum, which proved rather easy, since all I had to do was download some free software and install it on my website, but now I want to expand the site, to include pages for people to share pictures and maybe even video relating to the topic of the site, would this be as easy to set up, or would I need some sort of professional help? Anyone want to point me in the right direction, is it something I could arrange myself with no experience of actually writing websites, it's a pretty common feature, I think, just a case of getting my own copy, and then somehow linking it to my existing site...

2.126.209.75 (talk) 21:57, 26 June 2013 (UTC)[reply]

Depending on which forum-making package you used, there's probably an extension/addon available for it that can do what you need. Check and see if they have an official site or community support forums. --Yellow1996 (talk) 22:03, 26 June 2013 (UTC)[reply]

worth thinking carefully about what you are trying to do. Do you mean you want to allow people to upload pictures/videos to your forum website to share them from there? If so that would obviously have quite a large impact on the bandwidth that your site uses, and the amount of hosting space that you would need. For this reason some forums take the option of allowing users to embed files hosted by other webservices such as youtube. Doing so might reduce a few headaches of hosting files on your own site such as copyright/ bandwidth and security. --_nonsense ferret 22:44, 26 June 2013 (UTC)[reply]

We know from an earlier question that the OP is using Go Daddy. I'm pretty certain that Godaddy won't allow you to use your web site for third-party file sharing. Generally it costs quite a bit to get a service that will, and even then there are going to be limitations. Looie496 (talk) 22:47, 26 June 2013 (UTC)[reply]

I've run two forums on GoDaddy. Both with image galleries that I hosted on the site. The images could be hot linked from the galleries onto other sites.

OP, there is likely some other software package that you can download and install rather easily but without knowing more about what software you are already working with, it's hard to tell you more. Also, you may want to look into a CMS or Content Management System if you intend on having non-forum pages as well. Dismas|^(talk) 23:05, 26 June 2013 (UTC)[reply]

I'm running Vanilla Forums at the moment, I can look around their website some more, but I haven't seen any add-ons for this so far. And yes, I know I'll need a lot more bandwidth and storage space once the gallery starts growing, I'm willing to pay what I need to for that. 2.126.209.75 (talk) 14:00, 27 June 2013 (UTC)[reply]

June 27

Looking for a media player

Is there a media player with a "jump to the next line in the subtitle file" keyboard shortcut option?

46.107.26.54 (talk) 12:46, 27 June 2013 (UTC)[reply]

I don't know of one that allows you to skip to another line, but VLC media player allows you to increase or decrease the subtitle delay by pressing 'g' or 'h'. - Cucumber Mike (talk) 13:21, 27 June 2013 (UTC)[reply]

I'll just put in another reccomendation for VLC - excellent player. --Yellow1996 (talk) 16:13, 27 June 2013 (UTC)[reply]

Can you clarify what you want to do?

A. Do you want to skip to the point in the video where the next subtitle appears? This could be used to read and advance the video at a self-paced speed that is faster than listening to the ordinary-speed audio, but still allows watching the video for context (a possible advantage over just reading the subtitle file as a stand-alone transcript).

B. Do you want to keep the video playing normally, but shift the subtitles so the next subtitle appears right away? This sounds like an easier way to re-synchronize the subtitles to the video than changing the "subtitle delay".

If you can't find a video player that does what you want, I wonder if watching your video and subtitles in a subtitle editor like Aegisub might give you an option to do what you want. --Bavi H (talk) 00:52, 28 June 2013 (UTC)[reply]

June 28

Port Forwarding Through a Range Extender

I have to use a range extender to be able to connect my Desktop to the network in order to get my internet. I have a cable running from the extender to my desktop and then the extender has a wireless connection to the router. I am trying to port forward my computer so that I can have a friend (who is in Australia, I am in America) can join on my private minecraft server for a project we are building. However when I port forward my computers IP address and the port the servers connected to like normal he can't connect. All my online searching keeps telling me that I just have to port forward like normal and it should work. However it's not working. My extender doesn't have port forwarding but does have it's own separate signal for wifi. I can even set the password to something completely different from the routers if I want to. I'm new to extenders as I haven't needed to use one until now so I am not sure how this is suppose to work. Does anyone know how I can get my server, which is on my computer, to be port forwarded through my extender and router so my friend can join me? This stuff confuses me so please be simple with explaining it. Thank you. 24.113.181.116 (talk) 02:41, 28 June 2013 (UTC)[reply]

It's likely to depend on the way the "extender" actually works. Do you have a manufacturer and model? --Phil Holmes (talk) 09:16, 28 June 2013 (UTC)[reply]

How do i add "Contents" table on a wikimedia site?

I am wanting to make a table of contents like the one shown here:

http://en.wikipedia.org/wiki/Red_Dwarf

I noticed i can get the right justified images by clicking "Edit" on the article and finding the relevant code. However, i cant find the code for the Contents table. Right where its meant to be there is nothing. How can i achieve these highly useful tables? Thanks!

216.173.145.47 (talk) 03:41, 28 June 2013 (UTC)[reply]

It is added automatically if an article has sections. There is a way of suppressing it, but you don't have to do anything special to get it. Looie496 (talk) 04:04, 28 June 2013 (UTC)[reply]

That's nearly correct. The TOC will automatically be put in if the article has at least four sections. Dismas|^(talk) 04:21, 28 June 2013 (UTC)[reply]

This information is correct. Thank you! 216.173.145.47 (talk) 04:27, 28 June 2013 (UTC)[reply]

Detecting HTML 5 support (in general, and specifically on Wikipedia)

How does a web page detect if a browser can use HTML 5 video? If I go to WP:VE, it says I should use an "[HTML 5 video browser]" and the video won't play. But, if I go to Apple's HTML 5 test site [1], the video plays without any problems. So, generally, how does a website or widget detect whether or not I have an HTML 5 browser? And, specifically, why does Wikipedia think I don't have one, when the Apple HTML 5 video works fine? I haven't tried any other HTML 5 video, and I am using Safari 5.1.8. RudolfRed (talk) 06:16, 28 June 2013 (UTC)[reply]

Excel number crunching - am I missing a trick?

Hi there,

So I've got another question about excel lists and was wondering if anyone could help me.

Essentially the table looks a bit like the following table, except it's got over 15000 rows.

Name	Value	Date
Bob Jones	200	1/6
Mike Evans	32	1/6
Suzy Boo	109	2/6
Roger Smith	24	3/6
Bob Jones	51	3/6
Suzy Boo	67	3/6
Henry Rogers	33	3/6
Dan Edwin	110	3/6

You'll see that some people appear in the table more than once. What I need to do is calculate the total "value" for each person - in some cases (eg in this example) they're going to have several entries (eg: Bob Jones = 200 + 51), and in some they'll only have one. I could sort it by name, but then I'll still have to go through it manually and find duplicate names. Is there an easy way to combine the "value" entry for identical "name" fields? In theory there's no limit to the number of times someone can appear in the table. Please let me know if you have any questions. Thank you! Seal Boxer (talk) 09:53, 28 June 2013 (UTC)[reply]

To get this:

Name	Value	Date	Total
Bob Jones	200	1/6	251
Mike Evans	32	1/6	32
Suzy Boo	109	2/6	176
Roger Smith	24	3/6	24
Bob Jones	51	3/6	251
Suzy Boo	67	3/6	176
Henry Rogers	33	3/6	33
Dan Edwin	110	3/6	110

Use this formula in cell D2 (assuming the cell with "Name" in is A1): =SUMIF($A$2:$A$9,A2,$B$2:$B$9). Rixxin (talk) 12:58, 28 June 2013 (UTC)[reply]

I would export the spreadsheet to R via csv and then use tapply or the plyr package.

E.g. export to csv from excel resulting in something like this:

data.csv

name, value, date
Bob Jones, 200, 1/6
Mike Evans, 32, 1/6
Suzy Boo, 109, 2/6
Roger Smith, 24, 3/6
Bob Jones, 51, 3/6
Suzy Boo, 67, 3/6
Henry Rogers, 33, 3/6

and then in R run

data = read.csv('data.csv')
merged.value = tapply(data$value, data$name, sum)
# e.g. to see the highest values (and the associated names) run
tail(sort(merged.value))

Learning the basics of R might take an evening but it's quickly going to be worth it if the alternative is using excel for everything. --81.175.227.88 (talk) 13:03, 28 June 2013 (UTC)[reply]

Copying and pasting the title of a newspaper adds additional text: what's the go with that?

Hi all,
I've often noticed when I add citations to articles from online newspaper sources, there is often additional data attached to the plain text in the title.
Example: when I fixed a dead link here from this source I was expecting to be able to paste into the {{cite news}} "title" field just "Art's Great Whodunit: The Mona Lisa Theft of 1911". No such luck.

The text is "Art's Great Whodunit: The Mona Lisa Theft of 1911"
When copied, the text is "Art's Great Whodunit: The Mona Lisa Theft of 1911 Read more: http://www.time.com/time/arts/article/0,8599,1894006,00.html#ixzz2XUy8liNs".

I do grok a little html, .css and .js, but I'm still 99.94% confused. Why does this happen? How does it work? Is this some way for the online works to keep track of their content?
Pete aka --Shirt58 (talk) 09:56, 28 June 2013 (UTC)[reply]

I've seen that happen - notably with MailOnline. I suspect they do it so they get the linkbait from unsuspecting people copy&pasting chunks out of their articles. Not entirely sure how, however. Seal Boxer (talk) 12:23, 28 June 2013 (UTC)[reply]

HTML analysis/compression/"un-templating"

Is there a library out there that detects patterns in a stream of HTML pages and then separates the common and more or less varying parts? This is difficult to search for since I don't really know what would be the keywords. --81.175.227.88 (talk) 12:15, 28 June 2013 (UTC)[reply]