on 09-28-2011 2:16 PM
Does anyone know if you can perform a mass load of user mitigations in RAR? We are in GRC 5.3 SP 13.
Our user group is about to make some RAR ruleset changes that will result in a lot of new SODs. Because of this they are looking at having to enter hundreds of new user mitigations. They keep saying that someone told them you could do mass loads in 5.3.
The only thing I can find is the mitigation export/import utilities, but I can't get it to import new records. I can export the data and then import the same file back in, but can't get new records to import. I've tried to load the exported file into Excel, add the new records, and then save as a text file, but the import utiility keeps finding errors with the new file.
Any ideas?
Thanks.
Hi Bob,
We faced similar issue in our project and mitigation file was not getting uploaded due to invalid date format. Please make the date format as 2011-2-25 2012-2-25 (separate by hyphen). After downloading, if you try to change it through excel then the date format changes to 2011/2/25 2012/2/25, thus making the file upload a problem. So, just give a try by uploading the text file as date format shown below:
VALIDFROM VALIDTO
2011-2-25 2012-2-25
Thanks
Imran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bob,
I can recommend some ideas:
Check that the file you are trying to upload has tab's between fields.
Check the systems that you are trying to upload. (i mean sometimes i exported mitigation data from production systems and i tried to upload in preproduction system, but the backends connected were differents)
I hope it help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm saving the file out of Excel as Text (tab delimited).
I'm also using the exact same file I just exported out of our test system to load back into the test system, so data-wise everything should match. I'm just opening it in Excel and then saving it as a text file.
When I try to import back in the originl export file (where I exported all tables), I always get an error about the SQL insert values.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.