Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for Purdue Federal [US] #102

Closed
nocalla opened this issue Nov 2, 2017 · 2 comments
Closed

Support for Purdue Federal [US] #102

nocalla opened this issue Nov 2, 2017 · 2 comments

Comments

@nocalla
Copy link
Member

nocalla commented Nov 2, 2017

Sourced from wesmcouch/Purdue-Federal-You-Need-A-Budget-Converter-YNAB-.

if row[1].include? '(Pending)' # Do not include pending transactions in the import
		next
	end
	
	if row[4][0].chr == '(' # Move outflows and inflows to proper columns
		datLength = row[4].length
		datLength = datLength - 2
		row[4] = row[4][1, datLength]
		row[5] = ""
	else
		row[5] = row[4]
		row[4] = ""
	end

To be filled in as required. Delete fields that match default values.
Source Filename Pattern = example_transaction_export_filename
Source Filename Extension = .csv
Use Regex for Filename = False
Source CSV Delimiter = ,
Source Has Column Headers = True
Input Columns = Date,Payee,Outflow,Inflow,Running Balance
Plugin =

From Issue #21 master list

@nocalla
Copy link
Member Author

nocalla commented Nov 2, 2017

Looks like it handles inflow/outflow by having brackets to denote outgoings. Needs plugin handling.

@torbengb torbengb added this to Candidates in 1.1.0 via automation Feb 22, 2018
@nocalla
Copy link
Member Author

nocalla commented Jun 4, 2018

Proposed mechanism of preprocessing in plugin:

for each row in file:
    check our Inflow column for brackets
    if there are brackets:
        strip out the start and end brackets
        add a minus to the start

@torbengb torbengb added this to Candidates in 1.2.0 via automation Oct 16, 2018
@torbengb torbengb removed this from Candidates in 1.1.0 Oct 16, 2018
@torbengb torbengb added this to Candidates in 1.3.0 via automation Apr 18, 2019
@torbengb torbengb removed this from Candidates in 1.2.0 Apr 18, 2019
@nocalla nocalla closed this as completed Jan 25, 2020
1.3.0 automation moved this from Candidates to Done Jan 25, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
1.3.0
  
Done
Development

No branches or pull requests

1 participant