— Logs a event into log.txt if it exists function log_deprecated(Function, Description) — if log.txt exists it logs the action, if not ignores the loging if File.DoesExist(_SourceFolder .. “\\Data\\log.txt”) == true then local LogText = System.GetDate(DATE_FMT_ISO) .. ” ” .. System.GetTime(TIME_FMT_MIL) .. ” ” .. Function .. ” -> ” .. Description .. “\r\n”; TextFile.WriteFromString(_SourceFolder ..
To open a diferent application from Kalipso you just need to use the function Run Process with the package from the application that you want to open. For example, if you wanted to open..
When the SSLForFree joined with the ZeroSSL just ruined the hole purpose from their website a screw the life of many people. I has to find a new way to get my certificates, the only way and more simple was with the Let’s Encrypt. Just download the file below, install and you will be able ..
Kalipso Studio ico icon is just used to set the icon inside the KClient when testing the application. To have a compative icon you will need to use an icon with 32X32 witho..
A stored procedure that check if a file exists or not and returns 0 or 1 accordingly if file exis..
To make a database backup you need to use a simple code exemplified below. Code: BACKUP DATABASE PRIDEMO TO DISK = ‘C:\MIS\PRIDEMO.BAK’ WITH CHECKSUM BACKUP DATABASE [DATABASE NAME] TO DISK = ‘[DETINATION FULL PATH]’ WIT..
To allow access to this component run the code below to activate. Code: — Activate OLE Access sp_configure ‘show advanced options’, 1 GO RECONFIGURE; GO sp_configure ‘Ole Automation Procedures’, 1 GO RECONFIGURE; GO sp_configure ‘show advanced options’, 1 GO RE..
To use this function you need to give your server user sys.spOACreate permissions. Code: — ============================================= — Author: Bruno Figueiredo — Description: Returns the file information — ============================================= CREATE FUNCTION fn_getfiledetails ( @Filename sysname ) /* How to use: select * from fn_getfiledetails(‘c:\file.ext’) */ RETURNS @filedetails TABLE ( [Path] VARCHAR(100), [ShortPath] VARCHAR(100), [Type] VARCHAR(100), ..
$file_url = ‘https://www.airtistic.net/wp-content/uploads/2019/01/logo_main-2.png’; function getRemoteFilesize($file_url, $formatSize = true) { $head = array_change_key_case(get_headers($file_url, 1)); // content-length of download (in bytes), read from Content-Length: field $clen = isset($head[‘content-length’]) ? $head[‘content-length’] : 0; // cannot retrieve file size, return “-1” if (!$clen) { return –1; } if (!$formatSize) { return $clen; // return size in bytes } $size ..
Action Bank Infusion
This plugin adds some much-needed, functions to the general Action Bank.
New Actions range from DialogEx functions to XML functions and are infused directly into their respective pare..
This sample calculates the MD5 from a string using the Kalipso function and a java script function. Topics covered: MD5 Calculation Use of javascript function Sample in the .git reposito..
This sample searches all the Bluetooth devices near the device. Topics covered: Devices search Devices find Pair device function Sample in the .git r..
This sample show a working digi..
This sample shows how you can read and write a..
If you need to test communication to and from a specific port you can use a software called i4SocketWorkBench that can send and receive packets on designated ports. It’s specially handy if you are developing applications to work with iOT devices and specific port..
To connect to other types of databases you can also use a connection string and define as manual. You can check the different connection string on the link below. https://www.connectionstrings.c..
This functionality only works on the latest versions of SQL Server, FOR XML needs the 2014 version and the FOR JSON 2017 version. SELECT Column1, Column2, * FROM Table FOR JSON AUTO SELECT Column1, Column2, * FROM Table FO..
CommandCam is a simple and easy to use command line webcam image grabber for Windows. It captures a single image from a webcam and stores it in a bitmap file. CommandCam is ideal for use in batch files and other situations where you want a very simple way to automate image capture. CommandCam uses Microsoft’s DirectShow API to access webcams, so it should work with most USB ..
How to get the actual date subtracting 1 day, 1 month and 1 year. You can use this example also to add. ..
The easiest way is to create a function to get the HASH with a simple online request. The script to see the HASH in the browser (PHP): <?php function get_hash($address) { function x509_fingerprint($pem,$hash=’sha1′) { $hash = in_array($hash,array(‘sha1′,’md5′,’sha256’)) ? $hash: ‘sha1’; $pem = preg_replace(‘/\-+BEGIN CERTIFICATE\-+/’,”,$pem); $pem = preg_replace(‘/\-+END CERTIFICATE\-+/’,”,$pem); $pem = str_replace( array(“\n”,”\r”), ”, trim($pem)); return ..