Precheck headers in Excel and CSV files

Prechecks the headers of input/output files. Most of the process has at least one or more input/output file (either XL or CSV) which is provided by the business.

Top Benefits

  • Avoid confusion if any headers or order of the headers get changes in the input files.
  • Reduce the maintenance work
  • Reduce developer effort each and every time to validate the header checks for each process.
  • Enforces coding standards.
  • Easy to identify and fix the issue at the production without Tech help.
  • BOT handled both XLSX or CSV files.

1. It validates n-number of input files either XL or CSV file 2. It validates the headers horizontally 3. It validates the headers vertically. 4. It validates the headers sit on any row or any column. 5. It validates n-number of rows of headers/columns in the single file. 6. It gives the details of which column/row header/order changed. 7. Flexibility to validate based on simple configuration change.

It enforces the coding standards, reduces the maintenance work, reduces the developer rework effort and increase the speed of coding. In XML, at least keep minimum one template nodes ex: XL or csv If only XL needed, keep CSV nodes and make its values empty If only CSV needed, keep XL nodes and make its values empty. As per the business requirement if header names or the order of headers got changed BOT will fail and it will impact the business needs. Most of the processes skip the header validations due to the extra coding effort require apart from the business rules & requirement. Before you run, you have to map the input file path and headers in the XLReusableBOT.xml file.

Key Use Case: 1. Most of the process at least one more input/output files are used. 2. Input/output file type either XL or CSV. 3. Configure file path, headers and header row/column in the XML. 4. Call this BOT at the start of process.1. Most of the process at least one more input/output files are used.
2. Input/output file type either XL or CSV.
3. Configure file path, headers and header row/column in the XML.
4. Call this BOT at the start of process.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
242
Vendor
Automation Type
Bot
Last Updated
July 24, 2020
First Published
October 9, 2018
Support

See the Bot in Action

PREV NEXT

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • AAE v11.2
  • Inputs: Any XL or CSV input files