1 / 9

Exporting Data to Excel

Exporting Data to Excel. David Huckleberry 2014 Harmony Users Conference French Lick. Are you a miner?. Knowledge is power Data is Gold! Become a Gold Miner and get rich….. ….ok, maybe not, but you can be valuable!!. Why is this important?. “I need a class list”

willa
Download Presentation

Exporting Data to Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Exporting Data to Excel David Huckleberry 2014 Harmony Users ConferenceFrench Lick

  2. Are you a miner? Knowledge is power Data is Gold! Become a Gold Miner and get rich….. ….ok, maybe not, but you can be valuable!!

  3. Why is this important? • “I need a class list” • “I need to make a mail merge with student data” • “I WISH I COULD…..” • Be thinking what you need out of Harmony and we will discuss that in the 2nd half today.

  4. Direct from a Harmony View I can SEE what I need, how do I export it? Two possibilities: FILE…EXPORT method COPY SELECTED AS TABLE method Example: DISCIPLINE SUSPENSIONS SELECT ALL

  5. Exporting from Utilities Do you speak Harmony???? “Ok class, give me the definition of the fields <A_9>, <P_1> & <P_9>?”

  6. Exporting from Utilities Data Dictionary Located in the Support Portal

  7. Exporting from Utilities • Know what database to start in • Select the documents you want • CREATE, UTILITIES, EXPORT DATA • Know where you save it • Know what forms to load • If unsure, try it…see what it gives you.

  8. Your Turn – Q & A on Exporting What data do you need that you know is in Harmony, but you’d like to extract?

  9. The End Have a great day at the conference!!

More Related