Looking for something?

You will find your answers here!

    Sorry, we didn't find any relevant articles for you.

    Send us your queries using the form below and we will get back to you with a solution.

    How to Read the Text File in the Batch Close E-mails

    How to read the text file in the batch close e-mails

    Description

    How do I read the text file in the batch close e-mails?


    Resolution

    The Paya Virtual Terminal can send an e-mail notification whenever a batch is settled. See: How do I control where my batch close notifications are sent? These notifications contain a batch report in .txt format.

    On most computers, these files will open in Notepad and this can be confusing, especially if Word Wrap is enabled:

    The file is formatted like this as it is intended to be imported into a program that can interpret comma-delimited files. This article will show you how to view this using Microsoft Excel 2010.

    Begin by opening Excel and choose the Data tab, and then select From Text:


    Find the Batch Report that you want to import and select Import:


    Choose Delimited, and then press Next:


    Under Delimiters, make sure only Comma is selected, then press Finish:


    If you are asked where you want to put the data, select either Existing Worksheet or New Worksheet. Since we started from a blank page, it does not matter which you choose. You should now have a spreadsheet that contains all the data from the text file, organized into the appropriate columns. This spreadsheet can be manipulated like any other:


    If you have questions or require additional information, please submit a ticket and we will be in touch with you shortly.




    Was this article helpful?

    Still can't find
    what you are looking for?

    Our award-winning customer care team is here for you.

    Contact Support

    Knowledge Base Software by