importing from excel, handmade xml question
Posted: Mon Sep 13, 2010 3:55 pm
After years of keeping dives in a lot of notebooks and a lot of computers, I moved it all over to excel. Now I'd like to move it all to macdive, and I tried using xml. I copied the divelog syntax, I think, and added columns to excel with the xml tags. Then I export from excel as csv, get rid of the comments, add a few lines for a header, and.... it should work but it doesn't. I get nothing but a bunch of 0 depth 0 time dives, all done on 1/1/2, with a new computer for every one.
I'm now working with just a single dive so it's not too messy. This is my xml. Can anyone see a problem? Do I need a more complete set of tags, even for fields that are blank?
thanks in advance.
I'm now working with just a single dive so it's not too messy. This is my xml. Can anyone see a problem? Do I need a more complete set of tags, even for fields that are blank?
thanks in advance.
Code: Select all
<dives>
<units>Imperial</units>
<schema>2.0.0</schema>
<dive>
<date>1989-02-19</date>
<maxdepth>20</maxdepth>
<duration>32</duration>
<country>USA</country>
<location>California</location>
<site>Corona Del Mar</site>
<buddies>
<buddy>Rusty</buddy>
</buddies>
<boat>Beach</boat>
<tags>
<tag>Class</tag>
</tags>
</dive>
</dives>