This process may take a while to run (~5 minutes). XML Validation GUI - to be run on .txt files i.e. files post conversion This is an interactive tool highlighting errors in the file according to the schema. It will stop at the first error it finds. It is possible to then use the Instance” pane as a text editor to correct “XML the errors however this may not be very practical if there are a lot of errors. Convert XLS Report back to TXT to be run on files created by this Tool – This will convert an Excel file back to TXT format which it should be possible for the Registry to import. The idea here is that it may be quicker to make bulk corrections using Excel than via the Renal System. We also have the ability to produce Excel exports of existing data to allow sites to improve completeness. We would however hope that sites would then also make the changes to their Renal Systems, particularly given the potential changes in how the Registry extracts will work. One caveat about the validation is that not everything that could be validated is validated yet there is more work to be done transcribing the specification. Another is that the validation – keeps to the v3.14b specification as published at . There may be some places where we need to change the specification in light of the data being collected. At present it is also unable to flag errors based on the values in other fields for example – missing Cause of Death if a Date of Death has been entered. It is hoped that this will be added in the future. If you have any problems with the software please run it from a Command Prompt. This will make any error messages persist which will help us diagnose problems. If you have any queries then please contact George Swinnerton -
This process may take a while to run (~5 minutes). XML Validation GUI - to be run on .txt files i.e. files post conversion This is an interactive tool highlighting errors in the file according to the schema. It will stop at the first error it finds. It is possible to then use the “XML Instance” pane as a text editor to correct the errors however this may not be very practical if there are a lot of errors. Convert XLS Report back to TXT – to be run on files created by this Tool This will convert an Excel file back to TXT format which it should be possible for the Registry to import. The idea here is that it may be quicker to make bulk corrections using Excel than via the Renal System. We also have the ability to produce Excel exports of existing data to allow sites to improve completeness. We would however hope that sites would then also make the changes to their Renal Systems, particularly given the potential changes in how the Registry extracts will work. One caveat about the validation is that not everything that could be validated is validated yet – there is more work to be done transcribing the specification. Another is that the validation keeps to the v3.14b specification as published at . There may be some places where we need to change the specification in light of the data being collected. At present it is also unable to flag errors based on the values in other fields – for example missing Cause of Death if a Date of Death has been entered. It is hoped that this will be added in the future. If you have any problems with the software please run it from a Command Prompt. This will make any error messages persist which will help us diagnose problems. If you have any queries then please contact George Swinnerton -
Instructions-for-the-Renal-Registry-Site-Validation-Routines.docx