search

elplatt / seltzer

CRM for hackerspaces
GNU General Public License v3.0
104 stars 50 forks source link

interested in another payment provider module? #213

Open davidbuzz opened 11 years ago

davidbuzz commented 11 years ago

We have a bank here in Australia called "Westpac" that we ( hsbne.org) use that lets us export transactions to csv format. it's a different csv format to paypal, with different column names, and there is no email address to act as the relationship between the payment and the member... so anyway, I've written a payment importer for this specific format ( a worked-over version of the paypal one ) , and it tries to determine who made the payment based on the generic "reference" text field, where we tell our members to put their nickname/name when they make a payment. So, the code tries to match a payment to a member that way, and if it can't match it to a "single" seltzer username, or to a persons full name, then it errors ( ie no match, or multiple possible matches ) . If you are interested in the module, please comment here, and I can supply the code. :-)

davidbuzz commented 11 years ago

example csv data: (header and 1 row ) Bank Account, Date, Narrative, Debit Amount, Credit Amount, Categories, Serial 1234567890123,23/09/13,"DEPOSIT SomeName FullName MyNick",,60.00,DEP,