News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • mn–

    Forum Replies Created

    Viewing 15 posts - 1 through 15 (of 971 total)
    • Author
      Posts
    • in reply to: Setting up backup in Mint Mate 19.2 OS #2006835

      mn–
      AskWoody Lounger

      What you want is to identify the WD My Passport external USB drive that you wish to reformat. I’m guessing that it’s what Mint has labeled “sdg” in your post above, but you need to make darn sure of it before proceeding with the reformat.

      Also gparted has that “View” menu. I suggest turning on View -> Device Information so you can check model and serial numbers. Should open a side pane.

      You could also pay attention to the mount point information if it’s shown. Fairly fundamental information on Linux that “/” is your currently running system disk. USB media may be autoattached to places like /media/user/something and normally can be unmounted using that button if you’re not actively using anything there. (Having a terminal window open in there counts as active.)

      The drive that Mint is designating as “sda” will typically be the boot drive. (I see that @wavy has addressed this point–thanks!) Other drives will be “sdb,” “sdc,” and so on.

      Typically but by no means certain, and you can’t rely on that not changing between boots either. It goes by initialization order, so if your motherboard is built to do USB before (some) SATA …

      (Mine does exactly this. The normal SATA slot is always sda, then any USB drives present during bootup, and only then the mSATA slot where I have my / … yes, I have a larger spinning drive in the normal SATA slot and a smaller faster SSD in the mSATA. Also gparted doesn’t show where I keep my / because of my encryption setup…)

      3 users thanked author for this post.
    • in reply to: Identify problem characters #2006701

      mn–
      AskWoody Lounger

      However in a subsequent test I then changed data in one of the cells (the first cell after the dots) from 137WEB to 136WEB. This was a change common to modify this sheet prior to upload and after making this change, it was not highlighted.

      Does that mean that the changes highlighted have nothing to do with “real” changes but only relate to invisible formatting?

      Changing between a dot and a comma, as shown in the screenshot, tends to be extremely significant in a csv. It stands for “comma separated values”, after all. So,

      Price 20,.137WEB

      is 2 data cells so goes in two columns and

      Price 20..136WEB

      is a single data cell. As in single column.

      And everything else on that row after the change is then shifted one column…

      If your tool does this change silently, you need to fix or replace that tool.

      data that is being entered by customers (sometimes invisible when they may use a cut and paste from a browser helper and this way not using proper csv characters or as MN- suggested perhaps using a different MS office language plugin. Ideally when a file is being rejected for import, I would like to have a feature/ application/ macro that would allow me to pinpoint the “offending” entry

      Yeah, the problem is in part that there is no such thing as invalid character in a csv file in general. Any applications that I know of, accept only a small subset of the possible csv contents.

      You’d need to have the filter tool written for your application specifically, and this’ll need specific knowledge on what is allowed and what goes where, so that all the rows have the right number of columns and the like.

      This is possible, but to determine if it’ll be easy or difficult already requires more application-specific knowledge.

      I do get the warning each time when saving some formatting being incompatible and I click yes to save (as csv). I am not sure if someone saved this as xls first and then resaved as csv this would lead to the original failure?

      Oh, Excel does that if you do pretty much anything at all.

      See, Excel likes to save view state, as in which columns and rows were last visible if it doesn’t all fit on screen, and… And there’s just no place to save that information in a csv.

      Excel isn’t very good with csv files.

    • in reply to: Firefox – Do I need to make new Rescue Media? #2006682

      mn–
      AskWoody Lounger

      Um. I don’t think you should need a dedicated rescue media for Firefox.

      The normal Windows one is usually prudent to have, yes, and regular backups… but you could just make regular on-disk copies of the Firefox settings folder and have them included in the backups.

      Anything that clobbers those would usually make a mess of the rest of your system too, not just Firefox, and in that case you’d need the Windows rescue media and backups anyway.

    • in reply to: New pc Outlook 2016 contacts missing #2006674

      mn–
      AskWoody Lounger

      Well, Outlook has multiple possible locations to store an address book so the another file is not impossible.

      Also if you’d set a non-default address book folder in a .pst, the data may be there but not automatically used.

      But, then there’s the address autocomplete cache that some people mistake for a contacts list… which it isn’t, and is stored differently. Also a bother to move if it isn’t a .nk2 file.

      See https://support.office.com/en-us/article/import-or-copy-the-auto-complete-list-to-another-computer-83558574-20dc-4c94-a531-25a42ec8e8f0 for that case.

      Windows activation is not likely to be relevant.

    • in reply to: Identify problem characters #2006390

      mn–
      AskWoody Lounger

      Is there any formula or function to run against the original csv file to figure out the culprit?

      Not in the general case as csv just isn’t standardized very well… heh, Microsoft Office 365 web management often produces csv files that cannot be opened in Microsoft Office local applications…

      However, in this specific case you may already have a clue you could use…

      We then copied the full data set into a new csv file with values only. The upload then worked as expected.

      You could just compare the old and new files with an appropriate tool. You know, with a hexadecimal view, because that’ll show you any “non-character” content too.

      2 users thanked author for this post.
    • in reply to: error 0X800CCC1A #2005265

      mn–
      AskWoody Lounger

      Hm, did Outlook happen to update at the same time, and what patch of 1903 did you update from?

      Because, there were SSL/TLS changes in the October 8 updates and if your previous version was earlier than that…

      Yes, that error code is different from those listed in
      https://support.microsoft.com/en-us/help/4528489/transport-layer-security-tls-connections-might-fail-or-timeout-when-co but might be related anyway.

    • in reply to: November 2019 Patch Tuesday arrives #2004750

      mn–
      AskWoody Lounger

      Okay, one W10 1809 (Pro 64) box installing KB4523204 and KB4523205 without being told to. As in policy-managed, not approved.

      … BUT apparently another third-party tool that can trigger updates WAS run today.

      Sheesh, herding cats and all…

      At least nothing seems to have broken yet.

    • in reply to: Setting up backup in Mint Mate 19.2 OS #2006848

      mn–
      AskWoody Lounger

      Oh, you can also go look in /dev/disk/by-id/ or /dev/disk/by-path/ – those get filled with symlinks to the sdX devices and such.

      Especially the by-path one is interesting for those who have numbered SATA connectors on the motherboard and may need to figure out which one goes where.

      And these are supposed to be persistent without regard to other devices or initialization order.

      1 user thanked author for this post.
    • in reply to: Identify problem characters #2006449

      mn–
      AskWoody Lounger

      I suspect that during the processing of the file, we somehow saved it incorrectly thus messing up the characters but I don’t know enough to draw any other conclusions. It seems to me it is not a specific field that was wrong. Does the additional ” appearing in all the fields shed any more light on this?

      The thing is, CSV is not defined precisely enough to determine this from the file itself. As per RFC 4180, either with the ” or without it is allowed, but so is having the fields in EBCDIC instead of ASCII.

      You need to determine the exact requirements from the application. And as to how to produce files that conform to that, depends on where those come from…

      Microsoft applications in particular are known to be picky about CSV files with no good reason, even to the extent that a CSV file produced in MS Excel set to a random European locale might not work in same version of MS Excel set to “US English”.

    • in reply to: When Windows 10 Feature Updates don’t go smoothly #2006405

      mn–
      AskWoody Lounger

      The only common thread in all of this lots-of-issues vs no-issues, is never skipping an update/upgrade except drivers.

      Well, except for the part where the same symptoms sometimes happen on a brand new PC, on first user login after domain join. (Worked for local admin, worked for domain admin, error for domain user with domain-granted local admin rights. No feature updates installed after factory. User’s Windows 7 PC continues to work.)

      1 user thanked author for this post.
    • in reply to: Intel chip security flaws remain #2006404

      mn–
      AskWoody Lounger

      Well, it is not that they can’t develop new CPUs; rather, until relatively recently it has been something that was not cost-effective for them to do.

      Indeed, it’s something they already did. Just didn’t sell well enough.
      Really, was pretty consistent about the sidechannel attacks… “IA-64 is not vulnerable”

    • in reply to: Considering upgrade, which components are worth retaining? #2006384

      mn–
      AskWoody Lounger

      Most of the alerts I am seeing relate to motherboard and CPU temperatures and core voltages, which is why I think the MB and CPU are what I would change first. The graphics card was the most expensive part of the original build and I love the Sonar sound card.

      Yeah, the sound card is one part where new units aren’t noticeably better for the price, and it’s also unlikely to be the cause of your current problems. (It is a PCIe version, right? Current motherboards don’t come with old-style PCI slots much…)

      I’d probably also keep the optical drive unless you’d be upgrading to something that writes M-Disc too.

      Can’t think of any direct reason to replace keyboard and mouse.

      Graphics cards have had a lot of development and the 7970 is a bit of a power hog. Graphics is also unfortunately quite close to the critical path in a lot of things… though the 7970 is a real beast with FP64 performance so if that’s what your computing needs, it’ll be hard to replace.

      BUT… cooling is actually one thing that can fail easily. Fan bearings wear out, current draw increases so voltage drops, and airflow is reduced… especially if there’s dust buildup anywhere. Also thermal pastes can dry out.

      Also, voltage fluctuations are typically a PSU fault and can cause secondary effects — and that’s typically less work to replace than any of the more active components. And replacing the PSU would also be prudent with anything else.

      So, first thing, I’d check for dust buildup and that all fans rotate easily, including those integrated into the PSU and graphics.

      Then if that didn’t help, I’d replace the PSU and see if replacing the thermal compounds in the CPU and such is feasible on this setup.

      Only if that doesn’t help either, I’d then replace the motherboard and CPU, and get a NVMe SSD with those.

      Oh, one important thing – if this is a business-critical system… I’d get a second PC equipped for all of your critical work before touching this one.

      1 user thanked author for this post.
    • in reply to: When Windows 10 Feature Updates don’t go smoothly #2006351

      mn–
      AskWoody Lounger

      … and with reason.

      Because this is the EXACT symptom that some users seem to have on move to Windows 10.

      Preinstall W10 Pro, preload end-user specific preloadable application kit. Go to user desk, shutdown and unplug Windows 7 PC, plug in new one. Log in as local admin, join to domain, run gpupdate just in case.

      Test login as generic admin with domain account, working.
      Log in as designated end user (who even for the moment has local admin rights through their domain login!) … “Hi” loop, gpsvc errors, “windows\system32\config\systemprofile\desktop is unavailable”.

      Put the old Windows 7 box back in and take the new one back to IT …

      So yeah. This one can happen for only some users on a shared PC, and also on other than first login after update.

      And I still don’t actually know what causes it… I have some educated guesses though.

    • in reply to: error 0X800CCC1A #2005353

      mn–
      AskWoody Lounger

      Hope you followed the advice when 1903 was still current and saved one of those…?

      At some earlier points Microsoft offered a selection on the download screen, hm, was it 1809 or 1903 at the time… well, now it seems to be 1909 only on the “regular” MS page.

    • in reply to: Intel chip security flaws remain #2005235

      mn–
      AskWoody Lounger

      … Really, would’ve been nice if IA-64 had gotten more market share. The architecture was (well, “is”, because apparently they can still be ordered until January) different enough that it at least doesn’t have the same flaws…

      Unlike things like POWER, Sparc, Arm and such that do have at least the general category of speculative/timing-based sidechannel attack possible.

    Viewing 15 posts - 1 through 15 (of 971 total)