[moneydance] XML Tags

[Ash Ponders]

Hey Randy!

would you mind adding that guide to the Moneydance Wiki?
I'm sure it'd be pretty helpful to others in your situation.

~Ash

On Jan 6, 2008, at 8:49 AM, rpiercemd wrote:

>
> 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.
>
> _______________________________________________
> moneydance-info mailing list
> moneydance-info at moneydance.com
> http://moneydance.com/mailman/listinfo/moneydance-info