I am new to this forum, and hope that I will find the help that I need.
Where I work, we receive Excel spreadsheets that list any number of task numbers which we need to complete. These tasks are written in S1000D XML, and stored on a database. In order to write the procedures, they must first exist on the database. For this specification, there is a file called a Data Module List. It is an XML file that lists any number of data modules (XML files). The project we are working on is on the order of 2800 xml files that need to be entered into the DB before my writers can begin. In the past we have been entering each data module into the DB by hand. After some thought I "dis-assembled" spreadsheet that we are sent into a CSV, giving all the info required for the tags in XML.
I have begun trying to map the info to the schema that governs this list. I have only been successful in mapping two of the elements. When I try to map the numbers, I get ta dialog box that says:
"The operation cannot be completed because the result would overlap an external data range or Pivot table"
I am not sure what this means, or how to resolve the issue.
"LOL The IoT version is for embedded systems"
LOL. The IoT version is for whatever you want, why are you so stuck up? It's just A NAME. Open your mind, buddy 😅. It's not a different version of Windows, only the licensing model and the support dates change, nothing else.
"there no real reason to do that"
Everyone has their reasons. You love to use Linux. Why? You have YOUR reasons. Other people will have theirs. I use Windows 11 and Linux on the side. Why? I have my reasons.
"No security updates? Who cares!"
Many people do, just not you. Why not use a supported OS instead of an unsupported one if you can?
LOL. I find it odd that a person that loves Linux and choice/freedom so much has such a hard time understanding why people do things different than him.
Ummmm I thought we talking about the desktop for home users? LOL The IoT version is for embedded systems. No regular user is using that version and there no real reason to do that.
Why does it seem like half the people here hate using an appropriate OS for the hardware they have?
The kind of comments I see here all the time...
No security updates? Who cares! I really like Windows 8.1 which was very underrated. Did I run it when it was supported? Well no I used Windows 7 at the time.
My hardware doesn't support Windows 11. Windows 10 or Linux than? Nope! They are of course running Windows 11. LOL
My hardware does support Windows 11. Never! I am running Windows 10 forever or at least until Windows 12 comes out and then you will have to rip my copy of Windows 11 from my dead, cold hands!
I have a 12 year old PC and it's machine #4. Well that would be perfect to run Linux sir! Nah! I will run Windows on that too. Windows 7 of course and yes I absolutely sometimes must browse the Internet with it. Freedom!
Did I cover all the scenarios we see here? LOL
Question
twfurst
Hello,
I am new to this forum, and hope that I will find the help that I need.
Where I work, we receive Excel spreadsheets that list any number of task numbers which we need to complete. These tasks are written in S1000D XML, and stored on a database. In order to write the procedures, they must first exist on the database. For this specification, there is a file called a Data Module List. It is an XML file that lists any number of data modules (XML files). The project we are working on is on the order of 2800 xml files that need to be entered into the DB before my writers can begin. In the past we have been entering each data module into the DB by hand. After some thought I "dis-assembled" spreadsheet that we are sent into a CSV, giving all the info required for the tags in XML.
I have begun trying to map the info to the schema that governs this list. I have only been successful in mapping two of the elements. When I try to map the numbers, I get ta dialog box that says:
"The operation cannot be completed because the result would overlap an external data range or Pivot table"
I am not sure what this means, or how to resolve the issue.
If anyone can help, i would be very greatful.
Tom
Link to comment
https://www.neowin.net/forum/topic/761886-mapping-excel-2007-spreadsheet-to-xml/Share on other sites
0 answers to this question
Recommended Posts