Information to Run Your Program
June 2013
Say Hi to Emily!
ACEware would like to welcome Emily Taylor to our staff. Emily is the new Jeanie who just retired and will be running the office, managing account billings and answering the phone when you call the office.

When you get a chance, say hi to Emily.  Her email is
Working On A New Tool
Many of you have already talked with Chris Harvey and done customer feedback sessions with him.  Here at the cabin, we are busy taking your feedback and putting it into action.

One of the first projects underway is a new visual guide to reports.  People are having a difficult time finding the correct report too use and locating it among the dozens of reports available.  This new tool will list reports and explain what they do.

Along with the explanations will be a list of the 25 reports that you should know about and be using.  A video and webinar about organizing reports is also being developed.

Watch your newsletter for more information as these tools are completed and released.
Matthew's Corner: Name Import Wizard

The idea behind this feature was to have an easy way to import an Excel file of names into Student Manager. 


Unfortunately, prior to this, the easiest way to import was to convert the spreadsheet before doing convertw or quickie. Even then, it was hard to format things.


Let me explain.


With Office 2007, Excel took out the ability to save your spreadsheet as a .dbf (DataBase File format). They also introduced the .xlsx format for Excel spreadsheets as the new way forward. Visual FoxPro and, by extension, Student Manager had no way to read .xlsx format. Before that even, it was hard for Student Manager to read .xls format (vrunfox could do it if you knew the proper commands).


Now, we did have workarounds by utilizing OpenOffice to help with data conversions (using convertw with .dbf formats). Unfortunately, most customers were not allowed to get open source software installed on their computers.


Doing some research one day, I came upon a blog written by Jun Tangunan who I met at a Visual FoxPro conference. In the blog, he showed a very simple way to open an Excel spreadsheet in .xlsx format and read from it. He hinted that it could be extended to import data. Also, if the Excel spreadsheet had multiple workbooks, you can pick which workbook you wanted to work with.


So, I took the simple approach he took and complicated the heck out of it. A week later I was able to read in a .xlsx or .xls format, allow the user to specify what Student Manager fields to put the Excel columns in (see image), do some complicated formatting checks (zip code is a character, not a number!), and write the data into the names table. I then spent another couple of days cleaning up (added source code and interest code) and putting in additional checking. I also added in the name UDFs to be selected as well.


This can be accessed if you go to Tools -> Import/Export -> Name Import Wizard in Student Manager 7.2.A.014 or later. You can also go from the Speed Registration Entry (under Module -> Registrations) and click on the Import Wizard button from there to not only import the names but also register them all in a single class (you can then use Mass Register on the Course screen if you need to add them to other courses).


The downside is that there is no duplicate checking done with this unless the Student Manager ID is also imported in with the spreadsheet. In this case, if the ID is already in the system, it will not be added to the names table, but will still register the person if you are doing the Speed Registration Entry. 


If you do not include the ID field or have some that are blank, Student Manager will generate an ID for you just like when you add any other name.


In my opinion, all of this adds up to being the awesomest (ED Note: This is a technical term :) ) thing I have ever programmed. I hope you find it useful for your situation.

Until next time...


Editor's Note:  We are working on a video to show how this feature works.



New Videos
A couple new videos to enjoy!

Trimming Contacts from LinkedIn
Trimming Contacts from LinkedIn
Updating Zipcodes in Student Manager
Updating Zipcodes in Student Manager

June Newsletter Quiz!
First things first...Congrats to Donna Ruskin on winning last months quiz!  The answer was 7.2a!  Donna is with the International Center of Photography.

Here is this month's question:

Which shortcut key brings up a list of ALL shortcut keys?

If you think you know the answer submit it at:

The quiz will be open to the end of June and a winner will be picked from the winning entries.

This month's winner gets there choice of a $10 Amazon or Starbucks gift certificate.
Did You Know?

Forums!  It's all about forums!  Keep up to date on the latest Student Manager changes, get answer to your questions, communicate with other Student Manager users...its all available in the forums.

Not using forums?

Ask your tech how to get registered.
About Aceware
Aceware provides easy to use registration software designed for non-credit programs.  

Our goal is to provide you with the tools you need to run your program.

Quick Links

Webinar Archive
Catch up on the ones you missed 

YouTube Channel
New help videos for Student Manager 

Facebook Page - Something New to Like!

Contact Us

Voice: 800.925.2493
Fax: 785.537.6811


Tech Support:


ACEware Systems, Inc.
7480 Dyer Road
Manhattan, KS 66502


Questions about this newsletter? Please contact 

Join Our Mailing List!