importing data

[David T.]

Tereque--

I suspect the lack of an answer is indicative.

Please keep in mind that I am just another user of Gnucash (and not a particularly savvy one), but I have been using it for a while now.

You surmise (correctly, I believe) that there is no way to import Gnucash data directly into Gnucash, and your spreadsheet solution is probably as good a way as any to achieve your goals.

That said, I believe that you are seeking to have Gnucash provide you with more of an enterprise solution than Gnucash was designed to provide. Gnucash is primarily meant for single users; requests for it to provide more robust multi-user access (as by allowing multiple file import, or by allowing multiple simultaneous users) have met with little enthusiasm.

HTH,
David



________________________________
 From: tereque <tereque at gmail.com>
To: gnucash-user at gnucash.org 
Sent: Monday, July 23, 2012 6:10 PM
Subject: Re: importing data
 


On 21/07/2012 15:54, tereque wrote:
> ... I need people to work with external data sources that I would like to
> import into gnucash (as the 'master' accounts so to say).
> 
> most logical would seem to me to import another gnucash file but I only
> can find a 'replay gnucash logfile'option on the import section. I tried
> this but nothing seems to happen. Did I do it wrong (>file >import
>  >replay gnucash file >choose)or is there any way to import a gnucash
> account into another?

no comments on this so far. is there a way?

> importing csv (being produced in Excel in our case) is a workable way of
> course but I wonder whether it may be possible to import data from two
> different fields of the Excle CSV into the 'desription' of gnucash. It
> seems that it is opnly allowed to map one field only to the
> 'description', It is not essential but would make life easier somehow.

a workaround i figured myself is to to the gathering work in the spreadsheet the data comes from. In my case it is Excel but I figured the formula is the exact same in ooffice.

you just gather or combine date of several field into a new field

basic formula is =A1&A2

that leads to display of both cells content in the cell you paste the formula. problem: there is nothing in between to separate the contents from each other (not even space). to achieve separation you have to add

=A1&"|"&A2

which leads to a separation as you chose between the "   ". In my example the two contents are separated with a |, but it can bee basically whatever you want. One might want to be cautious using mathematical things like -, +, / as separators though. I am not sure how these would behave once such a file would be reopened in the spreadsheet software and maybe stuff gets interpreted in a mathematical way which might lead to wrong display.

Use of such formula is not supported by a CSV file, so before importing this into gnuchash this file has to be 'saved as CSV' again.
The cell containing the combined data has to be cut 'n' pasted as it's content only before saving (maybe that happens even automatically once you process the 'saves as CSV')
_______________________________________________
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.