Gordon Durgha – dev, techie, casual blogger from Long Island, NY – 2013

Permalink Gallery
HTML template specifications

Coding

HTML template specifications

For the past couple days I have reading up on the new specifications for the <template> tag in HTML 5.1. This new tag allows you to specify a client side template. Although the concept of templates aren’t new its good to see the W3C community coming up with a standard.

In the past to create a “template” you would typically define a div tag with the elements, then you would hide this div by using CSS code display: none

To learn more check out W3C specifications for template.

By gordon|June 26th, 2013|Coding|0 Comments

History of Programming Languages

The history of programming, brought to you by Veracode.com

By gordon|June 18th, 2013|Coding|0 Comments

Permalink Gallery
Command line utility to copy files to Azure’s blob storage

Coding

Command line utility to copy files to Azure’s blob storage

I am in the process of moving a client’s site from a traditional web hosting platform to azure’s cloud service. The web app uses a sql database that has a file name reference to images in a physical folder on the web server. I need to get these images into an Azure’s blob storage.

To get these images uploaded I decided to use a command line tool called “AzCopy”. You can learn more about the project at: http://blogs.msdn.com/b/windowsazurestorage/archive/2012/12/03/azcopy-uploading-downloading-files-for-windows-azure-blobs.aspx.

The link to download the utility is located on Github.

Here is a sample command:

AzCopy C:webrootiisimages.site.comwwwrootuploads 
https://CONTAINER_NAME.blob.core.windows.net/uploads/ /destkey:[AZURE KEY]

Enjoy!

By gordon|June 14th, 2013|Coding|0 Comments

VBScript snippet to clean up old files

I wrote this basic VBScript sample to delete old .bak files from a particular folder if its older than X number of days.

'============================== 'Remove old backups 'http://gordondurgha.com '============================= 'Definitions iDaysOld = 3 strExtension = ".bak" sDirectoryPath = "D:\MSSQL\Backups\" Set oFSO = CreateObject("Scripting.FileSystemObject") Set oFolder = oFSO.GetFolder(sDirectoryPath) Set oFileCollection = oFolder.Files 'Walk through each file in this folder collection. For each oFile in oFileCollection If oFile.DateLastModified < (Date() - iDaysOld) Then If Right(UCase(oFile.Name), Len(strExtension)) = UCase(strExtension) Then oFile.Delete(True) End If End If Next 'Clean up Set oFSO = Nothing Set oFolder = Nothing Set oFileCollection = Nothing Set oFile = Nothing

By gordon|June 13th, 2013|Coding, Sample Code|0 Comments

Simple c# example on how to use Koogra

This is a sample code for C# to read up an excel file and return the results in a CSV format using the Koogra library.

// This example shows how to read and excel file using the Koogra library (http://sourceforge.net/projects/koogra/) // Supports .xls and .xlsx example public static string ReadExcelContent(string filePath) { uint rowNum = 0; uint colNum = 0; var data = new StringBuilder(); try { Net.SourceForge.Koogra.IWorkbook wb; string fileExt = Path.GetExtension(filePath); if (string.IsNullOrEmpty(fileExt)) { throw new Exception("File extension not found"); } if (fileExt.Equals(".xlsx", StringComparison.OrdinalIgnoreCase)) { wb = Net.SourceForge.Koogra.WorkbookFactory.GetExcel2007Reader(filePath); } else if(fileExt.Equals(".xls", StringComparison.OrdinalIgnoreCase)) { wb = Net.SourceForge.Koogra.WorkbookFactory.GetExcelBIFFReader(filePath); } Net.SourceForge.Koogra.IWorksheet ws = wb.Worksheets.GetWorksheetByIndex(0); for (uint r = ws.FirstRow; r <= ws.LastRow; ++r) { Net.SourceForge.Koogra.IRow row = ws.Rows.GetRow(r); if (row != null) { string lineEnding; for (uint colCount = ws.FirstCol; colCount <= ws.LastCol; ++colCount) { string cellData = string.Empty; if (row.GetCell(colCount) != null && row.GetCell(colCount).Value != null) { cellData = row.GetCell(colCount).Value.ToString(); } if (colCount == ws.LastCol) lineEnding = Environment.NewLine; else lineEnding = "\t"; //tab data.Append(string.Concat(cellData, lineEnding)); } } } } catch (Exception ex) { Exception exception = ex; exception.Source = string.Format("Error occured on row {0} col {1}", rowNum, colNum); throw ex; } return data.ToString(); }

By gordon|June 13th, 2013|Coding, Sample Code|0 Comments

Monthly Archives: %sJune 2013