Jobs and Subjobs are imported using the following templates:

1. EralisJob_ImportTemplates_Jobs.xls
2. EralisJob_ImportTemplates_Subjobs.xls
3. EralisJob_ImportTemplates_Contracts.xls

Complete the templates ensuring that each row’s mandatory fields are completed with relevant data. Refer to the import template worksheets for instructions on what data types can be inserted on each column.

Note: Where GL account codes are required and a segmented GL is in use, the system code must be used (e.g _SYS00000000032).

To import the templates, use Microsoft DTS packages.

Import Process (Microsoft DTS)

The import process for a SQL database is completed using Microsoft Data Transformation Services. For SAP HANA database, refer to the import process section below.

The following tables can be imported to using this process:

• ENPRISE_JOBCOST_JOB
• ENPRISE_JOBCOST_NEWPROJECTS
• ENPRISE_JOBCOST_JOBDEFINTIIONS
• ENPRISE_JOBCOST_SUBJOB
• ENPRISE_JOBCOST_SUBJOBDEFINITIONS
• ENPRISE_JOBCOST_CONTRACT
• ENPRISE_JOBCOST_CONTRACTLINES

1. Ensure the import template is closed prior to beginning the import.
2. Select Import Data from the All Tasks menu by right-clicking on the database you wish to import to.
   
   
   
3. The DTS Wizard will load and guide you through the import procedure.
   
4. Select Microsoft Excel as the Data Source, then select the import file from its saved location and Excel version. Tick the First row has column names box.
   
5. Select the Destination as either SQL Native Client or Microsoft OLE DB Provider for SQL Server. Specify the server connection details and database for import.
   
   
   
6. Select Copy data from one or more tables or views to specify that you wish to copy the data from the source spreadsheet.
   
   
   
7. Tick the Source column checkbox for each worksheet(s) you intend to import and select the Eralis Job table with the same name from the drop-down selection in the Destination column.
   
   
   
8. Select each row / table that you are importing and click the Edit Mappings button in the footer of the window to map fields from the spreadsheet to fields in the Eralis Job tables.
9. Select the Append rows to destination table radio button in the header of the Mapping screen.
10. In the Mappings grid, Microsoft DTS will attempt to map the spreadsheet (Source) to the Eralis Job table (Destination) automatically based on column names.
    
    If changes to the suggested mappings are required, select the correct column or change the destination to <ignore> from the drop-down list to change the source or not import any data.
    
    
    
11. Repeat this process for each of the tables that you are importing to.
12. Specify whether you wish to run the DTS package immediately or save it and execute later.
    
    
    
13. Microsoft DTS will give a status report once the DTS package has been run. Where errors occur, you can drill down on the rows for a detailed message on the issue. Update the import template or DTS package and re-run the import.
    

Hints

• If several instances of the same worksheet show as source options during the import, select the worksheet which ends in $.
• Imports sometimes fail because of blank rows at the end of an excel worksheet. To eliminate blank rows, highlight only the rows and columns with data for import and copy and paste these to a new worksheet, save it and then import the new worksheet.

Import Process (SAP HANA Studio)

The import process for a HANA database is completed using the HANA Content Import Wizard. 

 The following tables can be imported to using this process:

• ENPRISE_JOBCOST_JOB
• ENPRISE_JOBCOST_NEWPROJECTS
• ENPRISE_JOBCOST_JOBDEFINITIONS
• ENPRISE_JOBCOST_SUBJOB
• ENPRISE_JOBCOST_SUBJOBDEFINITIONS
• ENPRISE_JOBCOST_CONTRACT
• ENPRISE_JOBCOST_CONTRACTLINES

1. Ensure the import template is closed prior to beginning the import.
2. Use the File menu option at the top. Select File then Import.

3. Import options will be displayed in the pop-up screen. Under SAP HANA Content, select Data from Local File.  The import wizard will load and guide you through the import procedure.

4. Select the target database.

5. Provide the Source File by using the Browse button to select the import file from its saved location. In the File Details, select the worksheet you intend to import and tick the Header row exists.  Choose Existing target table and use the Select table button to select the Eralis Job table.

6. In the Source File grid, click on the Mapping Menu icon and select Map by Name. This will attempt to map the spreadsheet (Source) to the Eralis Job table (Target).  You can see the preview at the bottom.

7. Review the Summary screen to confirm the Source and Target information. Click Finish to start the import.

8. Once the import has started, you will be able to see the job progress and the status from the bottom of HANA studio.

9. Repeat this process for each of the tables that you are importing to.