XML Authoring

[HB13DISH]

I have a sample XML file generated with the user interface of an application, with just few typed data and I want to add few thousands more.
Perhaps using Excel and then generate an xml file, if this is possible.
What is the best way to do this?
I have downloaded the oXygen XML Author, but it doesn't seems to be friendly enough and also not cheap.
Is there an easy way to do this?

 

[mhku]

How complex is the XML? Do the nodes have subnodes or attributes?

I think I looked at this in the past _http://www.tucows.com/preview/304529

 

[HB13DISH]

How complex is the XML? Do the nodes have subnodes or attributes?

I think I looked at this in the past _http://www.tucows.com/preview/304529

Very simple.
It is a language synonym file, something like
man > male
woman > female
work > employment, job

How would you create satellites.xml file?

The link software is still not what I need.
But thanks anyway.

 

[compufunk]

You can save an excel file as .xml. I dont know how useful the output file would be though.

Probably the best approach (If you are going to use excel) would be to create a simple xml file with a few lines of what you want to include, then open it with excel and add all the data.

 

[mhku]

This isn't the way I'd do it but you can use Excel and notepad to "make" an XML file.

I created a file in Excel (attached). Saved as a .csv

Opened in Notepad

<,start,>,,,,
<,male,>,man,</,male,>
<,female,>,woman,</,female,>
<,work,>,employment,</,work,>
<,work,>,job,</,work,>
<,work,>,career,</,work,>
</,start,>,,,,

and replaced all the commas with a blank, which gives:

<start>
<male>man</male>
<female>woman</female>
<work>employment</work>
<work>job</work>
<work>career</work>
</start>

Saved as a .xml file

If you know all the node names and they are repeated you could use a lookup sheet to generate a list for column B/ column F values and save having to type them each time.