Complete our Foxtrot RPA Health Check today for a free analysis and recommendations on how you can better utilize your RPA software.
Foxtrot RPA Services
Do you ever think to yourself “There has to be an easier way to do this?” Find yourself doing repetitive tasks each month that you wish could just be automated. Robotic Process Automation is a great way to take time consuming repetitive tasks and utilize technology to increase efficiency, accuracy and reduce operation costs. Peak Consulting offers professional services for your institution, whether you are currently utilizing Foxtrot RPA or looking to purchase. Our in-house technical architect can review current process scripts and run times, recommend changes and opportunities for advancement of your utilization, and create custom scripts for your current projects. See below for more details…
Nintex RPA Licensing
RPA Core Conversions
Script Monitoring and Automation
Large Data Processing
Large files are always the worst to deal with when running a script on a single machine. RPA can only work as fast as the browser or application will go. By using RPA Central Data or FoxHub large data files can be processed on multiple machines at one time, allowing you to increase the bandwidth to the number of available bots.
Peak Consulting can be your one stop shop for all of your scripting and development needs. From simple to advanced script writing, BCP or vacation scheduling, to full turn key production Peak is here to work with you in all of the areas.
Peak offers a variety of virtual or onsite training engagements, from a one to four day training option that covers basic to advanced scripting. In addition, we will work with you on “real world” scripts that your institution needs that you’ll be able to take away from your training session and implement in your current environment.
RPA SQL Integration
By leveraging RPA with SQL server, you can start pulling and sending information to SQL for data processing. Most data comes from a SQL server and requires a job to run, and the file to placed in a central location for RPA to pick-up. By using SQL you can remove the need for the file to be placed on the server and run a procedure to pull the information directly from SQL.
Working with Multiple Data Sets
This is where the true thinking begins. A common scenario is opening a collateral record and adding loans to it. To help save time in the script you can have the collateral record drive your script for the main loop and query a list to pull in the data that is associated with your collateral record. This allows RPA to have the true one to many record result set and process end to end with less scripts and time.
Custom Excel File Data Output
Let’s get real on this. RPA uses Microsoft Access to store its run time data. This is perfect for running the data through RPA as it gives more options for the script. But for the end user who is reviewing the data, this is not common and adds complexity to them. By outputting your processed and exception records to excel, you can give the end user a file format that they are more familiar with and place it in a shared location or email through secure mail.
Text File Import Analysis
Not all data is a clean Excel file, or single row of information in a spreadsheet. Sometimes data comes from basic text files where a single record of information can be on one line or multiple. By using RPA to loop through a text file we can create a clean output and perform analysis on the file to help flag and identify records to be addressed/updated with Foxtrot. Director client reports such as Escrow Analysis are common files to be analyzed using RPA.
Sometimes you have a file that a user saves to a common location when they are ready for RPA to process. Or sometimes you have that same file needing to be copied or moved to another location on the network or FTP. RPA can copy, move listen and look for files placed in a location and perform scripted actions to remove the manual element of needing to handle the files.