The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
export recurring activities?
Posted: 06 Aug 10 10:58 AM
|
v7.2.2.1956
Does anyone have a way to get all the recurring activities out the system, represented as individual events?
Could I even cheat and just set the system date to a future date and somehow get all the recurring activities as individual activities in History?
I need a script or something to handle this. |
|
|
| |
|
Re: export recurring activities?
Posted: 09 Aug 10 11:26 AM
|
I already read it and its incomplete. It was a good starting point, but now I'm here.
I think I've read everything on the subject that google has.
I think the best approach may be to backup the system, set all the upcoming activities to closed and then export the differences from the history. Restore the DB to its prior state when done.
Any holes in this approach? |
|
|
|
Re: export recurring activities?
Posted: 10 Aug 10 7:59 AM
|
I would script it out and finish the incompletion (Ryan wasn't trying to do your work for you), but then that's me. SLX uses a listview to display activities because of the recurring activities and their 'skipped' steps. You can't display recurring activies in a grid.
There's no reason to 'restore' your database to its prior state.....take a snapshot, restore the snapshot of the database to a reporting database. Point the sync logs elsewhere. Run through every user and complete all of their activities as scheduled? sounds like fun. I've got a couple hundred user's our system and a few thousand activites...many recurring. You can throw away the snapshot or restore over it next month and start the process all over again.
Have fun! |
|
|
|
Re: export recurring activities?
Posted: 10 Aug 10 8:50 AM
|
| OK all done, thanks for your help. Good luck reverse-engineering the recurring activities and completing that incomplete document. Have Fun! :P |
|
|
| |
| |
| |
|
Re: export recurring activities?
Posted: 10 Aug 10 10:51 PM
|
| It sounds like I'm too late to be of much help, but I've done this. It's certainly not easy, and it can't really be done with VB scripting, but it could be done with almost any programming language that allows the use of bitwise operators. Was this just a one-time thing though, or is it an ongoing requirement? |
|
|
|
Re: export recurring activities?
Posted: 11 Aug 10 8:38 AM
|
| Also, if you examine the Web Client Dlls with a Reflection tool you will find several functions that are used to Expand the Recurrencies for the Activities. |
|
|
|