Import rules from an excel-file to RSUSR008_009_NEW-tabels

[Former Member]

hi

i have created a ruleset based on the structure of RSUSR008_009_NEW in excel:

Variants for Critical Authorizations, Critical Authorization, Authorization Data, Authorization ID, color, .., Group, Object, Fieldname, ...

is there any way to import my ruleset into the tables of this application or do i have to type all.

i appriciate any idea.

thank you

Pourang

[Former Member]

Hi Pourang,

As per my experience on same you need to create these combinations manually as there is no option of importing data from file. You can copy variants.

[Former Member]

Hi ConceptK

i have about 800 rows of rules in excel and i don't like to type them in. i will develop a report to import them

thank you

[jurjen_heeck]

> As per my experience on same you need to create these combinations manually

Doesn't that make ECATT an option? (don't know the screens involved so just guessing here)

[Former Member]

I have tried in the past with eCATT but couldn't get it to work.

An upload program + a macro for formatting would be a pretty useful way to get it done I reckon. The table setup behind the reporting is reasonably simple from what I can remember.

[Former Member]

following file-interface might be enought:

Critical Authorization

-AUTH_ID

-XUTEXT

-AUTH_COLOR

Authorization Data

-CR_AUTH

-XUOBJECT

-XUFIELD

-XUVAL

-XUVAL

-XANDOR

-XUTEXT

Putting the Critical Authorizations in to Varints might be done manually.

[Frank_Buchholz]

Please have a look to the new Blog

Export/Import Critical Authorizations for RSUSR008_009_NEW

Kind regards

Frank