IRD DB

[cavagnaro]

Hi guys,
I have came with a problem...I need to test customers strategies in my lab before doing a migration. So...I got his IRD DB where all strategies are stored and loaded in my SQL server and configured my IRD DAP to point to that DB, but now...how do I open them as I don't have the scripts in CME for them?? Do you know any way I can achieve that?
Thanks

[aponterules]

I really would like to help you, but i have no idea.

I hope somebody else can help you,

good luck

[ecki]

Hi Cav,

You should be able to open them without the script. That is the whole idea with storing the code in to CME database. So what is the exact problem you are dealing with?

E.

[catanirex]

Oh, you mean that you ONLY got the table ird_strategies from the customer?

Sorry, in that case you need to have the exports (zcf files) and import them into your CME. In other word you do not have any use of the IRD table..

[René]

Hi Cav,

It's possible to open the strategies stored in the IRD_STRATEGIES table but it requires some manual changes in the CME to be done... Here are the steps to follow:

1/ Create a new object of type "Simple Routing" in the Scripts directory in corresponding tenant (e.g. Resources) in CME
2/ Create a new section called "strategy" on the Annex tab of this new object
3/ Add following key to the strategy section
      location = database
      type = Custom
4/ Save the changes
5/ Find DBID of the object you've just created (CME started with the switch -d will show you DBID when you open the object)
6/ Open the IRD_STRATEGIES table and change DBID of corresponding row to match DBID of newly created Simple Routing object
7/ Open the strategy using the IRD

The steps above are valid just for routing strategies and not for subroutines as these require different parameters to be set.

As Catanirex wrote, the easiest way is to ask customer to export the strategies using the IRD.

R.

[cavagnaro]

[quote author=René link=topic=5636.msg24652#msg24652 date=1276677748]
Hi Cav,

It's possible to open the strategies stored in the IRD_STRATEGIES table but it requires some manual changes in the CME to be done... Here are the steps to follow:

1/ Create a new object of type "Simple Routing" in the Scripts directory in corresponding tenant (e.g. Resources) in CME
2/ Create a new section called "strategy" on the Annex tab of this new object
3/ Add following key to the strategy section
      location = database
      type = Custom
4/ Save the changes
5/ Find DBID of the object you've just created (CME started with the switch -d will show you DBID when you open the object)
6/ Open the IRD_STRATEGIES table and change DBID of corresponding row to match DBID of newly created Simple Routing object
7/ Open the strategy using the IRD

The steps above are valid just for routing strategies and not for subroutines as these require different parameters to be set.

As Catanirex wrote, the easiest way is to ask customer to export the strategies using the IRD.

R.
[/quote]

Nice, this will work.
Customer access to its CME settings is hard to get because of security...don't ask me...

Thanks guys!

[Timur Karimov]

[quote author=René link=topic=5636.msg24652#msg24652 date=1276677748]
It's possible to open the strategies stored in the IRD_STRATEGIES table but it requires some manual changes in the CME to be done... Here are the steps to follow:
[/quote]

cool hack =))) fanx

[Fra]

Cav,

René is right (as usual) - the strategies saved in the IRD_STRATEGIES need to be referenced in the config db.

Fra