« OFAX Process | Main | Form upgrade »
February 15, 2008
Hobson notes
I need to move data from banner into this Hobson software and also the other way around. Getting data from banner to Hobson is the easy part. I created SZRHOBS to pull recruit info based on term code , a from date, and a to date. The resulting file is a flat comma delimited flat file. Currently negotiating the exact format of the data with Hobson.
The other direction will be a lot trickier to deal with. I've set up an account to ftp output from Hobson over to wou_sis$disk:[wouprd.ftp.hobson] on spruce. I'll have to set up a temp table to sqlload the data into and then deal with creating new people in Banner without a unique id. Thinking of searching for matches with last name, first name initial, and birthdate. The only other stuff we have generating new ids now is the credit card stuff.
Posted by wendlerb at February 15, 2008 10:11 AM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)