System Related Functions
$$ExcelInfo
This function is used to get the Excel ‘version’ and to check whether ‘XLSX’ format is supported.
Syntax
$$ExcelInfo : <Keyword>
Where,
<Keyword> can be IsXLSXSupported or Version. The keyword IsXLSXSupported returns TRUE, if the format “xlsx” is supported, while Version returns the Excel version number.
Example
Set As : $$ExcelInfo:IsXLSXSupported
$$IsInternetActive
$$IsInternetActive is a function which helps to determine if the Internet is currently active. It returns TRUE if the Internet is accessible, else returns FALSE. It can be used to perform conditional operations, i.e., based on the Internet Connectivity, certain actions can be triggered.
This function checks if the internet is active, such that the operations pertaining to connecting to web pages, emailing, uploading files to FTP, etc., can be performed.
Syntax
$$IsInternetActive
Example
[Function : EmailifConnected]
00 : IF : $$IsInternetActive
;; Function called to Email O/s Stmts
10 : Call : Email Outstanding Statements
20 : ENDIF
In this example, the Outstanding Statements are E-Mailed, if Internet connection is present.
SysInfo
Use the function SysInfo to retrieve system-related information, like system date, operating system version, and so on. $$SysInfo accepts one parameter at a time, out of the 19 explained below.
Syntax
$$SysInfo : <Parameter>
where <parameter> is one of the values explained in the table below.
|
No. |
Parameter |
Description |
Example |
|
1 |
ApplicationPath |
The folder path where the current copy of Tally is running. |
C:/TallyPrime |
|
2 |
CurrentPath |
The data path configured in tally.ini, residing in the application path. |
C:/TallyPrime/Data |
|
3 |
SystemDate |
The system date. |
27-May-2017 |
|
4 |
SystemTime |
The system time. |
18:27 |
|
5 |
SystemTimeHMS |
The system time in hh:mm:ss format. |
18:27:36 |
|
6 |
SystemName |
The system name. |
TallyClient2 |
|
7 |
IsWindows |
Checks whether the system has Microsoft Windows operating system. |
Yes |
|
8 |
WindowsVersion |
The Microsoft Windows version with the build number. |
6.2 (9200) |
|
9 |
WindowsUser |
The name of the Windows user who has logged in. |
geetha.ram |
|
10 |
IPAddress |
The IP Address of the system. |
192.168.1.17 |
|
11 |
MACAddress |
The Media Access Control Address of the network adapter in the system. |
0720fhac027a |
|
12 |
RunningIPV4Addr |
The currently running Internet Protocol Version 4 address. |
192.168.1.17 |
|
13 |
RunningIPV6Addr |
The currently running Internet Protocol Version 6 address. |
2001:db8:85a3:8d3:1319:8a2e:370:7348 |
|
14 |
IsOSx64 |
Checks whether the operating system is 64-bit. |
Yes |
|
15 |
IsAdmin |
Checks whether the operating system is running in Admin mode. |
No |
|
16 |
TallyinAdminMode |
Checks whether TallyPrime is running in Admin mode. |
No |
|
17 |
UACStatus |
Checks whether the User Account Control is enabled. |
Yes |
|
18 |
SystemProxySettings |
The proxy settings in the system. |
192.168.1.17:8000 |
|
19 |
ModuleName |
The folder path and file name of the current application. |
C:/TallyPrime/tally.exe |
The function SysInfo is enhanced to get the file name of the current application with the folder path.
Example
$$SysInfo:ModuleName
If the application path is C:\TallyPrime , it returns C:\TallyPrime\tally.exe .
$$MakeFTPName
Function $$MakeFTPName is used for creating the file transfer protocol, based on specifications.
Syntax
$$MakeFTPName : <FtpServer>: <FtpUser>: <FtpPassword>: <FtpPath>
Where,
<FtpServer>is the FTP server name.
<FtpUser>is the FTP user name.
<FtpPassword>is the FTP password.
<FtpPath>is the full path of the folder on the FTP server.
Example
$$MakeFTPName:”ftp://ftp.microsoft.com”:””:””:”dbook.xml”
$$MakeHTTPName
Function $$MakeHTTPName is used for creating the HyperText Transfer Protocol for the specified security features.
Syntax
$$MakeHTTPName : <HttpUrl>: <HttpIsSecure>: <HttpUserName>: <HttpPassword>: <CompanyName>
Where,
<HttpUrl>is the HTTP URL name.
<HttpIsSecure>is a logical attribute which checks whether the HTTP is secure or not.
<HttpUserName>is the HTTP user name.
<HttpPassword>is the HTTP password.
<CompanyName>is the name of the Company.
Example
$$MakeHTTPName:”https://www.abc.com”:Yes:”guestuser”:”pswd99″:”ABC Company Ltd”
$$ MakeMailName
Function $$MakeMailName is used to construct the URL. The mail is sent to specified mail addresses using the given server.
Syntax
$$MakeMailName :<ToAddress>:<SMTP Sever name>:<From Address>:<CC Address>:<Subje c t>:<Username>:<Password>:<Use SSL flag>
Where,
<ToAddress>is the e-mail id of the receiver.
<SMTP Server Name>is the name of the server from which the mail is sent.
<From Address>is the send e r’s e-mail id.
<CC Address>is the email-id where the copy of the mail is to be sent.
<Subject>is the subject of the mail.
<User Name>is the user id on the secured server.
<Password>is the password for the user id on the secured server.
<Use SSL Flag>can be TRUE / FALSE OR YES / NO. If the Use SSL flag is set to TRUE, then the Username and Password must be specified, i.e., they can’t be empty.
Example
$$MakeMailName:”xyz@xyz.com”:”smtp.gmail.com”:”abc”+”<“+”abc@abc.com”+”>”:”Your outstanding payment”:abc@gmail.com:abc123:True
