Jump to content

Wikipedia:Reference desk/Archives/Computing/2014 July 13

From Wikipedia, the free encyclopedia
Computing desk
< July 12 << Jun | July | Aug >> July 14 >
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.


July 13

[edit]

Where are my emails?

[edit]

Hopefully this is a simple qustion.

I'm getting rid of a laptop and I want to copy all the useful data from it first, onto a portable hard drive.

My documents were easy to find and copy. But what about all my emails? Where are they to be found?

It's a Windows 8 machine running MS Outlook.

Best, AndyJones (talk) 15:18, 13 July 2014 (UTC)[reply]

If you really mean Outlook (and not Outlook Express, which despite the similar name is really very different inside) then the location of the .PST file with your email is here. A warning: if you're hoping to change to a different email client (Windows Live Mail, Thunderbird, etc.) on your new machine, the safest idea is usually to install a copy of that on the old machine, have it import from Outlook, and then migrate across the data files of the new app to the new machine. This is because Outlook's native PST format is proprietary and only imperfectly understood outside Microsoft. -- Finlay McWalterTalk 15:26, 13 July 2014 (UTC)[reply]
Note that the AppData portion of the address, in the page I linked above, may be hidden. So to navigate to it with Windows Explorer, you might either have to manually type that portion into the address bar, or enable viewing hidden files as described here. -- Finlay McWalterTalk 15:44, 13 July 2014 (UTC)[reply]

Can an anti-virus be dangerous?

[edit]

It will have to access processes running and files, so these will have to be made accessible to it (and consequentially to other programs). I mean a common anti-virus from a serious company and not malware trying to pass as anti-virus. OsmanRF34 (talk) 18:21, 13 July 2014 (UTC)[reply]

Antivirus programs can (and do) have higher OS privileges than other software so that they can inspect executable files and process memory without that information necessarily being available to other software.
However, antivirus products are as buggy as other consumer software, and because of their higher privileges a bug is more likely to be usable to compromise the whole system. Here are a couple of papers that list various attacks: Attacking Antivirus by Feng Xue and Applied attacks against Sophos Antivirus by Tavis Ormandy. -- BenRG (talk) 18:04, 14 July 2014 (UTC)[reply]

Corrupt .docx file, need help urgently

[edit]

Dear everyone, I'm in deep trouble. I've been working on a project for over two weeks now, when LibreOffice suddenly closed the file... and I cannot recover it, when it opens, it's about a fourth of what it should be (i. e. about 110000 chars instead of close to half a million)... but the size it shows is right, it's close to a meg, so it seems all the content is still in there. It's a .docx (my mistake) that I've been working on under LibreOffice 4.2.1.1. running on Fedora 20. I've tried, to no avail, MS Word 2013 and 2007 to which I have access, as well as OOo, which is hanging up on me right now on my wife's machine. If anyone has any suggestions or expertise that may help, it's welcome. I've uploaded the file here if anyone would like to take a jab at it. Thanks for any input! Cheers, Ouro (blah blah) 18:45, 13 July 2014 (UTC)[reply]

.odt -- Finlay McWalterTalk 19:09, 13 July 2014 (UTC)[reply]
My heart jumped... but still, the file amounts to 110026 chars only... and it should be in excess of four times more... the text cuts of at 'Assets' while there should be much, much more... --Ouro (blah blah) 19:11, 13 July 2014 (UTC)[reply]
That's a cautionary tale about having good back-up habits. OsmanRF34 (talk) 19:32, 13 July 2014 (UTC)[reply]
More important than uploading the corrupt file is to find a temporary file somewhere in your computer. OsmanRF34 (talk) 19:36, 13 July 2014 (UTC)[reply]
Maybe it is, hell, this is the first time something like this has happened to me. I can't find any temporary file where it should be (as LO indicates the /tmp folder for temporary file storage, but no dice). --Ouro (blah blah) 19:51, 13 July 2014 (UTC)[reply]
I could find this, try to find any of the files listed below.OsmanRF34 (talk) 20:13, 13 July 2014 (UTC)[reply]
Extended content

M Filemode Length Date Time File - ---------- -------- ----------- -------- ------------------------------

 -rw-rw-rw-       573  13-Jul-2014  17:41:58  _rels/.rels
 -rw-rw-rw-       279  13-Jul-2014  17:41:58  customXml/_rels/item1.xml.rels
 -rw-rw-rw-       324  13-Jul-2014  17:41:58  customXml/itemProps1.xml
 -rw-rw-rw-       244  13-Jul-2014  17:41:58  customXml/item1.xml
 -rw-rw-rw-      7056  13-Jul-2014  17:41:58  word/theme/theme1.xml
 -rw-rw-rw-       308  13-Jul-2014  17:41:58  word/settings.xml
 -rw-rw-rw-      1251  13-Jul-2014  17:41:58  word/_rels/footnotes.xml.rels
 -rw-rw-rw-     23911  13-Jul-2014  17:41:58  word/_rels/document.xml.rels
 -rw-rw-rw-      1871  13-Jul-2014  17:41:58  word/fontTable.xml
 -rw-rw-rw-    265525  13-Jul-2014  17:41:58  word/footnotes.xml
 -rw-rw-rw-       694  13-Jul-2014  17:41:58  word/footer7.xml
 -rw-rw-rw-      4200  13-Jul-2014  17:41:58  word/header5.xml
 -rw-rw-rw-       694  13-Jul-2014  17:41:58  word/footer5.xml
 -rw-rw-rw-      3434  13-Jul-2014  17:41:58  word/header6.xml
 -rw-rw-rw-     13380  13-Jul-2014  17:41:58  word/media/image20112.emf
 -rw-rw-rw-     35540  13-Jul-2014  17:41:58  word/media/image20114.png
 -rw-rw-rw-     16492  13-Jul-2014  17:41:58  word/media/image20109.emf
 -rw-rw-rw-     19860  13-Jul-2014  17:41:58  word/media/image20106.emf
 -rw-rw-rw-     13852  13-Jul-2014  17:41:58  word/media/image20105.emf
 -rw-rw-rw-      6236  13-Jul-2014  17:41:58  word/media/image20104.emf
 -rw-rw-rw-     23272  13-Jul-2014  17:41:58  word/media/image20111.emf
 -rw-rw-rw-      6236  13-Jul-2014  17:41:58  word/media/image20103.emf
 -rw-rw-rw-     24740  13-Jul-2014  17:41:58  word/media/image20102.emf
 -rw-rw-rw-     17952  13-Jul-2014  17:41:58  word/media/image20100.emf
 -rw-rw-rw-     29406  13-Jul-2014  17:41:58  word/media/image20097.png
 -rw-rw-rw-     18880  13-Jul-2014  17:41:58  word/media/image20096.emf
 -rw-rw-rw-      1316  13-Jul-2014  17:41:58  word/media/image20095.emf
 -rw-rw-rw-      7212  13-Jul-2014  17:41:58  word/media/image20092.emf
 -rw-rw-rw-     29292  13-Jul-2014  17:41:58  word/media/image20091.emf
 -rw-rw-rw-     28116  13-Jul-2014  17:41:58  word/media/image20099.emf
 -rw-rw-rw-     27304  13-Jul-2014  17:41:58  word/media/image20090.png
 -rw-rw-rw-     27587  13-Jul-2014  17:41:58  word/media/image20089.png
 -rw-rw-rw-     34190  13-Jul-2014  17:41:58  word/media/image20087.png
 -rw-rw-rw-     23864  13-Jul-2014  17:41:58  word/media/image20086.png
 -rw-rw-rw-     16682  13-Jul-2014  17:41:58  word/media/image20085.png
 -rw-rw-rw-      8187  13-Jul-2014  17:41:58  word/media/image20108.png
 -rw-rw-rw-     38726  13-Jul-2014  17:41:58  word/media/image20083.png
 -rw-rw-rw-     35275  13-Jul-2014  17:41:58  word/media/image20078.png
 -rw-rw-rw-     22428  13-Jul-2014  17:41:58  word/media/image20077.emf
 -rw-rw-rw-     13700  13-Jul-2014  17:41:58  word/media/image20075.emf
 -rw-rw-rw-      3700  13-Jul-2014  17:41:58  word/media/image20074.emf
 -rw-rw-rw-     16122  13-Jul-2014  17:41:58  word/media/image20071.png
 -rw-rw-rw-     18040  13-Jul-2014  17:41:58  word/media/image20070.emf
 -rw-rw-rw-      3696  13-Jul-2014  17:41:58  word/media/image20067.emf
 -rw-rw-rw-     31120  13-Jul-2014  17:41:58  word/media/image20064.emf
 -rw-rw-rw-      3220  13-Jul-2014  17:41:58  word/media/image20072.emf
 -rw-rw-rw-     13376  13-Jul-2014  17:41:58  word/media/image20059.emf
 -rw-rw-rw-      8012  13-Jul-2014  17:41:58  word/media/image20058.emf
 -rw-rw-rw-     31415  13-Jul-2014  17:41:58  word/media/image20063.png
 -rw-rw-rw-      8472  13-Jul-2014  17:41:58  word/media/image20057.emf
 -rw-rw-rw-      7504  13-Jul-2014  17:41:58  word/media/image20056.emf
 -rw-rw-rw-     12744  13-Jul-2014  17:41:58  word/media/image20055.emf
 -rw-rw-rw-     33424  13-Jul-2014  17:41:58  word/media/image20052.emf
 -rw-rw-rw-     31476  13-Jul-2014  17:41:58  word/media/image20062.emf
 -rw-rw-rw-     16820  13-Jul-2014  17:41:58  word/media/image20050.png
 -rw-rw-rw-     14668  13-Jul-2014  17:41:58  word/media/image20101.emf
 -rw-rw-rw-     23272  13-Jul-2014  17:41:58  word/media/image20048.emf
 -rw-rw-rw-     14648  13-Jul-2014  17:41:58  word/media/image20046.emf
 -rw-rw-rw-     15636  13-Jul-2014  17:41:58  word/media/image20081.emf
 -rw-rw-rw-     11584  13-Jul-2014  17:41:58  word/media/image20045.emf
 -rw-rw-rw-      7992  13-Jul-2014  17:41:58  word/media/image20069.emf
 -rw-rw-rw-     10564  13-Jul-2014  17:41:58  word/media/image20047.emf
 -rw-rw-rw-     33973  13-Jul-2014  17:41:58  word/media/image20043.jpeg
 -rw-rw-rw-     10520  13-Jul-2014  17:41:58  word/media/image20051.emf
 -rw-rw-rw-       934  13-Jul-2014  17:41:58  word/media/image20040.png
 -rw-rw-rw-     15280  13-Jul-2014  17:41:58  word/media/image20060.emf
 -rw-rw-rw-     35611  13-Jul-2014  17:41:58  word/media/image20079.png
 -rw-rw-rw-      5866  13-Jul-2014  17:41:58  word/media/image20042.png
 -rw-rw-rw-      8496  13-Jul-2014  17:41:58  word/media/image20039.emf
 -rw-rw-rw-      3696  13-Jul-2014  17:41:58  word/media/image20076.emf
 -rw-rw-rw-      9408  13-Jul-2014  17:41:58  word/media/image20068.emf
 -rw-rw-rw-     29276  13-Jul-2014  17:41:58  word/media/image20038.emf
 -rw-rw-rw-      9924  13-Jul-2014  17:41:58  word/media/image20041.emf
 -rw-rw-rw-     63916  13-Jul-2014  17:41:58  word/media/image20037.emf
 -rw-rw-rw-      7672  13-Jul-2014  17:41:58  word/media/image20035.emf
 -rw-rw-rw-     22764  13-Jul-2014  17:41:58  word/media/image20113.emf
 -rw-rw-rw-     27540  13-Jul-2014  17:41:58  word/media/image20036.emf
 -rw-rw-rw-     34576  13-Jul-2014  17:41:58  word/media/image20033.emf
 -rw-rw-rw-     24170  13-Jul-2014  17:41:58  word/media/image20054.png
 -rw-rw-rw-     13852  13-Jul-2014  17:41:58  word/media/image20110.emf
 -rw-rw-rw-      6682  13-Jul-2014  17:41:58  word/media/image20107.png
 -rw-rw-rw-      1855  13-Jul-2014  17:41:58  word/media/image20031.png
 -rw-rw-rw-         0  13-Jul-2014  17:41:58  word/media/image20029
 -rw-rw-rw-      8148  13-Jul-2014  17:41:58  word/media/image20093.emf
 -rw-rw-rw-     27760  13-Jul-2014  17:41:58  word/media/image20028.emf
 -rw-rw-rw-     67252  13-Jul-2014  17:41:58  word/media/image20026.png
 -rw-rw-rw-     15176  13-Jul-2014  17:41:58  word/media/image20084.png
 -rw-rw-rw-     16768  13-Jul-2014  17:41:58  word/media/image20082.emf
 -rw-rw-rw-       840  13-Jul-2014  17:41:58  word/media/image20024.emf
 -rw-rw-rw-     35264  13-Jul-2014  17:41:58  word/media/image20049.emf
 -rw-rw-rw-      1320  13-Jul-2014  17:41:58  word/media/image20094.emf
 -rw-rw-rw-      1316  13-Jul-2014  17:41:58  word/media/image20023.emf
 -rw-rw-rw-     22788  13-Jul-2014  17:41:58  word/media/image20027.emf
 -rw-rw-rw-     91780  13-Jul-2014  17:41:58  word/media/image20025.png
 -rw-rw-rw-      4895  13-Jul-2014  17:41:58  word/media/image20030.png
 -rw-rw-rw-      1804  13-Jul-2014  17:41:58  word/media/image20065.emf
 -rw-rw-rw-      9424  13-Jul-2014  17:41:58  word/media/image20034.emf
 -rw-rw-rw-     13123  13-Jul-2014  17:41:58  word/media/image20098.png
 -rw-rw-rw-      1320  13-Jul-2014  17:41:58  word/media/image20022.emf
 -rw-rw-rw-      3700  13-Jul-2014  17:41:58  word/media/image20073.emf
 -rw-rw-rw-      1792  13-Jul-2014  17:41:58  word/media/image20021.emf
 -rw-rw-rw-     36552  13-Jul-2014  17:41:58  word/media/image20088.emf
 -rw-rw-rw-      1792  13-Jul-2014  17:41:58  word/media/image20020.emf
 -rw-rw-rw-      6268  13-Jul-2014  17:41:58  word/media/image20061.emf
 -rw-rw-rw-      3700  13-Jul-2014  17:41:58  word/media/image20080.emf
 -rw-rw-rw-      1316  13-Jul-2014  17:41:58  word/media/image20019.emf
 -rw-rw-rw-      7284  13-Jul-2014  17:41:58  word/media/image20066.emf
 -rw-rw-rw-     13380  13-Jul-2014  17:41:58  word/media/image20053.emf
 -rw-rw-rw-     12464  13-Jul-2014  17:41:58  word/media/image20044.emf
 -rw-rw-rw-     21024  13-Jul-2014  17:41:58  word/media/image20032.emf
 -rw-rw-rw-      2268  13-Jul-2014  17:41:58  word/media/image20018.emf
 -rw-rw-rw-     34486  13-Jul-2014  17:41:58  word/numbering.xml
 -rw-rw-rw-       694  13-Jul-2014  17:41:58  word/footer4.xml
 -rw-rw-rw-       694  13-Jul-2014  17:41:58  word/footer3.xml
 -rw-rw-rw-       694  13-Jul-2014  17:41:58  word/footer6.xml
 -rw-rw-rw-      3148  13-Jul-2014  17:41:58  word/header7.xml
 -rw-rw-rw-      3431  13-Jul-2014  17:41:58  word/header4.xml
 -rw-rw-rw-       694  13-Jul-2014  17:41:58  word/footer1.xml
 -rw-rw-rw-       692  13-Jul-2014  17:41:58  word/header1.xml
 -rw-rw-rw-       692  13-Jul-2014  17:41:58  word/header2.xml
 -rw-rw-rw-      3433  13-Jul-2014  17:41:58  word/header3.xml
 -rw-rw-rw-     41981  13-Jul-2014  17:41:58  word/styles.xml
 -rw-rw-rw-       694  13-Jul-2014  17:41:58  word/footer2.xml
 -rw-rw-rw-   2109164  13-Jul-2014  17:41:58  word/document.xml
 -rw-rw-rw-       419  13-Jul-2014  17:42:00  docProps/app.xml
 -rw-rw-rw-       588  13-Jul-2014  17:42:00  docProps/core.xml
 -rw-rw-rw-     10897  13-Jul-2014  17:42:00  [Content_Types].xml

- ---------- -------- ----------- -------- ------------------------------

              4196524                         127 files
No success. I've tried searching manually, and by using find and by using locate. No hits of relevance.
You extracted this from the file I uploaded, right? Perhaps there is a way to extract just some of these files? The document with the actual file contents, most probably document.xml, is the one that I'd need most. How did you come around to this list? Perhaps I can do it on my own? --Ouro (blah blah) 20:41, 13 July 2014 (UTC)[reply]
All right, I know how you did this now :) and I extracted that file, and it seems the document is more or less still in there. So now, theoretically, I need to check file by file which one of them is corrupt, and then somehow attempt to repair it and theoretically the original .docx file would be correct... or would it? --Ouro (blah blah) 20:48, 13 July 2014 (UTC)[reply]
Just need to strip the tags away from that file somehow and I think I'm home... --Ouro (blah blah) 21:26, 13 July 2014 (UTC)[reply]
Happy to see that. If you have the text, and it is more or less complete, I'd try to re-make the document, not worry about corrupted files. That would be a way of reviewing the text too.OsmanRF34 (talk) 21:35, 13 July 2014 (UTC)[reply]
I would review it anyway, for sure. And I think that's the way I'm gonna go, remove the tags and copy-paste the entire thing into a new document. --Ouro (blah blah) 21:44, 13 July 2014 (UTC)[reply]
Stripped. I'm going to bed. Thanks for Your help, Osman! --Ouro (blah blah) 21:49, 13 July 2014 (UTC)[reply]

sql query

[edit]

I am a beginner in oracle database and there are two questions i want to ask. 1.all DMl operations are auto-commit but still Is there any way to retrieve a dropped column in oracle 10g or 11g. 2 there is a column named SAL with say x(y) being datatype(size) and i need to convert it into as accepting p integers and q decimals. what is/are the sql command(s) for it."set" is not allowed.182.18.179.2 (talk) 19:01, 13 July 2014 (UTC)[reply]