wehuberconsultingllc.com

CSVed 2.2.1

Bill — Fri, 04 May 2012 18:35:00 +0000

I was in need of a way to create a simple HTML table from an Excel spreadsheet. The “Save As” option in Excel created the standard Microsoft messy HTML. The Google Docs version was not much better. I finally ended up cleaning it up by hand. Then I tried CSVed. This is a good solution for this problem and other CSV problems. You can read the clipboard directly and export a fairly minimal HTML file.

My final solution was to write a PowerShell script that read the clipboard, transformed the data into a simple HTML table, and then sent the text back to the clipboard. A clipboard manager like Clipboard Manager is probably a necessity to manage the clips if you don’t get the correct results the first time.

CSVed is an easy and powerful CSV file editor, you can manipulate any CSV file, separated with any separator.

some features:

edit, add, insert and delete items;
import;
change separator;
add, delete columns;
rearrange column order;
save selection of rows and columns;
save filtered items;
save with double quotes;
search and replace;
filter items;

remove duplicates;
append and merge files;
install and uninstall
help in English
add prefix and suffix
split and join columns
export to HTML, Excel, Word, XML and more
proper words and strings
column search
column sort and global sort

The listview is running in virtual mode, that means the data is displayed on demand. (not the entire CSV file is loaded in the listview) so CSVed can handle big files and is very fast.
In other words, you can do everything with a CSV file you wanted. CSV is cardware.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Goodbye Twenga

Bill — Fri, 13 Apr 2012 17:52:25 +0000

Recently we had a performance problem that I traced back to shopping site called www.twenga.com. They were generating a lot of requests so I updated the the robots.txt file to slow everyone down and updated the robots.pm file used by awstats to see how much traffic Twenga and a couple others were generating. After a couple of days I decided I had enough and banned Twenga via the robots.txt file. They had consumed over 1.6 GB in the first week of April which was several times more traffic than robots like Google and Bing. Since we do not get any sales from Twenga it was an easy decision.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Is the end of Internet Explorer closer than we think?

Bill — Fri, 24 Feb 2012 20:59:50 +0000

I have been using Google Chrome for the last month at work. It started out as a frustrated response to Internet Explorer crashing random tabs. Then it became an experiment since although it was much faster than IE there were some applications that did not play nicely with Chrome. Now that I have worked through the problems, it is my production browser. On the other hand I still use Internet Explorer at home since I do not have the crashing tab problem. Considering the size of the smartphone and tablet market, if Internet Explorer cannot decisively when the desktop market the end is drawing near.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Why do I get 80072EE2 errors?

Bill — Fri, 24 Feb 2012 20:45:42 +0000

It took me awhile to track down the culprit for the 800732EE2 errors. We verify all FedEx ground shipping addresses by making a call to the FedEx API when we print the packing slips. Our Priority Mail vendor, Endicia, will not let us print a label with an invalid address. FedEx Express packages will not print the label with an invalid address. For some reason FedEx allows Ground/Home packages to go out with an invalid shipping address but then they would ding us $11 for each invalid address. I fixed the problem by automatically checking addresses. I don’t know where I got the original code but the timeouts worked for every day except the first printout on Monday morning. On Monday mornings we print a lot of packing slips so the ten second receive timeout did not work.

Why do I get 80072EE2 errors?

msxml3.dll error ’80072ee2′
The operation timed out

This means that the site you were trying to parse either could not be found, and the component gave up; or it is taking far too long for the page to finish loading. One way you can avoid this error is to set timeout values that are more conservative, e.g.:

<%
    url = "http://www.espn.com/main.html"
    set xmlhttp = CreateObject("MSXML2.ServerXMLHTTP")
    ‘ resolve, connect, send, receive – in milliseconds
    xmlhttp.setTimeouts 5000, 60000, 10000, 10000
    xmlhttp.open "GET", url, false
    xmlhttp.send ""
    Response.write xmlhttp.responseText
    set xmlhttp = nothing
%>

The four timeout values are as follows:
ResolveTimeout
This value is for the return of a DNS resolution (mapping the domain name to its representative IP address). The default value is infinite.
ConnectTimeout
This value is for establishing a connection with the server, and the default value is 60 seconds.
SendTimeout
This value is the time allowed for sending an individual packet of data to the server. The default value is 30 seconds.
ReceiveTimeout
This value is the time allowed for receiving an individual packet of data from the server. The default value is 30 seconds.

Why do I get 80072EE2 errors?

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Svnserve Based Server

Bill — Fri, 28 Oct 2011 16:15:22 +0000

This week I decided to update my Subversion components and it did not go well. The first surprise was after updating my version of TortoiseSVN to the 1.7 version, my Subversion icons disappeared. The fix was simple but it reminded me that it had been a long time since I updated the Svnserve server I was using from CollabNet. This would also be a nice time to add HTTP access to the repository. So I downloaded the CollabNet Subversion Edge Server and tried to get it to work with my existing repository. I ran into several problems(e.g. viewvc exception). While researching the solutions I decided an easier solution to my problems was to install the VisualSVN Server. So I uninstalled the Edge Server, installed VisualSVN Server, and imported my repository. This worked for HTTP access but I still wanted Svnserve access since I had existing folders checked out via this method. The VisualSVN bin directory has the current version of svnserve so I needed the instructions for installing it as a windows service. The instructions I found, Svnserve Based Server, worked for me but not until I stopped fixing things I should not be fixing in the “unusual command line” format.

Note the rather unusual command line format used by sc. In the key= value pairs there must be no space between the key and the = but there must be a space before the value.

So now I have a relatively simple Subversion server solution that works for both svnserve and http access and it should be easy to maintain.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Backblaze Blog » Petabytes on a Budget v2.0:Revealing More Secrets

Bill — Wed, 20 Jul 2011 16:56:44 +0000

135 terabyte, 4U server for $7,384 is pretty cool!

It’s been over a year since Backblaze revealed the designs of our first generation (67 terabyte) storage pod. During that time, we’ve remained focused on our mission to provide an unlimited online backup service for $5 per month. To maintain profitability, we continue to avoid overpriced commercial solutions, and we now build the Backblaze Storage Pod 2.0: a 135-terabyte, 4U server for $7,384. It’s double the storage and twice the performance—at lower cost than the original.

Backblaze Blog » Petabytes on a Budget v2.0:Revealing More Secrets

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Problem accessing shared drive

Bill — Tue, 05 Jul 2011 18:19:30 +0000

Last Friday I had a problem seeing my shared network drive. Today I figured out that Netbios over TCPIP was disabled. I am not sure how this happen. No related posts. Related posts brought to you by Yet Another Related … Continue reading → No related posts. Related posts brought to you by Yet Another Related Posts Plugin.

T410 Fan Error

Bill — Tue, 05 Jul 2011 18:05:18 +0000

This morning I tried to start up my laptop at work. It had just gotten beyond the Lenovo logo when it said it had a Fan Error and shut down. My boss came in and took the battery out. He … Continue reading → No related posts. Related posts brought to you by Yet Another Related Posts Plugin.

VirtualBox Migration Issues

Bill — Tue, 07 Jun 2011 17:14:45 +0000

Recently I have been interested in possibly converting my existing VPC and VMware images to VirtualBox. I have one image running under VPC and several images running under VMware server and ESXi. Although VMware has been an adequate platform the idea of running VirtualBox under Ubuntu server is appealing.

My first test was to try and convert my VPC image. It did not go well. I kept got a blue screen of death and wasted a lot of time. After soon research I realized that I did not setup the image correctly for migration. Someday when I have a lot more time, I will try again .

My second test was to convert a mail server image that sends out our newsletter. This mail server has a history of being pretty compute intensive since we use DKIM to sign every email. From previous experiments I determined that I could shorten the run time by setting up the mail server as a multi-processor image. The host was on an old dual processor with 4 GB of RAM and under VMware Server 2.0 I could take advantage of both processors. However when I converted the image to run under VirtualBox I could take advantage of only one CPU. Alas the processors do not support VT-x so VirtualBox restricts you to one processor. I ran one newsletter through the VirtualBox version and it took about twice as long. Oh well! Back to the drawing board.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Going Back a version of Adobe Flash

Bill — Tue, 24 May 2011 18:22:05 +0000

Recently I started getting some Flash display problems. The Flash graphics was appearing in the upper left corner of the screen and flashing intermittently. I believe these problems started occurring when I upgraded to the most recent version, 10.3.181.14. Here is what I tried and what worked for me.

I tried reinstalling the current version and the symptoms remained.
I tried a forced uninstall and a manual install of the current version. The symptoms remained.
I uninstalled the current version and installed the previous version, 10.2.159.1. I got the previous version from Archived Flash Player versions page. Now my graphics are working properly.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.