The File Import Service<\/strong> allows you to manage CentralPay operations in bulk<\/strong> by uploading simple CSV files instead of calling the API line by line.<\/p>\n\n To date, two types of files are supported:<\/p>\n\n For each file uploaded, CentralPay sends you report<\/strong> files indicating, line by line, what was accepted, refused, or rejected.<\/p>\n\n This service is designed for merchants who process large volumes<\/strong> of operations and prefer file exchange over real-time API integration: recurring direct debit collections, grouped outgoing payments, creation or migration of a customer\/SEPA mandate repository, etc.<\/p>\n\n The exchange occurs asynchronously<\/strong>: you upload your files, CentralPay processes them, then makes the reports available to you.<\/p>\n\n Direct debits require additional prerequisites, to be validated before<\/strong> any first submission:<\/p>\n\n SFTP is the recommended exchange channel. It ensures secure upload and retrieval, and allows CentralPay to automatically retrieve and process your files. <\/p>\n\n The SFTP is hosted by the merchant.<\/strong> <\/p>\n\n CentralPay connects to your<\/strong> SFTP, retrieves files from an outgoing folder, and deposits reports into an incoming folder.<\/p>\n\n The exchange relies on two directories<\/strong>:<\/p>\n\n This file creates your customer profiles. Depending on your needs, it can create in a single line<\/strong>: the customer profile alone, the customer + a bank account, or the customer + a bank account + an SDD mandate. <\/p>\n\n\n
Customer<\/code> files<\/strong>: to create your customer profiles in CentralPay, optionally with a bank account (BankAccount)<\/strong> and\/or a SEPA direct debit mandate (SDD)<\/strong>.<\/li>\n\n\n\nOperation<\/code> files<\/strong>: to initiate SEPA direct debits (SDD)<\/strong> on your customer profiles and\/or outgoing SEPA credit transfers (SCT)<\/strong> to your customer profiles’ bank accounts.<\/li>\n<\/ul>\n\n1. Who is this service for?<\/h2>\n\n
2. Prerequisites<\/h2>\n\n
2.1 Common Prerequisites<\/h3>\n\n
\n
2.2 Prerequisites for outgoing SEPA credit transfer operations (
CREDIT<\/code> \/ SCT)<\/h3>\n\n\n
2.3 Prerequisites for SEPA direct debit operations (
DEBIT<\/code> \/ SDD)<\/h3>\n\n\n
Customer<\/code> file, the mandate reference (MANDATE_RUM<\/code>) and its signature date (MANDATE_SIGN_DATE<\/code>). Consequently: \n\n
Without these prerequisites, files containing direct debits cannot be processed, whether in the testing or production environment.<\/pre>\n\n
3. How does the processing cycle work?<\/h2>\n\n
\n
Customer<\/code> and\/or Operation<\/code>) to the SFTP, in the upload folder.<\/li>\n\n\n\n.ACK<\/code><\/strong> file: each line is marked ACCEPTED<\/code> or REFUSED<\/code>, with the error reason if applicable.<\/li>\n\n\n\n.SET<\/code><\/strong> files indicating the settlement progress (ACCEPTED<\/code> \/ PENDING<\/code> \/ REFUSED<\/code>) once bank feedback is available.<\/li>\n\n\n\n.RET<\/code><\/strong> file detailing the reason and the returned amount.<\/li>\n<\/ol>\n\nCustomer<\/code> files do not<\/strong> generate a bank report (.SET<\/code> \/ .RET<\/code>): only an .ACK<\/code> is returned.<\/pre>\n\n4. SFTP Setup<\/h2>\n\n
4.1 Exchange Model<\/h3>\n\n
4.2 Folder Convention<\/h3>\n\n
Directory<\/th> Direction<\/th> Content<\/th><\/tr><\/thead> Upload<\/strong> folder (named \/OUT<\/code>)<\/td>Merchant \u2192 CentralPay<\/td> Your Customer<\/code> and Operation<\/code> files to be processed<\/td><\/tr>Return<\/strong> folder (named \/IN<\/code>)<\/td>CentralPay \u2192 Merchant<\/td> The .ACK<\/code>, .SET<\/code>, reports .RET<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n4.3 Setup Steps<\/h3>\n\n
\n
\n
.ACK<\/code>, then switch to production.<\/li>\n<\/ol>\n\n5. Prepare your files<\/h2>\n\n
5.1 Rules common to all files<\/h3>\n\n
\n
\n
<8 premiers caract\u00e8res de votre UUID marchand en minucules>_CUST_<r\u00e9f\u00e9rence libre>.csv<\/code><\/li>\n\n\n\n<8 premiers caract\u00e8res de votre UUID marchand en minucules<\/code>>_OPER_<r\u00e9f\u00e9rence libre>.csv<\/code><\/li>\n\n\n\nc494f877_CUST_20241025110500.csv<\/code> \u00b7 c494f877_OPER_20241025110500.csv<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\nOPERATION_TYPE<\/code> column, not by the sign of the amount. <\/li>\n\n\n\n\n
5.2 File
Customer<\/code><\/h3>\n\nColumn<\/th> Format<\/th> Status<\/th> Description<\/th><\/tr><\/thead> MERCHANT_ID<\/code><\/td>UUID<\/td> Mandatory<\/td> Your CentralPay merchant ID<\/td><\/tr> MERCHANT_CUSTOMER_ID<\/code><\/td>String(100)<\/td> Optional<\/td> Your internal customer reference (must be unique). Highly recommended for reconciling your operations. <\/td><\/tr> DESCRIPTION<\/code><\/td>String(256)<\/td> Optional<\/td> Free field for your use<\/td><\/tr> TYPE<\/code><\/td>INDIVIDUAL<\/code> \n\/\n LEGAL_ENTITY<\/code><\/td>Mandatory<\/td> Individual or legal entity<\/td><\/tr> SOCIAL_REASON<\/code><\/td>String(35)<\/td> Conditional<\/td> Required if TYPE = LEGAL_ENTITY<\/code> (company name)<\/td><\/tr>FIRST_NAME<\/code><\/td>String(35)<\/td> Mandatory<\/td> First name (of the legal representative if LEGAL_ENTITY<\/code>)<\/td><\/tr>LAST_NAME<\/code><\/td>String(35)<\/td> Mandatory<\/td> Last name (of the legal representative if LEGAL_ENTITY<\/code>)<\/td><\/tr>EMAIL<\/code><\/td>String(255)<\/td> Optional<\/td> <\/td><\/tr> PHONE<\/code><\/td>String(25)<\/td> Optional<\/td> International format +<indicatif><num\u00e9ro><\/code><\/td><\/tr>ADDRESS_LINE_1<\/code><\/td>String(255)<\/td> Mandatory<\/td> <\/td><\/tr> ADDRESS_LINE_2\/3\/4<\/code><\/td>String(255)<\/td> Optional<\/td> Address supplements<\/td><\/tr> POSTAL_CODE<\/code><\/td>String(15)<\/td> Mandatory<\/td> Allowed characters: letters, numbers, space, hyphen<\/td><\/tr> CITY<\/code><\/td>String(35)<\/td> Mandatory<\/td> <\/td><\/tr> COUNTRY<\/code><\/td>ISO 3166 alpha-3 code<\/td> Mandatory<\/td> Ex. FRA<\/code><\/td><\/tr>IBAN<\/code><\/td>String(34)<\/td> Conditional<\/td> Required to create a bank account<\/strong> (thus for any future outgoing transfer or direct debit). Validated according to ISO 13616 <\/td><\/tr> BIC<\/code><\/td>String(11)<\/td> Conditional<\/td> Required with IBAN<\/strong><\/td><\/tr> MANDATE_RUM<\/code><\/td>String(35)<\/td> Conditional<\/td> Required to create an SDD mandate.<\/strong> Unique Mandate Reference (UMR) of the mandate already signed on the merchant side<\/td><\/tr> MANDATE_SIGN_DATE<\/code><\/td>Date YYYY-MM-DD<\/code><\/td>Conditional<\/td> Required to create an SDD mandate.<\/strong> Mandate signature date<\/td><\/tr><\/tbody><\/table><\/figure>\n\n \"With or Without\" Logic<\/strong>