Simple Meta Tool
This is a more simplistic version of my same meta tool project that was capable of pulling from an Excel spreadsheet (link also below) as well as handling manual checking of URL’s. This simple project is where my base project started from but I branched off it quickly so I could get an Excel capable version done.
This tool performs the same metadata checking but the URLs are entered manually or by using the clipboard and then when processed the meta data populates their respective fields.
My meta tool projects are not completely error free but I make the best of it in my use of controls and code. Because I have to allow for the use of non-standard URLs I added a CorrectURL function to catch protocol-less URLs (www with no http://) and handle those or otherwise a URI error would get generated.
I am by no means a programmer but simply consider myself a coder since I have the basic understanding to create what I need. I urge to tell anyone similarly interested that research is always key in learning, but then again so is learning by mistakes.
The code in my projects are not pretty, it gets ugly, can absolutely be improved but I create out of personal need and currently my projects work for what I intended. I share the project and code in the event it helps someone else.
Meta Tool Using Excel
This is the same tool as above but I branched off and created this one for pulling in the URL data from an Excel spreadsheet.
This tool is currently hard-coded to grab columns A and B from Sheet1 within the Excel worksheet named testdoc.xlsx in the root folder this app sits in.
It pulls in two different columns (A and B) for each line and populates the data in the view. The first column in one row and then the second (B) column right below that and then cycle through the rest of the rows of URLs in the same manner.
I did it this way because I had to compare URLs between a stage and live environment. Within the tool the data is pulled in as:
Line 1 Column A
Line 1 Column B
Line 2 Column A
Line 2 Column B
The code can be redone to suit personal needs, such as to pull from plain text files or you can simply copy and paste a URL in and process it. Read the readme.txt file included in the Zip file.
This project, and executable, requires the following:
- Microsoft Office be installed, in my case it is Office 2010, since a reference has to be added for Microsoft.Office.Interop.Excel. I have not tested this with Office 2007 but there should not be a whole lot of difference if any.
- The free HTMLAgilityPack from CodePlex.
- .NET 4.5 Framework