Advanced Usage

Copy Image into Rich Text Editor

• Firstly, upload the image file to SQL Connect
• In SQL Account / SQL Payroll, go to View > File Explorer
• Navigate to This PC > SQL Drive on SQL Connect > double click to open your image file
• Select All (or press Ctrl + A), and then copy it.
• Go to the rich text editor, paste the image you just copy.

---

Delete Files in SQL Drive

---

Kill Firebird Connections

Method 1

• To use this method, take note that the last logged in user must be ADMIN.

Method 2

• To use this method, login as ADMIN.

---

Link with SQL Pos

1. This is for public cloud users only.
2. Once requested, you will receive a file link. In the file, you can find all the information required to link local SQL Pos with SQL Account. Example on how the file looks like:

3. In SQL Pos, fill in accordingly.

---

Printing Half Page

• Add half page paper size.

• Go to printer preferences.

• Configure the printer to use the paper size we created before.

• Next, go to printer properties.

• Set the default paper size to the custom paper size we created.

• Once you have done with the above settings, login into your SQL Connect session and test print with the following steps:

---

Saving PDF

If you want to download PDF file, save it to the "Download" folder in the "SQL Drive on SQL Connect"

The PDF file will be opened in a new tab, click download and save the file to local PC.

---

Signout (Private Cloud only)

The is exclusive for private cloud users only. In private cloud, the user has control over the server. Thus, the admin has the right to signout connections.

---

SQL Connect Printing

In SQL Connect, we have two groups of users (Public cloud users & private cloud users). As a private cloud users, you gain an extra option which able to print directly to your local printer as long as the printer is accessible from your server. While for public, you can select any option listed below:

• PDF Print
• SQL Connect Printer
• SQL Drive method

---

PDF Print

info

This feature is available in specific versions:

• SQL Account version 5.2024.976.842 and above
• SQL Payroll version 1.2024.254.204 and above

In SQL Account, go to the report preview, click on the PDF button located at the top left.

The pdf will be open in your new tab, you can then select your local printer and print.

---

SQL Connect Printer

By using "SQL Connect Printer", you will then able to access the browser print dialog which has the right to utilize your local printer. From there, you can select the printer you want, size you like and so on. After select all the options you wish, click print. Below is an example of chrome print dialog:

---

SQL Drive method

---

SQL Connect Subscription Checker

To check your subscription, you can open the app by following the steps below:

1. Go to File > Run
2. Select SQL Connect Subscription Checker

If the app is not there, you can add it manually by following the steps in SQL Utilities

---

SQL Utilities

By default, SQL Connect has already generate the list when you connect to a session. But if it didn't show up, you can add them manually by following the steps below:

1. Go to File > Run > Configure Program...
2. Add the utilities software from here: C:\eStream\Utilities
3. After add successfully, the program should be available at File > Run > ...