How to import XML file to Gnucash?
philippines at charter.net
Sun May 28 23:01:49 EDT 2006
Have you tried Googling for ways to convert your Excel to Qif. Try:
On Sun, 2006-05-28 at 19:40 -0700, Vel wrote:
> Please help. Im new to Linux in general and in Gnucash in
> 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
> <?xml version="1.0" encoding="UTF-8"?>
> <dataroot xmlns:od="urn:schemas-microsoft-com:officedata"
> <Description>Philcom Telephone</Description>
> 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 " 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: "Parsing error in file:///c:/gnucash/datapro. The prefix 'gnc'
> has not been mapped to any URI (line 3, column 32)."
> 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.
> 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.
> Please excuse my English. English is not my first language.
> gnucash-user mailing list
> gnucash-user at gnucash.org
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
More information about the gnucash-user