Skip to main content

Copy Data

  1. Last updated
  2. Save as PDF

Copy data from one modeled form to another.

RADplus Utilities > Database Management > Copy Data

When data is copied from one table to another, the following is changed in the table where data is copied:

  • Data entry by login

  • Data entry by form

  • Data entry date

  • Data entry time

  • The user performing the copy (Copy Data form), the copy date and time populate the fields above.

Import a file

  1. Create a tab delimited file.

  • Use any Windows-based word processing program. Save the document as a text (.txt) file. The file can be created in Microsoft Excel, and saved as a comma delimited text file.

  • Use six section delimited (ASCII character 9) columns. Follow each column with a carriage return (ASCII character 13), and a line feed (ASCII character 10).

  • Follow each entry with a period.

  • Use commas for blank entries.

  1. Save the file on the server.

  2. Open this form and click Import Mapping.

  3. Navigate to the file, click Open.

  4. Review the results User Scan Results field.
    If the file import has no errors Begin Copy is enabled.

  5. If appropriate, click Print Copy.
    All errors must be corrected before the file can be posted. After correcting the file, it must be re-compiled.

  6. In the Retain Original Data Entry Information field, select Yes to copy information entered in the original modeled form.

  7. Click Begin Copy.

Copy Data Format

Location (Column)

Description

1

Original data collection instrument form ID

2

SQL table name of the original table.

3

SQL table column name of the original table column

4

Receiving data collection instrument form ID

5

SQL table name of the receiving table.

6

SQL table column name of the receiving table column