Copying transactions from one book to another
Kurt Padilla
kurt.padilla at gmail.com
Tue Aug 30 12:43:25 EDT 2016
David,
I have about a month's worth of personal transactions that I will have to
do this for, so I was hoping for some sort of bulk operation. However, your
suggestion beats going through eight months worth of duplicate
transactions. Thanks!
Kurt
On Tue, Aug 30, 2016, 12:29 David Carlson <david.carlson.417 at gmail.com>
wrote:
> Kurt,
>
> I am not sure that this is sanctioned by the developers because it has the
> potential to shoot yourself in the foot if you are careless, but I think it
> works. This is using the standard GnuCash program in Windows or Linux.
>
>
> First open your destination file with GnuCash. Then, without closing that
> file open your source file. It may be necessary to do this from the
> operating system rather than through the GnuCash File Menu button. I don't
> know if that works on Apple machinery.
>
> Navigate to the desired transaction and from the menubar select
> Transaction>Copy.
>
> Switch to the destination file and go to the target account register,
> which hopefully has the same name as the source account had. On the
> menubar click Transaction> Paste. Repeat as needed.
>
> When you are done, close the source file first before closing the
> destination file.
>
> If the user preferences were different between the two files, they should
> stay ok if you use that sequence, but there is no guarantee.
>
> David C
>
> On Tue, Aug 30, 2016 at 9:39 AM, Kurt Padilla <kurt.padilla at gmail.com>
> wrote:
>
>> Does anyone know of a way to copy/export transactions within a certain
>> date
>> range from one GnuCash book and paste/import them into another? I see that
>> I can export to CSV by type (asset, expense, etc), but I seem to have
>> trouble importing them into another GnuCash book. Each book has the same
>> accounts. This method seems very indirect, so I am not sure if I am on the
>> right path.
>>
>> Thanks,
>>
>> Kurt
>>
>> ---------- Forwarded message ---------
>> From: Kurt Padilla <kurt.padilla at gmail.com>
>> Date: Tue, Aug 30, 2016, 10:27
>> Subject: Re: Recently, I changed phones
>> To: Ngewi Fet <tickets at gnucash.uservoice.com>
>>
>>
>> Ngewi,
>>
>> I understand that the export feature considers the entry dates of each
>> transaction rather than the posted dates but I expected that the backup
>> feature would retain the entry dates rather than treating them all as
>> brand
>> new transactions after restoring the backup. I am realizing that I could
>> have avoided the situation by running an export just prior to backing up
>> from my old phone and then again from my new phone after restoring the
>> backup. I guess my recommendation would be to add some verbiage to the
>> backup/restore page explaining what's going on.
>>
>> Kurt
>> On Tue, Aug 30, 2016, 07:29 Ngewi Fet <tickets at gnucash.uservoice.com>
>> wrote:
>>
>> > Hi Kurt,
>> > After the first import, all transactions are freshly entered in the
>> > database. If you export, then everything will be exported because
>> > everything is new.
>> > However, subsequent exports should export only newly added transactions
>> > since the last export.
>> >
>> > It is important to distinguish what the Export time range is for. The
>> > export time range functionality exports the transaction from the date
>> you
>>
> > entered/modified it, *not* the time when the transaction was posted
>
>
>> > (which is what you enter in the UI). The entered/modified time cannot be
>> > set by you directly. It is automatically updated whenever you create or
>> > edit a transaction.
>> >
>> > Hope this helps
>> > Cheers,
>> >
>> >
>>
> > Helpful? Click to give Ngewi Fet thanks!
>>
> > <
>> http://gnucash.uservoice.com/kudos?email_login_token=bb1596e4d119382189edcce083b6c6fc&kudo=bwJG1YCr%252B7FI%252BY5N4oE0KovNRmEqyAfyjUed%252BrwOh7j7r67joKsK7mJp6G7qqK4RTMrPwx8SCNGFNFlBx81TtQ%253D%253D&tracking_code=c87ddbc591b7e710891ca951a8def5f3
>> >
>
>
>> >
>> > On August 29, 2016 at 9:01 PM Kurt Padilla <kurt.padilla at gmail.com>
>> > wrote:
>> >
>> > Ngewi,
>> >
>> > Is there any chance that there will be a solution to my little
>> predicament
>> > through the app? One idea I have considered is to export all of my
>> > transactions to a new book in GnuCash desktop. From that new book, I
>> would
>> > only export the date range that I need into my regular desktop book. I
>> > would probably still have to take care of some duplicate transactions,
>> but
>> > not nearly as many as I am currently facing. I tried this idea, but I
>> ran
>> > into some problems with GnuCash Desktop.
>> >
>> > If anything, I think my experience demonstrates a problem with GnuCash
>> > Android backups, that the transaction entry dates and times don't seem
>> to
>> > get backed-up or restored.
>> >
>> > Kurt
>> >
>> > --
>> >
>> > Sent from the Google Inbox Android app. GnuPG encryption available upon
>> > request.
>> >
>> > On August 25, 2016 at 5:46 AM Kurt Padilla <kurt.padilla at gmail.com>
>> > wrote:
>> >
>> > First, I exported and restored a an XML backup to a new phone. Then,
>> after
>> > a few weeks, I tried exporting a QIF. This QIF contained all the
>> > transactions, even though I specified a particular start date.
>> >
>> > Unfortunately, I do not have the old phone anymore.
>> >
>> > Kurt
>> >
>> > Sent from the Google Inbox Android app. GnuPG encryption available upon
>> > request.
>> >
>> > On August 25, 2016 at 5:39 AM Ngewi Fet <tickets at gnucash.uservoice.com>
>> > wrote:
>> >
>> > Hi Kurt,
>> > Normally, this should not happen. What format did you export in?
>> > XML exports always contain everything. However, QIF and OFX only export
>> > everything created since the last export, and also allow you to manually
>> > set the date.
>> >
>> > Cheers,
>> >
>> > On August 23, 2016 at 7:04 PM Kurt Padilla <kurt.padilla at gmail.com>
>> > wrote:
>> >
>> > Recently, I changed phones. I backed-up GnuCash and I was able to
>> restore
>> > the back-up on my new phone without issue. However, when I went to
>> export
>> > my transactions (to upload to desktop) it exported all of my
>> transactions,
>> > rather than only those since my last export. This happened in spite of
>> me
>> > selecting a specific date from which to begin the export. I really don't
>> > want to have to sort all of the duplicate transactions on my desktop. Is
>> > there a way to just export transactions from within a specific date
>> range?
>> >
>> > Thanks,
>> >
>> > Kurt
>> >
>> > --
>>
>> Sent from the Google Inbox Android app. GnuPG encryption available upon
>> request.
>>
> --
>>
>> Sent from the Google Inbox Android app. GnuPG encryption available upon
>> request.
>>
> _______________________________________________
>> 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.
>>
>
> --
Sent from the Google Inbox Android app. GnuPG encryption available upon
request.
More information about the gnucash-user
mailing list