Tuesday, October 17, 2017

How to find the number of HTML, JPG, etc. files in directories and subdirectories using Windows Power Shell

I wanted to count the number of HTML files in a website, as well as images, etc.

So that I didn't mess up the site I downloaded the files to my Windows 10 computer with FileZilla - a free FTP solution. I then went to the directory containing the documents I wanted to count in the Windows Power Shell - cd changes to a directory, cd .. backs up to the one above where you are.

You can find the Windows Power Shell in Windows 10 by going to the Windows Logo in the bottom left-hand corner of your screen, then choosing All Apps by clicking the bottom icon in the top left-hand corner, then scroll down to W and find Windows Power Shell.

Then I used the command (Get-ChildItem *.*htm* -recurse).count. *.*.htm* was the regular expression I used for a file name (* means anything) because some of the files ended in .shtml and others were .html and maybe some could have been .htm. Then for any files ending in .jp* that gets you jpg or jpeg, plus other variations you type in (Get-ChildItem *.jp* -recurse).count.

Similarly you can count:
 - PDF files with (Get-ChildItem *.pdf -recurse).count
 - PNG image files with (Get-ChildItem *.png -recurse).count


Thursday, February 09, 2017

Stamps.com Add-In Doesn't Work with 64-bit MS Word

Despite downloading the Add-in for Microsoft Word Home and Business 2016 to my Windows 10 64-bit machine it would not install. I could see the Add-in under File - Options - COM Add-ins, but despite trying to click the box to the left of it, it would not install.

After calling Stamps.com I found that it does not support 64-bit MS Word, it only supports the 32-bit version.

So to save you frustration I'm posting this to warn you.

A workaround is to print your envelopes using Mail Merge from MS Word without the stamps and then print them with stamps only from the online version of Stamps.com.

Here's more info  - lest you try to run 32-bit addins on a 64-bit installation.

I haven't tried Endicia? Are there other solutions?

http://stackoverflow.com/questions/3945799/using-32bit-com-addin-under-ms-office-64-bit

Check The Firewall For Norton Internet Security (as of Feb 2017) with Stamps.Com - or any other Program or App

This morning I checked the documentation on Stamps.com for how to configure the Norton Internet Security firewall and found it doesn't have the latest version. So here's how to do it (as it was I found it had already been configured when I eventually got to the right screen), but just in case you want to check too here are the screens.
First open Norton Internet Security. Then choose Settings at the top of the screen.
Next choose Firewall.

Then look at the tabs and choose Program Control.

You'll get a list of programs that are already penetrating the Firewall. It will tell you when you click on a program whether the Firewall is allowing one-way or two-way traffic and in which direction. Scroll down the window until you see the app. 

For Stamps.com the app is called ipostage.exe. Check that this file has supports two-way communications through the firewall.


Thursday, January 07, 2016

Getting a Netgear D7000 Router to work with AT&T DSL (and Google Chrome)

I wanted to replace my Netgear D6200 (AC1200) router with a Netgear D7000 (AC1900 Nighthawk), the latter purchased from Fry's in Palo Alto. The assistant in Fry's said it would work with AT&T, but that I must call AT&T first otherwise it wouldn't work. Note this router does not work with UVerse. This is my fourth Netgear Router - the first one failed after years of use, the 2nd one was too feeble and the 3rd one was barely adequate as in bad weather the signal gave red signals on our repeater.  Furthermore, the new router had 2 USB 3.0 ports whereas the old one only had one USB 2.0 port.
You can manage the user interface from a web browser or Netgear's Genie App. I chose to manage it using Google Chrome by typing the URL routerlogin.net (or 192.168.0.1 - which I usually change to 192.168.1.1).

Setup Problems

I set my new router to exactly the same settings as my old router and it didn't connect. The Internet light was orange and the DSL light was unlit. I tried both the new VDSL filter and old ADSL filters that came with the older routers. I could not get it to light up. I even tried putting in a Polarity Reverser for the phone line (the router works on wires 2 and 3) lest the cable was bad.

Calling AT&T

So I called AT&T. First I called a "special number" that had been sent to me by email when I last had DSL problems. This was only Tier 1 support outside of office hours - despite the fact it says it works until midnight Eastern Time. I then called the regular support number  - they said I needed the AT&T service that deals with third party devices - (866) -293-3464. This took me through the same line tests as the regular support number, but finally a friendly technician came on the line.
We went through the settings and discovered:

  • the DSLconnection only worked when there was no filter
  • when it did connect the password was wrong

DSL Connection

To make this work try it without the filter on the line. I replaced the filter with a line splitter.  It seems the D7000 needs to be rebooted if you unplug and reconnect the DSL cable.  The router is also very slow to boot up - the last thing to come on is the DSL light. So be patient when booting it. I will just use a line splitter for the phone and not the VDSL or ADSL filter so I can run a rarely used fax on the same line.

Google Chrome Was Changing The Password

When I typed the email address xxx@sbcglobal.net it came up yellow. I then typed the AT&T assigned password. It had 6 characters but the number of "*"s replacing it was more than 6.  AT&T said this was normal  (in fact it is not, you should get 6 stars for 6 characters). So what was happening?  AT&T Tier 2 support told me that the password was wrong. I suddenly twigged.  Google Chrome was changing the password after I had entered it. That is why the login credentials were colored yellow.  Either that or AT&T had a dynamic password system turned on - that only affected that particular router - seems unlikely.
The remedy was to remove the login ID and password and select Apply, then retype them. AT&T had the right password. I also changed to Microsoft's Edge browser just to check that it too had the right password.

The Parameters

I am in Portola Valley, CA and these are the parameters I need for AT&T DSL.
  • Country - USA
  • Internet Service Provider - Other (seems to work better than AT&T). Note: first time I set it to Other the fields for choosing service provider disappeared to 1 character wide on reboot and I had to reset the D7000 to factory settings using a paper clip (push it in for 5 seconds or more - I think this is OK now though - maybe I hit Next too fast in the Setup Wizard - better not to use the Wizard).
  • Transfer Mode - ADSL (ATM)
  • DSL Mode - Auto (actually ADSL2+ was what the D6200 supports and you could probably select that too)
  • Internet - enable by checking the box - LLC-BASED
  • VPI - 0 (this needs changing from the default)
  • VCI - 35
  • Don't check Use VLANID
  • Does your Internet connection require a login - type Yes and supply credentials
  • Encapsulation - PPPoE
  • Service name - can leave blank
  • Connection Mode - Always On
  • Idle Timeout (minutes) - can leave at 0
  • Internet IP Address and Domain Name Server (DNS) Address - Get Dynamically from ISP - unless you are paying for a static address as you might if you have a website
  • NAT (Network Translation Address) - Enable (you probably need this if you have a bunch of devices using the router)
  • Router MAC Address - Use Default Address
So you may not have to call AT&T after all.