Connecting to Edval Daily - PosiEd K-12
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
Note: If this has already been configured in the Org during the Edval Daily setup, there's no need to repeat it.
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
Note: If this has already been configured in the Org during the Edval Daily setup, there's no need to repeat it.
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.
Edval Daily Syncing 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
Server 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
These records must be imported into the Org before the Publish process. Please refer to the instructions in the link below.
After importing the necessary records into the Org, you can begin the publishing process.
Publish the data sets in the order shown below. Publish each item separately and allow a few minutes before publishing the next item. This is to ensure that the processing of the data that was transferred is complete before the next set of data is sent.
Note: Before publishing, ensure the School’s PosiEd State is set to Subscriber.
From Edval Daily:
Publish Bell times
Before publishing the 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 Triggered 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)
Note that the 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 entered and specified in the Default Profile ID field of the custom settings.
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 Janice Young's Staff ID for YOUJSYS.
If you will republish the Publish Teacher or the Publish Daily Timetable, make sure you update the Staff ID of Janice Young to 34567.
Publish Daily Timetable/Daily Data (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 sync a 2-3-week range of data.
Publish Daily changes (Delta)
This will update your changes in the Daily Timetable (Session details).
User Password Expiry
You need to check the expiry of your password, follow these steps to check
Go to Profiles > Minimum Access API Integrations > Password Policies
If the User password expiry is limited, change it to Never expires and save.
If the password has expired already then reset the password.
Go to Set up > Users > Click the User name that has the Minimum Access API Only Integrations profile > Click Reset Password
The user receives an email that contains a link and instructions to reset the password.
Follow the instructions that were sent through the email to successfully reset the password. If you have set the user password expiry to "Never expire," your password will not expire, and you will not be required to change it.