Skip to main content

Replies sorted oldest to newest

Hi, Ben.

One way to convert Excel data into an XML file would be to create a merge template in Word, merge the data from the Excel spreadsheet, and then save the merged document as a text file with a .XML extension.

The real trick is determining what the XML file should look like. As a simple example, if you had a CSV file that looks like this...

"FirstName","LastName","MrMs","NoteDate","NoteTime","NoteText"
"Bob","Loblaw","Mr","2006-02-10","12:09:30","This is a note."

...after converting to XML it would look something like this...

<?xml version="1.0"?>
<AllData   xmlns             = "http://www.maximizer.com/maximizer/xmlimportexport/3.0"
           xmlns:xsi         = "http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation= "http://www.maximizer.com/maximizer/xmlimportexport/3.0  MXISchema.xsd">

   <Individual>
      <FirstName>Bob</FirstName>
      <LastName>Loblaw</LastName>
      <MrMs>Mr</MrMs>
      <Note>
         <Date>2006-02-10T12:09:30</Date>
         <Text>This is a note.</Text>
      </Note>
   </Individual>

</AllData>

To see more XML tags, try exporting some address book entries to XML and then look at the resulting file.

Add Reply

LEGAL INFO
CONTACT US
Copyright 2007-2018 Advoco Solutions Ltd. All Rights Reserved.
×
×
×
×
Link copied to your clipboard.
×