6/23/2023 0 Comments Tabular database![]() ![]() txt) file, another delimiter of your choice. Create columns for associated data for each Participant, separated by pipe characters or, if you have created a text (.If not configured differently, the heading must be ParticipantID. Alternately, download the sample file to edit. txt) document or use another supported format (see the note above). For example, if the data is a | b | c | d,e,f | g, “d,e,f” would need to be in quotes due to the commas within the data. Note that Excel automatically formats data in a useable format, but if your data comes from another source, you might need to put the data within each column in quotes if it contains commas or other delimiter values. You can specify the delimiter in your Data Mapping File, for example: #Delimiter=t. If no delimiter is specified, the import will use a pipe ( | ) by default. txt) file, you can use a delimiter of your choice, for example a comma or tab. Note: The following formats are supported: text (. You can also include other data items with OIDs. Use this file to specify Participant IDs for the Participants with data you want to import. You can view, download, or delete the import from there. You can click the Tasks button and select Bulk Actions Log to check the status of the job. Select your Data Mapping file and Tabular Data file together by pressing the Ctrl key (Windows) or Command key (Mac) and clicking on both files. ![]() ![]() To Import Data on the Import Tabular Data screen: Not allowed: importing into items in repeating groups.Not allowed: importing into forms in non-repeating common events containing multiple forms.This can be used to import any data except the following:.These are the user-defined IDs that identify Participants in user-facing pages across the system, as opposed to the automatically generated OIDs which identify the Participants on the backend. Note: The flat file import feature does not accept Participant OIDs, it Participant IDs. If you import into a Visit-Based Event, the data imports into existing scheduled Event occurrences. If you import into a Common Event, new event occurrences are created as needed. When you import a flat file, each data row imports into the Form in a different Event occurrence for the specified Participant. To do so, you need a Tabular Data file that contains your data and a Data Mapping file that maps your Tabular Data file columns to Form items. You can import data on the Import Tabular CRF Data screen. ![]()
0 Comments
Leave a Reply. |