PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Collapse]Settings
    [Expand]Subjects
    [Collapse]Items
      Environmental Duties
      SLOPAK Packaging Classification
     [Collapse]Items
       POS nastavitve
      [Collapse]Toolbar
       [Expand]Wizards
       [Expand]Report
       [Collapse]Import/Export Data
         Import Wizard
       Header
      [Expand]General
      [Expand]Costing/Pricing
       Description
       Withdrawal period
       Technological Description
      [Expand]Images
       Contract Prices
      [Expand]Stock
      [Expand]Serial Numbers
      [Expand]Specification
       Packaging/Environmental Duty
       Custom Fields
       External IDs
       Documents
       Documentation
       Attributes
       Note
      [Expand]Authorizations for Items Register
      [Expand]Assigning Identifiers
     [Expand]Item Types
     [Expand]Item Categories
     [Expand]Units of Measurement
     [Expand]Pricing Formulas
      Import Price List
     [Expand]Serial Number Templates
      Quick Pricing
     [Expand]Fixed Prices
      Find Item
     [Expand]TouchScreen Profiles
      Packaging and Packaging Waste
      Waste Materials
      Šifrant vrst odpadnega materiala
      Šifranti okoljskih dajatev
    [Expand]POS
    [Expand]Manufacturing
    [Expand]Personnel
     Calendar
    [Expand]Financials
    [Expand]Customs
    [Expand]Program
    [Expand]Documentation
    [Expand]Change User
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Expand]Financials
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 421.8824 ms
"
   1001202 | 208093 | 343109 | Updated
Label

Čarovnik za uvoz podatkov

Import Wizard

 

With the Data Import Wizard, advanced users can import records into Pantheon from an Excel file.

This instruction is made on the case of importing Items (although the window can be opened from different Pantheon forms).

 

In the next window, we define the excel file by clicking on three dots in the "Import File" field.

 

In Import Settings window set your SQL select statement based on your Excel file in correct column order.

 

In the "Field Transformation" window, we connect columns in Excel = External source and Pantheon fields. Enter External Source manually as there are Columns in Excel import file.

 

In the next window we get a preview of the data that will be imported:

 

In the next window we get a confirmation of imported data:

 

 

 

 


 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!