Modify csv import script
Budget: $70 – $120 USD
We have an import script to add payments to our system.
We need a modification that the script extracts:
- The transaction date in column "Booking date" -> array "time"
- The transactionsnumber in column "Booking text" after "Zahlungseingang / Ref.-Nr." -> array "transcationId"
- The Invoice ID, that is 6 digits long and is located in the column "Booking text" after the Word "Mitteilung:" (ignore words and other numbers).
- The field credit -> array "amount"
- The sender from column "Booking text" after the transaction ID before the word "Mitteilung".
- Everything under Bookingtext -> array "subject"
For example check "custom2" in bankcsv.class.php, that is the rule we use today for an other bank account.
Example csv attached
Bankcsv.class.php with examples (custom1, custom2, custom3, custom4) attached. I recommend to modify custom2.
We need a modification that the script extracts:
- The transaction date in column "Booking date" -> array "time"
- The transactionsnumber in column "Booking text" after "Zahlungseingang / Ref.-Nr." -> array "transcationId"
- The Invoice ID, that is 6 digits long and is located in the column "Booking text" after the Word "Mitteilung:" (ignore words and other numbers).
- The field credit -> array "amount"
- The sender from column "Booking text" after the transaction ID before the word "Mitteilung".
- Everything under Bookingtext -> array "subject"
For example check "custom2" in bankcsv.class.php, that is the rule we use today for an other bank account.
Example csv attached
Bankcsv.class.php with examples (custom1, custom2, custom3, custom4) attached. I recommend to modify custom2.