Importing Data for Existing Records

Security Full role is required to import data for existing records.

Follow these steps to import data for an existing record: 

  1. Navigate to the Security > Update and select the appropriate update template.
  2. Select Separator (delimiter) and click Create Template to download the import template.  Note: By default, Excel uses tab delimiter.
  3. Open the file with a spreadsheet.
  4. Populate the required columns and the columns that need to be updated.
  5. Delete all other columns.
  6. Save the file as either Text (Tab delimited) or CSV (comma delimited). 
  7. Select the file on the Update screen and click validate.  Note: If the file is validated, the “Validation Successful” message will appear.  Otherwise, validation failure errors will indicate what data needs to be corrected.
  8. Once the file is validated, select it one more time and click Update.

Note: Besides the required columns and the columns that are being updated, all other columns MUST BE DELETED from the file.  Otherwise, the data will be overwritten with blank values.

Here is a comprehensive index of Importing Data for Existing Records articles:

Importing Data for Existing Records - Courses
Importing Data for Existing Records - Customers
Importing Data for Existing Records - Historical Marks
Importing Data for Existing Records - Households
Importing Data for Existing Records - Household Persons
Importing Data for Existing Records - Inquiries
Importing Data for Existing Records - Student Health Issues
Importing Data for Existing Records - Students
Importing Data for Existing Records - Users
 
PCR Educator K-12 School Information System is an online database engineered for independent and private schools to deliver the highest level of flexibility, unique experience, transparent communication and customized design. Being a complete cloud-based solution, PCR Educator system guarantees convenient access anytime, anywhere.

Schedule Demo

School Name *
Relation to School *
select
Last Name *
Your First Name *
Your Email *
Your Phone # *