importing data

[tereque]

hi Bob,

thanks for your mail. Yes let's work on that. I am just not 100% sure
how you mean that and in what way I can contribute.
On 25/07/2012 08:25, Robert L Brush III wrote:
> If this is interesting to you, we may be able to work together to make
> it happen, it is on my list of things to do, but unfortunately about
> midway down.
Are you a developer or programmer? Or do you mean we can work together
in doing 'PR' in order to get this issue up in the priority list of
programmers?

If you were to offset some of the development it would
> make sense to move it up the list.
> The problem right now is most scenarios involve doing things that place us in unknown territory and
> there just isn't enough time to figure out what could, would, or did go wrong, so the consensus is don't until it is safe.
I am not a programmer at all and but what I can do is making comments on
how it should work or test things (from a users perspective). I am
willing to help, I am enthusiastic about participating but have just
very limited knowledge regarding writing code (=0) So if you let me know
how I can help and I will try to do it

For me it is most important to get my accounting workable (using
gnucash) and I have figured a way for myself for importing stuff now
(using CSV import, and gathering data in Excel/ooffice first in order to 
get all info's I need in the 'description'). That is workable for me for 
the moment. It would be great if importing other gnuchash files would be 
workable midtherm but I am quite a beginner still and can hardly say 
whether this is the most urgent thing in the further developing of the 
software. Or maybe it doesn't matter and we try to do what we would like 
to have working.

> Don't know if that is encouraging or discouraging..
encouraging

best
Bela


>
> On Tue, 2012-07-24 at 09:10 +0800, tereque wrote:
>>
>> 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  <mailto: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.
>
>