Posts

Create an Issue Using JIRA API

using System; using System.Collections.Generic; using System.Linq; using System.Net.Http; using System.Text; using System.Threading.Tasks; using Newtonsoft.Json; using Newtonsoft.Json.Serialization; namespace MyWorkView {     class Program     {         static void Main(string[] args)         {             var data = new Issue();             data.fields.project.key = "WKV";             data.fields.summary = "Created By JIRA API";             data.fields.description = "Created By JIRA API";             data.fields.issuetype.name = "Incident";             //data.fields.Assignee = "";             //data.fields.Reporter = "Ravi Govindasamy";             string postUrl = @"ht...

IBM FileNet: Bulk Processing using JavaScript

IBM FileNet: Bulk Processing using JavaScript The IBM FileNet Content Platform Engine server uses the Mozilla Rhino scripting engine to execute the JavaScript. Prerequisites for running the JavaScript examples: Content Platform Engine 5.2.0 or later Downloading document content    This JavaScript example downloads the document content to a specified directory. Because the JavaScript code is executed on a Content Platform Engine server, the content download directory that you specify in the code must exists on the CPE server and should have write permissions  Procedure Open an object store and create an object store search. On the  SQL view  tab, enter the following query: SELECT TOP 100 This FROM Document   Select  Enable bulk action  on the bulk action tab.  In the  Script  section, click  Run script .  Copy the following JavaScript code and paste it into the  Script  field:  im...

How to export the as excel without excel

public static void ExportToExcel(List MailBoxData)         {             try             {                 StringBuilder strHTMLBuilder = new StringBuilder();                 strHTMLBuilder.Append(" ");                 strHTMLBuilder.Append(" ");                 strHTMLBuilder.Append(" ");                strHTMLBuilder.Append(" ");                 strHTMLBuilder.Append(" ");                 strHTMLBuilder.Append(" ");                 strHTMLBuilder.Append(" MailId Size KB Size GB ");                 strHTMLBuilder.Append(" ");   ...

How to find Shared Mail Box Size

private static void FindSizeofEachMailBoxes()         {             string WVMailBoxNames = ConfigurationManager.AppSettings["MailBoxIds"].ToString();             string userMailId = ConfigurationManager.AppSettings["userMailId"].ToString();             string userpassWord = ConfigurationManager.AppSettings["userPassWord"].ToString();             string userdomain = ConfigurationManager.AppSettings["userDomain"].ToString();             try             {                 string[] WVMailBoxes = WVMailBoxNames.Split(new char[] { '^' });                 foreach (string WVMailBox in WVMailBoxes)                 {                ...

DB2 Date Time Functions

https://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html One of the most important database design decisions you will make – for DB2 or any relational DBMS – is to use the proper data types for your columns when building tables. The data type that you choose for each column should be the one that most closely matches the domain of values that the column can be used to store. Indeed, perhaps the most important design choice is to actually use the date/time data types that are available to you; for DB2 this is DATE, TIME, and TIMESTAMP. The ability to store dates as a native DB2 data type is a great advantage. If you need to store date information in your DB2 tables you should favor using the DATE data type instead of forcing a date into some other data type (such as CHAR or DECIMAL). Many a database design has been ruined (in my opinion) because somebody decided to store date data in a CHAR column. When DB2 knows that the data should be a DATE or a TIM...

To check your version of Java

To check your version of Java java -version in a console (command prompt). On Windows 7 with 64-bit Java 6 I get: java version "1.6.0_27" Java(TM) SE Runtime Environment (build 1.6.0_27-b07) Java HotSpot(TM) 64-Bit Server VM (build 20.2-b06, mixed mode) Note the 3rd line, which shows that this is a 64-bit version. On a 32-bit version you'll get something like: Java HotSpot(TM) Client VM (build 20.1-b02, mixed mode, sharing)

GUID Conversion

The conversion methods: public static String convertGuidToDbFormat (String guid) { String s1 = guid.substring(1, 3); String s2 = guid.substring(3, 5); String s3 = guid.substring(5, 7); String s4 = guid.substring(7, 9); String s5 = guid.substring(10, 12); String s6 = guid.substring(12, 14); String s7 = guid.substring(15, 17); String s8 = guid.substring(17, 19); String s9 = guid.substring(20, 24); String s10 = guid.substring(25,37); return s4+s3+s2+s1+s6+s5+s8+s7+s9+s10; } public static String convertGuidToWorkplaceFormat (String guid) { String s1 = guid.substring(0, 2); String s2 = guid.substring(2, 4); String s3 = guid.substring(4, 6); String s4 = guid.substring(6, 8); String s5 = guid.substring(8, 10); String s6 = guid.substring(10, 12); String s7 = guid.substring(12, 14); String s8 = guid.substring(14, 16); String s9 = guid.substring(16, 20); String s10 = guid.substring(20); return “{” + s4 + s3 + s2 + s1 + “-” + s6 + s5 + “-” + s8 + s7 + “-” + s9 + “-” + s10 + “}”; } else i...