slew77 / hle-ofx-quotes

Automatically exported from code.google.com/p/hle-ofx-quotes
0 stars 1 forks source link

Enhancement Request: Support for multiple Accounts to Import OFX #4

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
To support multiple accounts each in a different currency, the account number 
shuld not be hardcoded for the OFX geeration.

1. The user can set up a mappng of account numbers to currency codes. Ths can 
be done in a CSV file:

eg: 

9876543210,CAD,
9876543211,USD,

2. The user than can select the default account to import into, instead of 
selectng th edefault currency

Original issue reported on code.google.com by smene...@bigfoot.com on 18 Feb 2011 at 7:37

GoogleCodeExporter commented 8 years ago
Will provide a concept called profiles which user can choose file menu
{{{
File -> Profies -> USD Proffile
File -> Profies -> CAN Proffile
}}}

Input to populate above menu come from *.properties file under directory 
profiles/

Property file will key-value pair looking like this
{{{
name: USD Profile
accountid: 123456
currency: USD
}}}

Original comment by hle...@gmail.com on 19 Feb 2011 at 4:02

GoogleCodeExporter commented 8 years ago
Excellent! That would be great. Thank-you for all the effort you have put into 
this.

Original comment by smene...@bigfoot.com on 19 Feb 2011 at 12:02

GoogleCodeExporter commented 8 years ago
SNAPSHOT *.jar is available as:

  http://www.le.com/~hle/out/hleOfxQuotes/SNAPSHOT/hleOfxQuotes-SNAPSHOT_20110219_001.jar
  See also: http://www.le.com/~hle/out/hleOfxQuotes/SNAPSHOT/readme.txt

To try out the "Profiles" feature:
  . Create a directory named "profiles" in same directory as where you have the *.jar file.
  . Under "profiles", add new file "CAD.properties" with content
name: CAD
accountId: 0123456788
currency: CAD

  . Start tool
  . Try File -> Profiles -> CAD
  . There is a new label above that price table showing the currently selected "OFX Account Id"
  . Generate a new OFX, check to see if the acccountID is there.
  . Import to see if MM will prompt you to enter a new "Dummy" account

Original comment by hle...@gmail.com on 19 Feb 2011 at 2:49

GoogleCodeExporter commented 8 years ago
The SNAPSHOT build works great. I have tested it as follows: I have created two 
files (CAD.properties and USD.properties) in the profiles subdirectory. Each 
profile is mapped to a different account number, which corresponds to the two 
dummy accounts I have created, one for each currency. 

I have tried out both the yahoo and google quote sources and they both seem to 
work as expected. I have verified that each of the ofx files does contain the 
proper OFX content for ACCTID and CURDEF as defined in the profile file. I have 
also tried the import and not encountered any errors, and have verifid that it 
does indeed update the security quote.

The only unusual behaviour I encountered is that changing the profile, after 
retrieving the quotes wipes out the retrieved quotes, and the quotes have to be 
retrieved again after switching profiles. While this is fairly minor, I can 
think of no reason why the quotes should be wiped out on profile change.

Original comment by smene...@bigfoot.com on 19 Feb 2011 at 5:58

GoogleCodeExporter commented 8 years ago
I should add a big THANK-YOU for getting this feature in so quickly.

Original comment by smene...@bigfoot.com on 19 Feb 2011 at 5:59

GoogleCodeExporter commented 8 years ago
On #4: quotes had to be retrieved after profile loaded. Actually it is by 
designed (or a bug depending on how you looks at it ;-).

Changing of the currency changes how the OFX is written out so the already 
retrieved data are treated as "invalid".

For this particular case, the data really is not "invalid" but a more general 
case where security are in different currency: some are in USD, some are in 
CAD, some are in GBP, the data are invalid.

Original comment by hle...@gmail.com on 19 Feb 2011 at 7:12

GoogleCodeExporter commented 8 years ago

Original comment by hle...@gmail.com on 26 Feb 2011 at 3:31

GoogleCodeExporter commented 8 years ago
Done.
See: https://code.google.com/p/hle-ofx-quotes/wiki/Build_20110226_001

Original comment by hle...@gmail.com on 26 Feb 2011 at 5:49