Converting Files

convert veeva vault to ryze the veeva converter can be used to convert a veeva vault study design specification (sds) into an odm file you can then upload the odm file into your repository the source file must be saved as type 'xml spreadsheet 2003' the veeva converter can be used with the docid\ j8cgvkwmlg ina7yb0siz to import metadata from veeva vault edc convert medidata rave to ryze use this service to convert study metadata held in a rave als (architect loader spreadsheet) file into a formedix ryze file the als source file must always be in the 'xml spreadsheet 2003' format and can have xml or xls file extensions this service may take several hours to complete for large studies to convert a rave als file to a formedix ryze file select services from the navigation bar and open the services tab select convert medidata rave to ryze docid\ lfp4len0wnxbzeounzp w for the service and select convert the file is validated before conversion to check it's a valid file select downloads from the navigation bar check the conversion status completed this confirms that no problems were found with the input file and the output file complies with the odm standard completed with issues read the report and decide if you want to fix the source file and try again failed read the report and fix any issues before trying again to download the file, click the download icon convert oracle inform to ryze use this service to convert study metadata, held in two oracle inform files, into formedix ryze files csml source file from central designer client (mandatory) units xml file from central designer administrator (not mandatory unless study contains measurement units) you must name the units xml file 'unit definitions xml' if you use another name, the units will not be converted and the odm file will not contain units to convert an oracle inform cmsl file to a formedix ryzefile select services from the navigation bar and open the services tab select convert oracle inform to ryze select choose next to file and browse to select a csml file the file is validated before conversion to check it's a valid file (optional) select choose next to xml file and browse to select an xml file if your study contains measurement units select convert select downloads from the navigation bar check the conversion status completed this confirms that no problems were found with the input file/s and the output file complies with the odm standard completed with issues read the report and decide if you want to fix the source file and try again failed read the report and fix any issues before trying again to download the file, click the download icon convert define‑xml 1 0 to define‑xml 2 0 use this service to convert a define xml 1 0 file to a define xml 2 0 file the converted define xml 2 0 may require the addition of further information before it can be used a part of a submission to convert a define xml 1 0 file to a define xml 2 0 file select services from the navigation bar select convert define xml 1 0 to define xml 2 0 docid\ lfp4len0wnxbzeounzp w for the service and select convert select downloads from the navigation bar completed this confirms that the converted file complies with the define‑xml 2 0 standard completed with issues read the report and decide if you want to fix the source file and try again failed read the report and fix any issues before trying again select download convert excel to define‑xml 2 0 use this service to convert an excel spreadsheet file containing dataset metadata to a define xml 2 0 file to convert the excel file to define‑xml 2 0 select services from the navigation bar select convert excel to define xml select here to download the formedix template you must use a formedix spreadsheet template if you want to define your own code lists and value lists docid\ lfp4len0wnxbzeounzp w for the service and select convert select downloads from the navigation bar check the conversion status completed this confirms that the converted file complies with the define‑xml 2 0 standard completed with issues read the report and decide if you want to fix the source file and try again failed read the report and fix any issues before trying again to download the file, click the download icon convert sas xpt to define‑xml 1 0 use this service to create a define xml 1 0 file from one or more sas xpt files this includes code lists and value lists you must use a formedix spreadsheet template if you want to define your own code lists and value lists to create a spreadsheet in the formedix format download the formedix spreadsheet template and open within excel fill out the spreadsheet as described in the instructions tab and then select save do not use the save as option the file must remain in 'xml spreadsheet 2003' format to convert the file(s) select services from the navigation bar select convert sas xpt to define xml 1 0 upload the source file and complete the following protocol identifier an alphanumeric name that identifies the document used to define and manage the trial standard name select the cdisc standard that the datasets conform to the define‑xml file will then be supplemented with the additional information required for this standard generate valuelist from the data this option is not available if the standard name is set to 'none' select this option to include value lists in the output define‑xml for example, when you select a standard, all of the variables that would typically have value lists, such as ' testcd', will have value lists added generate lengths from the data select this option if you want the values for the 'length' attribute for each variable within the output define‑xml to be generated based on the input data the longest data value in each column will be used for the length if not selected, the lengths from the xpt metadata will be used generate code lists none select this option if no code lists are to be generated merge from file select this option if you want code lists to be generated based on a spreadsheet file a template for the spreadsheet and documentation for how to create it can be downloaded below select choose , browse to the code list file and select open generate from data select this option if you want code lists to be generated based on the input data code lists will be generated for each variable which has a code list specified in the cdisc standards code list items within the code lists will be generated based on the de‑duplicated input data values merge and generate select this option if you want code lists to be generated using both of the options above if a code list is specified for a variable in the spreadsheet and a code list is also specified for this variable in the cdisc standards, the spreadsheet code list will take precedence a template for the spreadsheet and documentation for how to create it can be downloaded below select choose , browse to the code list file and select open select convert and then select downloads from the navigation bar the cog icon indicates that the data upload may take a few minutes check the conversion status completed this confirms that the converted file complies with the define‑xml 1 0 standard if a standard name was specified, it also indicates that the define conforms to that standard completed with issues read the report and decide if you want to fix the source files and try again failed read the report and fix any issues before trying again to download the file, click the download icon convert sas xpt to define‑xml 1 0 (preview) use this service to generate a pdf showing the content of the define‑xml that would be generated by the full service you must use a formedix spreadsheet template if you want to define your own code lists and value lists