|
|
Rank: Newbie
Joined: 6/18/2013
Posts: 1
Location: Philadelphia
|
Hi,
I've tried to figure this out, but I'm really stumped.
I have an XML file I'm trying to convert to Excel, or at least a CSV file.
Can Altova XML spy Altova Mapforce do the conversion?
I can get the schema into Altova Mapforce...what are the next steps?
Thanks so much,
Michael Cabus
|
|
Rank: Advanced Member
Joined: 12/13/2005
Posts: 2,856
Location: Mauritius
|
Use Altova MapForce for this. It comes with tons of samples, including CSV and Excel - just look at them. Everything is far too easy.
|
|
Rank: Newbie
Joined: 11/6/2014
Posts: 3
Location: Dublin
|
cabusmichael wrote:Hi,
I've tried to figure this out, but I'm really stumped.
I have an XML file I'm trying to convert to Excel, or at least a CSV file.
Can Altova XML spy Altova Mapforce do the conversion?
I can get the schema into Altova Mapforce...what are the next steps?
Thanks so much,
Michael Cabus
The Altova Mapforce is the best way to convert to Excel spreadsheet. Their official site mentioned that the Altova Mapforce is able to produce output in the form of:
Excel spreadsheets
XML data
XSLT 1.0/2.0 stylesheets
SQL statements to update or insert databases
Flat files
EDI files
XBRL documents
|
|
Rank: Newbie
Joined: 1/20/2016
Posts: 2
Location: Sweden
|
vlad wrote:Use Altova MapForce for this. It comes with tons of samples, including CSV and Excel - just look at them. Everything is far too easy.
Where are the examples?
|
|
Rank: Newbie
Joined: 10/28/2002
Posts: 1,283
Location: AT
|
Quote:
Where are the examples?
FILE | OPEN .. then browse to the "C:\ProgramData\Altova\MapForce[VERSION]\MapForceExamples" directory and select "MapForceExamples.mfp"
|
|
Rank: Newbie
Joined: 1/20/2016
Posts: 2
Location: Sweden
|
Thanks for the quick reply.
I opened MapForceExamples.mfp. Where in the menu tree can I find an example for xml files to be converted to Excel?
Another issue I have is that I have openened an xml file with Altova MapForce and it doesn't recognise Asian characters as opposed to Notepad++ which reads my xml file OK, including Russian characters, etc.
|
|
Rank: Newbie
Joined: 10/28/2002
Posts: 1,283
Location: AT
|
Quote: I opened MapForceExamples.mfp. Where in the menu tree can I find an example for xml files to be converted to Excel?
Try the OOXML Excel 2007+ folder -->
Altova_Hierarchical_Excel.mfd
Sales_to_Excel.mfd
Quote:Another issue I have is that I have openened an xml file with Altova MapForce and it doesn't recognise Asian characters as opposed to Notepad++ which reads my xml file OK, including Russian characters, etc.
Maybe the characters are incorrectly encoded in the xml file, I can't answer this question without the actual file at hand. in general: I would suggest contacting support with the pertinent files and steps to reproduce the situation.
|
|
|
guest |
