Difference between revisions of "Getting started - Data Import"
From Catalyst
m (New page: {{Stub}}) |
|||
| Line 1: | Line 1: | ||
| − | {{ | + | {{Incomplete}} |
| + | == Summary == | ||
| + | reword> This article will describe the processes to create a data import template so that you are able to import specific data into the system. </reword> | ||
| + | |||
| + | == What is a Template? == | ||
| + | |||
| + | A template tells Platinum: | ||
| + | |||
| + | *What information you want to import. | ||
| + | *Which part of the system you want to import data into e.g. the Stock File, the Vehicle Stock File, the Accounts Transaction File etc. | ||
| + | *Where the file is that holds the data you are importing. | ||
| + | *Which fields within the chosen system you are importing data into e.g. Stock Code field, Stock Description field, Account Name etc. | ||
| + | |||
| + | |||
| + | == Process == | ||
| + | To create a data import template select the "Data Import" option from the main menu. | ||
| + | This will take you to a screen where you can search for existing Data Import templates or create a new one. | ||
| + | === Template Code === | ||
| + | {{Note|text=Each template should have a unique code e.g. {{DataValue|001}} or {{DataValue|STO}} (max. 3 character).}} | ||
| + | *Enter a code for the template and tap {{KeyPress|Enter}} | ||
| + | *Enter a description for the template e.g. {{DataValue|Stock File Import}} | ||
| + | |||
| + | === Destination === | ||
| + | {{Note|text=The Destination is the file you want to import data into. [[Destination Files|Click here]] to view a list of possible destinations.}} | ||
| + | *Tap {{KeyPress|Shift-F2}} to view a list of destinations then tap the {{KeyPress|Arrow-UP/Arrow-Down}} key to scroll through the list and tap {{KeyPress|F2}} to select the desired one. | ||
| + | *Alternatively type in the destination file code. | ||
| + | |||
| + | === Source File === | ||
| + | {{Note|text=The Source File is the file containing the data you wish to import. Your Source file will usually contain a series of records. A record is each line or lines of information relating to the same Stock Code, Vehicle, Account etc. The Data Import program can read most Plain Text files e.g. {{FileExt|CSV}} (Comma Separated Variable) files and {{FileExt|TXT}} (Text) files. }} | ||
| + | *Enter the name of, and if necessary the Path to, the file which holds the data to be imported e.g. {{FilePath|C:\STOCKFILE.CSV}}. | ||
| + | *If you need to find a file tap {{KeyPress|C-F1}} and search for the file using the explorer window. | ||
| + | |||
| + | Tap {{KeyPress|Enter}} to move to the template import configuration. | ||
| + | |||
| + | {{KB_Tags|Data, Import, Create, Creating}}{{KB_IM}} | ||
| + | {{ZN_Admin}} | ||
Revision as of 11:00, 7 October 2008
 |
This article or section is under development. Be aware: Content will change as the document progresses. |
Contents
Summary
reword> This article will describe the processes to create a data import template so that you are able to import specific data into the system. </reword>
What is a Template?
A template tells Platinum:
- What information you want to import.
- Which part of the system you want to import data into e.g. the Stock File, the Vehicle Stock File, the Accounts Transaction File etc.
- Where the file is that holds the data you are importing.
- Which fields within the chosen system you are importing data into e.g. Stock Code field, Stock Description field, Account Name etc.
Process
To create a data import template select the "Data Import" option from the main menu. This will take you to a screen where you can search for existing Data Import templates or create a new one.
Template Code
 | Each template should have a unique code e.g. '001' or 'STO' (max. 3 character). |
- Enter a code for the template and tap <Enter>
- Enter a description for the template e.g. 'Stock File Import'
Destination
| The Destination is the file you want to import data into. Click here to view a list of possible destinations. |
- Tap <Shift-F2> to view a list of destinations then tap the <Arrow-UP/Arrow-Down> key to scroll through the list and tap <F2> to select the desired one.
- Alternatively type in the destination file code.
Source File
| The Source File is the file containing the data you wish to import. Your Source file will usually contain a series of records. A record is each line or lines of information relating to the same Stock Code, Vehicle, Account etc. The Data Import program can read most Plain Text files e.g. '.CSV' (Comma Separated Variable) files and '.TXT' (Text) files. |
- Enter the name of, and if necessary the Path to, the file which holds the data to be imported e.g. 'C:\STOCKFILE.CSV'.
- If you need to find a file tap <Ctrl+F1> and search for the file using the explorer window.
Tap <Enter> to move to the template import configuration.
