If the Edval app is not yet created and configured in your Org, follow the steps below.
Go to Setup -> App Manager.
In the Lightning Experience App Manager, click the New Connected App button.
Input the following values:
Connected App Name = Edval
API Name = Edval (auto-populated)
Contact Email = product email/company email
Enable OAuth Settings = Checked
Callback URL = (URL is login if production, test if sandbox)
Selected OAuth Scopes = Full access (full)
Go back to the App Manager and click Manage beside the LISS/Edval app.
Click Edit Policies and update the IP Relaxation to Relax IP restrictions and save.
Go to Setup > OAuth and OpenID Connect Settings > enable Allow OAuth Username-Password Flows
Sharing Settings
OBJECT | READ | CREATE | EDIT | Default Internal Access | Default External Access |
Account | Private | Private | |||
Asset | Private | Private | |||
Bell Time | Controlled by Parent | Controlled by Parent | |||
Cohort | Private | Private | |||
Cohort Member | Controlled by Parent | Controlled by Parent | |||
Cohort Schedule | Controlled by Parent | Controlled by Parent | |||
Cohort Schedule Connection | Controlled by Parent | Controlled by Parent | |||
Cohort Session | Controlled by Parent | Controlled by Parent | |||
Employee Role | Controlled by Parent | Controlled by Parent | |||
Calendar | Show Details and Add Events | Show Details and Add Events | |||
PosiEd Log | Private | Private | |||
PosiEd Settings (custom) | -- | -- | |||
PosiEd Value Mapping (custom) | -- | -- | |||
Session | Private | Private | |||
Student Record | Controlled by Parent | Controlled by Parent | |||
Subject | Private | Private | |||
Subject Offering | Private | Private | |||
Timetable Structure | Controlled by Parent | Controlled by Parent | |||
User | Public Read Only | Public Read Only |
User Setup for Integration
Create a user with the following details:
Note: When trying to log in with the user above, you will see the message below.
Create the Permission Set first.
Label: Edval
API Name: (auto-populated)
Description: Permission set for objects and fields used for Edval processes
License: Salesforce API Integration
Give access to the following objects and fields
OBJECT | READ | CREATE | EDIT | VIEW ALL | MODIFY ALL |
Account | |||||
Asset | |||||
Bell Time | |||||
Cohort | |||||
Cohort Member | |||||
Cohort Schedule | |||||
Cohort Schedule Connection | |||||
Cohort Session | |||||
Employee Role | |||||
Event | |||||
PosiEd Log | |||||
Session | |||||
Student Record | |||||
Subject | |||||
Subject Offering | |||||
Timetable Structure |
Go to the user record and assign the EDVAL permission set. The EDVAL permission set provides access to the objects and fields needed for the sync process.
Update the Posimente sync config in Edval using the new Salesforce user's username and password. Save and click Test connection.
If the test is successful, you can proceed with the publish methods.
Edval Daily Synching Process
After creating the Edval app, connect your Org and the Edval file.
Open this link in a New tab
Webcode: <Enter your Webcode>
School Code: <Enter your Account’s School zcode> (Put the School Code value from your School Account record)
Once opened, click the Daily dropdown and choose Synchronise
Click Add sync system > and populate the fields with their corresponding values:
System= Posimente
Serever Address = https:// + {instance URL, from Setup -> My Domain -> Current My Domain URL+
/services/apexrest/PosiEd/liss
In the URL, if the connection is not working, try to:
exclude the Posi_Ed
or do not include the _ between Posi and Ed
Username = Salesforce org username
Password = Salesforce org password
Client Id = previous Connected App’s Consumer Key
Client Secret = previous Connected App’s Consumer Secret
App Manager > Edval > View > Manage Consumer Details
Click Test connection to confirm and click Save.
You can now start the Publish process.
Tick the Org you just configured > click the Advanced Sync button
Publish the records in this order.
From Edval Daily:
Publish Bell times/Time Block
Before doing the Publish Bell Time, we need to add the complete Period values.
Make sure TTStructure records are set correctly. (Check how many TTStructure is linked to the School account).
If the TTStructure is not set up correctly, the PPublish Bell time will be affected. There will be missing bell time records after synching.
Publish Rooms/Assets
Publish Student
Before doing the Publish Student synching, make sure to set up the PosiEd Value Mapping (custom settings) for the LISS Grade Level values and Gender field automation. See the file below for your reference.
Make sure the Student Records’ Start Date and End Date fields are populated.
Make sure that the Student Record and the Contact objects have the same Current Grade Level values.
Publish Teachers
Before doing the Publish Teacher, make sure the etz file for Teachers from Edval has the Email and Staff IDs field populated. These two should be unique. These are the criteria for the creation and the linking of the Users to the Employee Role records.
Workaround: If the Teacher records don’t have email and usernames, you can turn off the Employee Role triggered flow before publishing, and then turn it On again after publishing.
You also need to have the Users created (if not yet existing) before doing the Publish Teacher
Turn On the Employee Role Triggerd Flow and then manually link the Users to the Employee Role records (If the trigger is turned on, this will automatically create the Person Account for the Employee Role)
Employee Role triggered flow includes the creation of the Users and will automatically link to the Employee Role records. The User will have a Profile of Chatter Free
Note: The Staff users should have a correct profile license for the Calendar access. The Chatter Free license is a non-calendar license.
Publish Classes (Cohort)
Import the PosiEd Value Mapping for the Primary Grade Level population before doing the Publish Classes
Publish Class lists/Cohort Member
Start Date and End Date in the Student Records should be set up properly before publishing the class list
Publish Cyclical Timetable/Cohort Schedule
Issues workaround (Edval sample file only)
Before Publishing the Cyclical Timetable (CS) for the first time, make sure to update the Staff ID of Janice Young to YOUJSYS.
If you will republish the Publish Teacher, make sure you update the Staff ID of Janice Young to 34567.
Publish Daily Timetable (Session)
Before publishing, ensure the following values for the Session records are in your Salesforce Org. If the records are not yet there, republish the following.
Bell Time
Primary Staff Member
Primary Location
Make sure to set the From and To fields correctly. Set it based on your preferred dates for the Session creation.
You may encounter this system validation error if you generate records with a 2-month range.
This is because Salesforce only allows a size of 6MB or approximately 6000000 bytes of characters. If ever you encounter this issue, lessen the date range for lesser results so you won’t hit the limit. You may try to generate records with a 2-3-week range of data to sync.
Publish Daily changes (Delta)
This will update the changes you made in the Daily Timetable (Session details).