Plug-in (Function & Smart Service)Paid

Text Parse to SQL V22

by Machint Solutions (Partner)

Description

This plugin can be utilized to insert the records into a table using the MySQL queries generated after the plugin is processed,
It can be utilized in any of the business domain which deals with transactional data.
*** Works only until Appian Version 22.4***

Features

Capable of reading any delimiter-separated tabular data from various files .txt, .csv & .tsv

  • Accepts a file with single/multiple tabular data and generates SQL queries for respective tables with column names as per user inputs.
  • Validates every record in the table using a value format/regex pattern provided.
  • Skips the Record that doesn’t match per validation during the process and generates no SQL query for that particular record.
  • Disregard the superfluous text that sits between any two tables.
  • With the guidance of the table column’s start and end indexes, fixed positional tables can be read with ease.

Release notes

Text Parse to SQL V22 Version: 1.0.0 Release Date: January 12, 2024

Features and Enhancements:

  1. Data Processing and Query Generation:

-Introducing the Text Parsing tool which enables the user to generate MySQL queries from .Txt/.CSV/.TSV files based on JSON parameters provided by the user such as the number of tables, columns, column names, and the regex value for format validation as applicable.

  1. Fixed-Positional and Delimited Data Processing:

-The tool supports both fixed-positional and various delimited data sources, making it versatile in handling different data formats.

  1. Error Handling and Logging:

-Improved error handling and detailed logs which help troubleshoot and resolve issues during data processing, enhancing reliability.

  1. Performance Optimization:

-The tool is optimized for handling large datasets, ensuring efficient data processing without performance concerns.

  1. Database Integration:

-Generate MySQL queries for easy integration with SQL databases, allowing seamless data storage.

  1. Streamlined Data Validation:

-Enhanced data validation capabilities include support for regular expressions and mandatory pass checks, ensuring data integrity and accuracy.

  1. User-Friendly Input Configuration:

-Easily configure input parameters, including input files and JSON specifications with column names, table names, validations, and indexes, improving flexibility in data processing.

  1. Reporting and Output:

-Generate MySQL queries from parsed data for further analysis, storage, and enhancing data reporting capabilities.

Thank you for choosing the Text Parsing Plugin. Your feedback is valuable as we continue to refine and enhance this tool. For support, please contact us at machint-plugins.support@machintservices.com .

Best regards, Your Appian Plugin Team Machint Solutions machint-plugins.support@machintservices.com