Importing PSP files from Azure Blob Storage

Instead of uploading a file from your computer each time, you can let Continia Banking fetch the files from your payment service provider (PSP) automatically. When the PSP places its files in an Azure Blob Storage container, a job queue entry imports the files on a schedule. Continia Banking converts the files to PSP headers, and you create the cash receipt journal lines later.

Prerequisites

Before you set up the automatic import, make sure that:

• An Azure storage account and a container exist for the PSP files. For more information about the Azure side of the setup, see Setting up Azure Blob Storage for Continia Banking.
• The payment service provider has a CSV port. On the Payment Service Providers page, the CSV Port field must be filled in. The File Format of the CSV port determines whether the job imports CSV or Excel files.
• The PSP agreement has a Payment Service Provider and a Bal. Account No.

To set up the connection to Azure Blob Storage

1. Search for and select PSP Agreements.
2. Select the PSP agreement, and then on the action bar, click Azure Blob Storage Setup.
3. On the first page of the Azure Blob Storage Setup guide, click Next.
4. On the Authenticate page, in the Azure Blob Storage Name field, enter the name of the storage account. In the Azure Blob Storage Key field, enter the primary key of the storage account. Both fields are required.
5. Click Select Container. On the ABS Container List page, select the container that holds the PSP files, and then click OK. The name of the container is shown in the Selected Container field. Click Next.
6. On the Set up folder paths page, fill in the row for the file format of the CSV port:
   • File Path - enter the folder in the container that contains the PSP files. To browse the folders in the container, click the assist edit button in the field.
   • File Name Search Pattern - enter a pattern that identifies the PSP files, for example, *.csv. The pattern must contain at least one asterisk (*). The combination of file path and search pattern must be unique for each file format.
   • Archive File Path - enter the folder where Continia Banking moves the files after it processes the files. To show this field, click Advanced View.
7. Click Next, and then click Finish.

To schedule the import

1. Search () for and select PSP Agreements.
2. Select the PSP agreement, and then on the action bar, click Schedule Job Queue.

Continia Banking creates the job queue entry Azure Blob import of PSP Agreement followed by the name of the agreement, and then opens the entry. By default, the job runs every 60 minutes. You can change the schedule and the status of the entry on the Job Queue Entry Card page. For more information about job queues in Continia Banking, see Using job queues to schedule tasks.

What the job queue entry does

Each time the job queue entry runs, Continia Banking:

1. Lists the files in the File Path that match the File Name Search Pattern.
2. Downloads each file and saves the file in the file archive. Continia Banking skips files without content, and these files stay in the container.
3. Moves each file to the Archive File Path, or deletes the file from the container if no archive path is specified.
4. Converts the archived files to PSP headers by using the CSV port of the payment service provider.

If a PSP header with the same message ID already exists for the agreement, Continia Banking skips the file. If Handle Existing Records is set to Replace on the CSV port, Continia Banking replaces the existing header, unless lines of the header are already imported to a company.

The job doesn't create journal lines.

To review the imported data:

• Search for and select PSP Headers. For more information, see Working with PSP headers..

To create journal lines from the imported files

1. Search () for and select Cash Receipt Journals, and then open a journal batch that is set up for PSP payments.
2. On the action bar, click Home > Import Existing PSP Payments.
3. In the Import Payments dialog, select the PSP agreement, and then click OK.

Continia Banking creates journal lines from all PSP headers of the agreement that aren't imported yet. For more information, see Importing PSP payments.