Guidelines for creating a kit or randomization list

If you choose to upload a kit or randomization list into the system, there are certain guidelines related to special characters and file formatting that you should keep in mind before performing this task.

The guidelines listed below apply to both a randomization and a kit list. While some of the information below is comprised of several tips, there are some points that simply explain any odd behavior the system may exhibit when uploading a randomization or kit list.

Special characters in lists

Here are a couple things to keep in mind before uploading a kit or randomization list.
  • UTF-8 special characters such as "|", "/", "$", "&", "-" can be used in kit lists.
  • Follow the standard CSV file name format. For example, use "KitList.CSV" or "Kit_List.CSV", but do not use "Kit.List.CSV".
  • Commas are not permitted within randomization list fields. For example, use "PartB(400 mg) 65 more than one non-US" instead of "Part B(400 mg) 65, more than one, non-US".

Leading zeros in lists

When uploading a list, any leading zeros in your upload list are removed.

Formatting of the CSV file

When it comes to the format and structure of your lists, here are some things that you need to know before uploading a list in the system:
  • First row in a CSV file must be populated with the column headers for the mapping to be done in the system. For example, if you upload a kit list where the first row is populated with your internal naming convention for the file within column A and the rest of the columns are blank, the kit list won't be mapped in the system, except for column A.
  • Cells within the CSV file cannot contain any values if no column headers are populated in the file. For example, if you upload a list with four column headers, but you populated some rows in the fifth column, the system won't be able to upload your file.
  • Maximum allowed number of rows in a randomization and kit list is 500.000 rows.

Difficulties during the upload process

Sometimes, after having already uploaded one or two lists, a caching issues occurs in the system. For example, if you upload a second list in the system, you might get an error message stating that your list cannot be uploaded during this time. Usually, the cause of this error lies within the saving process. The system saved data from the first upload attempt, such as the list's name, therefore it won't allow you to upload another list again, as though you're attempting to load the same list with the same name a second time.

You can work around this issue by clearing the cache in your browser.