Importing payments into EME is done by using a CSV file. The csv delimiter and enclosure can be specified during import. If the delimiter value is empty, then “,” (comma) is taken as value. If the enclosure value is empty, then ‘”‘ (double quotes) is taken as value.
The first line should indicate the names of the columns being imported. Currently these names are recognized (unknown columns will be ignored):
“payment_date”,”unique_nbr”,”payment_id”,”payment_randomid”,”amount”
There are 3 columns required: “payment_date”,”amount” and one of the following 3: “unique_nbr”,”payment_id” or “payment_randomid”.
“payment_date” should be in a format that can be parsed using the PHP function date_parse (to be sure: use YYYYMMDD format). The amount should use the dot (“.”) as decimal separator. For the “unique_nbr” only the numbers will be taken into account. An example:
“payment_date”,”amount”,”unique_nbr”
“20230316”,”14.5″,”+++123/4567/89120+++”