How to import XML file to Gnucash?

[Dan Black]

Have you tried Googling for ways to convert your Excel to Qif.  Try:

http://xl2qif.chez-alice.fr/xl2qif_en.php

Dan



On Sun, 2006-05-28 at 19:40 -0700, Vel wrote:
> Please help. Im new to Linux in general and in Gnucash in
> particular.  
>  
> 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:
>  
> <?xml version="1.0" encoding="UTF-8"?>
> <dataroot xmlns:od="urn:schemas-microsoft-com:officedata"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:noNamespaceSchemaLocation="datapro%20expenses%202005.xsd"
> generated="2006-05-28T22:47:38">
> <datapro_x0020_expenses_x0020_2005>
> <Date>2005-01-02T00:00:00</Date> 
> <Num>OR#137709</Num>
> <Description>Philcom Telephone</Description>
> <Transfer>Expenses:Datapro:Communication:Phone</Transfer>
> <R>n</R>
> <Decrease>349.21</Decrease>
> </dataroot>
>  
>  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.
>  
> Vel
>  
>  
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.