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
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.
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.