[email protected] - Thursday, January 29, 2015 1:52 PM:
Perhaps I'm oversimplifying things, but I have been unable to export a Part, with it's BOM, to excel, or to a .csv. I'm running Aras 10.0 Build: 5846 and accessing it via Firefox.
I have a part, with a BOM. I'd like to export this information to excel, or even to a simple .csv.
I click on the 'Export to Excel' button in the part, on the BOM tab. It opens a 'save as' dialog where I can name the item. The only file type option is .xls. I click save and the document that is produced is some kind of xml document that excel does not recognize.
Here is a sample of what is created:
"<?xml version="1.0" encoding="UTF-8"?>
<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"><ss:Styles/><ss:Worksheet ss:Name="Innovator"><parsererror xmlns="www.mozilla.org/.../parsererror.xml">XML Parsing Error: not well-formed
Location: ...../Client/X-salt=std_10.0.0.5846-X/scripts/Innovator.aspx
Line Number 1, Column 3875:<sourcetext><table ><thead><th align='c'> </th><th align='c'>Sequence</th><th align='c'>Part Number</th><th align='c'>Revision</th><th align='c'>Name</th><th align='c'>Type</th><th align='c'>Quantity</th><th align='c'>State</th><th align='c'>Unit</th><th align='c'>Reference Designator</th><th align='c'>Changes</th><th align='c'>Fishbowl #</th></thead><columns><column width='24' edit='dropDownButton' sort='NOSORT' order='0' /><column width='70' edit='FIELD' sort='NUMERIC' locale='en-US' order='1' /><column width='120' edit='FIELD' sort='NOSORT' order='4' /><column width='50' edit='FIELD' sort='NOSORT' order='5' /><column width='200' edit='FIELD' sort='NOSORT' order='6' /><column width='120' edit='FIELD' sort='NOSORT' order='7' /><column width='80' edit='FIELD' sort='NUMERIC' locale='en-US' order='2' /><column width='80' edit='FIELD' sort='NOSORT' order='8' /><column width='60' edit='FilterComboBox' sort='NOSORT' order='9' /><column width='200' edit='FIELD' sort='NOSORT' order='3' /><column width='60' edit='FIELD' sort='NOSORT' order='10' /><column width='50' edit='FIELD' sort='NOSORT' order='11' /></columns><tr id='CEA9F1FDBC034945AB0B87108D5D9A61' action='CEA9F1FDBC034945AB0B87108D5D9A61' height='26'><td><img src=''/></td><td bgColor="#f3f3f3">1</td><td bgColor="#f3f3f3">4</td><td bgColor="#f3f3f3"></td><td>100069-001</td><td>A</td><td>FERRULE, 18 AWG, RED</td><td>Component/Electrical</td><td>Released</td><td>EA</td><td>false</td><td></td></tr><tr id='835B346981AE4CEAAAD79ED68D57AA2F' action='835B346981AE4CEAAAD79ED68D57AA2F' height='26'><td><img src=''/></td><td bgColor="#f3f3f3">2</td><td bgColor="#f3f3f3">1</td><td bgColor="#f3f3f3"></td><td>100068-001</td><td>A</td><td>PCB, A/B TRANSFER SWITCH, LED BOARD</td><td>Component/Electrical</td><td>Released</td><td>EA</td><td>false</td><td></td></tr><tr id='5E17823A1DAB470FB477FC91DB90C4EA' action='5E17823A1DAB470FB477FC91DB90C4EA' height='26'><td><img src=''/></td><td bgColor="#f3f3f3">3</td><td bgColor="#f3f3f3">1</td><td bgColor="#f3f3f3"></td><td>100067-001</td><td>A</td><td>PLUG, 4 PIN, 5.08MM, 12A, 250V, SPRING CAGE</td><td>Component/Electrical</td><td>Released</td><td>EA</td><td>false</td><td></td></tr><tr id='A8B2924BD0FF42BFBBE949AF65732FDB' action='A8B2924BD0FF42BFBBE949AF65732FDB' height='26'><td><img src=''/></td><td bgColor="#f3f3f3">4</td><td bgColor="#f3f3f3">1</td><td bgColor="#f3f3f3"></td><td>100066-001</td><td>A</td><td>HEADER, 4 PIN, 5.08MM, 12A, 250V, TH</td><td>Component/Electrical</td><td>Released</td><td>EA</td><td>false</td><td></td></tr><tr id='3BD5BE295F3A4A779CA9E18E7C830C00' action='3BD5BE295F3A4A779CA9E18E7C830C00' height='26'><td><img src=''/></td><td bgColor="#f3f3f3">5</td><td bgColor="#f3f3f3">1</td><td bgColor="#f3f3f3"></td><td>100065-001</td><td>A</td><td>LED, YELLOW CLEAR, 5MM, 588NM, ALINGAP</td><td>Component/Electrical</td><td>Released</td><td>EA</td><td>false</td><td></td></tr><tr id='22E275E3B2E84E4BA57C5F25B21CF13E' action='22E275E3B2E84E4BA57C5F25B21CF13E' height='26'><td><img src=''/></td><td bgColor="#f3f3f3">6</td><td bgColor="#f3f3f3">2</td><td bgColor="#f3f3f3"></td><td>100064-001</td><td>A</td><td>LED, GREEN CLEAR, 5MM, 574NM, ALINGAP</td><td>Component/Electrical</td><td>Released</td><td>EA</td><td>false</td><td></td></tr><tr id='D9A2B2E9644447D0A0D2AE086284A8D8' action='D9A2B2E9644447D0A0D2AE086284A8D8' height='26'><td><img src=''/></td><td bgColor="#f3f3f3">7</td><td bgColor="#f3f3f3">3</td><td bgColor="#f3f3f3"></td><td>100063-001</td><td>A</td><td>HOLDER, LED, PANEL-MOUNT, T-1 3/4</td><td>Component/Electrical</td><td>Released</td><td>EA</td><td>false</td><td></td></tr><tr id='969B143B14B641E7B049A577FCFD9698' action='969B143B14B641E7B049A577FCFD9698' height='26'><td><img src=''/></td><td bgColor="#f3f3f3">8</td><td bgColor="#f3f3f3">3</td><td bgColor="#f3f3f3"></td><td>100062-001</td><td>A</td><td>SPACER, LED, T-1 & T-1 3/4, 7.6L X 6.5W MM</td><td>Component/Electrical</td><td>Released</td><td>EA</td><td>false</td><td></td></tr><tr id='07031791575F42FAADB1FD49FD4DC472' action='07031791575F42FAADB1FD49FD4DC472' height='26'><td><img src=''/></td><td bgColor="#f3f3f3">9</td><td bgColor="#f3f3f3">3</td><td bgColor="#f3f3f3"></td><td>100061-001</td><td>A</td><td>RES, 0 OHM, THICK FILM, 3/4W, 2010, SMD</td><td>Component/Electrical</td><td>Released</td><td>EA</td><td>false</td><td></td></tr></table>
^</sourcetext></parsererror></ss:Worksheet></ss:Workbook>"
The data appears to be there, but it seems like it is poorly encoded/formatted, in an xml format that doesn't open with any utility well.
As the 'save as' dialog is the firefox utility, is it a web browser setting, perhaps?
I appreciate any thoughts or assistance.
Peter