gnucash-user Digest, Vol 38, Issue 25

Tue May 30 06:22:01 EDT 2006

I just want to thank Dan Black and Bengt Thuree for pointing me to
http://xl2qif.chez-alice.fr/xl2qif_en.php. The macro worked like
magic! Of course, thanks to the creator of the XL2QIF. -- Vel

On 5/30/06, gnucash-user-request at gnucash.org
<gnucash-user-request at gnucash.org> wrote:
> Send gnucash-user mailing list submissions to
> 	gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> 	gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> 	gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>    1. How to import XML file to Gnucash? (Vel)
>    2. Re: How to import XML file to Gnucash? (Dan Black)
>    3. Re: How to import XML file to Gnucash? (Bengt Thuree)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 28 May 2006 19:40:26 -0700
> From: Vel <vel.suminguit at gmail.com>
> Subject: How to import XML file to Gnucash?
> To: gnucash-user at gnucash.org
> Message-ID:
> 	<23b366290605281940o4f30d664r14a43a3782063fff at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20060528/f788572b/attachment-0001.html
>
> ------------------------------
>
> Message: 2
> Date: Sun, 28 May 2006 23:01:49 -0400
> From: Dan Black <philippines at charter.net>
> Subject: Re: How to import XML file to Gnucash?
> To: gnucash-user at gnucash.org
> Cc: Vel <vel.suminguit at gmail.com>
> Message-ID: <1148871709.8128.5.camel at localhost>
> Content-Type: text/plain
>
> 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.
>
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 29 May 2006 12:12:33 +0900 (JST)
> From: "Bengt Thuree" <bengt at thuree.com>
> Subject: Re: How to import XML file to Gnucash?
> To: gnucash-user at gnucash.org
> Message-ID:
> 	<47888.194.237.142.21.1148872353.squirrel at denton.thuree.com>
> Content-Type: text/plain;charset=iso-8859-1
>
>
> On Må, 2006-05-29, 11:40, Vel skrev:
> > 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:
>
> Hi
>
> I am sorry to say that I think your only chance is to convert your EXCEL
> sheet to QIF file.
> You could use google
> (http://www.google.com/search?q=excel+to+qif&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official)
> or perhaps directly check this link
> http://xl2qif.chez-alice.fr/xl2qif_en.php
>
> I have not tried any of the tools, but for sure GnuCash will not simply
> use your XML file as its datafile. To many other things are in it that
> needs to be correlated.
>
> For instance, you could create a few transactions in GnuCash and then open
> the XML file (uncompress if needed) and look at it.
>
> Good luck
>
> /Bengt
>
>
>
> ------------------------------
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
> End of gnucash-user Digest, Vol 38, Issue 25
> ********************************************
>

-- 
Vel J. Suminguit
DataPro Internet Access
Malaybalay, Bukidnon