Import Controls and Citations Group Data

before you create authority documents, import citations and controls via the data import wizard create control groups that align with current industry standards such as fedramp 20x (federal risk and authorization management program) iso 27001 2022 (information security management) iso31000 2018 (risk management) nist sp 800 53 (national institute of standards and technology special publication) pci dss (payment card industry data security standard) gdpr (general data protection regulation) citations are passages or expressions in a document that are quoted or cited and express a specific requirement from the authority document controls are the specific steps or actions within a compliance mandate that must be met to fulfill a compliance requirement controls can be mapped to multiple citations from multiple authority documents to import citations and controls set up the data import connection refer to setting up a data import connection docid\ z8kdisu8gjfwjewthqcuk use manual file upload for the connection type and upload the excel spreadsheet the source unique key is id the target business object is grc citation no filter setting is necessary add a row for the reference id , and the corresponding field is citatationid click publish & run now this imports the data from an outside source into the database and creates new records each record needs a unique id ( control recid or citation recid ) you must have permissions for shared access to both the file (and its enclosing directories) and the server receiving the data