Skip to main content

Instructions

Retrieving the Import Template

Download the JEMS import template, which was developed for importing transactions into JEMS. Browser-specific instructions:

  • Both Internet Explorer and Firefox will prompt you to either save or open the file when you click on the link above. If you choose "Open," you can save the file once it has opened in Microsoft Excel. Choose to save the file if you want to save it first, and then open the file later.
  • If you are using Netscape, clicking on the file link should automatically prompt you to select a location to save the file. Make special note of where you are saving the file, so you will be able to find it for use after it has been downloaded.

Note: JEMS currently only supports tab-delimited text files.  When saving the file in Excel, you must save it as type "Text (Tab-Delimited)" so that it can be imported into JEMS. For more information, see below.

Saving to a Text File within Excel

  • Create a new workbook, or open a previously saved workbook.
  • Click "Save" (File menu) for a new workbook, or "Save as" (File menu) for a previously saved workbook.
  • In the File name box, type the file name for the workbook.
  • Under "Save as" type, select "Text" (tab delimited).
  • Click "Save."
  • If you have created a new workbook with multiple sheets, click "OK" in the first dialog box that asks you to verify that you want to save only the active sheet in text (tab delimited) format. Click "Yes" in the next dialog box that asks you if you want to keep your file in this format.
  • If you have opened a previously saved workbook or created a new workbook containing only one worksheet, click "Yes" in the dialog box that asks you if you want to keep your file in this format.

Note: The Excel template is marked as "read-only," so when you attempt to save any changes you have made to this file, you will need to save it to a different file name.

Support Policy for JEMS Running on Windows 95

The JEMS support staff has recently received many support requests from across the university, some of which are from units on campus using the Windows 95 operating system (OS), which is no longer supported by Microsoft Corp. While all of the support calls are important to us, because it is no longer supported, the Division of Financial Affairs has discontinued support for JEMS on the Windows 95 OS. Below is a summary of some of the factors taken into account when making this decision.

  • The Windows 95 OS has not been supported by Microsoft Corp since Nov 30, 2001.
  • Windows 98/98 SE and NT 4.x have been in an "Extended Phase" of support since June 30, 2002. Microsoft will no longer support these OSs after June 30, 2003. (Microsoft Web site referenced no longer available)
  • CIT's minimum systems requirements no longer list Windows 95 as an acceptable OS. Also note the minimum requirements of 64MB of RAM for Windows 98 and 128MB for all other OSs. These minimum RAM requirements are worthwhile to note, as JEMS requires at least 15 to 25 MB to run.
  • CIT no longer supports Windows 95.
  • CIT offers services to help units upgrade to newer OS versions at greatly reduced rates. Contact CIT or go to CIT's Software Licensing page for more information.
  • Cornell's computing directors have defined a set of standards for computers used to carry out administrative functions at the university. These standards do not list Windows 95 as an acceptable operating system for use in units.