Knowledge Base Q&A's on Workplce Applications

  • 0 Replies
Knowledge Base Q&A's on Workplce Applications
« on: July 07, 2017, 06:38:44 PM »
1.What are the Workplace Applications that AA supports to automate the processes?

Almost every aspect of daily life in business world We do use workplace applications like Excel, Database etc.. to analysis company data(such as sales figures, sales taxes), visualization of data and information that helps to organize business system, processes of data and information in order to keep the company functioning.

You can automate the following Application Softwares using AA to reduce man-hours:
  • Microsoft Excel
  • Database
  • Read from CSV – Text
  • XML (Extensible Markup Language)

2.What is Excel Automation in AA?

The use of spreadsheets, especially Excel, helps companies track, manage, plan, and evaluate several business processes. Users rely on Excel to gather data and perform detailed analysis or reports, but often find it time-consuming, highly manual, and not integrateable between applications.

Automation Anywhere helps fill this void. It provides a tool to reduce the manual and time consuming components of Excel by automating tasks within Excel.

Automation Anywhere also allows automation of data transfer between Excel and any Windows or web based application like Salesforce, SAP, Access, SQL, etc. Scheduling automated tasks to run at pre-defined times further helps automate business processes such as data retrieval, data input, or generating reports periodically. You can also run Excel macros as a part of a fully automated sequence.

3.What is the common use case scenarios of Excel Command?

Use this command to transfer data to and from Microsoft Excel spreadsheets. The Excel command is one of the most powerful commands provided by Automation Anywhere.

Many Excel automation scenarios have been implemented by companies worldwide. Some common scenarios include:
  • Copying data from one Excel spreadsheet to another.
  • Extracting data from an application to an Excel spreadsheet.
  • Extracting data from a website to an Excel spreadsheet.
  • Moving data from an Excel spreadsheet to another application.
  • Transfer data from Microsoft Access to Excel.
  • Transfer Excel data to a website form.
  • Delete rows or columns in Excel.
  • Compare two columns or two cells in an Excel spreadsheet.
  • Sort data in Excel spreadsheets and delete duplicate rows.
You can also run Excel macros as part of complete, end-to-end processes.
NOTE: Excel command is supported from Microsoft Office 2000 and later.

4.Explain Operations under Excel Command in detail?

  • Open Spreadsheet: Use this command to open an Excel spreadsheet. If your task involves working with many spreadsheets and workbooks, you can specify the session name, sheet name and even passwords for users with read only or edit rights.
  • Close Spreadsheet: Use this command to complement the Open Spreadsheet command. It closes a spreadsheet that is previously opened using an Open Spreadsheet command. The command identifies the spreadsheet using the session name that was provided in the Open Spreadsheet command.
  • Activate Sheet: Use this command to activate a specific spreadsheet in an open workbook.
  • Get Cells: Use this command to retrieve the values of the active cell or a specific cell, as well as a range of cells from the spreadsheet opened by the Open Spreadsheet command. When you retrieve values for an active or specific cell, you can assign the value to a variable.
  • Set Cells: Use this command to set the value of the active cell or a specific cell in an Excel spreadsheet previously opened using the Open Spreadsheet command. You can also use a variable to assign the value in the cell.
  • Go to Cell: Use this command to move to a specific cell. The movement options include:
           1. Move one cell to the left or to the right of the active cell
           2. Move one cell above or below the active cell
           3. Move to the beginning or end of a row or column within a spreadsheet that was previously opened using the Open Spreadsheet command

  • Run Excel Macro: Use this command to run an Excel macro that is stored within an Excel spreadsheet that was previously opened with the Open Spreadsheet command.
  • Delete Cells: Use this command to delete the values in the active cell or in a specific cell within an Excel spreadsheet that was previously opened using the Open Spreadsheet command.
  • Save Spreadsheet: Use this command to save a spreadsheet in an open workbook.
  • Find/Replace: Use this command to find and replace data in a spreadsheet within an open workbook. You can specify a cell range with specific search options.

5.What is Contains Header in Excel command?

When using Excel operations for fetching/retrieving large amounts of data from excel spreadsheets that has its first row defined as a heading, you need to specify the rows and columns in a manner that they take those headings into consideration.
The 'Contains Header' option allows you to configure the command parameters to include or exclude headers; as the case may be.

6.What is the necessity of Contains Headers in Excel Operations?

Contains Header allows you to retrieve/fetch data from a spreadsheet that has its first row defined as a header. You can define the option in Open Spreadsheet for a particular session. It is applicable to Excel operations Get Cells, Set Cell, Go to Cell, Find/Replace and Delete Cell for that particular session (as configured in Open Spreadsheet).

Also, in cases where one or more columns of the target Excel spreadsheet change position due to any update (i.e. introducing new columns/deleting existing columns), the corresponding automation task has to be updated to accommodate the change. Using 'Contains Header' you can enable the task to automatically map re-positioned columns of the target Excel spreadsheet.

7.What is Database Automation?

Data drives today’s businesses, and managing databases often involves complex planning, time management, and system-wide routine task implementation. Database automation helps enterprises better manage their database operations, reducing down-times as well as the overall time taken in database management.
Automation Anywhere works with any SQL database, like Oracle, MS SQL, Sybase, SQL DB2, etc. Unlike other automation solutions, it does not require significant training. Easy-to-use yet powerful, it can automate any database task.

8.List down the advantages of AA while automate database processes?

  • Ease the burden of database administration by using Automation Anywhere to automate tasks to run during off hours, thereby easing the burden of database administration, during peak hours or planned outages.
  • Database administrators can automatically generate reports with custom parameters.
  • Set up triggers to alert you when certain database tasks are disrupted, etc., even when scheduled to run automatically during off-hours.
  • Simple drag and drop technology with over 270+ commands empowers users to automate small or complex tasks easily and quickly.

9.What does Database command do in AA?

Use this command to integrate databases with your automated task and move or capture data.

Automation Anywhere enables you to transfer data between a database and other applications. You can import or export data, in various formats, and convert data from one format to another. For example, you might want to transfer and convert data while completing a data migration project.

You can also transfer data from a custom database to a Microsoft Excel spreadsheet, or from one database to another in predefined formats.

Restriction: For the Database command, Microsoft Access 2007 and Access 2010 users are required to use Microsoft Office 12.0 Access Database Engine OLE DB Provider.

10.What are the Sub-Commands available under Database Command?

The Database command provides the following sub-commands:

  • Connect: Use this command to connect to a database by providing a session name and a connection string.
  • Disconnect: Use this command to disconnect from a database.
  • SQL Query: Use this command to issue SQL queries using a Select statement.
  • Insert/Update/Delete: Use this command to specify an Insert, Update, or Delete operation by using a Select statement.
  • Run Stored Procedure: Use this command to run an existing procedure that is stored in your database. You can add and update by providing Input and Output types of parameters.

11.What XML Command is used for?

Use this command to process XML information that is generated from web services and cloud computing applications.

The XML command supports sessions, node editing, and Xpath expression execution, based on a tree structure of an XML document. The command enables the automated task to navigate the tree and make selections based on various criteria.
The XML command enables you to capture data that has XML formatting and saves it to a specified location.

12.Explain XML operations using Sub-Commands?

  • Start XML Session: Use this command to specify the session name and data source (a file or text).
  • End XML Session: Use this command to complement the Start XML Session command and close an open XML session.
  • Insert Node: Use this command to insert a node with attributes and name spaces you specify. The location of the node is based on the position of the XPath expression. 
  • Delete Node/Attribute: Use this command to delete a node or attribute from the XML file, as a result of specifying the XPath value.
  • Update Nodes: Use this command to update nodes in a session at the position that is specified for the XPath expression.
  • Validate XML Document: Use this command to validate session data using XML schema files (.xsd) or internal Document Type Definitions (DTDs). You can also validate whether the session data is well-formed.
  • Get Node(s): Use these commands to retrieve the values of nodes or attributes in the session data.
  • Save Session Data: Use this command to save the session data to a variable. You can also save it to a location you specify.
  • Execute Xpath Function: Use this command to execute an XPath function and store the results in a variable.

13.What can I do with Read from CSV – Text command in AA?

You can use this command to automate the process of reading data from CSV and Text files and encode the files using ANSI, UNICODE, and UTF8.

You can do the following:
  • Read List Separated or Tab delimited data from a CSV file.
  • Read multiple lines in CSV or text files
  • Use encoding options: ANSI, UNICODE, and UTF8.
« Last Edit: July 07, 2017, 07:12:01 PM by admin »