Bug 312730 - Some scheduled transactions cannot be selected and are not saved in SQL database
Summary: Some scheduled transactions cannot be selected and are not saved in SQL database
Status: RESOLVED NOT A BUG
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 4.6.2
Platform: openSUSE Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-06 06:15 UTC by Theo
Modified: 2013-01-12 17:04 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Theo 2013-01-06 06:15:11 UTC
All scheduled transactions are shown in the ledgers, but some cannot be selected. When clicking on one of these, the selection jumps to earlierer scheduled transactions. And exacly these transactions are not exported to the table kmmSplits when the data is saved as MySQL database.

Reproducible: Always
Comment 1 Alvaro Soliverez 2013-01-06 13:35:36 UTC
Those scheduled transactions are latter occurrences of schedules. When you select it, it selects automatically the first occurrence of that schedule, which is the only one you can actually enter as a transaction.
This is by design.
Comment 2 Theo 2013-01-06 16:01:15 UTC
So is it badly designed with respect to the export of the SQL database? I tried to do computations with scheduled transactions by saving the data (from *.kmy) to a SQL database and use the power of SQL queries.

In the table kmmSplits I find the first occurrences of scheduled transactions only up to the end of March 2013 (these are not all, some schedules have their closest scheduled transaction later this year). And these are not all transactions scheduled within that period of time (some schedules have lower frequency than others). Isn't it then confusing and pointless to put scheduled transaction into kmmSplits at all?
Comment 3 Alvaro Soliverez 2013-01-06 22:30:33 UTC
You can decide how many occurrences in the future you want to view. (or days, I don't recall exactly now)
Comment 4 Theo 2013-01-06 23:04:07 UTC
Right, I can set the number of days to preview schedules in the ledger under Settings/Configure KMyMoney/Scheduled transactions. But I want the scheduled transactions that are shown in the ledger to show up also in the table kmmSplits after saving the data as SQL database. There I can find only the first occurrences within a fixed period of time, which is unaffected by the settings.
Comment 5 Alvaro Soliverez 2013-01-06 23:36:21 UTC
To KMyMoney, only the first occurrence really exists, the rest are just shown on the ledger as a "convenience"

There is a report for schedules, perhaps that suits your needs.
Comment 6 Theo 2013-01-12 17:04:43 UTC
I couldn't find any report that gives all scheduled transaction within a certain time period. Exporting schedules to icalendar also gives only the first occurrences. It seems there is no way to export a list of scheduled transactions as shown in the ledger view.