Welcome to my site

Creativity happens here

Welcome to my site
  • Main Posts
  • Being Geek
  • Creative Corner
    • Musical Instruments
    • Other Projects
    • Energy Projects
  • Rants

Metadata Tool (C Sharp Project)

By Steve Gossett October 24, 2014 Being Geek

 

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.

DOWNLOAD


 

Meta Tool Using Excel

MDScreen

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.

DOWNLOAD

REQUIREMENTS

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

RESOURCES

CSharp.net-informations.com
MSDN Regex examples
Home and Learns site

Tagged on: c sharp, c#, csharp, css, html, metadata, programming
  • ← Mavericks Virtual Machine
  • Bitnami WordPress Virtual Machine →

Recent Posts

  • C# Project – Scraping Files for Data
  • BootstrapCDN – WordPress CDN Plugin
  • Magnet Train Science Project
  • Windows Search is a pain in the ass
  • Wifes Urn Project

Categories

  • Being Geek
  • Energy Projects
  • Main Posts
  • Musical Instruments
  • Other Projects
  • Rants

Archives

Copyright © 2023 Welcome to my site | Theme by: Theme Horse | Powered by: WordPress