Tutorial by Examples: x

Handling ImportError Exception

When you use python file as module there is no need always check if package is installed but it is still useful for scripts. if __name__ == '__main__': try: import requests except ImportError: print("To use this module you need 'requests' module") t ...

Python Language • Usage of "pip" module: PyPI Package Manager

Filter expression

Simple filter expression is also an array. It contains one or more filter terms, combined with operators - 'AND', 'OR', 'NOT'. (Operators are case insensitive): [ ['mainline', 'is', 'T'], 'and', ['type','anyof',['CustInvc','CustCred']], 'and', 'not', ['amount', 'equalto', '0.00'], 'or'...

netsuite • Scripting searches with Filter Expressions

Filter expressions vs Filter Objects

Filter expressions cannot include Filter Objects. This is very important. If you decide to form your filters with Filter Expression, you use array of string arrays. The following syntax is wrong: // WRONG!!! var f1 = search.createFilter({ name: 'mainline', operator: searc...

netsuite • Scripting searches with Filter Expressions

Watch Extension Configuration

WatchKit App import WatchConnectivity and conform to WCSessionDelegate. use the static session delegate via WCSession.default(). Send data to the iPhone app using: WCSession.default().sendMessage(message, replyHandler:_ errorHandler:_) The message object should be a dictionary of typ...

watchkit • WatchConnectivity

Text Matching or Similarity

One of the important areas of NLP is the matching of text objects to find similarities. Important applications of text matching includes automatic spelling correction, data de-duplication and genome analysis etc. A number of text matching techniques are available depending upon the requirement...

machine-learning • Natural Language Processing

Example - Temperature sensor

Interfacing of DS18B20 with Raspberry pi Connection of DS18B20 with Raspberry pi You can see there are three terminal Vcc Gnd Data (One wire protocol) R1 is 4.7k ohm resistance for pulling up the voltage level Vcc should be connected to any of the 5v or 3.3v pins of Raspberry pi (PI...

Python Language • IoT Programming with Python and Raspberry PI

Disabling All Excel Functionality Before executing large macros

The procedures bellow will temporarily disable all Excel features at WorkBook and WorkSheet level FastWB() is a toggle that accepts On or Off flags FastWS() accepts an Optional WorkSheet object, or none If the ws parameter is missing it will turn all features on and off for all WorkSh...

excel-vba • Excel-VBA Optimization

Extended Stats Aggregation

A multi-value metrics aggregation that computes stats over numeric values extracted from the aggregated documents. These values can be extracted either from specific numeric fields in the documents, or be generated by a provided script. The extended_stats aggregations is an extended version of the ...

Elasticsearch • Aggregations

Why does a regex skip some closing brackets/parentheses and match them afterwards?

Consider this example: He went into the cafe "Dostoevski" and said: "Good evening." Here we have two sets of quotes. Let's assume we want to match both, so that our regex matches at "Dostoevski" and "Good evening." At first, you could be tempted to keep...

Regular Expressions • Regex Pitfalls

*ngFor X amount of items per row

Example shows 5 items per row: <div *ngFor="let item of items; let i = index"> <div *ngIf="i % 5 == 0" class="row"> {{ item }} <div *ngIf="i + 1 < items.length">{{ items[i + 1] }}</div> <div *ngIf="i + 2 &l...

Angular 2 • Angular - ForLoop

Create a Excel file

MemoryStream excelMS = GetExcelFile(); //Using Resposne Stream to Make File Available for User to Download; Response.Clear(); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("Content-Disposition", string.F...

apache-poi • Getting started with NPOI

Creating a simple UNNotificationContentExtension

Step 1 Making the environment suitable for Notification. Make sure you enabled Background Modes and Push Notification Step 2: Creating an UNNotificationContentExtension Click on the + icon in the bottom which creates a target template and select Notification Content Extention -> next -> ...

iOS • Rich Notifications

HTML example using requireJS CDN to include an already compiled TypeScript file.

<body onload="__init();"> ... <script src="http://requirejs.org/docs/release/2.3.2/comments/require.js"></script> <script> function __init() { require(["view/index.js"]); } </script> </body>...

TypeScript • Using Typescript with RequireJS

tsconfig.json example to compile to view folder using requireJS import style.

{ "module": "amd", // Using AMD module code generator which works with requireJS "rootDir": "./src", // Change this to your source folder "outDir": "./view", ... }

TypeScript • Using Typescript with RequireJS

Adding RichText to a cell

Each element of text you want to use distinct formatting on should be added separately, by adding to the cell's RichText collection property. var cell = ws.Cells[1,1]; cell.IsRichText = true; // Cell contains RichText rather than basic values cell.Style.WrapText = true; // Required to honor n...

epplus • Rich Text in cells

Text formatting Properties

There are a number of properties that can be applied to sections of RichText. var title = cell.RichText.Add("This is my title"); // Data Type: bool // Default Value: false title.Bold = true; // Data Type: System.Drawing.Color // Default Value: Color.Black title.Color = C...

epplus • Rich Text in cells

INDEX Hints

Index hints are used to force a query to use a specific index, instead of allowing SQL Server's Query Optimizer to choose what it deems the best index. In some cases you may gain benefits by specifying the index a query must use. Usually SQL Server's Query Optimizer chooses the best index suited for...

Microsoft SQL Server • Query Hints

Listing Elixir modules and functions

To get the list of Elixir modules just type h Elixir.[TAB] Pressing [TAB] autocompletes modules and functions names. In this case it lists all modules. To find all functions in a module e.g. List use h List.[TAB]

Elixir Language • Getting help in IEx console

The PX(DB)DateAndTime Attribute

The PXDBDateAndTime attribute and the PXDateAndTime attribute are designed to work with a DAC field of the Nullable<DateTime> (DateTime?) type and store both date and time value parts inside a single field: #region UsrDateAndTime public abstract class usrDateAndTimeAttribute : IBqlField { }...

acumatica • Creating Date and Time Fields in Acumatica

The PXDBTime Attribute

The PXDBTime attribute is designed to work with a DAC field of the Nullable<DateTime> (DateTime?) type and store only the time part without date inside a DAC field: #region UsrTime public abstract class usrTime : IBqlField { } [PXDBTime(DisplayMask = "t", InputMask = "t&qu...

acumatica • Creating Date and Time Fields in Acumatica