INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Mapping xml Schema In Excel

Mapping xml Schema In Excel

(OP)
I have recently started a project wherein the EPA allows companies to report their green house gas emissions through the manual input in a website, or the use of an xml file.  The EPA has provided a schema for use in the preparation of the xml files and is located at

http://www.ccdsupport.com/confluence/download/attachments/33915237/e-GGRT+XML+Reporting+Schema+2010v1.2.zip?version=1&modificationDate=1312300492000

The "root" of the schema is when uploading to excel is "GHG"

Currently, the emissions data is compiled within excel spreadsheets and manually entered into an online input system, however I'm interested in trying create a new spreadsheet that contains the mapped schema so that the spreadsheet can be exported from excel into an xml format.  However, I have some experience in C++ and very little in HTML, but absolutely none in xml.

The process seemed extremely simply, however I've run into a number of issue, which I'll mention below.  Any help anyone can describe in regards to these specific issues, or my approach to this whole issue would be greatly appreciated.

Issues:

1.  The schema declares a namespace of "ghg", however after importing the schema to excel it changes the namespace to the generic "ns1" and I can't seem to determine how to change this.  The EPA is very picky about the formatting and the namespace I believe must be "ghg" for acceptable submission

2.  The most frustrating issue thus far is the "list of lists" and "A mapped element's relationship with other elements cannot be preserved" errors.  I've read through the MS documentation on this issue, but I don't see how this applies to my issue.  An example would be mapping the section for "facility owner information" where if I map any of those values, I automatically receive a "list of lists" error, even if I only map one value and define it with a single input.


Thanks again for any help anyone can provide me with, thanks in advance!

I've attached my current working file that has the "parent company name" mapped resulting in the "list of lists" error.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close