13 Importing and Exporting Data

The Simphony Data Import/Export web application is a user interface (UI) that helps you to create and submit data import and export job requests. Exporting menu items from one system and importing them to another saves time for the administrator or manager. This process allows the menu items to be functional and saleable on the new system’s POS client workstations. The web application allows you to:
  • Import and export data manually

  • Export data automatically using the scheduler

  • Review the status of completed import and export jobs

  • Access a Help page that provides additional database and application program interface (API) details

Import/Export Prerequisites

  • You can export and import menu items with Simphony version 2.8 and later.

  • Use a spreadsheet application (for example, Microsoft Excel) that can receive database export and import requests. Data export requests are usually set to output to files that are formatted with comma-separated values (CSV).

  • Obtain Simphony EMC logon credentials to access the web application.

  • You must have the privilege to access the database and run the Simphony Import/Export Service.

  • Install a Secured Sockets Layer (SSL) certificate to establish a secure connection. See How to trust the IIS Express Self-Signed Certificate for information about installing SSL or digital certificates.