April 17 th Student October

1. April 17thStudent October • Purpose • Goal – Show some common login errors and FAQ items for Student October. Support at: datapipeline.support@cde.state.co.us 1

2. Webinar Etiquette • Mute Your Phone (*# Mutes and Unmutes Individual Phones) • Enter your Name and your District when logging into the webinar (no password will be needed) • If you have a question or comment either: • Type it in the Chat Box for a response OR • Raise Your Hand: • A presenter will call your name • After your name is called, unmute your phone and speak your question/comment • Please be respectful of others time; we may need to have a separate conversation later to best help you 2

3. Login issues You are not authorized to use this application! Contact administrator and provide message: <ERROR CODE> • This error indicates problem with identity management. • Please email to screen shot to • datapipeline.support@cde.state.co.us 3

4. File loading order • Files need to be loaded in order • Student Demographics • Student School Association • Advanced Course Completion • Link to access system: • https://cdx-test.cde.state.co.us/pipeline/login.action 4

5. Changes in file values • Free and reduced lunch values are now • 00 – Not eligible • 01 – Free • 02 – Reduced • No longer a valid code • 03 – No longer valid (used to be not eligible) 5

6. Changes in file values • All race/ethnicity field values • 0 – False for this race/ethnicity • 1 – True for this race/ethnicity 6

7. Changes in file values • Primary school flag needs to be set • 0 – False this is not student’s primary school • 1 – True this is the student’s primary school 7

8. Common File loading issues • Open spreadsheet and error on the file upload. - (Fix close spreadsheet before loading) • Blank rows in spreadsheet – (Convert to CSV and use note pad) • Extension Important – text file must end in .txt, comma separated - .csv 8

9. Common issues • Unable to find a record with error in edit screen – Use the go to standard view button or reports. • Make sure to set the primary school flag 9

10. Rules not working correctly • Problem with rule sp373 and the primary school flag. • Student may only contain one primary school in a district. • Changed to a warning 10

11. Rules not working correctly • Rule OC14 is firing and shouldn’t be – Changed this to a warning. • At least one school within your district has been approved to provide online education services as a single district online program, but none of the students in your district have been reported funding code 91 (Full Time On-line - Single District On-line Program) or 94 (Part Time On-line - Single District On-line Program). 11

12. Rules not working correctly • Rule OC68 - If language proficiency is 4 or 5, then prior's year language background needs to be eng. Or be the same as this years language background 12

13. Issues identified • Language background “ach” is missing from language table. • The table needs to be updated with the valid language codes. • Error message incorrect – rule SP66 (text needs updated) 13

14. Common issues • Historical data is not loaded. • We are working on loading prior year data. This has not been done for all districts. 14

15. District Feedback • Edit screen is not user friendly on large data sets. • Cognos emailing of reports is not working. – Please send issue to me. If seeing this. 15

16. District Feedback • Cognosreport and export to excel does not work. Just spins. • This is more than likely a browser configuration issue. Please email datapipeline.suport@cde.state.co.us and we will email configuration for broswer 16

17. District Feedback • PL/SQL error taking snapshot. • Title I does not appear correct – need to research. 17

18. How long will pilot run? • Until September. • We will not have daily webinars, but I will support districts who would like to pilot. Support at: datapipeline.support@cde.state.co.us 18

19. Page Not Found – Need IP address • This error indicates a problem with IP address • Go to www.whatismyip.org and email to • datapipeline.support@cde.state.co.us 19

20. Good news • Multiple districts loaded data • Respondents are able to login • Districts are creating snapshots • Seeing good performance on loads • Districts are using Cognos reports 20

21. Questions??? Thank you Town Hall tomorrow Next Webinar: Friday, April 19th9:00 – 10:00 21

22. Demo of loading files • Review file upload • Creating snapshot • Review reports • Link to access system: • https://cdx-test.cde.state.co.us/pipeline/login.action 22

23. Questions??? Thank you Next Webinar: Tuesday, April 16th 9:00 – 10:00 23

24. Information slides Slides after this are for examples and problems which existed prior to the pilot 24

25. Login error OIDSY0001 You are not authorized to use this application! Contact administrator and provide message: OIDSY0001 • This error indicates the groups have not been assigned to your • account • Please work with your local access manager in your district to • assign the following roles to your account. • <district name> PIPELINE-xxxx-STD~LEAUSER Submit & Modify role • <district name> Pipeline-xxxx-OCT~LEAAPPROVER Approver role 25

26. Login error OIDAR005R You are not authorized to use this application! Contact administrator and provide message: OIDAR005R • This error indicates an invalid group is assigned to your account • Please work with your local access manager to remove the • pipeline groups associated with CBD or EOY 26

27. Login error OIDAR003O You are not authorized to use this application! Contact administrator and provide message: OIDAR003O • This error indicates a problem with the group configuration • Please email this datapipeline.support@cde.state.co.us 27

28. Introductions • Kevin Smith Support at: datapipeline.support@cde.state.co.us 28

29. Page Not Found – Need IP address • This error indicates a problem with IP address • Go to www.whatismyip.org and email to • datapipeline.support@cde.state.co.us 29