Support Support HYPERPLANNING

  • Import the data from a spreadsheet

All of this data can be imported from Excel into HYPERPLANNING: work-study programs, porters, calendars, courses, curricula and modules, teachers' discharges, definition of the families, teachers, companies, students, training programs, links between groups/options, counselors, subjects, customized subjects, parents, progressions, classes, competence reference frames, groupings, rooms, internships, users, cities.

First step: preparing the spreadsheet for import

  1. By importing some data, you create other data if it does not already exist in the database - like subjects when importing curricula and modules.
  2. If the database already contains data, check the spelling of family names, designations, etc., so that HYPERPLANNING does not create duplicates.
  3. The spreadsheet must include one row per data item and one column per type of information (field). An example Excel file is provided with the application in C:\Program Files\Index Education\Hyperplanning 2023\Réseau\Client\Exemples\Fichiers Import\
  4. It is not necessary to have a line of labels, but it can facilitate the matching with the HYPERPLANNING fields during the import.
  5. HYPERPLANNING requires a minimum number of fields, to identify them, make a test import by following the second step described below and identify in the import window the necessary fields.
  6. If some data may be affected by homonyms, it is necessary to ensure the presence of a field allowing the distinction, the field Code will fulfill this function in most cases.
    1. To import a field not provided for in HYPERPLANNING, a column for this type of information must be provided in the spreadsheet and the syntax <Type of information>Information> must be complied with so that HYPERPLANNING transforms this column into a family during the import.

      Second step: Import the data in HYPERPLANNING

      1. In the spreadsheet file, select the data to be imported and press Ctrl + C to copy it.
      2. Go to any of the displays from the tab Schedules.
      3. Press Ctrl + V to paste the data: the import window opens.
      4. At the top, select the type of data to import:
      5. Indicate Tabulation as field separator.
      6. Match each column with a HYPERPLANNING field. To do this, click on the arrow next to the Ignored Field heading and select the field to which the column corresponds from the drop-down menu.
        • If a column should not be imported, leave Field ignored. As long as any required fields are missing, all data will be displayed in red. If some data remains in red at the end of the mapping, it is because it does not match the expected format: hover over it to see why. Most of the time, the data is still imported but modified to be compliant.
        • If you have copied the column headings, tick Do not import the [1] first lines.
        • If imported columns contain more than one piece of data (e.g., courses with more than one teacher, teachers with more than one subject, etc.), verify the sign that separates them in the field Multiple resource separator (by default, the comma).
        • If a column contains data not provided by HYPERPLANNING, choose Family that allows you to create the unplanned fields.
        • The lower right area of the import window displays import options specific to the selected data type.
      1. Click on Import: HYPERPLANNING proposes to switch to Exclusive usage mode (the other users are transferred to Consultation mode during the import and you can choose not to keep the imported data at the end of the process).
      1. HYPERPLANNING displays a report with the number of users imported, created or modified.
      2. Close the window.
      3. HYPERPLANNING proposes to save the import format, the matching of the fields with the columns will be kept for all future user imports.
      4. If you were in Exclusive usage mode, click on the button in the tool bar.
      5. In the pop-up window, choose by saving your modifications.
      Was this content useful to you?
      https://docs.index-education.com/docs_en/en-hyperplanning-support-page-732-2253-import-the-data-from-a-spreadsheet.php

      Can't find an answer to your question ?

      Contact our support

      INDEX ÉDUCATION | © 2024 - C