tag:blogger.com,1999:blog-44992642831933827942024-03-15T18:10:18.731-07:00Macro of MicroA Inclusive pages for Exclusive innovationsmacroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.comBlogger35125tag:blogger.com,1999:blog-4499264283193382794.post-65825835814227321302018-01-11T06:03:00.001-08:002018-01-11T06:08:22.952-08:00Ajax Quick Tutorial<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
AJAX stands for Asynchronous JavaScript and XML. AJAX is not a programming language but a technique for creating interactive web applications. It sends and receives data from client browser to server(independent of server technology).<br />
<br />
<b>Significance</b><br />
<br />
<ul style="text-align: left;">
<li>Though XML is the common format, Ajax supports other types like plain text, Json</li>
<li>It allows web pages to be updated asynchronously by exchanging data with a web server behind the scenes. This means that it is possible to update parts of a web page, without reloading the whole page.</li>
</ul>
<br />
<br />
<b>Limitations</b><br />
<br />
<ul style="text-align: left;">
<li>AJAX has browser incompatibility </li>
<li>For security reasons, modern browsers do not allow access across domains data</li>
</ul>
<br />
<br />
<b>Workflow</b><br />
<br />
<ul style="text-align: left;">
<li>Trigger (on page load, onclick, onchange, etc,.)</li>
<li>create XMLHttpRequest object in JavaScript</li>
<li>send a request to a web server</li>
<li>receive the response</li>
<li>process the response in JavaScript</li>
</ul>
<br />
<br />
3 Way to use Ajax<br />
<br />
<b>Direct Method</b><br />
<br />
function loadDoc() {<br />
var xhttp = new XMLHttpRequest(); //create XMLHttpRequest object in JavaScript<br />
xhttp.onreadystatechange = function() {<br />
if (this.readyState == 4 && this.status == 200) //checking the status and read the data<br />
{document.getElementById("result").innerHTML = this.responseText;}<br />
};<br />
xhttp.open("GET", "feed.xml", true); // get or post<br />
xhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");//to set header for content type or cookies<br />
xhttp.send("m=1&type=summary");//for get parameters can be passed<br />
xhttp.send();<br />
}<br />
<br />
-----------<br />
<b>Callback Method</b><br />
onclick="loadDoc('ajax_info.txt', myFunction)"<br />
<br />
function loadDoc(url, cFunction) {<br />
var xhttp;<br />
xhttp=new XMLHttpRequest();<br />
xhttp.onreadystatechange = function() {<br />
if (this.readyState == 4 && this.status == 200) {cFunction(this);}<br />
};<br />
xhttp.open("GET", url, true);<br />
xhttp.send();<br />
}<br />
function myFunction(xhttp) {<br />
document.getElementById("result").innerHTML = xhttp.responseText;<br />
}<br />
<br />
<b>JQuery Method</b><br />
add Jquery lib http://ajax.googleapis.com/ajax/libs/jquery/2.0.0/jquery.min.js <br />
<button id="readFile">Read File</button><br />
$(document).ready(function() {<br />
$("#readFile").click(function() {<br />
$.ajax({<br />
url : "http://macrolayer.blogspot.com/2016/03/waterways.html?m=1",<br />
dataType: "text",<br />
success : function (data) {<br />
alert(data.length);<br />
alert(data);<br />
}<br />
});<br />
});<br />
});<br />
<br />
<br />
<br />
<table border="1"><tbody>
<tr><th>Method</th><th>Description</th></tr>
<tr><td>new XMLHttpRequest()</td><td>Creates a new XMLHttpRequest object</td></tr>
<tr><td>abort()</td><td>Cancels the current request</td></tr>
<tr><td>getAllResponseHeaders()</td><td>Returns header information</td></tr>
<tr><td>getResponseHeader()</td><td>Returns specific header information</td></tr>
<tr><td>open(method,url,async,user,psw)</td><td>"Specifies the request<br />
method: the request type GET or POST<br />
url: the file location<br />
async: true (asynchronous) or false (synchronous)<br />
user: optional user name<br />
psw: optional password"</td></tr>
<tr><td>send(optional string)</td><td>Sends the request to the server. parameter is used for POST requests. </td></tr>
<tr><td>setRequestHeader()</td><td>set the header content to be sent</td></tr>
</tbody></table>
<br />
<br />
<table border="1"><tbody>
<tr><th>Property</th><th>Description</th></tr>
<tr><td>onreadystatechange</td><td>Defines a function to be called when the readyState property changes</td></tr>
<tr><td>readyState</td><td>"Holds the status of the XMLHttpRequest.<br />
0: request not initialized<br />
1: server connection established<br />
2: request received<br />
3: processing request<br />
4: request finished and response is ready"</td></tr>
<tr><td>responseText</td><td>Returns the response data as a string</td></tr>
<tr><td>responseXML</td><td>Returns the response data as XML data</td></tr>
<tr><td>status</td><td>"Returns the status-number of a request
200: ""OK""<br />
403: ""Forbidden""<br />
404: ""Not Found"""</td></tr>
<tr><td>statusText</td><td>Returns the status-text (e.g. "OK" or "Not Found")</td></tr>
</tbody></table>
<br />
<br />
<br />
<br /></div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com6tag:blogger.com,1999:blog-4499264283193382794.post-25410576407693765972017-10-19T07:49:00.000-07:002018-01-03T07:53:24.272-08:00Run Time Errors and solution in VBA<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Run-time Error '3': Return without GoSub</b><br />
when GoSub and Return are matched. Unlike For/Next, While/Wend, and Function...End Function, which are matched at compile time.<br />
<br />
<b>Run-time Error '5': Invalid procedure call or argument</b><br />
when a procedure call with exceeded range of arguments or procedure that isn't valid on the current platform<br />
<br />
<b>Run-time Error '6': Overflow</b><br />
If variable exceeds the limit then it considers as overflow. i.e integer value more than 32767. Occurs in assignment, calculation, data type conversion.<br />
<br />
<b>Run-time Error '7': Out of memory</b><br />
Close any unnecessary applications, documents, or source files that are open.<br />
Break large modules or procedures into smaller ones. This doesn't save memory, but it can prevent hitting 64K segment boundaries.<br />
Increase virtual memory by freeing some disk space<br />
Reduce the number of Public variables.<br />
<br />
<b>Run-time Error '9': Subscript out of range</b><br />
nonexistent array element. larger or smaller subscript of arrays or collections <br />
<br />
<b>Run-time Error '10': This array is fixed or temporarily locked</b><br />
when array is redim, sometime it happens. Note that not all arrays can be redimensioned.<br />
<br />
<b>Run-time Error '11': Division by zero</b><br />
when a variable with division zero which is not possible<br />
<br />
<b>Run-time Error '13': Type mismatch</b><br />
datatype should be matched. If not use conversion functions like Cbool, cint, cstr. use Variant type for flexible datatype<br />
<br />
<b>Run-time Error '14': Out of string space</b><br />
<b>Run-time Error '16': Expression too complex</b><br />
<b>Run-time Error '17': Can't perform requested operation</b><br />
<b>Run-time Error '18': User interrupt occurred</b><br />
<b>Run-time Error '20': Resume without error</b><br />
<b>Run-time Error '28': Out of stack space</b><br />
<b>Run-time Error '35': Sub, Function, or Property not defined</b><br />
<b>Run-time Error '47': Too many DLL application clients</b><br />
<b>Run-time Error '48': Error in loading DLL</b><br />
<b>Run-time Error '49': Bad DLL calling convention</b><br />
<b>Run-time Error '51': Internal error</b><br />
<b>Run-time Error '52': Bad file name or number</b><br />
<b>Run-time Error '53': Can't find specified file</b><br />
<b>Run-time Error '54': Bad file mode</b><br />
<b>Run-time Error '55': File already open</b><br />
<b>Run-time Error '57': Device I\O error</b><br />
<b>Run-time Error '58': File already exists</b><br />
<b>Run-time Error '59': Bad record length</b><br />
<b>Run-time Error '61': Disk full</b><br />
<b>Run-time Error '62': Input past end of file</b><br />
<b>Run-time Error '63': Bad record number</b><br />
<b>Run-time Error '67': Too many files</b><br />
<b>Run-time Error '68': Device unavailable</b><br />
<b>Run-time Error '70': Permission denied</b><br />
<b>Run-time Error '71': Disk not ready</b><br />
<b>Run-time Error '74': Can't rename with different drive</b><br />
<b>Run-time Error '75': Path\File access error</b><br />
<b>Run-time Error '76': Path not found</b><br />
<b>Run-time Error '91': Object variable or With block variable not set</b><br />
<b>Run-time Error '92': For loop not initialized</b><br />
<b>Run-time Error '93': Invalid pattern string</b><br />
<b>Run-time Error '94': Invalid use of Null</b><br />
<b>Run-time Error '96': Can't sink this object's events because it's already firing events to the maximum number of supported event recipients</b><br />
<b>Run-time Error '97': Can't call Friend procedure on an object that isn't an instance of the defining class</b><br />
<b>Run-time Error '98': A property or method call cannot include a reference to a private object, either as an argument or as a return value</b><br />
<b>Run-time Error '321': Invalid file format</b><br />
<b>Run-time Error '322': Can't create necessary temporary file</b><br />
<b>Run-time Error '400': Form already displayed; can't show modally</b><br />
<b>Run-time Error '422': Property not found</b><br />
<b>Run-time error '424': Object Required Error</b><br />
<b>Run-time Error '429': ActiveX component can't create object or return reference to this...</b><br />
<b>Run-time Error '430': Class doesn't support Automation or does not support expected interface</b><br />
<b>Run-time Error '432': File name or class name not found during Automation operation</b><br />
<b>Run-time Error '438': Object doesn't support this property or method</b><br />
<b>Run-time Error '440': Automation error</b><br />
<b>Run-time Error '442': Connection to type library or object library for remote process h...</b><br />
<b>Run-time Error '443': Automation object doesn't have a default value</b><br />
<b>Run-time Error '445': Object doesn't support this action</b><br />
<b>Run-time Error '446': Object doesn't support named arguments</b><br />
<b>Run-time Error '447': Object doesn't support current locale setting</b><br />
<b>Run-time Error '448': Named argument not found</b><br />
<b>Run-time Error '449': Argument not optional</b><br />
<b>Run-time Error '450': Wrong number of arguments or invalid property assignment</b><br />
<b>Run-time Error '451': Property let procedure not defined and property get procedure did not return an object</b><br />
<b>Run-time Error '452': Invalid ordinal</b><br />
<b>Run-time Error '453': Specified DLL function not found</b><br />
<b>Run-time Error '454': Code resource not found</b><br />
<b>Run-time Error '455': Code resource lock error</b><br />
<b>Run-time Error '457': This key is already associated with an element of this collection</b><br />
<b>Run-time Error '458': Variable uses a type not supported in Visual Basic</b><br />
<b>Run-time Error '459': This component doesn't support events</b><br />
<b>Run-time Error '735': Can't save file to TEMP directory</b><br />
<b>Run-time Error '744': Search text not found</b><br />
<b>Run-time Error '746': Replacements too long</b><br />
<b>Run-time Error '31001': Out of memory</b></div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com1tag:blogger.com,1999:blog-4499264283193382794.post-39843181310585503632017-09-07T08:54:00.001-07:002017-09-07T08:54:11.719-07:00Decoding bai file type<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif;">This post is all about decoding bai
file type. so that any application can be developed convert bai file type to csv or any. csv file is nothing but
comma separated values, a simple file format used to store tabular data like
spreadsheets. Prior to that, what is bai file type? bai is a file type (.bai extension) used to balance report in banking industry. </span>Technically .bai is just a text file with respective delimiters called codes. Though comma is the column separator, the .bai files are
typically formatted in such a way to represent other information using the prefix numeric code with every newline.</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="background: white; font-family: "segoe ui" , sans-serif;">The first two digits of each line is the standard
code for each line type to tell the system what type of line it is.</span><span style="font-family: "segoe ui" , sans-serif;"><br style="box-sizing: border-box;" />
<span style="background: white;">------------------------------------------------</span><br style="box-sizing: border-box;" />
<span style="background: white;">01,,,,,,,,</span><br style="box-sizing: border-box;" />
<span style="background: white;">02,,,,1230530,,,</span><br style="box-sizing: border-box;" />
<span style="background: white;">03,80457080,,,,,,</span><br style="box-sizing: border-box;" />
<span style="background: white;">16,475,3000,,1230530,,,456,</span><br style="box-sizing: border-box;" />
<span style="background: white;">88,,<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="background: white; font-family: "segoe ui" , sans-serif;">16,475,30000,,1230530,,,789,</span><span style="font-family: "segoe ui" , sans-serif;"><br style="box-sizing: border-box;" />
<span style="background: white;">98,,,</span><br style="box-sizing: border-box;" />
<span style="background: white;">99,20000,,2</span><br style="box-sizing: border-box;" />
<span style="background: white;">------------------------------------------------<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="background: white; font-family: "segoe ui" , sans-serif;">Interpretation<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
01 File Header Begins File<o:p></o:p></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-indent: .5in;">
02 Group Header Begins Group<o:p></o:p></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; text-indent: .5in;">
03
Account Identifier Begins Account<o:p></o:p></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 1.0in; margin-right: 0in; margin-top: 0in; text-indent: .5in;">
16
Transaction Detail (Optional) Within Account <o:p></o:p></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 1.0in; margin-right: 0in; margin-top: 0in; text-indent: .5in;">
88
continuation of details<o:p></o:p></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; text-indent: .5in;">
49
Account Trailer Ends Account <o:p></o:p></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-indent: .5in;">
98 Group Trailer Ends Group <o:p></o:p></div>
<div style="border-bottom: solid windowtext 1.0pt; border: none; mso-border-bottom-alt: solid windowtext .75pt; mso-element: para-border-div; padding: 0in 0in 1.0pt 0in;">
<div class="MsoNormal" style="border: none; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-border-bottom-alt: solid windowtext .75pt; mso-padding-alt: 0in 0in 1.0pt 0in; padding: 0in;">
99 File Trailer Ends File<o:p></o:p></div>
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184; width: 0px;">
<tbody>
<tr style="height: 60.0pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td nowrap="" style="border: solid windowtext 1.0pt; height: 60.0pt; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
01<o:p></o:p></div>
</td>
<td nowrap="" style="border-left: none; border: solid windowtext 1.0pt; height: 60.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 104.0pt;" valign="bottom" width="139"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
File Header<o:p></o:p></div>
</td>
<td style="border-left: none; border: solid windowtext 1.0pt; height: 60.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 225.0pt;" valign="bottom" width="300"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
The file header marks the beginning of a file. It identifies the
sender and receiver of the transmission, and it describes the structure of
the file.<o:p></o:p></div>
</td>
</tr>
<tr style="height: 60.0pt; mso-yfti-irow: 1;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 60.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
02<o:p></o:p></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 60.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 104.0pt;" valign="bottom" width="139"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
Group Header<o:p></o:p></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 60.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 225.0pt;" valign="bottom" width="300"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
The group header identifies a group of accounts that are from
the same originator and includes the same as-of-date and as-of-time.<o:p></o:p></div>
</td>
</tr>
<tr style="height: 75.0pt; mso-yfti-irow: 2;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 75.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
03<o:p></o:p></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 75.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 104.0pt;" valign="bottom" width="139"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
Account Identifier and Summary/Status<o:p></o:p></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 75.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 225.0pt;" valign="bottom" width="300"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
This record identifies the account number and reports activity
summary and account status information. Summary information may be
accompanied by an item count and funds availability distribution.<o:p></o:p></div>
</td>
</tr>
<tr style="height: 60.0pt; mso-yfti-irow: 3;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 60.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
16<o:p></o:p></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 60.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 104.0pt;" valign="bottom" width="139"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
Transaction Detail<o:p></o:p></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 60.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 225.0pt;" valign="bottom" width="300"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
This record is used for transmission of detail transaction
information. Transaction detail may include two reference numbers and a
free-form alphanumeric text.<o:p></o:p></div>
</td>
</tr>
<tr style="height: 1.25in; mso-yfti-irow: 4;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 1.25in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
88<o:p></o:p></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 1.25in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 104.0pt;" valign="bottom" width="139"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
Continuation<o:p></o:p></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 1.25in; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 225.0pt;" valign="bottom" width="300"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
A Continuation record is used when data exceed the maximum
physical record length, or whenever it is desirable to continue data into an
additional record. It may follow any record type, including another
“continuation” (88) record.<o:p></o:p></div>
</td>
</tr>
<tr style="height: 45.0pt; mso-yfti-irow: 5;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 45.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
49<o:p></o:p></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 45.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 104.0pt;" valign="bottom" width="139"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
Account Trailer<o:p></o:p></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 45.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 225.0pt;" valign="bottom" width="300"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
The Account Trailer record provides account control<br />
totals<o:p></o:p></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 6;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
98<o:p></o:p></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 104.0pt;" valign="bottom" width="139"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
Group Trailer<o:p></o:p></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 225.0pt;" valign="bottom" width="300"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
This record provides group control totals.<o:p></o:p></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 7; mso-yfti-lastrow: yes;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
99<o:p></o:p></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 104.0pt;" valign="bottom" width="139"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
File Trailer<o:p></o:p></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 225.0pt;" valign="bottom" width="300"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
This record provides file control totals.<o:p></o:p></div>
</td>
</tr>
</tbody></table>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>File Header<o:p></o:p></b></div>
<div class="MsoNormal">
It contains sender, receiver alphanumeric identifiers, File
created date in YYMMDD format, File created time, file identification id, number
of characters, block size, version number.<o:p></o:p></div>
<div class="MsoNormal">
<b>Group Header<o:p></o:p></b></div>
<div class="MsoNormal">
It contains receiver identifier, originator identifier,
status, date, time, currency code.<o:p></o:p></div>
<div class="MsoNormal">
<b>Account Header<o:p></o:p></b></div>
<div class="MsoNormal">
It contains customer account number, currency code, type
code, amount, item count, fund type<o:p></o:p></div>
<div class="MsoNormal">
<b>Transaction Header<o:p></o:p></b></div>
<div class="MsoNormal">
It contains Transaction type code, Amount, fund type, bank
reference number, customer reference number, Text. Among transaction type code 010
to 099 are reporting purpose. 100 to 399 type codes indicate Credit transaction.
400 to 760 indicate debit transaction.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="background: white; color: #222222; font-family: "arial" , sans-serif;">A bai
file should starts with 01 & ends with 99 code. It can have multiple groups
starts with 02 & ends with 98 codes. Account details should be inside the
group header. 16 indicates all type of Transaction details when the information
is large than the continuations will be present with 88 code in next line.<o:p></o:p></span></div>
<br />
<div class="MsoNormal">
<br /></div>
</div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com1tag:blogger.com,1999:blog-4499264283193382794.post-35679422216711451032017-05-12T05:43:00.000-07:002017-09-19T05:49:27.713-07:00Automation Testing with CodedUI<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt; line-height: 115%;">Manual Testing is the process of testing a software manually. when there is requirement for GUI testing then one of the best solution is CodedUI. since it is Microsoft stack and integrated in visual studio. </span><span style="font-family: "verdana" , sans-serif; font-size: 10pt;">Visual Studio 2010 Ultimate/ Premium has codeUI option where user can test the performance of graphical user interface. </span><span style="font-family: "verdana" , sans-serif; font-size: 10pt;">CodedUI tests provide functional testing as well</span><span style="font-family: "verdana" , sans-serif; font-size: 10pt;"> </span><span style="font-family: "verdana" , sans-serif; font-size: 10pt;">regression testing.</span><br />
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;"><br /></span>
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;">Below are the minimum requirement for CodeUI</span><br />
<span style="font-family: "verdana" , sans-serif;"><span style="font-size: 13.3333px;">Microsoft Visual Studio 2010 or above</span></span><br />
<span style="font-family: "verdana" , sans-serif;"><span style="font-size: 13.3333px;">Microsoft Test Manager 2010 or above</span></span><br />
<br />
<span style="font-family: "verdana" , sans-serif;"><span style="font-size: 13.3333px;">Microsoft Test Agent 2010 or above</span></span><br />
<br />
To Open Test<br />
<div>
<br />
<ul style="text-align: left;">
<li><span style="font-family: "verdana" , sans-serif; font-size: 13.3333px; text-indent: -0.25in;">To start a new test project, go to File -> New -> Project. In the New Project window, select the Test Project template from Visual C# ->Test and select the OK button to create it.</span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: 13.3333px; text-indent: -0.25in;">To create a new test, Right click on Project solution and then Add -> Coded Test</span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: 13.3333px; text-indent: -0.25in;">To record steps ,select Record actions, edit UI MAP or add assertions and click OK to start the recording process</span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: 13.3333px; text-indent: -0.25in;">To record steps , select “Record actions, edit UI map or add assertions” and click OK to start the recording process</span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: 13.3333px; text-indent: -0.25in;">Now Coded UI Test Builder is displayed to start recording . click record button in Coded UI Test Builder</span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: 13.3333px; text-indent: -0.25in;">Do the manual process like opening a webpage/application, click different controls. finally click Stop button to stop the recording</span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: 13.3333px; text-indent: -0.25in;">Click the Generate Code button in the Coded UI Test Builder to generate a test method and give custom name and click "add and generate". Now code is recorded. Let's now create an assertion that will check the value of Name. </span></li>
<li><span style="text-indent: -0.25in;"><span style="font-family: "verdana" , sans-serif;"><span style="font-size: 13.3333px;">To create an assertion, press the third button in the Coded UI Test Builder and To identify a new control, drag the crosshair onto the control or hover mouse over the control. After releasing the mouse button, an Add Assertions window is displayed allowing you to add assertions. Assertion added for the Name for inner text properties. </span></span></span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: 13.3333px; text-indent: -0.25in;">Click the Generate Code button in the Coded UI Test Builder to generate an assertion method. </span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: 13.3333px; text-indent: -0.25in;">Source file for CodedUI</span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: 13.3333px; text-indent: -0.25in;"> If we need to run the test for multiple inputs then need to add parameter values form data source. </span></li>
</ul>
<ol style="text-align: left;">
<li> Add an xml file in codedUI test</li>
<li> Open properties window to add data connection string.Test ->TestView right click on codedUi test method and open propeties. select Xml file.</li>
</ol>
<ul style="text-align: left;">
<li><span style="font-family: "verdana" , sans-serif; font-size: 13.3333px; text-indent: -0.25in;">Once all tests and assertions are created, you can run tests. open the Test View window by selecting Test -> Windows > Test View from the main menu of Visual Studio. Now right-click in the test method, and then click Run Tests or Debug Tests</span></li>
</ul>
</div>
<div>
<table responsive="true" style="border-collapse: collapse; border: 1px solid rgb(187, 187, 187); color: black; font-family: "Segoe UI", "Lucida Grande", Verdana, Arial, Helvetica, sans-serif; font-size: 13px; margin-bottom: 20px; margin-top: 20px; word-break: break-word;" summary="table"><tbody>
<tr responsive="true"><th scope="col" style="background-color: #ededed; border: 1px solid rgb(187, 187, 187); color: #636363; padding: 10px 8px; text-align: left;"><div style="color: #2a2a2a; line-height: 18px; padding-bottom: 0px;">
File</div>
</th><th scope="col" style="background-color: #ededed; border: 1px solid rgb(187, 187, 187); color: #636363; padding: 10px 8px; text-align: left;"><div style="color: #2a2a2a; line-height: 18px; padding-bottom: 0px;">
Description</div>
</th></tr>
<tr><td data-th="File" style="border: 1px solid rgb(187, 187, 187); min-width: 80px; padding: 10px 8px; vertical-align: top;"><div style="line-height: 18px; padding-bottom: 0px;">
<span class="code" style="font-family: "consolas" , "courier" , monospace;">CodedUITest1.cs</span></div>
</td><td data-th="Description" style="border: 1px solid rgb(187, 187, 187); min-width: 80px; padding: 10px 8px; vertical-align: top;"><div style="line-height: 18px; padding-bottom: 0px;">
Contains the coded UI test class, test methods and assertions. We can modify it.</div>
</td></tr>
<tr><td data-th="File" style="border: 1px solid rgb(187, 187, 187); min-width: 80px; padding: 10px 8px; vertical-align: top;"><div style="line-height: 18px; padding-bottom: 0px;">
<span class="code" style="font-family: "consolas" , "courier" , monospace;">UIMap.uitest</span></div>
</td><td data-th="Description" style="border: 1px solid rgb(187, 187, 187); min-width: 80px; padding: 10px 8px; vertical-align: top;"><div style="line-height: 18px; padding-bottom: 0px;">
Contains the XML model for the <a href="https://msdn.microsoft.com/en-us/library/microsoft.visualstudio.testtools.uitest.common.uimap.uimap(v=vs.100).aspx" style="text-decoration-line: none;">UIMap</a> class, including all windows, controls, properties, methods, parameters, actions, and assertions. This file is not directly editable. But the Coded UI Test Builder helps to modify the existing test which will automatically modify the UIMap.uitest and UIMap.Designer.cs file.</div>
</td></tr>
<tr><td data-th="File" style="border: 1px solid rgb(187, 187, 187); min-width: 80px; padding: 10px 8px; vertical-align: top;"><div style="line-height: 18px; padding-bottom: 0px;">
<span class="code" style="font-family: "consolas" , "courier" , monospace;">UIMap.Designer.cs</span></div>
</td><td data-th="Description" style="border: 1px solid rgb(187, 187, 187); min-width: 80px; padding: 10px 8px; vertical-align: top;"><div style="line-height: 18px; padding-bottom: 0px;">
Contains the code representation of the XML contained in the <span class="code" style="font-family: "consolas" , "courier" , monospace;">UIMap.uitest</span> file. Do not edit this file.</div>
</td></tr>
<tr><td data-th="File" style="border: 1px solid rgb(187, 187, 187); min-width: 80px; padding: 10px 8px; vertical-align: top;"><div style="line-height: 18px; padding-bottom: 0px;">
<span class="code" style="font-family: "consolas" , "courier" , monospace;">UIMap.cs</span></div>
</td><td data-th="Description" style="border: 1px solid rgb(187, 187, 187); min-width: 80px; padding: 10px 8px; vertical-align: top;"><div style="line-height: 18px; padding-bottom: 0px;">
Contains more of the code for the <a href="https://msdn.microsoft.com/en-us/library/microsoft.visualstudio.testtools.uitest.common.uimap.uimap(v=vs.100).aspx" style="text-decoration-line: none;">UIMap</a> class. You can put any customizations for the UI map in this file.</div>
</td></tr>
</tbody></table>
</div>
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;"><br /></span>
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><span style="font-size: 13.3333px;">Reference(s)</span></span><br />
<span style="font-family: verdana, sans-serif;"><span style="font-size: 13.3333px;">https://msdn.microsoft.com/en-us/library/dd286681(v=vs.100).aspx</span></span><br />
<div>
<br /></div>
</div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com1tag:blogger.com,1999:blog-4499264283193382794.post-35359732429059104632016-04-14T21:25:00.000-07:002018-01-12T21:26:18.678-08:00How to Manage Outlook Effectively<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;">Keep monitoring and
prioritizing the mails are big challenge when you work with busy Mailers. In this
post, I would like to bring you some suggestions/idea to manage the mails
especially Outlook. Controlling time-wasters and focusing on important tasks
will lead to achieve long-term goals.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;"><b>First time First Serve</b><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;">Whenever you read an email,
flag it or decide</span><span style="color: #0d0d0d; font-family: "verdana" , sans-serif; font-size: 10.0pt;"> what action or response</span><span style="font-family: "verdana" , sans-serif; font-size: 10pt;"> it needs. Instead of reading it again, do at first time.
Don’t read first few lines and keep it for later reading. It kills your time. Prioritize
the task by reminders or Follow up flags.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfoZ8VX7POFfhjYRPa4fsYICvIYLKg_ZAvK9-jlgQ3Mxze8TKrUuhYwd2SqfVSLRaBZHXeCLOCEr7Np5_z-gweIU4nCsEFFC4i2dfaHF7HMRWJbfBaMmpFda7uTVDG8OPK6MAnMA_GE3A/s1600/followup.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="420" data-original-width="282" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfoZ8VX7POFfhjYRPa4fsYICvIYLKg_ZAvK9-jlgQ3Mxze8TKrUuhYwd2SqfVSLRaBZHXeCLOCEr7Np5_z-gweIU4nCsEFFC4i2dfaHF7HMRWJbfBaMmpFda7uTVDG8OPK6MAnMA_GE3A/s320/followup.png" width="214" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;"><b>Divide and Rule</b><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;">Split the mails and tag it
with related category. So that it gets easier to just glance at the e-mails and
know, how much work you have from which category. Mails can be possible in
below categories like Manager follow up, client follow up, team follow up,
pending action etc., so tag it and work accordingly<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8MGogDvAdkPFriDVIHFIRfSSDdvWfJGwnMF7kMH_YhVB2z9r8n5IWkbukxxFfZyOwCCnPWKutDTpuKJR21ryohMzzOGQ69bowl7tVOBLmfzc_dxa-q3L42OIsGbkkpv2Z8mJ2C0cI1VM/s1600/category.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="402" data-original-width="299" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8MGogDvAdkPFriDVIHFIRfSSDdvWfJGwnMF7kMH_YhVB2z9r8n5IWkbukxxFfZyOwCCnPWKutDTpuKJR21ryohMzzOGQ69bowl7tVOBLmfzc_dxa-q3L42OIsGbkkpv2Z8mJ2C0cI1VM/s320/category.png" width="238" /></a></div>
</div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;"><b>Rule it</b><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;">One of the best way to
manage your work mailbox is to create rules. If you receive multiple emails
from various senders and which you don’t want to miss ever, you can create a
rule and move these e-mails directly to a designated folder. Rules can be
created for all mails from particular sender or particular keywords or
particular scenario to push it in particular folder or make alert or custom
reply. This will help to focus attention for a particular sender.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;">Goto Manage Rules and
Alerts-> Create new Rule, select new <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIontLJ-PmXr4DuoWBPkZyLOXYZ-pevVCYanqnFC00GYes5rocZgRduNUd9PoSQHMc2PiB_4y97z__1UJ6GkBleD4DvUPOGO_exhhdE_pKF-71BLsYTf70bY3wCtY49wynAqe6k6srae0/s1600/outlookrule.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="482" data-original-width="635" height="302" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIontLJ-PmXr4DuoWBPkZyLOXYZ-pevVCYanqnFC00GYes5rocZgRduNUd9PoSQHMc2PiB_4y97z__1UJ6GkBleD4DvUPOGO_exhhdE_pKF-71BLsYTf70bY3wCtY49wynAqe6k6srae0/s400/outlookrule.png" width="400" /></a></div>
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;"><!--[if gte vml 1]><v:shape
id="Picture_x0020_9" o:spid="_x0000_i1026" type="#_x0000_t75" style='width:468pt;
height:354.75pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\raja_raman\AppData\Local\Temp\msohtmlclip1\01\clip_image005.png"
o:title=""/>
</v:shape><![endif]--><!--[if !vml]--><br /><!--[endif]--></span><span style="font-family: "verdana" , sans-serif; font-size: 10pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;"><b>Know how to search</b><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<a href="https://www.blogger.com/blogger.g?blogID=4499264283193382794" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=4499264283193382794" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=4499264283193382794" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=4499264283193382794" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=4499264283193382794" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=4499264283193382794" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=4499264283193382794" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=4499264283193382794" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><span style="font-family: "verdana" , sans-serif; font-size: 10pt;">Art of search is one of the
key aspect in Digital world. Here in Outlook, when you click the search box,
Outlook brings the SEARCH tag with multiple feature. If you click Has
Attachments, it will brings you the mail with attachment. It gives options of search
by From sender name or Subject. Unread emails can be grabbed quickly here. We
can set chronological limit for the search. Your recent search strings can be
reused or viewed in “Recent Searches” Option.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyQKorQhliBp6Qf-H8iTi_L_f5w9DI-0V5WbivCKiYa4kIPNM72PKyoxaI4crLyh3R80f-S2jQk_BDUN7CT1s9KloQ3epNL_faI1hMwNi5qfFOK8IfmdxSJOSZfj882reFaxGDlyxrdME/s1600/search.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="176" data-original-width="668" height="168" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyQKorQhliBp6Qf-H8iTi_L_f5w9DI-0V5WbivCKiYa4kIPNM72PKyoxaI4crLyh3R80f-S2jQk_BDUN7CT1s9KloQ3epNL_faI1hMwNi5qfFOK8IfmdxSJOSZfj882reFaxGDlyxrdME/s640/search.png" width="640" /></a></div>
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;"><b>Responsible Responds</b><o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="line-height: normal; margin-right: 11.25pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: "verdana" , sans-serif; font-size: 10pt;">Though not every email
seeks the reply, however important mails are looking for your response. So it
is advisable to keep responding to the mail so that reminder mails will be
avoided. Keep using Out of Office features so that senders can understand and
act accordingly. For critical mails, set auto replies like “working on it” so
that send keep wait till your response.<o:p></o:p></span></div>
</div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com1tag:blogger.com,1999:blog-4499264283193382794.post-7602070224564318012016-01-11T06:16:00.000-08:002018-01-11T06:17:37.804-08:00CDN for javascript libraries <div dir="ltr" style="text-align: left;" trbidi="on">
<a href="https://upload.wikimedia.org/wikipedia/commons/5/51/Google.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" data-original-height="290" data-original-width="800" height="115" src="https://upload.wikimedia.org/wikipedia/commons/5/51/Google.png" width="320" /></a>It is best practice to have content delivery network to host common library files. This post wil bring you the few informations about available well known CDNs. For hosting Jquery below are the available locations<br />
<br />
<b>Google CDN</b><br />
It provides a high availability, low latency resource for delivering scripts to websites. It hosted Libraries including jQuery, AngularJS, Prototype and Dojo.<br />
<br />
ajax.googleapis.com/ajax/libs/jqueryui/[VERSION NO]/jquery-ui.min.js<br />
ajax.googleapis.com/ajax/libs/jqueryui/[VERSION NO]/themes/[THEME NAME]/jquery-ui.min.css<br />
for details list of libraries are provided at https://developers.google.com/speed/libraries/#jquery<br />
<br />
<b>Microsoft CDN</b><br />
<div class="separator" style="clear: both; text-align: center;">
<b><a href="https://upload.wikimedia.org/wikipedia/commons/thumb/9/96/Microsoft_logo_(2012).svg/2000px-Microsoft_logo_(2012).svg.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" data-original-height="171" data-original-width="800" height="68" src="https://upload.wikimedia.org/wikipedia/commons/thumb/9/96/Microsoft_logo_(2012).svg/2000px-Microsoft_logo_(2012).svg.png" width="320" /></a></b></div>
<br />
For websites built in ASP.NET, Microsoft’s CDN provides a support for JavaScript frameworks without having delay. The same files can be access for other websites as well. Below is the path<br />
<br />
ajax.aspnetcdn.com/ajax/jquery.ui/[VERSION NO]/jquery-ui.min.js<br />
ajax.aspnetcdn.com/ajax/jquery.ui/[VERSION NO]/themes/[THEME NAME]/jquery-ui.min.css<br />
For more detailed Microsoft CDN content visit https://docs.microsoft.com/en-us/aspnet/ajax/cdn/overview<br />
<br />
<b>jQuery CDN</b><br />
<div class="separator" style="clear: both; text-align: center;">
<b><a href="https://upload.wikimedia.org/wikipedia/en/thumb/9/9e/JQuery_logo.svg/1024px-JQuery_logo.svg.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" data-original-height="195" data-original-width="800" height="78" src="https://upload.wikimedia.org/wikipedia/en/thumb/9/9e/JQuery_logo.svg/1024px-JQuery_logo.svg.png" width="320" /></a></b></div>
<br />
code.jquery.com/ui/[VERSION NO]/jquery-ui.min.js<br />
code.jquery.com/ui/[VERSION NO]/themes/[THEME NAME]/jquery-ui.min.css<br />
jquery dot com provides various version for UI, mobile, color etc., visit http://code.jquery.com<br />
<br />
<b>Yandex CDN</b><br />
<div class="separator" style="clear: both; text-align: center;">
<b><a href="https://upload.wikimedia.org/wikipedia/commons/thumb/9/91/Yandex_logo_en.svg/1200px-Yandex_logo_en.svg.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" data-original-height="314" data-original-width="800" height="78" src="https://upload.wikimedia.org/wikipedia/commons/thumb/9/91/Yandex_logo_en.svg/1200px-Yandex_logo_en.svg.png" width="200" /></a></b></div>
<br />
A russian provider who also provide Javascript libraries and CSS including Bootstarp, angular JS<br />
https://yastatic.net/jquery/[VERSION NO]/jquery.min.js<br />
<br />
It provides Backbone.js, Bootstrap, D3.js, jQuery, Lo-Dash, Raphaёl, React, SWFObject, Underscore.js, bem-components. visit<br />
https://tech.yandex.ru/jslibs/<br />
<br />
<br />
http://www.bootstrapcdn.com/<br />
<br />
community-powered CDN https://cdnjs.com/api<br />
<br />
Beside this, there are many commercial entities to provide CDN services for hosting custom contents. you can host your own scripts,<br />
<br />
images, multimedia files without delay.<br />
www.akamai.com<br />
www.cloudflare.com<br />
www.fastly.com<br />
for more providers visit http://blog.cloudharmony.com/2015/02/cdn-marketshare-alexa-fortune-500.html</div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com1tag:blogger.com,1999:blog-4499264283193382794.post-54748624440774436792015-12-31T23:52:00.001-08:002016-01-02T10:10:29.597-08:00Free Service doesn't affect Net Neutrality<div dir="ltr" style="text-align: left;" trbidi="on">
If you are against FreeBasics of Facebook because of OTT Price or Facebook company or Modi government or as a competitor etc., then this post will not entertain you. But If you are against FreeBasics of Facebook only for Netneutrality please read further. Let us consider facebook as a company without any pre assumption.<br />
<br />
Actually Net neutrality is nothing but transparent equal access for all internet data. Definitely it should not mean equal pricing, there can be price variation on various socio-economic reasons. watching an entertainment website and downloading a study material should not be priced equally on data. When we oppose rigidly on free basics and support for equal pricing, then students and knowledge seekers are affected when prices were hiked. There are many baseless rumours like free services will create monopoly, suppress start-ups, price hike and more. However If we are really worried about the operating company, then we should draft a regulation laws instead of banning free services.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRMCu11J9Gv3BTZ_5-_edextW3cIuwf-hsbfMrq9xW-WM-X7TfDoQAugEU44HtSNh0phe2lo-NGRhN1gQRqfRMmVtkqZah65u_uZrYkekQsOguprNDh0VxDN7B_w4I-pIV0iedgrIEcWU/s1600/free+basics.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="195" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRMCu11J9Gv3BTZ_5-_edextW3cIuwf-hsbfMrq9xW-WM-X7TfDoQAugEU44HtSNh0phe2lo-NGRhN1gQRqfRMmVtkqZah65u_uZrYkekQsOguprNDh0VxDN7B_w4I-pIV0iedgrIEcWU/s1600/free+basics.png" width="400" /></a></div>
<br />
<br />
<br />
<a name='more'></a>Google emerged into search engine industry by offering free listing when industry was based on paid results. If we had banned it for free listing then just thing of now. If a company can spend data charge for its own customer by offering its service for data free, then definitely it is a revolution in e-commerce. In India, the Telecom industry is not a monopoly but a perfect competitive industry. An user have option to shift the provider when they feel price is high even we have number portability.<br />
<br />
<br />
<br />
case study 1:<br />
You have constructed a free library for needy in your colony and subscribed with some basic magazines as per your wish list. since you have not purchased all magazines, readers needs to spend money when they need other magazines from shops. Does it mean you violate the library neutrality? do you agree to subscribe all magazines to provide equal access?<br />
<br />
<b>Providing free access for selective web service will not mean suppressing other web service. It is not violation of expression of speech</b><br />
<br />
case study 2:<br />
To preserve domestic market the government impose exise duty for foreign imported goods. The duty value would be higher based on goods which are lower than local price. Do you say all the imported goods should be equally charged based on weight(in same trasport mode)? do you claim 50g gold and 50g groceries should be charged equally as both are shiped equally?<br />
<br />
<b>when voice service websites exploit the telecom companies business, regulatory can impose OTT charges to balance the trade</b>.<br />
<br />
Case study 3:<br />
Many roadside retailers were affected because of online e-commerce sites. Many start-ups like mobiles, gadgets and electronics sellers have severely affected due to online business. Now do you shout against e-commerce sites to shutdown as it destroys many start-ups?<br />
<br />
<b>free and fair competition will create start-up players to utilize the oppurtunity costs. </b><br />
<br />
Case study 4:<br />
You are a Publisher and you publish free matrimonial ads from your readers. As you have received information only from some community, you can't show matrimonial matches for all community. Does it mean you are favouring some and blocking other cummunities?<br />
<br />
<b>If we really concerned by favouring or blocking a website, then we should urge regulatories to frame proper laws to ensure fair competition</b><br />
<br />
Case study 5:<br />
when Chennai was flooded recently, many volunteers showed their humanity and offered many freebies to almost all people. Including many corporate companies offered funds for relief work. so do you generalize nothing is free in world? Few domestic food industry offered its products for free of costs so does it mean they try to create any monopoly in food industry? few telecom operators provided free onnet calls, so does violate telecom neutrality?<br />
<br />
<b>If you are concerned about freebie will lead to monopoly industry, then you should create regulations to support other small scale industries to do fair trade.</b><br />
<br />
Case study 6:<br />
With Private-Public partnership, you have got new highway in your city. Vehicles are being charged based on category. Here do you ask gatekeepers to charge equally for all vehicles? If you are the two wheeler commuter will be happy to pay as equal to earth movers?<br />
<br />
<b>Based on various purpose of business internet data can be charged or waived. If you feel secrecy in data charging, then you should reach consumer consortium for rights.</b><br />
<br />
<br />
Criticism 1:<br />
The main Net neutrality activists may be supported by direct competitors of free services<br />
Criticism 2:<br />
These activists deviated the common public from raising a voice for transparent policies for fair competitions<br />
Criticism 3:<br />
These activists never recall what they answered when retail shopkeepers are affected by online business.<br />
<br />
<br />
The conclusion is that differential pricing should not be considered as net neutrality violation. Instead Perfect law should be framed to avoid unfair business ethics.<br />
<br /></div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com1tag:blogger.com,1999:blog-4499264283193382794.post-14452628531417253022014-04-24T12:55:00.000-07:002014-04-24T12:55:01.310-07:00How to generate automatic emailsAutomatic emails can be defined as the emails which are sent out without human action. Automated emails help not only to avoid repeated tasks and also ensure the punctuality in email transfer. I can classify it in two types, predefined and dynamic based on nature of email body content.<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht-fufXQGgGH-Wtabh18S8TQQbMSk3Sw9gJQDRqpMCHk2sknpEBENcrBa73KycFj5EoYxCFGqmLuXPcP723qN3fD80EBAUXrzdyqRXeBvEfP_vh2M1_dsNVBNdCCU64o-afJsKnJcwGTA/s1600/dove+email.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht-fufXQGgGH-Wtabh18S8TQQbMSk3Sw9gJQDRqpMCHk2sknpEBENcrBa73KycFj5EoYxCFGqmLuXPcP723qN3fD80EBAUXrzdyqRXeBvEfP_vh2M1_dsNVBNdCCU64o-afJsKnJcwGTA/s320/dove+email.png" /></a></div><a name='more'></a><br />
predefined emails are delayed emails, which are created and set for future date. Basically, in this type email body needs to be created by us and set time for send. Check out below steps for creating delayed emails in MS Outlook. http://office.microsoft.com/en-us/outlook-help/delay-or-schedule-sending-email-messages-HP010355051.aspx<br />
Similar like outlook, gmail too have such feature. Here is the addon https://code.google.com/p/gmail-delay-send/<br />
<br />
<br />
On other hand dynamic emails are triggered through an email server using some scripts. It will be more beneficial for reports and logs. Here, the body of the email is created by script based on many factors. If you are interested in programming then check below resources.<br />
For Java<br />
http://www.tutorialspoint.com/java/java_sending_email.htm<br />
For VBA <br />
<a href="http://macrolayer.blogspot.com/2014/02/send-automatic-email-using-vba.html">send-automatic-email-using-vba.html</a><br />
For python,<br />
https://docs.python.org/2/library/email-examples.html<br />
For PHP<br />
http://webcheatsheet.com/php/send_email_text_html_attachment.php<br />
For Google apps script<br />
https://developers.google.com/apps-script/articles/sending_emails macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com0tag:blogger.com,1999:blog-4499264283193382794.post-72064249013869520162014-03-18T12:41:00.000-07:002014-03-18T12:41:08.450-07:00Basic examples for Outlook VBAThis post contains few basic examples for VBA in Microsoft Outlook. To get developer tab visible, File -> Option -> Customize Ribbon -> Developer.<br />
<br />
Let see a simple example to send an email. Below is the basic code which will generate and shoot the email. In visual Basic Editor, use ThisOutlookSession or any other user modules.<br />
<br />
Private Sub SendEmail()<br />
Dim olObj, mlObj<br />
Set olObj = CreateObject("Outlook.Application") 'declaring object<br />
Set mlObj = olObj.CreateItem(0) 'declaring an email item<br />
With mlObj<br />
.To = "me@mydomain.com" 'Give your email<br />
.Subject = "Testmail" ' Give the subject<br />
.Body = "Testmail" ' Give the Body<br />
.Send 'command to send the email<br />
End With<br />
Set olObj = Nothing 'Clear the memory<br />
Set mlObj = Nothing<br />
End Sub<br />
<a name='more'></a><br />
<br />
If you are asked for permission while before sending the email, then you can set the security level accordingly to avoid dialogboxes. Here is an another example for reading a subject from opened email item<br />
<br />
Dim oMail As Outlook.MailItem 'declare item variable<br />
Dim sSub As String<br />
Set oInspector = Application.ActiveInspector 'declare an object<br />
If oInspector Is Nothing Then ' This is to skip if no email is opened<br />
MsgBox "No Mail is opened"<br />
Exit Sub<br />
End If<br />
Set oMail = Application.ActiveInspector.CurrentItem 'assign the current email item<br />
sSub = oMail.Subject 'Assign subject<br />
sBob = oMail.Body ‘This will read Body<br />
msgBox (sSub)<br />
<br />
Using Regex pattern you can get any information from subject line and then process it accordingly. similarly, you can also forward the email item to any. But Outlook 'Rule' feature allows you to set directly forward, However below code is for your customization<br />
<br />
Sub email_forward()<br />
Set myitem = ActiveExplorer.Selection(1).Forward<br />
myitem.Subject = Replace(myitem.Subject, "FW:", "")<br />
myitem.To = "me@mydomain.com"<br />
myitem.Save<br />
myitem.Send<br />
End Sub<br />
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com0tag:blogger.com,1999:blog-4499264283193382794.post-28392794472135510362014-02-05T13:15:00.000-08:002014-02-05T13:15:52.100-08:00Send automatic email using VBAHere I have shared the simple code for sending an automatic email using Macros. It can be excuted in all primary products of the Microsoft. you can send emails to recipient from excel data too. Basically To address, subject and HTMLBody are the apex elements. assign those values and shoot the emails using below simple syntax<br />
<br />
Dim OutApp As Object<br />
Dim OutMail As Object<br />
Set OutApp = CreateObject("Outlook.Application")<br />
Set OutMail = OutApp.CreateItem(0)<br />
On Error Resume Next<br />
With OutMail<br />
.to = "Macroraman@example.com" 'To address<br />
.CC = ""<br />
.BCC = ""<br />
.Subject = "Assignment"<br />
.HTMLBody = "Hi"<br />
'.Attachments.Add ActiveWorkbook.FullName (for active book)<br />
'.Attachments.Add ("D:\Book1.xls") (for external book)<br />
'.Display (to see the message window)<br />
'.Save (to save as Draft)<br />
.Send<br />
End With<br />
Set OutMail = Nothing<br />
Set OutApp = Nothing<br />
<br />
You may face one dificulty when you run the code due to your Outlook security setting. It may ask your acceptance through popup. to avoid such popups follow below steps<br />
<br />
For older window versions<br />
Tools menu -> Options -> Security tab<br />
uncheck and save "Warn me when other applications try to send mail as me" check box.<br />
<br />
For latest Window versions<br />
File - > Options -> Trust Center -> Trust Center settings -> Programmatic Access<br />
Uncheck and save warning option<br />
<br />
In office/secured environment, If you are unable to change the security settings, you can use less equivalent code instead of ".Send"<br />
.Display<br />
Application.Wait (Now + TimeValue("0:00:02"))<br />
Application.SendKeys "%s"<br />
<br />
which means your are executing as manual operationmacroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com0tag:blogger.com,1999:blog-4499264283193382794.post-27677605335486511742013-11-22T18:08:00.000-08:002014-02-25T13:34:55.633-08:00Online service of Indian Gov<div dir="ltr" style="text-align: left;" trbidi="on">
To apply passport<br />
Step 1 Visit http://passportindia.gov.in/ and register yourself<br />
Step 2 Login to the Passport Seva Portal with your registered Login Id<br />
Step 3 Click "Apply for Fresh Passport/Reissue of Passport" link.<br />
Step 4 update the required details in the form and submit.<br />
Step 5 Click the "Pay and Schedule Appointment" link on the "View Saved/Submitted Applications" screen then schedule an appointment with your convenient time. <br />
Step 6 Click the "Print Application Receipt" link to print the application receipt containing Application Reference Number (ARN)/Appointment Number.<br />
Step 7 On scheduled time visit the booked Passport Seva Kendra (PSK), along with original documents.<br />
<br />
For booking appointments, Online Payment has been made mandatory using any one of the following modes:<br />
Credit/Debit Card (MasterCard & Visa)<br />
Internet Banking (State Bank of India (SBI) and Associate Banks Only)<br />
<br />
<br />
To apply PAN request to Income Tax Department<br />
https://tin.tin.nsdl.com/pan/form49A.html<br />
<br />
To apply voter id to Election commission<br />
http://eci-citizenservices.nic.in/frmPublicInformation.aspx?Flag=OnlineApp<br />
<br />
To apply visa request to Bureau of immigration<br />
http://boi.gov.in/content/apply-visa-online<br />
<br />
Online service for driving licence <br />
https://sarathi.nic.in:8443/nrportal/sarathi/HomePage.jsp<br />
<br />
To apply Letter of Intent to NAAC: <br />
http://www.naac.gov.in/Apply_Online.html</div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com0tag:blogger.com,1999:blog-4499264283193382794.post-6210416596205820562013-10-31T23:37:00.000-07:002015-12-20T00:57:46.090-08:00Wikipedia BOT using Google scriptThis page will guide you to create a basic edit model Wikipedia BOT. As we know wikipedia is an open source online encyclopedia, it also allows anyone or any bot to update the pages. Basically, Wikipedia and all its sister projects use Mediawiki software and the <a href="https://www.mediawiki.org/wiki/API:Main_page" rel="nofollow">API</a> of Mediawiki is available for developer. so using Google Apps Script and Mediawiki API one can develop wonderful BOT application for Wikipedia.<br />
<a name='more'></a><br />
There few steps to remember while creating a Wikipedia BOT(for newbie).<br />
Mediawiki API responses are available in most forms. But Json format is most suitable for Google Apps Script. Mediawiki requires two steps to login, first is to get token and second is to confirm the token. And also note that method like Post or get should be appropriate according to the query. Finally you will need to carry the token, session id and user id along with all queries to keep your Authentication for all edits. which is similar like cookies in client machines. Below snippet of code will give you an idea of building cookies using login tokens.<br />
<br />
function myFunction() {<br />
var header="Test";<br />
var msg="Hello World";<br />
var lang = "en";<br />
var dom =".wikipedia.org";<br />
var user ="YOURWIKIACCOUNT"; <br />
var pass="YOURWIKIPASSWORD";<br />
var page= "User:" + user + "/sandbox";<br />
var options1 ={"method": "POST"};<br />
var lurl = "http://" + lang + dom + "/w/api.php?action=login&format=json&lgname=" + user + "&lgpassword=" + pass;<br />
try {<br />
var login = UrlFetchApp.fetch(lurl,options1); <br />
var data = Utilities.jsonParse(login.getContentText());<br />
if (login.getResponseCode() === 200) {<br />
var options2 = {"method": "POST", "headers": {"cookie":lang+"wikiSession=" + data.login.sessionid + "; path=/; domain=" + dom + "; HttpOnly;" + lang + "wikiUserName=" + user}};<br />
var lconfirm = UrlFetchApp.fetch(lurl + "&lgtoken=" + data.login.token ,options2); <br />
if (lconfirm.getResponseCode() === 200) <br />
{<br />
var data1 = Utilities.jsonParse(lconfirm.getContentText());<br />
if(data1.login.result=="Success"){<br />
var options3 = {"method": "GET", "headers": {"Content-Type":"application/x-www-form-urlencoded", "cookie":lang + "wikiSession=" + data1.login.sessionid + "; path=/; domain=" + dom + "; HttpOnly;" + lang + "wikiUserName=" + data1.login.lgusername + "; " + lang + "wikiUserID=" + data1.login.lguserid + "; " + lang + "wikiToken="+ data1.login.lgtoken}};<br />
var queryurl = "https://" + lang + dom + "/w/api.php?action=query&format=json&prop=info&intoken=edit&titles=" + page;<br />
var qresult = UrlFetchApp.fetch(queryurl,options3); <br />
var datai =qresult.getContentText();<br />
var toke = (datai.split("edittoken")[1]).split("\+")[0];<br />
var token = toke.substring(3,toke.length);<br />
var options4 = {"method": "POST", "headers": {"Content-Type":"application/x-www-form-urlencoded", "cookie":lang + "wikiSession=" + data1.login.sessionid + "; path=/; domain=" + dom + "; HttpOnly;" + lang + "wikiUserName=" + data1.login.lgusername + "; " + lang + "wikiUserID=" + data1.login.lguserid + "; " + lang + "wikiToken="+ data1.login.lgtoken}};<br />
var editurl = "https://" + lang + dom + "/w/api.php?action=edit&format=json&title=" + page + "§ion=new&summary=" + header + "&text=" + msg + "&bot&token=" + token + "%2B%5C";<br />
var edit = UrlFetchApp.fetch(editurl,options4);<br />
Logger.log(edit.getContentText());<br />
}<br />
else{Logger.log("Unable to login");}<br />
}<br />
}<br />
} catch (e) {Logger.log(e.toString());}<br />
}<br />
<br />
<a href="https://en.wikipedia.org/wiki/User:Neechalkaran/AppsWiki">AppsWiki Editor</a> is the one of the successful Bot applications available in online. (<a href="https://github.com/neechalkaran/Appswiki" rel="nofollow">source code</a>) NeechalBOT, kalaiBOT are some of the wiki bot accounts use this Editor.macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com0tag:blogger.com,1999:blog-4499264283193382794.post-64901453314711175742013-09-14T01:46:00.000-07:002013-09-14T01:46:45.950-07:00Simple template for blogger Aggregator<div dir="ltr" style="text-align: left;" trbidi="on">
Aggregator is a application which collects latest blog post from various feeds. There are many aggregator tools which will allow you to built a aggregator with or without voting options. But for which you have to setup a server to host. But If you are eager to have own aggregator without any complex tools and simple with blogger environment, this template is for you. Macrolayer introduces new Aggregator template "Aggregator Titan" exclusively made for aggregating service.<br /><a name='more'></a>
<br />
download it from <a href="https://docs.google.com/file/d/0B4h6e6FJ1K3LWGlLUVp3VEFkbTQ/edit?usp=drive_web" rel="nofollow" target="_blank">here</a><br />
<br />
In blogList gadget, you need to add your blogs or import your following blogs. thats it! now you got a aggregator of your own. If you interested more you can add gadgets, ads, links and more on beside the page<br />
<b>Frontend View</b><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimZ7oIrvSuiaua2OTNJR4-AHfs6OZbSWqILhLdzWLNvueQojjXvzhL8mcFvTbJzJM85EAaDdF82CnQEhcZsss1ygQ96gw4EH7IGn2G9q0hLmqYonSxRymXsBpINi6TzyWR7abnU_1OKRE/s1600/Aggregator+titan.png" imageanchor="1"><img border="0" height="282" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimZ7oIrvSuiaua2OTNJR4-AHfs6OZbSWqILhLdzWLNvueQojjXvzhL8mcFvTbJzJM85EAaDdF82CnQEhcZsss1ygQ96gw4EH7IGn2G9q0hLmqYonSxRymXsBpINi6TzyWR7abnU_1OKRE/s400/Aggregator+titan.png" width="400" /></a><br />
<br />
<b> Layout View</b><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx_Uxl13VbaMxYvA09qdHzkqXA4MrrZBX4SD1G9G1hEnjtoISdG5LdL3zTDIjsAP4ZV5mx2dCjDcvvWawnZcgZGe7dOZtnQdPnPcpkOsg7-MYYYZNIHkVjmNPBzV-szIAmUG7z1aFTKM8/s1600/Aggregator+titan.png" imageanchor="1"><img border="0" height="286" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx_Uxl13VbaMxYvA09qdHzkqXA4MrrZBX4SD1G9G1hEnjtoISdG5LdL3zTDIjsAP4ZV5mx2dCjDcvvWawnZcgZGe7dOZtnQdPnPcpkOsg7-MYYYZNIHkVjmNPBzV-szIAmUG7z1aFTKM8/s400/Aggregator+titan.png" width="400" /></a><br />
find the live demo <a href="http://feedlayer.blogspot.com/">here</a><br />
<br />
<b>Some features of the template</b><br />
<br />
<ul style="text-align: left;">
<li>Template looks good for aggregtor and easy to add blogs </li>
<li>More gadget options to add other blogger gadgets </li>
<li>Blog posts are invisible and static pages are only visible </li>
<li><a href="http://macrolayer.blogspot.com/p/nccode.html">NCcode</a> for customized commenting for Static page is inherited </li>
<li>You can have your blog follow list publicly. </li>
<li>You can have own blogs aggregators in different fields. </li>
<li>You can have a aggregator for different labels in your blog
and more</li>
</ul>
feedbacks and suggestions are always welcome
</div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com4tag:blogger.com,1999:blog-4499264283193382794.post-46757352185951042602013-07-27T15:11:00.000-07:002013-07-27T15:11:09.773-07:00Google UiApp Tutorial<div dir="ltr" style="text-align: left;" trbidi="on">
The Google has a wonderful web server scripting application called Apps script. which is not only used for scripting for google products but also can be used to develop stand alone webpages with few limitations. This stand alone web interface is supported by UiApp class. This tutorial will explain about UiApp and its basic controls with a live example script<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghaRLoV2PsAY9elVrHK2PioNaWNGOAihei9XfUtnFBde8EwjJpWp2P45Od9xtiIok50a47VZ7IOXX3PDq2ZJ0EEziOYeCVZoJTmG7C5rQNJiwQNK5h64Oy_IeX7bIbMqqHX54vA8QNluc/s1600/UiApp+Tutorial.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="275" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghaRLoV2PsAY9elVrHK2PioNaWNGOAihei9XfUtnFBde8EwjJpWp2P45Od9xtiIok50a47VZ7IOXX3PDq2ZJ0EEziOYeCVZoJTmG7C5rQNJiwQNK5h64Oy_IeX7bIbMqqHX54vA8QNluc/s400/UiApp+Tutorial.png" width="400" /></a></div>
<br />
// Below script contains two functions. one is main function called doGet, which runs by default, other one is user defined function sendback().<br />
<br />
//doGet function starts<br />
<span style="color: blue;">function doGet() {</span><br />
//initialize UiApp class<br />
<span style="color: blue;">var app = UiApp.createApplication();</span><br />
<br />
<br />
//limited HTML<br />
//create HTML using HTML tages and set id or style. note that <a href="http://macrolayer.blogspot.com/2013/06/anchor-tag-tutorial.html" rel="nofollow" target="_blank">Anchor tag</a> will not work in this class<br />
<span style="color: blue;">var myHTML = app.createHTML("<center><b>Test Script</b></center>").setStyleAttribute("color", "green").setId('Result');</span><br />
//add it to UiApp class<br />
<span style="color: blue;">app.add(myHTML);</span><br />
<br />
//textArea in UiApp<br />
//create textarea control using textarea class and set id or name, which will help to read and write data<br />
<span style="color: blue;">var textAreaA = app.createTextArea().setId('TextArea1').setName('textAreaA');</span><br />
//you can design the textarea by calling its id<br />
<span style="color: blue;">app.getElementById('TextArea1').setHeight('100').setWidth('450');</span><br />
//finally add it to UiApp class<br />
<span style="color: blue;">app.add(textAreaA);</span><br />
<br />
//textbox in UiApp is more similar like text Area<br />
<span style="color: blue;">var textBoxA = app.createTextBox().setId('TextBox1').setName('textBoxA');</span><br />
<span style="color: blue;">app.getElementById('TextBox1').setWidth('300');</span><br />
<span style="color: blue;">app.add(textBoxA);</span><br />
<br />
//Button in UiApp<br />
//Create button with any name<br />
<span style="color: blue;">var addButton = app.createButton("Submit").setEnabled(true);</span><br />
//assign the any user define function and arguments(textAreaA)<br />
<span style="color: blue;">var handler = app.createServerClickHandler('sendback').addCallbackElement(textAreaA);</span><br />
//assign above function to onclick event<br />
<span style="color: blue;">addButton.addClickHandler(handler);</span><br />
//finally add it to UAiApp Class<br />
<span style="color: blue;">app.add(addButton);</span><br />
<br />
<br />
//label in UiApp<br />
//create label and resize the alignment as well<br />
<span style="color: blue;">var labelA = app.createLabel("Developed by macrolayer.blogspot.com").setPixelSize(900,80).setHorizontalAlignment(UiApp.HorizontalAlignment.RIGHT);</span><br />
//Finally add it to UiApp<br />
<span style="color: blue;">app.add(labelA);</span><br />
<br />
//anchor in UiApp<br />
//As I said early, Html doesnot support Anchor tag, this anchor class will help to do so. create and add it to UiApp<br />
<span style="color: blue;">var anchor1 = app.createAnchor("View my blog |", "http://macrolayer.blogspot.com");</span><br />
<span style="color: blue;">app.add(anchor1);</span><br />
<br />
<br />
<br />
//you can add those classes with good allignment using VerticalPanel or HorizontalPanel<br />
//finally close the function by returning the UiApp class<br />
<span style="color: blue;"> return app;</span><br />
<span style="color: blue;">}</span><br />
<br />
//doGet function will execute as userinterface and sendback function will be called once the function is called.(in our example "onclick")<br />
<br />
//since we passed argument for this function, the function should have argument e<br />
<span style="color: blue;">function sendback(e) {</span><br />
//get the existing UiApp<br />
<span style="color: blue;"> var app = UiApp.getActiveApplication();</span><br />
//get textAreaA value from parameter e<br />
<span style="color: blue;"> var line=e.parameter.textAreaA;</span><br />
<br />
<br />
//write your code for other execution using the input value 'line'<br />
<br />
<br />
<br />
//response by new control<br />
//create and add new textArea class and write the output using settext class<br />
<span style="color: blue;">var textAreaB= app.createTextArea().setId('TextAreaB').setName('textAreaB').setHeight('100').setWidth('450');; </span><br />
<span style="color: blue;">app.getElementById('TextAreaB').setText(line);</span><br />
<span style="color: blue;">app.add(textAreaB);</span><br />
<br />
//response by existing control<br />
//call the existing control and write the output<br />
<span style="color: blue;"> app.getElementById('TextArea1').setText("Your input is " + line);</span><br />
<br />
<br />
//finally return the app to display the results<br />
<span style="color: blue;">return app;</span><br />
<span style="color: blue;">}</span><br />
<br />
<br />
<br />
<br />
Reference:https://developers.google.com/apps-script/reference/ui/ui-app</div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com0tag:blogger.com,1999:blog-4499264283193382794.post-29306407407613523372013-06-30T22:54:00.000-07:002013-07-25T23:10:16.138-07:00Anchor tag tutorial<div dir="ltr" style="text-align: left;" trbidi="on">
Anchor tag is a traditional tag used from the initial stage of HTML to give the navigation option to the user. It allows user to jump a page from and to. This page will describe its attributes and their significance.<br/>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6XvwRCNF5x-j4aU_VL5BxqzzZ_IHLcgFd-XOxXpUCennowo_2LZzuRHaknsIlY_LebLcN6_hsXcEL_PCtVymz84OmNhw9MrjELA789GIEA6RbAarKRiAl_MwZrVY6eavBJ0VMWVMjeTU/s1600/Anchor+tag.png" imageanchor="1"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6XvwRCNF5x-j4aU_VL5BxqzzZ_IHLcgFd-XOxXpUCennowo_2LZzuRHaknsIlY_LebLcN6_hsXcEL_PCtVymz84OmNhw9MrjELA789GIEA6RbAarKRiAl_MwZrVY6eavBJ0VMWVMjeTU/s320/Anchor+tag.png" height="300" width="320" /></a>
<br />
<table border="1" cellspacing="0">
<tbody>
<tr>
<th align="left" width="20%">Attribute</th>
<th align="left" width="20%">Value</th>
<th align="left">Description</th>
</tr>
<tr>
<td rowspan="4">href</td><td>absolute URL</td><td>different domain, which start with http protocol<br />
href="http://www.differentsite.com/test.asp"</td></tr>
<tr><td>relative URL</td><td>url link on same domain, which doesnot need to start with http protocol<br />
href="homepage.html"<br />
href=<same directory="">+"/homepage.html"<br />
example: href="http://www.example.com/2013/test/homepage.html"<br />
<br />
href="/homepage.html"<br />
href=<root directory="">+"/homepage.html"<br />
example: href="http://www.example.com/homepage.html"<br />
<br />
href="//homepage.org"<br />
href="http:"+"//homepage.org"<br />
example: href="http://homepage.org"<br />
<br />
href="./homepage.html"<br />
href=<same directory="">+"/homepage.html"<br />
example: href="http://www.example.com/2013/test/homepage.html"<br />
<br />
href="../homepage.html"<br />
href=<previous directory="">+"/homepage.html"<br />
example: href="http://www.example.com/2013/homepage.html"</previous></same></root></same></td></tr>
<tr><td>anchor URL</td><td>href="#top"<br />
href=<pageurl>+"#top"<br />
example:href="http://www.example.com#top"</pageurl></td></tr>
<tr><td>mailto protocol</td><td>href="mailto:user@example.com? subject=MessageTitle& body=Message Content"</td></tr>
<tr>
<td rowspan="5"><a href="">target</a></td>
<td>_blank</td><td>Opens the linked document in a new window or tab</td></tr>
<tr><td>_self(default)</td><td>Opens the linked document in the same frame as it was clicked</td></tr>
<tr><td>_parent</td><td>Opens the linked document in the parent frame</td></tr>
<tr><td>_top</td><td>Opens the linked document in the full body of the window</td></tr>
<tr><td>framename</td><td>Opens the linked document in a named frame</td></tr>
<tr>
<td>charset</td>
<td><i>char_encoding</i></td>
<td><span class="deprecated">Not supported in HTML5.</span> Specifies the character-set of a linked document</td>
</tr>
<tr>
<td rowspan="3">coords (supported in Firefox and Opera only)</td>
<td>x1,y1,x2,y2</td><td>If the shape attribute is set to "rect", it specifies the coordinates of the top-left corner and the bottom-right corner of the rectangle</td></tr>
<tr><td>x,y,radius</td><td>If the shape attribute is set to "circle", it specifies the coordinates of the circle center and the radius</td></tr>
<tr><td>x1,y1,x2,y2,..,xn,yn</td><td>If the shape attribute is set to "poly", it specifies the coordinates of the edges of the polygon. If the first and last coordinate pairs are not the same, the browser must add the last coordinate pair to close the polygon</td>
</tr>
<tr>
<td>hreflang</td>
<td><i>language_code</i></td>
<td>A two-letter language code that specifies the language of the linked document.
To view all available language codes, go to <a href="http://www.w3schools.com/tags/ref_language_codes.asp" rel="nofollow">w3schools</a> Language code reference.</td>
</tr>
<tr>
<td>media</td>
<td><i>media_query</i></td>
<td>Specifies what media/device the linked document is optimized for. <a href="http://www.w3schools.com/tags/att_a_media.asp" rel="nofollow">more</a></td>
</tr>
<tr>
<td>name</td>
<td><i>section_name</i></td>
<td><span class="deprecated">Not supported in HTML5.</span> Specifies the name of an anchor</td>
</tr>
<tr>
<td rowspan="12">rel</td>
<td>alternate</td><td>Links to an alternate version of the document (i.e. print page, translated or mirror)</td></tr>
<tr><td>author</td><td>Links to the author of the document</td></tr>
<tr><td>bookmark</td><td>Permanent URL used for bookmarking</td></tr>
<tr><td>help</td><td>Links to a help document</td></tr>
<tr><td>license</td><td>Links to copyright information for the document</td></tr>
<tr><td>next</td><td>The next document in a selection</td></tr>
<tr><td>nofollow</td><td>Links to an unendorsed document, like a paid link.("nofollow" is used by Google, to specify that the Google search spider should not follow that link)</td></tr>
<tr><td>noreferrer</td><td>Specifies that the browser should not send a HTTP referer header if the user follows the hyperlink</td></tr>
<tr><td>prefetch</td><td>Specifies that the target document should be cached</td></tr>
<tr><td>prev</td><td>The previous document in a selection</td></tr>
<tr><td>search</td><td>Links to a search tool for the document</td></tr>
<tr><td>tag</td><td>A tag (keyword) for the current document</td></tr>
<tr>
<td>rev</td>
<td><i>text</i></td>
<td><span class="deprecated">Not supported in HTML5.</span> Specifies the relationship between the linked document and the current document</td>
</tr>
<tr>
<td>shape</td>
<td>default<br />
rect<br />
circle<br />
poly</td>
<td><span class="deprecated">Not supported in HTML5.</span> Specifies the shape of a link</td>
</tr>
<tr>
<td>type</td>
<td><i>MIME_type</i></td>
<td>The MIME type of the linked document.
Look at IANA MIME types for a complete list of standard MIME types</td>
</tr>
</tbody></table>
</div>
Reference:
w3schools.com
w3.orgmacroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com0tag:blogger.com,1999:blog-4499264283193382794.post-75586790330199999752013-05-31T21:10:00.000-07:002013-06-24T21:10:53.575-07:00How to file online Indian Income Tax<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJfhubvzfPDDVDysAcHr-cmJ006SJZGFY8GLZPrAhuVMgvCC-m6f1vz4daLKftScaPvRcYb6nsGAYi5McpFx3Mazn-di2H3cUkP6dLT2IZhLERi90ZRkWpBsr2Qn_Yz286lYrPizDM55c/s1600/Income+tax+filling.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJfhubvzfPDDVDysAcHr-cmJ006SJZGFY8GLZPrAhuVMgvCC-m6f1vz4daLKftScaPvRcYb6nsGAYi5McpFx3Mazn-di2H3cUkP6dLT2IZhLERi90ZRkWpBsr2Qn_Yz286lYrPizDM55c/s400/Income+tax+filling.png" width="400" /></a></div>
<br />
<br />
<ol style="text-align: left;">
<li>Log on to <a href="https://incometaxindiaefiling.gov.in/">https://incometaxindiaefiling.gov.in/</a></li>
<li>If you don't have credentials then create a profile using your PAN as user id.</li>
<li>Select your applicable IT Return Form right side of the homepage</li>
<ol>
<li>ITR 1, for Individuals having Income from Salary / Pension / Income from One House Property / Bank interest</li>
<li>ITR 2, other individuals, who are not having Income from Business or Profession.</li>
<li>Click here for the applicability of form and for other forms: https://incometaxindiaefiling.gov.in/portal/individual_huf.do</li>
</ol>
<li>Fill the IT return excel sheet with</li>
<ol>
<li>Your personal information, ensure you mention your email id correctly.</li>
<li>Salary & TDS information stated in the Salary Certificate and Form 16.</li>
<li>Fill in the details of house property, bank interest and deductions if not claimed in form 16.</li>
<li>Bank details are mandatory, ensure that you enter MICR code correctly.</li>
<li>Follow the tips and in-built validations to ensure that the information filled is complete and accurate. You can save the form at any stage and complete the form as per your convenience.</li>
</ol>
<li>Determine your income & pay tax if necessary.</li>
<ol>
<li>The tax can be paid online, please click on link <a href="https://onlineservices.tin.nsdl.com/etaxnew/tdsnontds.jsp">https://onlineservices.tin.nsdl.com/etaxnew/tdsnontds.jsp</a>.</li>
<li>FAQ - <a href="https://www.tin-nsdl.com/oltas/oltas-faq-payment.php">https://www.tin-nsdl.com/oltas/oltas-faq-payment.php</a></li>
</ol>
<li>Verify your details and then generate .XML File</li>
<ol>
<li>The Excel Utility creates .xml file based on the details filled. Save this in your system</li>
</ol>
<li>Logon to <a href="https://incometaxindiaefiling.gov.in/e-Filing/UserLogin/LoginHome.html">https://incometaxindiaefiling.gov.in/e-Filing/UserLogin/LoginHome.html</a> using your user id and password or create a profile using your PAN as user id</li>
<li>Select Assessment Year under submit returns section</li>
<li>Browse and select .xml file saved in your system</li>
<li>Please note latest version will be considered, so you can resubmit the xml if the information needs to be changed and ensure original form acknowledgement mentioned in revision xml</li>
<li>After successful upload, an electronic receipt of the IT return will be generated.</li>
<ol>
<li>In case you have signed your return with digital signature, the receipt of e-return may be kept for your records and this receipt need not be submitted to the IT Department.</li>
<li>In case you have filed without digital signature, the electronic receipt is generated i.e. ITR-V form. Please note that the ITR-V form can be generated only by the IT Department once you submit the ITR form.</li>
</ol>
<li>Print the ITR-V, Sign and Post to Income Tax Department – CPC, Post Bag No - 1, Electronic City Post Office, Bengaluru - 560100, Karnataka. (Do not drop your ITR-V in proof submission drop boxes) The due date for submission of ITR-V is 120 days from the date of upload of e-return.</li>
<li>As an acceptance of your ITR-V, Income Tax Department sends an e-acknowledgement from mail id –donotreply@incometaxindia.gov.in</li>
</ol>
<br />
<br />
Other points<br />
- For queries, please contact the Income Tax Departments Helpdesk No.<br />
<div style="text-align: justify;">
For Income Tax related queries 1800 180 1961</div>
<div style="text-align: justify;">
For Rectification and refund 1800 425 2229</div>
<div style="text-align: justify;">
For e-Filling of Returns 1800 4250 0025</div>
<div style="text-align: justify;">
Working Hours 09:00 to 20:00 Mon-Sat- </div>
<div style="text-align: justify;">
<br /></div>
</div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com2tag:blogger.com,1999:blog-4499264283193382794.post-90489382940324697212012-04-22T13:11:00.004-07:002012-04-22T13:25:44.428-07:00DHTML blogger comments<div dir="ltr" style="text-align: left;" trbidi="on">This post will describe about some techniques to comment a blogger site with DHTML content. especially dedicated to <a href="http://ifindi.blogspot.com/" rel="nofollow">Ifinder</a><br />
<br />
DHTML is nothing but Dynamic HTML and which is the combination of HTML, Javascript, CSS, HTML DOM. As we discussed in <a href="http://macrolayer.blogspot.com/2012/01/full-html-access-for-blogger-comments.html">HTML comments for Blogger site</a> post, using <a href="http://macrolayer.blogspot.com/p/nccode.html">NCcode</a> we can post HTML contents which gives you customized style of comments. Since external javascript are not secure, though NCcode recognize javascript, it will not accept external javascript. But javascript can be used without functions and variables.<br />
<br />
below are the few examples for including javascripts in blogger comments(for non-techies please replace the highlighted parts with your images.)<br />
<br />
Effect: on click, image toggle<br />
<img border="0" height="180" onclick="if (this.src=='http://www.w3schools.com/dhtml/bulboff.gif'){this.src='http://www.w3schools.com/dhtml/bulbon.gif';}else{this.src='http://www.w3schools.com/dhtml/bulboff.gif';}" src="http://www.w3schools.com/dhtml/bulboff.gif" width="100" /><br />
<br />
NCcode:<br />
〈img onclick="if (this.src=='<span style="color: red;">http://www.w3schools.com/dhtml/bulboff.gif</span>'){this.src='<span style="color: red;">http://www.w3schools.com/dhtml/bulbon.gif</span>';}else{this.src='<span style="color: red;">http://www.w3schools.com/dhtml/bulboff.gif</span>';}" border="0" src="http://www.w3schools.com/dhtml/bulboff.gif" width="100" height="180" /〉<br />
<br />
<hr />Effect: Anchor tag on particular pixel(Map effect)<br />
<img height="126" src="http://www.w3schools.com/jsref/planets.gif" usemap="#planetmap" width="145" /><map name="planetmap"> <area alt="Venus" coords="124,58,8" href="http://www.w3schools.com/images/venglobe.gif" id="venus" shape="circle"></area> </map><br />
<br />
NCcode:<br />
〈img src="<span style="color: red;">http://www.w3schools.com/jsref/planets.gif</span>" width="145" height="126" usemap="#planetmap" /〉〈map name="planetmap"〉 〈area id="venus" shape="circle" coords="124,58,8" alt="Venus" href="<span style="color: red;">http://www.w3schools.com/images/venglobe.gif</span>" /〉 〈/map〉<br />
<br />
<hr />Effect: Hide/unhide the comments<br />
<input onclick="document.getElementById('p2').style.visibility='hidden'" type="button" value="Hide text" /><input onclick="document.getElementById('p1').style.visibility='visible'" type="button" value="Show text" /><br />
<br />
<br />
<br />
<div id="p2">you can hide me.</div>NCcode:<br />
〈input type="button" value="Hide text" onclick="document.getElementById('pic').style.visibility='hidden'" /〉〈input type="button" value="Show text" onclick="document.getElementById('pic').style.visibility='visible'" /〉<br />
〈p id="p1"〉<span style="color: red;">you can hide me.</span>〈/p〉<br />
<br />
<hr />Effect:mouse over enlarge the image<br />
<img height="180" id="image" onmouseout="this.width='100';this.height='180';" onmouseover="this.width='200';this.height='360';" src="http://www.w3schools.com/dhtml/bulbon.gif" width="100" /><br />
<br />
NCcode:<br />
〈img id="image" src="<span style="color: red;">http://www.w3schools.com/dhtml/bulbon.gif</span>" onmouseover="this.width='<span style="color: red;">200</span>';this.height='<span style="color: red;">360</span>';" onmouseout="this.width='<span style="color: red;">100</span>';this.height='<span style="color: red;">180</span>';" width="<span style="color: red;">100</span>" height="<span style="color: red;">180</span>" /〉<br />
<br />
<hr />If you notice you would have found one thing that is javscript can be included in events like onMouseout, onMouseover, Onclick... you can develop complex javascripts with in events and you can make the effect in blogger comments. If you use image toggling effect, then it would reduce your page loading time comparing to large images<br />
<br />
<br />
Suggestion for Blog owner:<br />
If you are good in javascript, then allow the javascripted comments while moderating your blog comments. If not Please don't allow any javascripted comments it may have span links.<br />
<br />
<br />
<br />
Reference:<a href="http://www.w3schools.com/dhtml" rel="nofollow">W3shools</a></div>macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com25tag:blogger.com,1999:blog-4499264283193382794.post-73856030244448852652012-03-23T12:38:00.004-07:002012-03-23T12:41:14.749-07:00ASCII comments for social sites<div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: left;" trbidi="on">Have you ever wondered about ASCII arts? It would be the pictorial representation by simple text characters.<pre> |\_/|
/ @ @ \
( > º < )
`»»x««´
/ O \ </pre>
There are many types of ASCII Art like text art, image art, 3D image art etc., Now here Macrolayer introduce one more new tool to generate text ASCII art with personalized symbols. From which you can create text messages in the ASCII symbols. It can be a greeting phrases, welcome notes, or any personal talk. You can choose the ASCII symbol which you need to spread across the art; you can resize the art with different size; you can paint ASII text color or its background color.
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmFMv1W7Y6p_6WPbfI7KbKEO9Ui_YTvdH951kyBSMlBjIUhdfJ_ED5vpFOPSt5g336Cjp-Z5oIIOMn1SUPI1rnv7RbO3i3quQ8R8V9sKcUUtfw8L_cPR4kB43DeDxC5aDMEbcwI8r2ybQ/s1600/ASCII+art.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="302" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmFMv1W7Y6p_6WPbfI7KbKEO9Ui_YTvdH951kyBSMlBjIUhdfJ_ED5vpFOPSt5g336Cjp-Z5oIIOMn1SUPI1rnv7RbO3i3quQ8R8V9sKcUUtfw8L_cPR4kB43DeDxC5aDMEbcwI8r2ybQ/s400/ASCII+art.JPG" width="400" /></a></div><div style="text-align: center;"><b><a href="http://macrolayer.blogspot.com/p/ascii-font.html">ASCII FONT Generator</a></b> </div><a name='more'></a>
<b>Significance:</b>
<ul style="text-align: left;"><li>Unlike most of the online tools generated Art, this can be used in any social sites. Because ASCII characters are filled without any blank space. {Even you can generate ASCII fonts with blank space but which can't be used in social sites.}</li>
<li>You can use it as HTML format or simple text format. The Tool allows you to get HTML code format of the output. Since HTML format support color attributes, you can avail such colors. Since most of the social sites won't allow HTML format you may not get that. {Exception for Blogger if you use<a href="http://macrolayer.blogspot.com/p/nccode.html"> NCcode</a>}</li>
<li>The tool use two combinations of characters which you prefer. by default it choose light and bright symbols '░' and '▓', which would be recommended for black & white format. If you willing to take HTML format then it can be any symbols since you can select the color to contrast the visibility</li>
<li>It would be recommended to choose equal width characters like (-,=) and not (|,M), Since combination of "||||||||||" characters will not meet length of "MMMMMMMMMM". There are few suggested style lists which help you to choose better one.</li>
<li>You can even use any HTML codes as a symbol below is the output of two HTML codes</li>
</ul>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimSzfGRnoSQTWIQsrUQH_piRp7oJD1_5Rp5WcSlB10QGFPUqE0EuCZ1WgBGW13NY3YkxJfek8C-GDHWS5ajVNkHsl-DxHBv1RgdPyqB6G6M9vubZ-ZsJihII5gfVkFJ4faWRXM_MxzG2E/s1600/ASCII+font.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimSzfGRnoSQTWIQsrUQH_piRp7oJD1_5Rp5WcSlB10QGFPUqE0EuCZ1WgBGW13NY3YkxJfek8C-GDHWS5ajVNkHsl-DxHBv1RgdPyqB6G6M9vubZ-ZsJihII5gfVkFJ4faWRXM_MxzG2E/s320/ASCII+font.JPG" width="320" /></a></div>Codes are:
<img width="20" src="image url"/>
<img style="visibility:hidden;" width="20" src="image url"/></div>you can comment a blogger post or scrap a facebook page or twit a limited text in twitter.
More over paste it in you mail and let this to roam around the world.
─╫╫╫╫╫─╫───╫───╫───╫───╫─╫──╫───╫────╫──╫╫╫──╫───╫
───╫───╫───╫──╫─╫──╫╫──╫─╫─╫─────╫──╫──╫───╫─╫───╫
───╫───╫╫╫╫╫─╫───╫─╫─╫─╫─╫╫───────╫╫───╫───╫─╫───╫
───╫───╫───╫─╫╫╫╫╫─╫──╫╫─╫─╫──────╫────╫───╫─╫───╫
───╫───╫───╫─╫───╫─╫───╫─╫──╫────╫──────╫╫╫───╫╫╫─
Suggestions and bugs are invited.</div>macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com3tag:blogger.com,1999:blog-4499264283193382794.post-33223013345140873162012-03-01T19:20:00.004-08:002012-03-01T19:26:10.894-08:00Random gadgets for Bloggers<div dir="ltr" style="text-align: left;" trbidi="on"><br />
It is an interesting thing to show random messages or pictures or ads in the Website. you may love to show different messages on the same page when user visit same page again. That may be your picture, which have different pose on every refresh. Even that can be a blogger gadgets, on every refresh on the same page you can make to get random gadgets. This type of Randoming will make different look on your pages. Let see how to make random elements<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWxSHOWJcaqTlATJ68WpgE0hUHhSRnWfsx7MD9H7frYdeJ7kg03S5ew7raj_qgaky3LrC2tVM5xv6W5ZhyphenhyphengomUsg5RkdBCTZp0Bqd2p8Vc7PGXFE5T8BMi7aYKkI1iPuedS8ZAQApnpQ4/s1600/Random+HTML.jpg" imageanchor="1" style="clear:center; float:center;margin-right:1em; margin-bottom:1em"><img border="0" height="279" width="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWxSHOWJcaqTlATJ68WpgE0hUHhSRnWfsx7MD9H7frYdeJ7kg03S5ew7raj_qgaky3LrC2tVM5xv6W5ZhyphenhyphengomUsg5RkdBCTZp0Bqd2p8Vc7PGXFE5T8BMi7aYKkI1iPuedS8ZAQApnpQ4/s320/Random+HTML.jpg" /></a></div><br />
<a name='more'></a><br />
<br />
<br />
<b>Code:</b><br />
<div id="Randomme" style="display: none;"><br />
<span style="color: red;"><b>......</b></span><br />
</div><br />
<div id="Randomme" style="display: none;"><br />
<span style="color: red;"><b>......</b></span><br />
</div><br />
<div id="Randomme" style="display: none;"><br />
<b><span style="color: red;">......</span></b><br />
</div><br />
<script language="JavaScript"><br />
Randomme[Math.round(Math.random()*(Randomme.length-1))].style.display="block";<br />
</script><br />
<br />
This is the Basic syntax for the random contents. Note that highlighted dots are the space for your contents. That can be a HTML. Below is the unit content and you can add n number of contents that you wish.so final output will be any one from these whole content in random pick.<br />
<div id="Randomme" style="display: none;"><br />
<b><span style="color: red;">......</span></b><br />
</div><br />
<br />
<b>How to add?</b><br />
First select your contents(Pictures or Message with HTML format) and fill the above syntax.<br />
you can add it directly to your Blog template where you need this effect<br />
For Blogspot site, you can also add this codes in Template-> add Gadget-> HTML/JavaScript<br />
<br />
<b>Applied Examples:</b><br />
Below is the code which display below effect<br />
<br />
<div id="Randomme" style="display: none;"><br />
<span style="color: red;">I use <a href="http://google.com">Google</a></span><br />
</div><br />
<div id="Randomme" style="display: none;"><br />
<span style="color: red;">I like to blog about webdesign and Cartoons/Paintings </span><br />
</div><br />
<div id="Randomme" style="display: none;"><br />
<span style="color: red;">Thanks for visiting My blog. Please Visit me again</br></span><br />
<span style="color: red;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE-EpBssLpmc1-t99Nja3QenpSgkiVM2OFK5YU1cp0F2J4OhOzD6jOPOFbbTkJG_2ahAtrlZd0ICt_9n0dlAtSVL71X7XMaPzWza6Rt4jzPjhL4eU5-1pA1EI2-rifxTzsCByRXu84ysU/s1600/Macrolayer.jpg" imageanchor="1" style="clear:left; float:left;margin-right:1em; margin-bottom:1em"><img border="0" height="89" width="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE-EpBssLpmc1-t99Nja3QenpSgkiVM2OFK5YU1cp0F2J4OhOzD6jOPOFbbTkJG_2ahAtrlZd0ICt_9n0dlAtSVL71X7XMaPzWza6Rt4jzPjhL4eU5-1pA1EI2-rifxTzsCByRXu84ysU/s320/Macrolayer.jpg" /></a></span><br />
</div><br />
<div id="Randomme" style="display: none;"><br />
<span style="color: red;">If you are the new blogger read me <a href="http://macrolayer.blogspot.com/2011/10/five-steps-for-new-bloggers.html">5 Tips for you</a></span><br />
</div><br />
<div id="Randomme" style="display: none;"><br />
<span style="color: red;"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguYx0-piz4ofkeiIIaLk7OZfIy4UoTHyUVX3HmVKSnGmBfku9943HznnPwULbadK_ZtAiA75cbz04qI7tGbsWzA9y5lX76mt-iAyJ7UR2RQNYLVTrFv1jPw5y-ghzsTclVKTyJvXbzX9g/s1600/0GetHer.gif" /></span></div><br />
<div id="Randomme" style="display: none;"><br />
<span style="color: red;"><!-- Place this tag in the <head> of your document --></span><br />
<span style="color: red;"><link href="https://plus.google.com/108072841148840858643" rel="publisher" /><script type="text/javascript"></span><br />
<span style="color: red;">window.___gcfg = {lang: 'en'};</span><br />
<span style="color: red;">(function() </span><br />
<span style="color: red;">{var po = document.createElement("script");</span><br />
<span style="color: red;">po.type = "text/javascript"; po.async = true;po.src = "https://apis.google.com/js/plusone.js";</span><br />
<span style="color: red;">var s = document.getElementsByTagName("script")[0];</span><br />
<span style="color: red;">s.parentNode.insertBefore(po, s);</span><br />
<span style="color: red;">})();</script></span><br />
<span style="color: red;"><g:plus href="https://plus.google.com/108072841148840858643" width="300" height="131" theme="light"></g:plus></span></div><br />
<script language="JavaScript"><br />
Randomme[Math.round(Math.random()*(Randomme.length-1))].style.display="block";<br />
</script><br />
<br />
<br />
<br />
<br />
Demo:<br />
<table width="100%"><tbody>
<tr> <td style="-moz-border-radius: 1em; background-color: #effbff; border: 2px solid #99CEDF; font-family: Arial; font-size: 15px; padding: 10px;"><br />
<div id="Randomme" style="display: none;">I use <a href="http://google.com/">Google</a></div><div id="Randomme" style="display: none;">I like to blog about webdesign and Cartoons/Paintings </div><div id="Randomme" style="display: none;">Thanks for visiting My blog. Please Visit me again<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE-EpBssLpmc1-t99Nja3QenpSgkiVM2OFK5YU1cp0F2J4OhOzD6jOPOFbbTkJG_2ahAtrlZd0ICt_9n0dlAtSVL71X7XMaPzWza6Rt4jzPjhL4eU5-1pA1EI2-rifxTzsCByRXu84ysU/s1600/Macrolayer.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="89" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE-EpBssLpmc1-t99Nja3QenpSgkiVM2OFK5YU1cp0F2J4OhOzD6jOPOFbbTkJG_2ahAtrlZd0ICt_9n0dlAtSVL71X7XMaPzWza6Rt4jzPjhL4eU5-1pA1EI2-rifxTzsCByRXu84ysU/s320/Macrolayer.jpg" width="320" /></a></div><div id="Randomme" style="display: none;">If you are the new blogger read me <a href="http://macrolayer.blogspot.com/2011/10/five-steps-for-new-bloggers.html">5 Tips for you</a></div><div id="Randomme" style="display: none;"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguYx0-piz4ofkeiIIaLk7OZfIy4UoTHyUVX3HmVKSnGmBfku9943HznnPwULbadK_ZtAiA75cbz04qI7tGbsWzA9y5lX76mt-iAyJ7UR2RQNYLVTrFv1jPw5y-ghzsTclVKTyJvXbzX9g/s1600/0GetHer.gif" /></div><div id="Randomme" style="display: none;"><link href="https://plus.google.com/108072841148840858643" rel="publisher"></link><script type="text/javascript">
window.___gcfg = {lang: 'en'};
(function()
{var po = document.createElement("script");
po.type = "text/javascript"; po.async = true;po.src = "https://apis.google.com/js/plusone.js";
var s = document.getElementsByTagName("script")[0];
s.parentNode.insertBefore(po, s);
})();
</script><br />
<g:plus height="131" href="https://plus.google.com/108072841148840858643" theme="light" width="300"></g:plus></div><script language="JavaScript">
Randomme[Math.round(Math.random()*(Randomme.length-1))].style.display="block";
</script><br />
</td></tr>
</tbody></table><br />
Refresh this page to see the difference.<br />
</div>macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com2tag:blogger.com,1999:blog-4499264283193382794.post-19788374335162765912012-02-02T13:21:00.000-08:002012-02-02T13:30:11.346-08:00How to avoid country specific Blogspot URL<div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: left;" trbidi="on"><span style="color: red; font-size: large;">R</span>ecently Blogger has announced country code Top Level Domain (ccTLD) for few countries like India, Australia,.. As per Blogger note, it will be launched for more countries in near futures. Technically, which means a visitors from these countries will be redirected to their ccTLD eg) an Indian visitor view my blog as macrolayer.blogspot.in & australian visitor view my blog as macrolayer.blogspot.com.au.<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhDvAEYu-GNJHkzCPIJcRJEi56Ck6uM_OzXKxpuL2Fz8SLVfL1hiBgK1cg2QXw0qJngDqCzCga6AMFqRis2Yc-4oz0qY-NuSXQjnvPb9lWi-66_7pVBk9xUVXwX7RMxwiWNa9QOflIY4U/s1600/Blogger+domain.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="268" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhDvAEYu-GNJHkzCPIJcRJEi56Ck6uM_OzXKxpuL2Fz8SLVfL1hiBgK1cg2QXw0qJngDqCzCga6AMFqRis2Yc-4oz0qY-NuSXQjnvPb9lWi-66_7pVBk9xUVXwX7RMxwiWNa9QOflIY4U/s400/Blogger+domain.png" width="400" /></a></div><a name='more'></a><br />
Moreover this localization is for to filter the content accordingly to the local laws by their domain name. As a blogger, It affects minimum on SEO effect and maximum on add-ons. In SEO part serach engines suck the content as per canonical tag in you blog and blogger.com promised that SEO loss will be minimized. In add-on part, it affect thirdparty builts like twitter button, facebook button, other aggregators and third party gadgets which play with blogspot.com domain. which means, facebook button shows only the sharing count of the blogspot.com or blogspot.in to respective audience. so probable you would miss the gross sharing counts. similarly for other voting built-ins which read different counts. gadgets which are developed for .com will not work for .in domains probable google gadgets won't be affected as it is their redirection. so ultimately, If you are looking for the solution to avoid blogspot ccTLD redirection please go ahead.<br />
<br />
<b><u>For readers:</u></b> you can directly place /ncr in the url and avoid the localization<br />
eg) macrolayer.blogspot.com/ncr<br />
<br />
<b><u>For Blog owners:</u></b><br />
It may be an important act for some owner to avoid localization to consolidate their social networking presence. you have two option to avoid this.<br />
<br />
<b>option:1</b><br />
which is a simple Technic, just replacing all .in links in your page to .com domain. most of the social sharing buttons are responsive for this method. For which you have to place below code just above the </body> tag in your blog template<br />
<script type='text/javascript'><br />
document.body.innerHTML = document.body.innerHTML.replace(/blogspot\.<span style="color: red;">in</span>/gi, "blogspot.com");<br />
</script><br />
<br />
<b>option:2</b><br />
Which is the solid Technic to just revert the blogger redirect against them. It will secure you blog from localization for visitors. This will help all types of third-party add-ons. For which you have to place below code just below <head> tag in your blog template<br />
<br />
<script type='text/javascript'><br />
var local = "<data:blog.url/>";<br />
var checker = local.split(/blogspot\.<span style="color: red;">in</span>/i)<br />
if(checker[1]){window.location = local.replace(/blogspot\<span style="color: red;">.in</span>/gi, "blogspot.com/ncr");}<br />
</script><br />
<br />
</div><br />
note:above codes are mainly for Indian users, other country users can use the same code by just replacing .in with their respective country TLdomains</div>macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com21tag:blogger.com,1999:blog-4499264283193382794.post-49823868238392821382012-01-22T15:56:00.000-08:002012-02-02T13:22:37.290-08:00Full HTML access for Blogger Comments<div dir="ltr" style="text-align: left;" trbidi="on">Lets break the rules for commenting in Blogger website.<br />
<br />
As you know <a href="http://macrolayer.blogspot.com/p/nccode.html">NCcode</a> made blogger comments to show images, texts, and more with some syntax. But there was few discussions with fellow bloggers on personalized needs. and Ncode was also frequently updated with more syntax to adhere the commentors wish.<br />
<br />
Now time for releasing the new feature to accrue HTML syntax. You have to do just a single conversion from HTML to NCcode and post it in blogger website. This will help you to post comments with HTML code<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMst5U1E3LHnDLTy4hhCCn_06B_DI8ftQ9MyTAiTVq6kc-zl1k6OObCa_4A7EkthBK6blTj-soLGzcY8Q2eDaQl7cZEabDR0mABua9nGQgTbcgiCcN5NBDeomukF7sO3ST-49vs3NblY8/s1600/HTML+Blogger+comments.jpg" imageanchor="1" style="clear: left; float: center; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="306" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMst5U1E3LHnDLTy4hhCCn_06B_DI8ftQ9MyTAiTVq6kc-zl1k6OObCa_4A7EkthBK6blTj-soLGzcY8Q2eDaQl7cZEabDR0mABua9nGQgTbcgiCcN5NBDeomukF7sO3ST-49vs3NblY8/s320/HTML+Blogger+comments.jpg" width="320" /></a></div><a name='more'></a><br />
<b>How to Install?</b><br />
As it mentioned <a href="http://macrolayer.blogspot.com/2010/12/picture-comments-for-blogger.html">early</a>, Just place this single snippet in blogger template, If you haven't placed early. Those who have already added ignore this steps.<br />
<table frame="box"><tbody>
<tr><td><br />
<script src='http://hosting.gmodules.com/ig/gadgets/file/105066904960012479556/nccode.js' type='text/javascript'/></td></tr>
</tbody></table><br />
<b>How to Use?</b><br />
As it informed early, you can use syntax [im],[ma],[si].... to get images,marquee and more... without using HTML. These syntax are listed over here. Moreover new version has been upgraded with HTML language. You have to post the HTML code in your blog once it converted to NCcode.<br />
You can find converter Here- <a href="http://macrolayer.blogspot.com/p/nccode.html"><b>HTML to NCcode converter</b></a><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtbiXWnA3vvzfRgP57euPeLhPV0b-fq-bqfbpLBQc1KHJlGJyjsiKBfaf6YS26E09QTWkTZAmAjCY41xCN4ykiWMSuoyKFFzdF9UCz6VQyzdCXieGYDteJoRZxCcPGT1WkvoYiOfW9xpA/s1600/HTML+to+NCcode.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="249" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtbiXWnA3vvzfRgP57euPeLhPV0b-fq-bqfbpLBQc1KHJlGJyjsiKBfaf6YS26E09QTWkTZAmAjCY41xCN4ykiWMSuoyKFFzdF9UCz6VQyzdCXieGYDteJoRZxCcPGT1WkvoYiOfW9xpA/s320/HTML+to+NCcode.jpg" width="320" /></a></div><br />
<b>Examples:</b><br />
To add this format <br />
<h1 style="color: orange; text-align: center;">CSS example!</h1>you have to paste below code in blogger comment box<br />
&#12296;h1 style="color:orange;text-align:center;"&#12297; CSS example!&#12296;/h1&#12297;<br />
<br />
this is nothing but just a NCcode converted from HTML code using the converter<br />
<h1 style="color: orange; text-align: center;"><br />
<br />
To add this format<br />
<span style="text-shadow: rgb(0, 0, 0) 5px 0px 7px;"><b>Welcome to Macro Layer</b></span><br />
Paste below codes<br />
&#12296;span style="text-shadow: 5px 0px 7px #000;"&#12297;&#12296;b&#12297;Welcome to Macro Layer&#12296;/b&#12297;&#12296;/span&#12297;<br />
<br />
<br />
You can create tables, designs, formatted comments like a blog post. You can comment with your creative works. once you converted the desire NCcode, you can use the same as syntax. Those who are new to HTML, you can get HTML code for web design from blogger compose page or HTML editors like <a href="http://freeonlinehtmleditor.com/" rel="nofollow">freeonlinehtmleditor.com</a>.<br />
<br />
For Blog owners, you can instruct your visitors by Placing the below message in Settings-> comments->Comment Form Message for blog readers.<br />
<table frame="box"><tbody>
<tr><td><br />
You Can use HTML code once it converted to NCcode by <a href="http://macrolayer.blogspot.com/p/nccode.html">NCode converter</a></td></tr>
</tbody></table><br />
For Readers, You can avail HTML properties in Blogger comments, If that blog have installed with NCcode.<br />
<br />
<br />
<b>Note:</b><br />
* You have to be conscious not only the comment body but also the HTML elements used, If you are the approver for you blogger comments.<br />
* External CSS or Javascript function will not work. Temporarily, Video streamings are also blocked for public opinion. Do you think video are secure to enable here? Suggestions and Bugs are always welcomed.</div>macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com38tag:blogger.com,1999:blog-4499264283193382794.post-31867175449147933402011-12-31T18:13:00.000-08:002012-01-27T16:01:32.931-08:00AppsScript - Macro - Javascript<div dir="ltr" style="text-align: left;" trbidi="on">Google Apps script and VBA Macro and Javascript are the powerful scripts which work on worksheets. Depending on the usage of the worksheet we can choose any of the above scripts. let say, If you need online automation then Appscript would be the best of the choice. For local automation Macro and Javascript play vital role. Many of us are not sure about similarities on these. In this series, I would like to share the similarities on these scripts. In this post let see how to read the spreadsheets<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCoXddGGm9TD_se6dxh5fOgHq8dCaYj_eg6HQBXSeFab-oXeiLlUAgzkZ-j1KLPNw8aMFGX8gqCx0VYp721xNA5PCWOuJ7b1EWt47q_eH4Dcv02734IGnkFq7eHbDPb-iAODk3QvE5sXY/s1600/Macro+AppsScript+Javascript.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCoXddGGm9TD_se6dxh5fOgHq8dCaYj_eg6HQBXSeFab-oXeiLlUAgzkZ-j1KLPNw8aMFGX8gqCx0VYp721xNA5PCWOuJ7b1EWt47q_eH4Dcv02734IGnkFq7eHbDPb-iAODk3QvE5sXY/s320/Macro+AppsScript+Javascript.png" width="308" /></a></div><br />
For reading the worksheet:<br />
Google Apps Script for reading another spread sheet<br />
<br />
<blockquote class="tr_bq"> var myBook = spreadsheetApp.openById("0Aoh6e6FJ10dSGc"); // open id is the key string able to find in the spread sheet url </blockquote><blockquote class="tr_bq">var mySheet = myBook.getSheetByName("sheet1"); //name of the sheet<br />
var <span style="color: red;">myRange</span> = mySheet.getRange(1,1).getValue(); // range represent first row first column<br />
</blockquote>VBA Macro Script for reading another Worksheet <br />
<blockquote class="tr_bq">Dim myBook as Excel.workbook<br />
set myBook = Getobject("C:\sample\book1.xls")<br />
<span style="color: red;">myRange</span> = myBook.worksheets(1).Cells(1,1).Value<br />
myBook.Close 'make sure this needs to be closed, if it is declared early.</blockquote><br />
<br />
JavaScript for reading another Worksheet<br />
<br />
<blockquote class="tr_bq">var myBook = new ActiveXObject("Excel.Application").workbooks.open("c:\sample\book1.xls");<br />
var mySheet = myBook.Sheets(1);<br />
var<span style="color: red;"> myRange</span> = mySheet.cells(1,1).Value; //ActiveXObject is supported by IE only & other browsers are not supportable</blockquote><br />
<b> <span style="color: red;">myRange</span> is the Read value </b><br />
<br />
<br />
on simple way we can compare these as<br />
SpreadsheetApp.openById("0Aoh6e6FJ10dSGc").getSheetByName("sheet1").getRange(1,1).getValue());<br />
<br />
new ActiveXObject("Excel.Application").workbooks.open("c:\sample\book1.xls").Sheets(1).cells(1,1).Value;<br />
<br />
Getobject("C:\sample\book1.xls").worksheets(1).Cells(1,1).Value</div>macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com0tag:blogger.com,1999:blog-4499264283193382794.post-19185703781979940982011-11-20T13:54:00.000-08:002014-02-09T16:32:18.876-08:00Sort Blogger comments by Descending<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: red;">Below Code has been depreciated when Google introduced Thread commenting feature</span><br />
<br />
Recently <a href="http://www.blogger.com/profile/03481511574299034043" rel="nofollow"><b><span style="color: #3366cc;">Purnomo</span></b></a> has quested how to reverse the blogger comments order?<br />
But I searched in web is there any existing technique for this, But unfortunately no idea was available for the users. So MacroLayer Pleasure to introduce new Script for Date Descending.<br />
<br />
Let we see how to sort the Blogger comments orders in our blogs. Since blogger hosts the comment, we can’t alter the order which it comes. But we can make prolific blogs design which reads blogger comments in descending order. Technically, latest comments will display top on your comment area. Not sure everyone likes to sort their comment order, but definitely many blog owners are looking for comment sorting option. This new Script will make you to sort simply a reverse. This script doesn’t affect any template design or any add-on which are in your blog. More over it is user friendly for most of the blogger templates. Now it is tested clean for IE,Firefox,Chrome. <br />
<br />
How to install:<br />
Just copy the below code and paste it above the <b></body></b> code in your blog template. <br />
<br />
<span style="color: purple;"><script src='http://hosting.gmodules.com/ig/gadgets/file/105066904960012479556/ncsort.js' type='text/javascript'/></span><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIifsQvR-_QtsZcY25dVITPqLaORwDMmKUDiqrR1iiXFUUpwBswz4UNfNNhoZ9dZUSkfpBVPnO8po6ehFzm8z990XUVOAtgq8O_gEi7SPV6lAAlHRn0vWUEGsxZ2NzgFDCE8L80uB-_kg/s1600/Blogger+comment+sort.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIifsQvR-_QtsZcY25dVITPqLaORwDMmKUDiqrR1iiXFUUpwBswz4UNfNNhoZ9dZUSkfpBVPnO8po6ehFzm8z990XUVOAtgq8O_gEi7SPV6lAAlHRn0vWUEGsxZ2NzgFDCE8L80uB-_kg/s400/Blogger+comment+sort.jpg" hda="true" height="400" width="372" /></a></div>
<br />
this script will sort out all your comments in all your posts in your blog. If you want to sort only a particular post then replace the below red words with your post address and copy this and paste it in your template just above any of the <b><div id='backlinks-container'></b> tag or <b><p class='comment-footer'></b> tag <br />
<br />
<br />
<b:if cond='data:post.url == "<b><span style="color: red;">http://yourblogaddress.blogspot.com/2011/11/sample.html</span></b>"'><br />
<script src='http://hosting.gmodules.com/ig/gadgets/file/105066904960012479556/ncsort.js' type='text/javascript'/><br />
</b:if><br />
<br />
<br />
Still if you have a Problem in your template drop a comment with your blog address<br />
Enjoy!</div>
macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com25tag:blogger.com,1999:blog-4499264283193382794.post-39335398582623907192011-10-19T18:37:00.000-07:002011-10-19T18:37:05.468-07:00Five steps for new bloggers<div dir="ltr" style="text-align: left;" trbidi="on">Are you the new enthusiastic to the blogging world? here are the Five important steps that you have to do to ensure the quality of your blog page, Mainly for Blogger webpages.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-wV1pocgmAXf8skV3R63LxYht3Vgz2EjYCOItG1-MLy8l1HEBVl3BPt0MmMh4IAKIIil3SZcjmfieBiDQqOXkMnRoo1KxJzbqNbECl9hx5Zgurl1ILvk38bLDkc_Y2ioyvpyP15gKLIU/s1600/five+steps+for+bloggers.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="214" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-wV1pocgmAXf8skV3R63LxYht3Vgz2EjYCOItG1-MLy8l1HEBVl3BPt0MmMh4IAKIIil3SZcjmfieBiDQqOXkMnRoo1KxJzbqNbECl9hx5Zgurl1ILvk38bLDkc_Y2ioyvpyP15gKLIU/s320/five+steps+for+bloggers.jpg" width="320" /></a></div><br />
<span class="Apple-style-span" style="color: red; font-size: large;">H</span>ope you do title and description for your site for visitors. But one more thing you have to do same for web crawlers. I mean, You have to provide description and keywords for varies web crawlers from search engine in Meta tags. in easy word, this description will be listed on Google search results when your blog is listed over there. If you not listed your blog description then Google or other search engine do pick random sentence from your post and which does not provide the actual description for the visitors.<br />
<a href="http://www.google.com/search?q=macrolayer.blogspot.com" rel="nofollow">you can check this site in Google</a><br />
Goto you template editor mode [for blogger's Edit HTML] and place below code just below the head element which will start with <head><br />
<br />
<br />
<center>-------------</center><br />
<b:if cond='data:blog.pageName == &quot;&quot;'><br />
<title><data:blog.title/></title><br />
<meta content='<b><span class="Apple-style-span" style="color: red;">Macro pages of micro thoughts in Webdesign,Tips,Animation,Cartoon,Javascript,Gadgets and more</span></b>' name='description'/><br />
<b:else/><br />
<title><data:blog.pageName/> | <data:blog.title/></title><br />
</b:if><br />
<meta content='<b><span class="Apple-style-span" style="color: red;">Webdesign,Tips,Animation,Cartoon,Javascript,Gadgets,innovation</span></b>' name='keywords'/><br />
<br />
<center>-------------</center><br />
change the bold letters with your own descriptions and keywords for you blog<br />
<br />
<span class="Apple-style-span" style="color: red; font-size: large;"><b>E</b></span>nsure the blog comment box as visitor friendly. which is the way you can get real inputs and support from readers. some Blog doesn't have comment box and other hand do restrict some accounts for commenting. As far as you concern on security, you can follow strict usage; but friendly request is to make available for all to comment. Blogspot sites are advised to remove the word verification on comment window that can be done by Settings-> comments-> Show word verification for comments? set to No<br />
<br />
<b><span class="Apple-style-span" style="color: red; font-size: large;">S</span></b>ubmit you site to search engines for web search. There are more search engines are available among that <a href="http://www.google.com/addurl/" rel="nofollow">Google</a>, <a href="http://www.search.yahoo.com/info/submit.html" rel="nofollow">Yahoo</a> and <a href="https://ssl.bing.com/webmaster/SubmitSitePage.aspx" rel="nofollow">Bing</a> are the remarkable engines. Do submit you sites<br />
<br />
<span class="Apple-style-span" style="color: red; font-size: large;"><b>A</b></span>dd share buttons in the post which will let your blog to more readers. you can use <a href="http://www.google.com/search?q=share+buttons" rel="nofollow">ready-made</a> code snippet which contain all social networking sites or you can use manual code from particular sites. Ultimate intention behind this is to encourage your readers to share your page content to their friends. which get you more readership<br />
<a href="http://www.google.com/webmasters/+1/button/" rel="nofollow">Google Plusone</a><br />
<a href="http://twitter.com/about/resources/tweetbutton" rel="nofollow">Twitter</a><br />
<a href="http://developers.facebook.com/docs/reference/plugins/send/" rel="nofollow">Facebook</a><br />
<br />
<span class="Apple-style-span" style="color: red; font-size: large;"><b>F</b></span>inal Step would be the Quality content & good reader. Do make posts with quality contents which you love and post with regular intervals. As a good reader, you should reader more blogs from your neighborhood and also comment on their posts, which is the one of the way of marketing as well you get more health blogging network.<br />
<br />
</div>macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com2tag:blogger.com,1999:blog-4499264283193382794.post-45586429730274065242011-09-10T02:15:00.000-07:002012-01-09T18:13:26.509-08:00How to pull Blogspot Data in Google Docs<div dir="ltr" style="text-align: left;" trbidi="on">It is really an interesting application, which pulls Blogspot details from Rss or Page source. Yahoo Pipes is the one of the online web application which used to mashups the web feeds and web contents. Since it is a graphical interface we can drive pipes as much as we imagine and we can use the output feeds in varies forms with help of Javascript. I was searching for an alternate for Yahoo pipes for pulling the blog details, and accidentally met Google Docs. Basically, Google Docs serves as storage device for resource with real time collaboration, Google apps script is the key which plays vital role in such development. In this article I have shared a technique which can be a tutorial for Google apps script for Pulling data from blogspot<br />
<br />
Goto Google spreadsheet,<br />
To view Script editor, go to Tools->Script Editor<br />
Just copy paste the below codes and run the Script<br />
<br />
function rumme() {<br />
var line = <span class="Apple-style-span" style="color: red;">"2";</span><br />
var mySheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); <br />
var range = mySheet.getRange(1,1);<br />
var bname= "<span class="Apple-style-span" style="color: red;">macrolayer</span>";<br />
var burl = "http://" + bname + ".blogspot.com/feeds/posts/summary?max-results=1";<br />
response = UrlFetchApp.fetch(burl);<br />
xml = Xml.parse(response.getContentText(), false);<br />
root = xml.getElement(); // feed element<br />
var btitle = root.getElement("title").getText(); //blog's Title<br />
var bdes = root.getElement("subtitle").getText(); //Description<br />
var blink = root.getElements("link")[2].getAttribute("href").getValue(); // Url address<br />
var blogr = root.getElement("author").getElement("name").getText(); //Author name<br />
var blogid = root.getElement("author").getElement("uri").getText(); //Author Profile url<br />
var blogmail = root.getElement("author").getElement("email").getText(); //Author email address<br />
var bupdated = root.getElement("entry").getElement("updated").getText(); // last updated date<br />
if(btitle!="")<br />
{<br />
mySheet.getRange(1,line).setValue(btitle); <br />
mySheet.getRange(2,line).setValue(bdes); <br />
mySheet.getRange(3,line).setValue(blink);<br />
mySheet.getRange(4,line).setValue(blogid);<br />
mySheet.getRange(5,line).setValue(blogr);<br />
mySheet.getRange(6,line).setValue(blogmail); <br />
mySheet.getRange(7,line).setValue(bupdated); <br />
}<br />
}<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkkGpsCTBISzXdeThnTz9D5oOPlDH0KrUTagrRG8eXd9BxdcldENyXtwj8QhA2xML-j2oWZiW0mQll4n2HFyOsv9n_0xDY2CtmwI1reNMBZbAb21CH5penNVd2K2bh2u8MT14x0hbZ1JU/s1600/Google+Apps" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="258" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkkGpsCTBISzXdeThnTz9D5oOPlDH0KrUTagrRG8eXd9BxdcldENyXtwj8QhA2xML-j2oWZiW0mQll4n2HFyOsv9n_0xDY2CtmwI1reNMBZbAb21CH5penNVd2K2bh2u8MT14x0hbZ1JU/s640/Google+Apps" width="640" /></a></div><div style="text-align: center;">-------</div><div style="text-align: center;">This Script will pull the Title, description, Url, so and so as in image. you can use for look to get more blogs details at the time. You can change the colored string to your wish. </div><div style="text-align: left;">Above is the Basic sample Code for pulling the Blogs details, You can change Feeds url and its attribute for other sites. And check the every element of the blogs feed before pulling it</div><div style="text-align: left;"><br />
</div><div style="text-align: left;"><br />
</div></div>macroramanhttp://www.blogger.com/profile/01753095492027517813noreply@blogger.com2