abbyy vantage convert to excel video cover

ABBYY Vantage Video – Converter Skill for Microsoft® Excel®

Watch our video to learn how to use our ABBYY Vantage Connector to save extracted metadata in an easily consumable XLSX format.

Hello. Today I’d like to share with you our Microsoft® Excel® Converter Skill. The goal of this skill is to take the metadata that’s provided from ABBYY Vantage and convert it to Excel. And in today’s demo, actually what happens is when we convert it to Excel, we also email it to ourselves so that we have access to that extracted Excel data that we’ve set up in our process skill here.

So this is a very typical process skill. We have an input channel. We have an extract step because it’s only a singular document here that we’re extracting from. We’re gonna export to Excel, which is the purpose of this video. And then of course we’ll typically have an output stage. Just for reference the Excel export can be part of the output stage if we want to. So depending on the business process or the client’s need, we may have the ability to just consider the Excel step as the output step, instead of having it kind of separated as a custom activity here.

But what I’m gonna do is I’m just gonna go ahead and drop an invoice into a import folder. And we’re gonna watch ABBYY Vantage monitor this folder and pick it up.

Now that ABBYY Vantage has picked up that document. It is now gonna start flowing through. So ABBYY Vantage is going to extract the data from that invoice. It’s going to export it to Excel. And then that’s of course the final stage of it.

Now, what ends up happening is we will get an email that is sent to us here as part of our Excel export. So we can see here that I now have a PDF with all of the extracted data from my document. Now, within the invoice documents, we have a number of different groups of fields. Sometimes we even have repeating information like line items. So anytime we have a group or we have line items or a repeating group of information, you will see here that we create a separate tab. So for example, we have an invoice tab, which is our typical invoice header information. You can see that here. This would be your typical invoice details. Then we have some vendor information. Then of course taxes. We may have a purchase order. And then when we get line items, of course we’ll expect multiple line items on an invoice and you can see here, they’re extracted to their own tab. And then of course we have business unit, which is just a separate group.

So you can see here, this is everything specific about the invoice, whether it’s the header information, vendor, line items, et cetera, all of that is provided in one very simple and clean Excel export. So that’s all I wanted to share with you today is our Excel export option here within ABBYY Vantage. I hope you enjoyed this video. Thank you so much.

Music- “‘Engineered to Perfection’ performed by Peter Nickalls, used under license from Shutterstock”.

“Microsoft” and “Excel” are trademarks of the Microsoft group of companies.

ABBYY Vantage Video – Setting Up a Condition (IF) Activity

Watch our video to discover how to implement an if-then type of logic of a Condition (IF) Activity in ABBYY Vantage.

Hello. Today I’d like to show you how we can set up a Condition Activity within our Vantage Process Skill. A Condition Activity is really the idea of implementing if-then type of logic. So if certain conditions happen, we may want to do something different than another condition. So you can see here. What I have in front of us is a typical setup. So we’re gonna input a document. We’re gonna extract some information from it, and then we’re gonna have some conditional logic that based on a certain field value within our document, after the extraction has happened, we may wanna route it to a human in the loop for review, but otherwise we’ll go ahead and just automate the output.

What we’re gonna do is we’re just gonna add those two things here. So we’re gonna add a review step, and then we’re gonna add an output step. Okay. So let me just give you an idea and some hints on setting this up. The first thing you do is go ahead and put your pads in place. So I always like to just map my output step, because I know that’s where I’m gonna go for sure. And then I’m gonna also map my review step, and then I’m also just gonna go ahead and finish the loop there that way after an item is reviewed, we would then output it. Okay.

Now, if you’ll notice here, when I click my “IF” activity, I have some actions here in the action pane that says, if certain conditions occur, then go this route. Otherwise go to the output. So now we can get very specific in the logic to route documents to this review step.

I’m gonna actually share one with you. This is a pretty standard example where we will look at the document. And in this case, the first document and transaction will find us a specific field. And as long as that field is not empty and has an actual text value in there, will return “true”, which really just means we’re gonna take this route of the condition activity. Otherwise, “false” obviously means we’re not going to take this route in this condition activity.

So this is a pretty standard script. You’ll notice here then that kind of rounds out our condition skill. So bring a document in. Extract the data. If a certain value exists, we’ll route it to a human review. Otherwise we will go to the output queue.

So actually let’s run a test. What I’ll do is I’ll publish this for us. Now that I’ve published this for us, I’m gonna go ahead and just drop some items into a queue so that the software will pick it up. So I dropped two items. One matches the condition criteria, and one does not. I’m gonna go to my skill monitor, make sure I go directly to that skill. And if I just look here. I’ll do it here. Within the last one hour. We’re gonna have some items get picked up from our input source in just a second. And then the software will start its transaction. All right, so the software just picked them up. We can see here that we have two in progress. Once again, one of them matches our manual review and one does not. So the software right now is extracting the detail from these documents. And then based on our logic, we’ll see how the software routes that document.

Now that we’re wrapped up here, you can see this first one, which matches our document is in manual review and the other one is completed. If we wanted to see this document, that’s over here in manual review, I can simply click my manual review tab here and we will open that document. If you remember from the script, we actually were looking at the employee ID field and if it contained this value, we wanted to route it to human review. So that’s an example of how we set up a Condition Activity for if-then type of logic. I hope you enjoyed this video.

Music- “‘Engineered to Perfection’ performed by Peter Nickalls, used under license from Shutterstock”.

ABBYY Vantage Video – Connector for Amazon S3™

Watch a video to learn how to create an ABBYY Vantage Process Skill that will allow you to send a document and its metadata to an Amazon S3™ Bucket.

Hello. Today I’d like to share with you how we can set up an ABBYY Vantage Process Skill to pass a document and it’s related metadata to an S3 Bucket. Now, what you see in front of us is a very typical workflow. A document will come in. In this case through an email. We will classify the document to learn the document type. We will extract critical metadata from the document. We will then pass that over to an S3 Bucket. And it’s pretty simple.

So what I’ll show you here is that I have an email box. We’ll monitor that and then we will pass that over to our S3 Bucket. So I’m just gonna, go ahead and place a proper email in the proper location. Now that I have an email in this proper location, you’ll notice that when Vantage uses its next pull to grab the email and its contents, this email will disappear, and the document will get processed and we will move that document over to our S3 Bucket.

You can see in front of us here, that email is now gone. So ABBYY Vantage is now classifying the document. It will extract its metadata. And then when we refresh our S3 Bucket, we will see a document in here where that document can then be used for historical record and then we will have a copy of that in our organizations for historical reference.

Now, with one simple refresh, we can see here within our Amazon S3 Bucket, I have the document that was picked up from an email box, processed through ABBYY Vantage and now exists in this bucket.

So I hope you enjoyed this video. If you have any questions on the process or this connector, please reach out to us. Thank you so much.

Music- “‘Engineered to Perfection’ performed by Peter Nickalls, used under license from Shutterstock”.

“Amazon Web Services”, “Amazon Simple Storage Service (Amazon S3)”, “Amazon S3”, and the “Amazon S3” logo, are trademarks of Amazon.com, Inc. or its affiliates in the United States and/or other countries. The primary URL for Amazon Simple Storage Service (Amazon S3) is https://aws.amazon.com/s3/?nc=sn&loc=0.

ABBYY Vantage Video – Convert to CSV Connector

Watch a video to learn how to use our ABBYY Vantage Connector to extract data from an emailed document and convert the document data to a CSV format.

Hello. Today I’d like to share with you our Convert to CSV Connector for ABBYY Vantage. Now, this is a fairly simple concept that you’ll see in front of us here. I have a process skill. The process skill will monitor an email box. We’ll then classify the incoming document. Extract the metadata from the document. We will then convert the metadata that we’ve extracted to a CSV format, which in today’s demo will then just get emailed back to us and so that we can have that as something we can consume downstream. And then that’s considered the last stage of the document here.

Now, what we do with the CSV is really up to your organization. Our goal is to convert the document to CSV. You can do anything you want with it. Today’s demo, I’m gonna show it getting emailed. In real life we may pass that to another system or another downstream step. So a lot of flexibility in the way that we use this step, but for today’s demo, I just wanted to share with you that we can convert the metadata that we’ve extracted off of this document to CSV format.

So what I’m gonna do is I’m gonna go ahead and create an email that the software will then monitor the email box, it will pick it up, convert the document to CSV, and then provide us an email of that CSV.

All right. So I have an email that is ready to be pulled within our CSV folder. So ABBYY Vantage will pull this document when it’s ready. It will automatically process the document. And then we will use our CSV connector to pass that over through CSV format, to an email.

All right, we can see there that ABBYY Vantage has picked up the document that we sent into that email folder. It is now in processing. Once again, I’ll remind you, it will go through this step where it pulled it from the document that we just saw. It will then classify, extract, convert it to CSV, and then provide us an output. Now the output, I actually just received the email. You can see here, it’s simply an email with a CSV. All of this is configurable. If you did wanna receive the document through email, we could obviously customize the subject, the to, the body, et cetera. But the more important part here is that we now have the extracted data off of the document in CSV format. So we can consume this downstream by a downstream step. So it’s a very simple process, but one that’s very critical to processing a document and its extracted metadata.

So I hope you enjoyed this video. If you have any questions on the connector, please reach out to us. We would love to chat with you about different ways that you can use our Convert to CSV Connector for ABBYY Vantage.

Music- “‘Engineered to Perfection’ performed by Peter Nickalls, used under license from Shutterstock”.

Related Content:

ABBYY Vantage Video – Connector for Google Drive™

Watch a video to observe how to pass documents from an email box to Google Drive™ for data extraction and storage by way of the ABBYY Vantage – Connector for Google Drive.

Hello. Today I’d like to show you our Google Drive Connector for ABBYY Vantage. You can see the process that I’m going to demo for you today in front of us. We have an input channel, which for today’s demo is an email address that the software is monitoring. We will classify the document to learn the document type. We will extract the related data from that document. We will then use this custom activity to pass the document and its metadata to Google Drive, which is our connector. And then that is the last step here as the output.

So in today’s demo, that’s what we’re gonna do. You’ll see here, I have an email box that we’re gonna pass a document into, and then we will have a Google Drive testing folder where we’ll see the document come into. So let’s get this process started. First, what I’m gonna do is create an email and let the software grab the document automatically and then it will start the processing.

You can see here we now have an email ready within our Google Drive folder. When ABBYY Vantage uses its next email pulling, it will grab that document and that email content and then we’ll start processing that. When it’s picked up it will then move it over here to our Google Drive. Specifically our testing folder within the Google Drive.

You can see there, the software automatically picked up the document. Now that document is in processing and we expect to find it over here in our Google Drive folder when it’s complete. Now, after I refresh the screen, you can see that document is within our Google Drive folder.

In short, what it did is the software monitored the email box. We determined the document and extracted the data. We then passed it over to Google Drive. And so that’s what happened here. You can now see that document lives within Google Drive and we can now reference that as a historical record for the document.

Thank you so much for watching this video.

Music- “‘Engineered to Perfection’ performed by Peter Nickalls, used under license from Shutterstock”.

“Google Drive” is a trademark of Google LLC. Use of this trademark is subject to Google Permissions.

Vantage- SharePoint Con 600x481 Updated

ABBYY Vantage Video – Connector for Microsoft® SharePoint®

Watch a video to discover how to pass documents and their metadata to Microsoft® SharePoint® through use of the ABBYY Vantage – Connector for Microsoft SharePoint.

Hello. Today I’d like to show you how we set up our Vantage Process Skill to pass documents and their related metadata to Microsoft SharePoint. Now in my process skill, I have an input source, which is simply an email box that we’re monitoring. We will then classify. Extract related metadata off of these documents. And then our Microsoft SharePoint Connector uses a custom activity, which will pass that document and its data to SharePoint. And then of course, we are done here at the process skill. So today we’re gonna have an email that flows in through our email box here, and then we will then see the data and the document passed to Microsoft SharePoint.

So let’s watch this happen. All right. So now you can see, we have our email ready. The software has monitored it and pulled it so it’s automatically released from our SharePoint email box. The next thing we will see is a document passed over to our Microsoft SharePoint site. And there you go. You can see there is our document that we sent in. So now within SharePoint, I have the document, potentially its related metadata stored here for us as a historical record of this document.

So that’s our demo. Once again, a very simple process document comes in. We classify it so we know the document type. We extract the data. We use our custom activity to pass the data over to SharePoint. And then of course we are done with this process skill.

Thank you so much for watching this video. If you have any questions, please reach out to us.

Music- “‘Engineered to Perfection’ performed by Peter Nickalls, used under license from Shutterstock”.

“SharePoint” and “Microsoft” are trademarks of the Microsoft group of companies.

Related Content: