Wiki source code of Импорт денежных сертификатов
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
5.1 | 1 | (% class="lead" %) |
| |
58.1 | 2 | Since version 2022.1 it is now possible to import ready-made [[gift certificates>>doc:Main.Using.Gift_certificates.WebHome]] created outside of the Loymax system. |
| |
3.1 | 3 | |
| |
58.1 | 4 | Importing money certificates involves the following steps: |
| |
6.2 | 5 | |
| |
19.6 | 6 | {{toc start="3"/}} |
| |
16.10 | 7 | |
| |
58.1 | 8 | === Certificate type creation === |
| |
16.10 | 9 | |
| |
58.1 | 10 | You need to create [[certificate type>>doc:Main.Using.Gift_certificates.Gift_certificates_MMP.Certificate_types.WebHome]] to further issue and order certificates. The type of denomination and its value can be any. |
| |
16.10 | 11 | |
| |
58.1 | 12 | === Template Creation === |
| |
16.10 | 13 | |
| |
58.1 | 14 | You need to create [[Template>>doc:Main.Using.Gift_certificates.Gift_certificates_MMP.Certificate_patterns.WebHome]] to further issue and order certificates. |
| |
16.10 | 15 | |
| |
58.1 | 16 | === Creation of certificate issue and ordering === |
| |
16.10 | 17 | |
| |
58.1 | 18 | You need to create [[Issue and Order>>doc:Main.Using.Gift_certificates.Gift_certificates_MMP.Certificate_orders.WebHome]] certificates (without pressing **Execute**). |
| |
16.10 | 19 | |
| |
58.1 | 20 | === Creation of a ruble account for a legal entity === |
| |
16.10 | 21 | |
| |
58.1 | 22 | Make sure that the legal entity has a ruble account. If a partner does not have a ruble account, it is necessary to add it [[via MMP>>doc:Main.Using.MMP.Admin_panel.Partners.Legal_entity_editing.WebHome]] or [[via API>>doc:Main.Integration.Ways_to_use_API.System_Api_Methods.Methods_of_system_api.PartnerLegal.WebHome||anchor="001"]] |
| |
16.10 | 23 | |
| |
58.1 | 24 | === Import certificates === |
| |
16.11 | 25 | |
| |
58.1 | 26 | Cash certificates are imported using [[API>>doc:Main.Integration.Ways_to_use_API.Gift_certificates_API.API_use_cases.WebHome||anchor="H41843C43F43E44044442434343543D43543D435433D644444B44514443544044443844443843A43044243E432"]] for cash certificates. To do this, you need to prepare a CSV file with information about money certificates. It is possible to get data about the number of import errors using a special [[API>>doc:Main.Integration.Ways_to_use_API.Gift_certificates_API.API_use_cases.WebHome||anchor="https://docs.loymax.net/xwiki/bin/view/Main/Integration/Ways_to_use_API/Gift_certificates_API/API_use_cases/#H41E43144043043143044244B43243043544243843C43F43E44044244143544044243844443843A43044243E432"]] method. |
| |
16.11 | 27 | |
| |
16.13 | 28 | (% class="box infomessage" %) |
| 29 | ((( | ||
| |
58.1 | 30 | **Notes:** |
 |
39.1 | 31 | |
| |
58.1 | 32 | 1. It is recommended to import no more than 100 certificates in one batch. |
| 33 | 1. If errors occur during the import, you can make corrections to the source file and repeat the import procedure. Certificates that were loaded without errors will be skipped when the import is restarted. | ||
| |
16.13 | 34 | ))) |
| 35 | |||
| |
58.1 | 36 | ==== Import file requirements ==== |
| |
3.1 | 37 | |
| |
58.1 | 38 | * Certificates must be uploaded to the System in CSV##;## file format |
| 39 | * [[Certificate identifiers>>doc:Main.Using.Gift_certificates.WebHome||anchor="ids"]] which can be used during import: | ||
| 40 | ** The unique number printed on the certificate (Number); | ||
| 41 | ** A unique barcode printed on the certificate (Barcode); | ||
| 42 | ** Information embedded in the magnetic strip (Strip1, Strip2, Strip3); | ||
| 43 | ** QR code printed on the certificate (QRcode). | ||
| 44 | * Possible [[states>>doc:Main.Using.Gift_certificates.WebHome||anchor="lifetime"]] of imported money certificates: | ||
| 45 | ** **Prepared**; | ||
| 46 | ** **Activated**; | ||
| 47 | ** **Redeemed**; | ||
| 48 | ** **Canceled**; | ||
| 49 | ** **Redunded**; | ||
| 50 | ** **Expired.** | ||
| 51 | * The certificate balance (Amount), i.e. the amount in the certificate account, can be anything in the range of 0...100000000, including fractional (rubles and kopecks). | ||
| 52 | * The dates of activation (ActivationDate) and expiration (ExpirationDate) must be transmitted in the format **YYYYY-MM-DD**. | ||
| |
3.1 | 53 | |
| |
33.1 | 54 | (% class="box warningmessage" %) |
| |
3.3 | 55 | ((( |
| |
58.1 | 56 | You cannot import money certificates that are in a state that indicates an incomplete process: **Activating** or **Returning **(Refunding). |
| |
3.3 | 57 | ))) |
| |
3.1 | 58 | |
| |
58.1 | 59 | Example of an imported CSV file with money certificates: |
| |
3.3 | 60 | |
| |
58.1 | 61 | {{code language="xml"}} |
| 62 | Number;BarCode;Strip2;Status;Amount;ActivationDate;ExpirationDate | ||
| 63 | 7770002105606220001;7770002105606220001;7770002105606227847=26067229740000001;Activated;555;2022-11-25;2023-11-25 | ||
| 64 | 7770002105606220002;7770002105606220002;7770002105606227848=26067229740000002;Activated;345;2022-11-25;2023-11-25 | ||
| 65 | 7770002105606220003;7770002105606220003;7770002105606227849=26067229740000003;Activated;100;2022-10-25;2024-10-25 | ||
| 66 | 7770002105606220004;7770002105606220004;7770002105606227850=26067229740000004;Prepared;1000;2022-10-25;2024-10-25 | ||
| |
3.3 | 67 | |
| 68 | {{/code}} | ||
| 69 | |||
| |
12.3 | 70 | ((( |
| |
33.1 | 71 | (% class="box infomessage" %) |
| 72 | ((( | ||
| |
58.1 | 73 | **Note:** you can only import data about a redeemed certificate (in Redeemed state) if the certificate is a one-time certificate or if the certificate amount (Amount) is zero. |
| |
12.3 | 74 | ))) |
| |
32.1 | 75 | |
| |
58.1 | 76 | === Updating information about certificates === |
| |
32.1 | 77 | |
| |
58.1 | 78 | If changes have been made after importing money certificates, e.g. certificates have been sold, redeemed, cancelled, etc., it is necessary to upload a CSV file with updated data on the certificates whose status has been changed. |
| |
37.1 | 79 | |
| |
36.1 | 80 | (% class="box successmessage" %) |
| 81 | ((( | ||
| |
58.1 | 82 | You can also perform **batch activation of money certificates** by transferring a file with money certificates in the state **Activated**. Thus, it is possible to issue a large number of certificates at one time. |
| |
36.1 | 83 | ))) |
| 84 | |||
| |
58.1 | 85 | For example, the certificate with number 7770002105606220002 has been redeemed, so you must transmit the updated status (Redeemed) and the redemption date - RedemptionDate in the format **YYYY-MM-DD**. The certificate with the number 7770002105606220004 has been activated, its status has changed from **Activated** to **Activated**, the data about the change should also be transmitted in the import file. An example CSV file for these certificates is shown below: |
| |
32.1 | 86 | |
| |
58.1 | 87 | {{code language="xml"}} |
| 88 | Number;BarCode;Strip2;Status;Amount;ActivationDate;ExpirationDate;RedemptionDate | ||
| 89 | 7770002105606220002;7770002105606220002;7770002105606227848=26067229740000002;Redeemed;0;2022-11-25;2023-11-25;2022-12-12 | ||
| 90 | 7770002105606220004;7770002105606220004;7770002105606227850=26067229740000004;Activated;1000;2022-10-25;2024-10-25 | ||
| |
32.1 | 91 | {{/code}} |
| 92 | |||
| |
33.1 | 93 | (% class="box infomessage" %) |
| 94 | ((( | ||
| |
58.1 | 95 | **Note: **when updating certificate data, you can transmit any one certificate identifier. |
| |
33.1 | 96 | ))) |
| |
58.1 | 97 | |
| 98 | |||
| |
33.1 | 99 | ))) |