[15:19:19 CDT(-0500)] <JasonElwood> Paul- is the masterChangeLog.xml ok for the data that you'll be inserting? I don't think it is dependent but want to make sure?
[16:04:47 CDT(-0500)] <pspaude> Sorry Jason, my tomcat log was hiding the chatroom. Yes its ok. No demo data is needed and it actually may conflict with the training data.
[16:30:09 CDT(-0500)] <pspaude> Jason good to go on the training data import?
[16:30:36 CDT(-0500)] <JasonElwood> Just writing you an email. the build just completed. it's a fressh install of rel-2-0-patches
[16:31:59 CDT(-0500)] <pspaude> Cool sounds great.
[16:41:44 CDT(-0500)] <pspaude> Away we go!
[16:44:18 CDT(-0500)] <pspaude> Done. Logged in Jason it appears good, but I'll let you be the judge!
[16:46:04 CDT(-0500)] <JasonElwood> I see a lot of data
[16:54:33 CDT(-0500)] <pspaude> It's SSP there is no such thing as too much data or too many api calls!
[17:01:02 CDT(-0500)] <JasonElwood> Paul- did you load the photo images into the Test Drive repo?
[17:02:54 CDT(-0500)] <pspaude> Ah, I forgot about the photos.
[17:03:00 CDT(-0500)] <pspaude> Did you want photos or the defautl?
[17:03:29 CDT(-0500)] <pspaude> *default no picture icon
[17:03:35 CDT(-0500)] <JasonElwood> default is going to be easiest
[17:03:49 CDT(-0500)] <JasonElwood> since the image files are not in the release
[17:03:58 CDT(-0500)] <pspaude> Okay one sec.
[17:04:07 CDT(-0500)] <JasonElwood> I can update the table
[17:05:03 CDT(-0500)] <pspaude> Oh cool that is what I was going to do. I'll change my scripts and commit to omit the url for future usages.
[17:11:35 CDT(-0500)] <JasonElwood> so far it looks great. thanks
[17:13:34 CDT(-0500)] <pspaude> Awesome just pushed a commit so no photo urls. Your welcome, hopefully it cuts down on the work you have to do. Keep track of any data changes you need and I can update the scripts as well.
[17:14:00 CDT(-0500)] <JasonElwood> not seeing students in the faculty rosters so far
[17:15:34 CDT(-0500)] <pspaude> That is weird my local I can see them which was built off the same script. I know there can be section/code issues, but that was a version or two ago.
[17:15:44 CDT(-0500)] <JasonElwood> I see that each faculty member has two rosters, but the students are loading
[17:16:46 CDT(-0500)] <pspaude> Yep each faculty is supposed to have two rosters of 10 random (from the pool of students in there already).
[17:19:59 CDT(-0500)] <pspaude> I logged in and see the issue.
[17:30:50 CDT(-0500)] <pspaude> Okay, its a issue where postgres is ordering the table based on last insert and I forgot the last inserts were students not in ssp.
[17:31:05 CDT(-0500)] <pspaude> So all the students assigned are external_students
[17:32:47 CDT(-0500)] <pspaude> Basically order by random() didn't work nor is it the right thing to use when we have the external_sync stuff going on so... let me work something out.
[17:36:41 CDT(-0500)] <JasonElwood> ok
[17:37:27 CDT(-0500)] <pspaude> Got a fix, testing it now.
[17:49:50 CDT(-0500)] <pspaude> Jason, did you want me to dump my two good external tables and email them to you so you don't have to start over?
[17:50:03 CDT(-0500)] <pspaude> Should be just a psql -d ssp -U postgres -f /pathTo/file.sql then.
[17:50:15 CDT(-0500)] <pspaude> Don't know what your server does with scp.
[17:50:32 CDT(-0500)] <JasonElwood> either that or export as csv. pgadmin tool is decent
[17:51:04 CDT(-0500)] <pspaude> Okay cool.
[18:26:33 CDT(-0500)] <JasonElwood> Paul- ETA on the files?
[18:27:36 CDT(-0500)] <JasonElwood> planning to close 1810 do you want me to update the fix and label while I'm in it
[18:27:43 CDT(-0500)] <JasonElwood> assuming you cherry pick soon
[18:30:01 CDT(-0500)] <dmccallum54> JasonElwood that's for me?
[18:30:33 CDT(-0500)] <dmccallum54> i can go ahead and try to cherry-pick it after i finish with this WT primary key stuff
[18:30:37 CDT(-0500)] <JasonElwood> ah yes
[18:30:54 CDT(-0500)] <JasonElwood> I can leave it as your reminder
[18:32:04 CDT(-0500)] <pspaude> Sorry jason coming up, forgot to take a dump before I fixed the files, now I'm back and will be emailing you shortly.
[18:32:15 CDT(-0500)] <JasonElwood> cool
[18:41:22 CDT(-0500)] <pspaude> email sent.
[18:43:47 CDT(-0500)] <pspaude> Let me know if you need me to run it. But, should be straight forward. Sorry no .csv, getting hit from all fronts need to clone myself 
[18:44:06 CDT(-0500)] <JasonElwood> no worries. I'll upload and run it
[18:48:37 CDT(-0500)] <JasonElwood> need to double-check but no students in rosters
[18:48:45 CDT(-0500)] <JasonElwood> there is data in the tables
[18:50:50 CDT(-0500)] <pspaude> is that data instantaneous or is it cached?
[18:51:00 CDT(-0500)] <dmccallum54> cached. hah.
[18:51:33 CDT(-0500)] <dmccallum54> good question tho, actually. only thing that's cached in ssp is the course list
[18:52:12 CDT(-0500)] <pspaude> ok, cool. Well its not that.
[18:52:39 CDT(-0500)] <JasonElwood> so I see the records in both the tables. I can search for students in the roster table and they are active in SSP
[18:54:34 CDT(-0500)] <dmccallum54> i believe that's an AJAX call. can see if anything is coming back from the server… start narrowing it down to client vs server
[18:58:18 CDT(-0500)] <pspaude> Dan sorry in and out due to TestDrive, but the server is returning good data and active students.
[18:58:33 CDT(-0500)] <dmccallum54> what's the url pls
[18:58:42 CDT(-0500)] <JasonElwood> linux ci
[18:58:48 CDT(-0500)] <pspaude> sorry one sec closed the browser
[18:59:21 CDT(-0500)] <dmccallum54> what user should be seeing a roster but isnt?
[18:59:22 CDT(-0500)] <pspaude> http://ec2-54-234-229-153.compute-1.amazonaws.com/ssp-platform/
[18:59:30 CDT(-0500)] <pspaude> faculty1
[19:01:30 CDT(-0500)] <dmccallum54> yeah, server is returning results
[19:02:36 CDT(-0500)] <JasonElwood> no linux ci sorry.
[19:04:32 CDT(-0500)] <JasonElwood> Not sure Paul. the data looks like it's correct
[19:05:26 CDT(-0500)] <pspaude> I'm not sure if a Tomcat restart would fix this?
[19:07:03 CDT(-0500)] <JasonElwood> I could. did you restart after loading before?
[19:07:54 CDT(-0500)] <pspaude> That is a good question. I don't think so.
[19:08:05 CDT(-0500)] <pspaude> I have pg_dumps that I use to reset things.
[19:08:45 CDT(-0500)] <pspaude> In a sec I can finish up the script and commit.
[19:09:10 CDT(-0500)] <dmccallum54> looks like it's blowing up trying to map the status codes
[19:10:07 CDT(-0500)] <dmccallum54> yes
[19:10:14 CDT(-0500)] <dmccallum54> here's the JSON that's coming back. literally.
[19:10:15 CDT(-0500)] <dmccallum54> "{"E":"Enrolled","default": "Enrolled""
[19:10:36 CDT(-0500)] <dmccallum54> so missing a closing brace at a minimum
[19:11:25 CDT(-0500)] <JasonElwood> I added E earlier through the tool. looks like trailing brace was omitted
[19:11:34 CDT(-0500)] <JasonElwood> or the original data didn't have it. don't remember seeing it
[19:12:34 CDT(-0500)] <JasonElwood> fixed and fixed. thanks Dan and Paul
[19:13:17 CDT(-0500)] <pspaude> What is this trailing brace? My code just puts an E in. You guys and your fancy braces.
[19:13:53 CDT(-0500)] <pspaude> Awesome! Thanks Dan!!! and Jason for being patient.