[moneydance] XML Tags

[rpiercemd]

I had not received any replies how to merge two securities, so with trial and
error I did find a solution.  This situation arose when my financial firm
suddenly changed the name of 5 of my securities, which left me with 10
securities in MD instead of five...not life-threatening unless you are
compulsive. 

You need an XML editor- I used XML Marker 1.1 (free), which works well. 
Print out report with all accounts, balances and share quantities for
verification later. 
MAKE A BACKUP!!!!! 
Export Moneydance file in xml format, and open in XML Marker 
In the left upper pane you will see your xml file broken down into an
hierarchal format. Select “CURRENCYLIST”, and in the right lower screen you
can order however you wish to find the two securities in question. Note
their “CURRIDs”. 
Edit-->Replace, enter name of security which you want to change, and search.
Your first search should bring you to the <CURRENCY>:</CURRENCY> section,
and I had two CURRIDs, one with right name, one with wrong.  I deleted the
wrong one, deleting from <CURRENCY> to next </CURRENCY> tag. The other one
was the correct one, so leave alone. 
I also copied the <CURRSNAP>..</CURRSNAP> for the deleted CURRENCY, and
placed it in chronological order in the section <CURRHIST> of the correct
CURRENCY, which I believe keeps all the historical pricing intact. (NOTE: if
you make a syntax error XML marker will notify you of a problem.)
“Find next”, and you will come to <ACCOUNTS>:</ACCOUNTS> section---there
should be two again. Please note the ACCTIDs for these two securities.
Delete the wrong-named account, from <ACCOUNT> to next </ACCOUNT> tag. 
Subsequently,  all “Find” actions pulled up transactions (<STXN>); here you
need to make sure the  ACCTID is correct for all transactions (delete the
ACCTID for the wrong-named security, replace with ACCTID for correct
security). 
Finally, re-search with “incorrect” security name, and verify that all
instances are correct with respect to name, CURRID and ACCTID. 
Open file in MD, and verify accounts and shares are correct.

I would appreciate it if someone else could verify this in a different
situation than mine for accuracy-sake. Obviously make a backup!

Randy
Carrollton, GA
rpiercemd wrote:
> 
> I have had a security name change, so now have two securities which are
> the same thing. I am editing the XML file to get everything under the
> security's newest name. There is a "TAGS" subheading under "CURRENCY"
> which contains a "KEY" = "price_date" with a "VALUE" = 1161078500000. It
> is not clear what this number represents. Does anyone have some insight? I
> would like to basically merge the xml data for these securities, but these
> "price_date values are clearly different.
> 

-- 
View this message in context: http://www.nabble.com/XML-Tags-tp5452069p14649894.html
Sent from the MoneyDance - General mailing list archive at Nabble.com.