asked on

Need help exporting to XML

I have a website form that I exported as XML that I'd like to do a large number of changes that involve duplicating some (not all) content. If I open the XML with MS Excel, it opens in Table view which is perfect for me to dump data into the columns from a CSV and duplicate the other cells in the row.

The problem is that I wish to save it in the original XML format (so I can import back into my website as a form), but I get the error message "Cannot save or export XML data. The XML Maps in this workbook are not exportable".

How can I overcome this problem?
gravityforms-export-2013-09-22.xml
Book1---Copy.xlsx

Reece

ASKER

I've thoroughly read that prior to asking this question and it DOES NOT offer any explanation or, more importantly, solution to the reasons I can't export.

I am opening the XML with Excel, adding a heap of data to one or two columns, and duplicating the data down the rows for all other columns...

I'm not starting from scratch or compiling an XML using imports etc.

When I click the Verify Map for Export link in the Source section, I get the following error, which the article you linked addresses, but does not offer a resolution for.

I attached the files I've been working with so people could understand what I'm trying to do... so have a play with them and see if there is a better suggestion you could offer.

I'm not a data format professional by any name and my knowledge of XML is really limited.

ASKER CERTIFIED SOLUTION

Jan Karel Pieterse

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sybe

Is there a special reason why you do not use a HTML-editor when editing a webpage? Because that seems the proper way to do it.