View Categories

Import Data

< 1 min read

There are three channels for submitting electronic stamp duty payment data for instruments into the GeStamp Duty system:

  1. Web Upload
  2. Secure File Transfer Protocol (SFTP)
  3. Web Application Programming Interface (Web API)

The types of files that can be imported into the GeStamp Duty system are three formats, including:

  1. Excel File (.xlsx)
  2. Comma Separated Value (.csv)
  3. JavaScript Object Notation (.json)

Web Upload #

This method allows users to import data into the system manually by uploading files through the web interface. The GeStamp Duty system will automatically split the data into batches of no more than the limit specified by the Revenue Department, which is currently set at 1,000 records per submission. Additionally, the system will separate any records that fail validation into a new batch with the status “Input Error,” allowing the user to review and correct the data accordingly.

Data Import Method via Web Upload

  1. Go to the Batch menu
  2. Click Upload button
  3. Click Choose File button and select the file you want to upload to the system.
  4. Click Upload button and wait for the system to complete the data import.

Secure File Transfer Protocal (SFTP) #

This method allows for automated data import into the system. You can configure your system to generate the data file and place it in a secure folder. The GeStamp Duty system will periodically retrieve your data file from the secure folder and automatically import it into the system. GeStamp Duty will split the data into batches, ensuring that each submission complies with the Revenue Department's current limit of 1,000 records per submission. Additionally, any data that fails the validation check will be separated into a new batch with the status “Input Error,” so that the user can correct and re-submit the erroneous records.

Before you can import data using this method, you must contact the system administrator to configure your Secure Folder settings and other necessary details to ensure the security of your data.

In addition, users can enhance data security as the system supports data encryption using PGP Encryption. Users must contact the system administrator to request the public key, which should be used to encrypt the data before placing it in the SFTP folder.

Web Application Programming Interface (Web API) #

The method of direct data transfer allows users to write programs that send data files directly to the GeStamp Duty system. This connection method is equally secure because, in addition to using HTTPS (Hypertext Transfer Protocol Secure), it requires authentication with a username and password before establishing the connection to transmit data. รายละเอียด Web API