FGM enhanced dataset: Submitting data via file upload

Submitting data to the FGM Enhanced Dataset using file upload is done via the Clinical Audit Platform (CAP); a secure, web based platform supported and hosted by NHS Digital.

To submit data to the collection, you must first register by creating an NHS England Single Sign-On (SSO) account and submitting the FGM User Registration Form.

Sign into the clinical audit platform using your user name (your registered email address) and click sign in. 

The email address you use for sign in must be the same as the one you submitted on the user registration form.  You will not be able to access the Clinical Audit Platform if you use different emails. 

Once you are signed in click on the FGM enhance data set under my available audits.

The FGM home page will be displayed. 

Click on file submission dashboard from either the top bar menu or the main menu on the FGM homepage.

The upper section of the dashboard shows details of files which have recently been uploaded, including the Job ID, who uploaded it and when it was uploaded. Only uploaded files for your organisation will be displayed. 

You can use the lower section of the dashboard to submit files.

Details on the success of the upload, including the number of records submitted and details of any errors or warnings can be found by clicking on view job details for each upload.

On the lower section of the file submission dashboard, click on the first browse button. Then choose file to upload dialogue box will be displayed.

Select the file you wish to upload, and click open. The file path will now be displayed in the filename field.

We recommend the files are uploaded one at a time and and must be in order (patient, attendance, FGM) to ensure all errors and warnings are addressed sequentially, however, it is possible to upload all files together by repeating the process described.

Once you have selected all the files you wish to upload, click on the upload button at the bottom of the screen.

File validation

Only valid files are able to be uploaded into CAP via the File Submission Dashboard. ALL files must be .csv files and must match the csv specification described in the dataset published on the FGM website. 

The header row for each file is optional. If one is used, then the name of the first column has to be preceded by the word HEADER_

Once you have selected your files and clicked on upload, a pop up box will be displayed once the upload is complete.

Use click here to check the file has been uploaded successfully.

The file submission details can be accessed immediately after the file has been uploaded (see Step 5) or via the File Submission Dashboard (see Step 3). Details of all submissions must be checked for errors and changes made where necessary.

The file submission details show

• records successfully imported into CAP which had no errors with their data
• records successfully imported with warnings, meaning that the record has been submitted to CAP, but there were issues with some data items, for example a non-required data item has been submitted or a data item has an invalid value
• records unsuccessfully imported into CAP, meaning that the record has not been submitted to CAP, possibly because a required data item is missing or has an invalid value. The data items must be corrected and uploaded again to ensure a successful submission

Details of the errors and warnings are displayed and should be self-explanatory. Corrections to data can either be done by amending and re-uploading  the csv file, or be done manually within the CAP patient record. 

Contact us by telephone 0300 303 5035 or email [email protected].