<div>Please help. Im new to Linux in general and in Gnucash in particular. </div>
<div> </div>
<div>I am already comfortable using Gnucash 1.18. As a former Windows user, I have lots of records (equivalent to 3 years of records to be exact) in MS Excel. I would like to import these records to Gnucash. The columns of my Excel file is identical to the columns of the "Cash Account" register of Gnucash. However, I dont know how to convert my Excel file to QIF, the format that can be imported by Gnucash. Knowing that Gnucash stores its data in XML format, I exported my Excel file to XML. A section of my XML file is listed below:
</div>
<div> </div>
<div><?xml version="1.0" encoding="UTF-8"?><br><dataroot xmlns:od="urn:schemas-microsoft-com:officedata" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance
</a>" xsi:noNamespaceSchemaLocation="datapro%20expenses%202005.xsd" generated="2006-05-28T22:47:38"><br><datapro_x0020_expenses_x0020_2005><br><Date>2005-01-02T00:00:00</Date>
<br><Num>OR#137709</Num><br><Description>Philcom Telephone</Description><br><Transfer>Expenses:Datapro:Communication:Phone</Transfer><br><R>n</R><br><Decrease>349.21</Decrease>
</div>
<div></dataroot></div>
<div> </div>
<div> I opened the datafile of Gnucash using the trial version of Stylus Studio Professional Edition (downloaded Xalan but I couldnt figure out how to use it). When I clicked validate XML document using Stylus, it says "
<font size="2">The XML file does not have a schema to validate against." So I clicked "Create Schema from the XML Content." but I got the following error: </font>"Parsing error in <a href="file:///c:/gnucash/datapro">
file:///c:/gnucash/datapro</a>. The prefix 'gnc' has not been mapped to any URI (line 3, column 32)." </div>
<div> </div>
<div>That ends my effort because I'm really just an ordinary user. I thought that my file can be mapped as source file and the gnucash as the target file using some XML parser. </div>
<div> </div>
<div>Can someone please help how to fix the 'gnc' error and map my source file to gnucash xml file. I could send part of my gnucash xml file to individuals who are willing to help.</div>
<div> </div>
<div>Please excuse my English. English is not my first language.</div>
<div> </div>
<div>Vel</div>
<div> </div>
<div> </div>