EDS - File Rejection: Structural Problems

Reported Issue: 

User receives a File Rejection email after uploading CSV or XML data file. There are multiple error messages you could receive regarding this so if you have any questions feel free to contact VON Support by emailing support@vtoxford.org or calling (802) 865-4814 ex. 240.

 

Resolution or Workaround:

The Vermont Oxford Network accepts two different file formats (.csv and .xml), both of which must adhere to their own structural rules.  File format description for .csv submissions can be found in Appendix A of the Instructions for Electronic Data Submission documentation.  

The XML Schema Definition (XSD) file used in validation of XML file submissions can be helpful in creating your XML file and can be found at the following link:

https://www2.vtoxford.org/xml/data/combined.xsd

A sample XML file can be found at this link:

https://www2.vtoxford.org/xml/data/H0999EDS0099.xml

Troubleshooting Tools

For both XML and CSV files, it is important to be able to view the file in an appropriate viewer, but you may also find it 

Summary of CSV Format Tests

FILENUM - This field cannot be blank.  This field must have an identical entry in every record in the file and must match the file number in the file name itself.

HOSPNO - This field cannot be blank.  This field must have an identical value in every record in the file.  This field value must match the center number in the file name itself.

ID - This field cannot be blank.  This field must have a unique value in every record in the file.  This field value must be within the center's certification range for ID.

BYEAR - This field cannot be blank.  This field value must be within the center's certification range for BYEAR.