BALIW™ developer's notes

-- TEST DECLARE @Xml XML DECLARE @Filename varchar(100) SET @Filename = 'M-PetiksHour-XXX.xml' SELECT @Xml = CONVERT(XML, BulkColumn)  FROM OPENROWSET(BULK 'C:\BizTalk_Files\MW\Maersk\Documentations\JKL-PetiksHour-XXX.xml', SINGLE_BLOB) AS x; -- End of TEST DECLARE  @XmlAltered XML ,@XmlAsNVarChar NVarChar(MAX) SET @XmlAsNVarChar  = CAST(@Xml AS nvarchar(MAX)) SET @XmlAsNVarChar = REPLACE(@XmlAsNVarChar, 'xmlns=""', SPACE(0))   SET @XmlAltered = CAST(@XmlAsNVarChar AS xml) DECLARE @GUID uniqueidentifier   SET @GUID = NEWID()   SELECT  col.value('data(ShipNumber[1])', 'int') as ShipNumber ,col.value('data(AccountPeriod[1])', 'int') as AccountPeriod ,col.value('data(PersonEmployeeId[1])', 'int') as PersonEmployeeId ,col.value('data(RankCode[1])', 'int') as RankCode ,col.value('data(TotalNonConformityDeviation[1])', 'decimal(20,2)') as TotalNonConformityDevi...

            var results = Regex.Split("\"TEST\",123 TEST,\"TEST 99,9\"", ",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)");             foreach (var item in results)             {                 Console.WriteLine(item);             }

USE [MyTestDb] GO DROP FUNCTION [dbo].[udf_Global_PadTwoDecimalDigitString] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[udf_Global_PadTwoDecimalDigitString](@StringDecimalValue varchar(25)) RETURNS varchar(25) AS BEGIN DECLARE  @Value varchar(25) ,@ValueAsFloat decimal(20, 3) ,@ValueAsFloatBackToVarchar varchar(25) ,@ValueAsVarcharWith2Decimal varchar(25) SET @Value = @StringDecimalValue -- Ensure that it has decimal values, if not, forced to add .00 SET @Value  = @Value + (CASE WHEN CHARINDEX('.', @Value) = 0 THEN '.00' ELSE SPACE(0) END) -- Secret sauce: SET @ValueAsFloat = CAST(@Value AS decimal(20, 3)) + .001 SET @ValueAsFloatBackToVarchar = CAST(@ValueAsFloat AS decimal(20, 3)) SET @ValueAsVarcharWith2Decimal = SUBSTRING(@ValueAsFloatBackToVarchar, 1, CHARINDEX('.', @ValueAsFloatBackToVarchar) + 2)     RETURN @ValueAsVarcharWith2Decimal END GO

Basic Dipping Sauce (Nuoc Cham) author andrea nguyen yield 3/4 cup Ingredients3 tablespoons lime juice (1 fat, thin skin lime)2 tablespoons sugar½ cup water2 ½ tablespoons fish sauce Optional additions 1 small garlic clove, finely minced1 or 2 Thai chilis, thinly sliced or 1 teaspoon homemade chili garlic sauce or store bought (tuong ot toi)

pi@raspberrypi:~ $ wpa_passphrase "cgull" "McHammer!" network={     ssid="cgull"     #psk="McHammer!"     psk=453d9ffdc2a884e410ababfb35a2d654ca48d0acf81e70f7f62ce6d374499f8b } pi@raspberrypi:~ $ sudo nano /etc/wpa_supplicant//wpa_supplicant.conf pi@raspberrypi:~ $ sudo reboot Connection to raspberrypi.local closed by remote host. Connection to raspberrypi.local closed. mccrazy@Lenovo-N22:~$ ssh pi@raspberrypi.local pi@raspberrypi.local's password:

        private static void Testing_Extracting_Email_Body_From_An_Email_File()         {             CDO.IMessage msg = GetCdoEmail(@"C:\BizTalk_Dropzone\MW\OSM.CrewMail\Process\00 - Emails from somebody (No MIME)\New folder\{2413639D-9F69-4E7F-ADE3-A0835E8821EB}.eml");             Console.WriteLine(msg.TextBody);             msg = null;         }         // Microsoft CDO for Windows 2000 Library         // Microsoft ActiveX Data Objects 6.0 Library         private static CDO.IMessage GetCdoEmail(string sAnEmailFile)         {             CDO.Message msg = new CDO.Message();             // load MIME into CDO             using (FileStream stream = new FileStream(sAnEmailFile, FileMode.Open))             {                 // read file into a byte stream                 byte[] emailData = new byte[stream.Length];                 stream.Read(emailData, 0, (int)stream.Length);                 // load byte stream data into an ADODB stream for CDO                 ADODB.Stream stm = ...

require 'net/smtp' require 'open-uri' def send_email_with_attachment(subject, body, to_email)  user = ' mailsender@gmail.com '  pwd = 'Mail123Pa55word'  to = to_email  from = ' noreply@baliw.com '  subject = "#{subject}" filename = "Excel_Attachment.xlsx" filename = "xlsTemplate.xls" filename = "xlsxTemplate.xlsx" # Read a file and encode it into base64 format filecontent = File.binread(filename) encodedcontent = [filecontent].pack("m")   # base64 marker = "AUNIQUEMARKER" body = <<EOF This is a test email to send an attachement using net/smpt. EOF # Define the main headers. part1 = <<EOF From: No Reply <#{from}> To: A Test User <#{to}> Subject: Sending Excel Attachement test123 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary = #{marker} --#{marker} EOF # Define the message action part2 = <<EOF Content-Type: text/plain Content-Transfer-Encoding:8bit...