Author: rocker8942

Encrytion using GPG – command line example for automation

This is the GPG command line example to be used inside of automation as C# console application. This encryption/decryption will only use the password. Encrypt Basic format gpg -o outputPath –cipher-algo AES256 –symmetric sourcePath Example to be used inside of automation echo letmeinPetbarn | gpg –batch –passphrase-fd 0 -o D:\Automations\Petbarn\EMListExtractAndFTP\DataOut\petbarn.csv.gpg –cipher-algo AES256 –symmetric D:\Automations\Petbarn\EMListExtractAndFTP\DataOut\petbarn.csv Decrypt… Continue reading Encrytion using GPG – command line example for automation

Useful command of MSSQL Query when comparing and manipulating text data

Extract table from another table SELECT * FROM dbo.SFG_Event_21_22 except SELECT * FROM dbo.SFG_Event_21 Bulk insert BULK insert dbo.SFG_Event_21_22 from ‘C:\Users\joemac\Desktop\final.csv’ WITH ( firstrow = 1, fieldterminator = ‘,’, rowterminator = ‘0x0a’ ); GO bulk insert cannot understand text qualifier bulk insert add NULL for blank data by default Replace string value of a column… Continue reading Useful command of MSSQL Query when comparing and manipulating text data

Published
Categorised as DB

PC Utility

CPU Temperature Check, Core Temp – Small and do the job. Disk Clean up, Directory Stat, WinDirStat – Very useful figuring out what’s consuming most of disk space. and then clean up based on the result. May take some time to read all the files and directories. Ultimate pc utility 2014 by Scott Hanselman

WordPress template selection for restaurant, Sep 2013

http://tasteofjapanwp.prospekt-solutions.com/ http://themelaboratory.com/showcase/mazzareli/wp/ http://demo.themovation.com/eatery/ http://www.themes.red-sun-design.com/lemonchili/ http://suitstheme.com/demo/verona/ http://alethemes.com/delizioso/  

OpenCart template selection for retail shop, Oct 2013

1. http://rgenesis.com/themeforest/RGen-OpenCart-Modern-Store-Design/demo8/ 2. http://321theme.com/sellya/ 3. http://bigturner.com/opencart/madame/demo2/ 4. http://journal.digital-atelier.com/4/ 5. http://oc.dedalx.com/simplegreat/simplegreat8/#