SEPA-Transfer

SEPA Direct Debit and Bank Transfers

Convert to SEPA Format With Command Line Parameters

Spending too much time on recurring tasks, espacially when regularly converting files to another format, is uneconomical. That's why we recommend using SEPA-Transfer Enterprise Edition. It offers full command line control with CMD and PowerShell syntax. Command line parameters allow you to automate processes. This way, you can use SEPA-Transfer from your own program or script, for example, and it comes in handy saving precious time.

Command line calls are particularly effective when you have to execute the same steps over and over again: you can run complex processes without having to run the click sequence each time. Let us give you some examples:

Automate import of Excel debits

When you want to import Excel tables as a recurring debit, this command might come in handy:

SEPATransfer.exe -command import -file "C:\transactions\debits.xlsx" -type debit -mandatetype recurring -table june

This command lets SEPA-Transfer import the table named "june" from the named file as a recurring debit. Learn more about SEPA import automation.

Automate sales export to CSV

Export your turnover figures comfortably to a CSV file using:

SEPATransfer.exe -command activities -file "C:\activities\june.csv" -startdate 01.06.2021 -enddate 30.06.2021

Learn more about SEPA export automation.

Automate transfer import from data base

Finally, how about automating transfer import from a data base, too?

SEPATransfer.exe -command import -db "Provider=Microsoft.Jet.OLEDB.4.0;Password=;Data Source=C:\transavtions\transfers.mdb;Persist Security Info=True" -type transfer

This example shows the call of a Access data base named "transfers.mdb" without the need of a password.

Automate DTA to SEPA

You often have to convert DTA files to SEPA? Try this out!

With the command line call

.\SEPA-Transfer.exe -Command Import -DTA "C:\[path to DTA]\DTA.dta" -Command Write -SEPA "C:\[path to converted SEPA]\SEPA.xml" -Type Transfer

you can convert DTA files to SEPA format. In the practical application, replace the example paths with your concrete data and choose a file name.

 

Further information on command line parameters can be found on our help page. You want to use the command line import without having to learn the syntax? Simply save your import settings from the import wizard! Further information can be found on the help page.

Find out which SEPA-Transfer edition fits best

Are you wondering which edition of SEPA-Transfer is the best for your needs?