Download Users Manual
Transcript
Data 89 5. In Step 1 you w ill identify how the import data is formatted and define w here the data values start and stop. 6. If you have already saved an Import Specification for this type of file and w ant to use it, click the Load button. Click to select the appropriate specification and click Open. This w ill load the parameters (including the mapping decisions) that have been saved for that specification. Continue to press Next to preview and move through each subsequent import step. Otherw ise, 7. Click the Fixed W idth radio button. Set the appropriate Date Format, T ime Delimiter, Date Delimiter and the Dec imal Symbol formats. 8. Use the scroll arrow s to set the First T itle Row and Number of T itle Rows. w ill appear next to the first and last Title Row lines in the data panel (if there is no Title Row , leave the Title Row at "0"). 9. Scroll dow n the data panel and identify w here the data starts. Position the cursor on the appropriate line number in the data panel and left-click. This w ill set the position of the First Data Row and w ill appear next to that line in the data panel. Any values above this row (apart from any set Title row s) w ill be ignored in the Import process. Continue to scroll dow n the data panel and identify w here the data stops. Right click on the appropriate line number in the data panel to set the position of the Last Data Row and w ill appear next to that line in the data panel. Any values below this line w ill be ignored in the Import process. 10. Click the Next button, The Import W izard Step 2 Dialogue box appears. 11. The Step 2 Dialogue box is divided into upper and low er panels. In the upper panel you can view and filter your existing data fields. In the low er panel you map those input fields to your DataSight database fields. This combination of filtering and mapping functionality means that you can accurately define and import all (or a DataSight Users Manual Version 2.9.4 © 2013 Seveno Pty Ltd