Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Canadian Schools
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
School Portal
Customer Portal
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Canadian Schools
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
School Portal
Customer Portal
Sign In
Demo
School CRM
Knowledge Base
Importing New Records - Customers and Addresses
Importing New Records - Customers and Addresses
Importing New Records - Customers and Addresses
Follow the steps for
Importing New Records
Field
Required
Type
Sample Value
Notes
Lookup_Household_Id
No
Lookup
"123"
Must match an existing household id in the system
Lookup_Household_Name
No
Lookup
"Smith Family"
Must match an existing household name in the system
Customer_Name
Yes
Text
"John Doe"
Customer_Alternate_Id
No
Text
"456"
Default_Asset_Accounts_Receivable_Account_Id
No
Identifier
"789"
Must match an existing
GL Account
id in the system with type "accounts receivable"
Default_Asset_Accounts_Receivable_Account_Number
No
Lookup
"1-00-00-4165-127"
Must match an existing
GL Account
number in the system with type "accounts receivable"
Billing_Email
No
Text
"john.doe@example.com"
Billing_Address_Id
No
Identifier
"123"
Must match an existing address id in the system
Billing_Address_Line1
No
Text
"123 Main Street"
Billing_Address_Line2
No
Text
"Building 100"
Billing_Address_Line3
No
Text
"Suite 201"
Billing_Address_City
No
Text
"Springfield"
Billing_Address_State
No
Lookup
"IL"
Must match an existing state in the system
Billing_Address_Zip
No
Text
"62704"
Billing_Address_County
No
Text
"Sangamon"
Billing_Address_Country
No
Lookup
"USA"
Must match an existing country in the system
See also
Importing New Records
GL Account
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
Please Enter a Maximum of 100 Characters.
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
Please Enter a Maximum of 30 Characters.
*
Your First Name
Please Enter a Maximum of 20 Characters.
*
Your Email
Invalid Email
Please Enter a Maximum of 100 Characters.
*
Your Phone #
Please Enter a Maximum of 20 Characters.
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.