I'm pretty sure this post is a consequence of my ignorance of xml, but I can't figure this out from the stata [D] manual.
I have a bunch of .xml files I got from here ttp://www.imowa.com.au/Attachments/STEM_bids_offers/Public_EM_Sept06.zip
I saved this to my C drive and would like to import it to Stata.
I thought -xmluse- would do the trick, but it hasn't so far.
I tried importing the first file by typing
. xmluse wprtl20060927PUB_STEMResultPartInfo
unrecognizable XML doctype
I thought the error I got was because I hadn't told it it was a .xml file (although doubted my conclusion because the manual says .xml is assumed if omitted)
I tried this again with .xml and failed again...
xmluse wprtl20060927PUB_STEMResultPartInfo.xml
unrecognizable XML doctype
Now, I'm not sure if I need to open each .xml file in Excel first and then save them as xml again for -xmluse- to work or what.
I tried opening these .xml files in Excel but it reads it in as would a normal text editor. I'm on Excel 2000 so I think that's just an Excel thing because I think xml support comes from Excel 2003 onwards.
I'd appreciate any pointers on how to read these files into Stata anyone may have. If all else fails I might consider using -filefilter- somehow.
Thanks!
Rodrigo
Rodrigo Martell
<http://www.frontier-economics.com>
Frontier Economics Pty. Ltd.
395 Collins Street
Melbourne VIC 3000
Australia
www.frontier-economics.com
switch:
direct:
fax:
mobile:
email:
+61 (0)3 9620 4488
+61 (0)3 9613 1518
+61 (0)3 8614 2711
+61 (0)407 909 811
[email protected] <mailto:[email protected]>
This e-mail, including any attachments, may contain confidential and privileged information for the sole use of the intended recipient(s). Any review, use, disclosure or distribution by others is strictly prohibited. If you are not the intended recipient (or authorised to receive information for the recipient), please contact the sender by reply e-mail and delete all copies of this message. Thank you.
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/