As long as you can talk to the data I wrote an odbc export tool you could use.
Curtis McKay Sent from my phone On Sep 25, 2010, at 9:44 AM, "Russ Gowin" <rgo...@dwschools.org<mailto:rgo...@dwschools.org>> wrote: I’m doing the same in SchoolMaster. I’m sure Skyward has to have a way to do a custom data export. Russ Gowin System Administrator Technology Specialist DeLand-Weldon CUSD #57 304 E. Illinois Route 10 DeLand, IL 61839 217-736-2311 From: tech-geeks-boun...@tech-geeks.org<mailto:tech-geeks-boun...@tech-geeks.org> [mailto:tech-geeks-boun...@tech-geeks.org] On Behalf Of Michael T. Bendorf Sent: Wednesday, September 22, 2010 12:09 PM To: Tech-Geeks Mailing List Subject: Re: [tech-geeks] Staff Phone List I tried it that way for some time too. What I am doing now is a custom data export - not a canned "report". I cannot tell you where in Skyward to go to do it - but it is under Utilies -> Import/Export -> Custom Data Export in SchoolMaster. I wasted too much time trying to doctor reports before I set up the data export - spits out a nice tidy *.csv for me. --Michael T. Bendorf-- Technology Administrator A-C Central C.U.S.D. #262 217.476.3312 ext. 2019 DID #: 217.476.6019 Cellular: 217.306.6824 "I'm trying to teach myself to ask the same questions that you do during your lectures so that I do not need you any more." A good teacher is like a candle - it consumes itself to light the way for others. "The computer revolution hasn't started yet. Don't be misled by the enormous flow of money into bad defacto standards for unsophisticated buyers using poor adaptations of incomplete ideas." - Alan Kay On Wed, Sep 22, 2010 at 12:00 PM, Daniel Zobel <<mailto:zob...@husd4.k12.il.us>zob...@husd4.k12.il.us<mailto:zob...@husd4.k12.il.us>> wrote: That is why I figure I am doing something wrong. :) I would think I should be able to pull out the info from Skyward the same as the student side, but so far I can only pull a report out and then export to excel which is too many extra steps for an auto system. I do the same thing here. I export the csv and then the phone system picks up the list and has it ready to go. Daniel Zobel Director of Technology Heyworth CUSD#4 309-473-2250 - Direct # 309-473-2822 - Grade School >>> "Michael T. Bendorf" >>> <<mailto:bendo...@a-ccentral.us>bendo...@a-ccentral.us<mailto:bendo...@a-ccentral.us>> >>> 9/22/2010 11:43 AM >>> I'd be surprised if you cannot pull staff numbers out of skyward - we use schoolmaster and i was able to put together a simple custom data export that runs nightly which pulls staff numbers. It is then automatically uploaded to our voice broadcasting system...I suppose if I needed to look something up I could go to either the student management system or the broadcast system's list. I hope I understand your question - on the flip side, I keep a google doc spreadsheet with staff directory info, including DIDs and extensions...but I do not believe you are asking about that. For the above to work I have three things dancing together: A windows scheduled task that runs the custom data export - a feature/function of schoolmaster. A scheduled task that runs a WinSCP command to upload the exported *.csv files, and a setup with the voice broadcasting company that slurps the uploads into our school interface. Are you looking for a good way to get staff phone numbers out of Skyward an into a document that can be distributed? on paper? --Michael T. Bendorf-- Technology Administrator A-C Central C.U.S.D. #262 217.476.3312 ext. 2019 DID #: 217.476.6019 Cellular: 217.306.6824 "I'm trying to teach myself to ask the same questions that you do during your lectures so that I do not need you any more." A good teacher is like a candle - it consumes itself to light the way for others. "The computer revolution hasn't started yet. Don't be misled by the enormous flow of money into bad defacto standards for unsophisticated buyers using poor adaptations of incomplete ideas." - Alan Kay On Wed, Sep 22, 2010 at 11:34 AM, Daniel Zobel <<mailto:zob...@husd4.k12.il.us>zob...@husd4.k12.il.us<mailto:zob...@husd4.k12.il.us>> wrote: How does everyone deal with their staff phone list for calling out? For students it is easy as there is the student management system that can handle it. But right now for staff we have the paper copy that is added to in the offices, but not always put in an electronic format or in a central location. I really want to build a list for me to put in the phone system. We use Skyward for the Student side of things, I can't pull staff info out of the system, or at least not phone numbers, unless I am missing things. I really hate finding that the system was used and we didn't have staff phone numbers listed. Thanks, Dan Daniel Zobel Director of Technology Heyworth CUSD#4 309-473-2250 - Direct # 309-473-2822 - Grade School | Subscription info at <http://www.tech-geeks.org> http://www.tech-geeks.org | | Subscription info at <http://www.tech-geeks.org> http://www.tech-geeks.org | | Subscription info at http://www.tech-geeks.org |
| Subscription info at http://www.tech-geeks.org |
