Wavetronix Command Translator (CMD-DT) - User Guide Manual de usuario Pagina 124
- Pagina / 156
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
CHAPTER 11 TASKBUILDER SUB-WINDOWS 123
Database Conversion Sub-window Elements
Figure 11.1 shows the Database Conversion sub-window with the following component
elements:
Source/Destination Database – ese drop-down lists allow you to choose the indi-
vidual database located on the target server machine. Because of the connection lag, it
may take a few seconds for the sub-window to update. Some databases, such as Access
and Oracle, will display only one option.
Source/Destination Table – Aer choosing a database, these drop-down lists will be
lled with every table within the database; choose a source and destination table for the
mapping. Because of the connection lag, it may take a few seconds for the sub-window
to update.
Source/Destination Columns – Aer choosing a table, these list boxes will automati-
cally ll with all of the columns in the selected table. e icon on the le of the name
will mark the column as a primary key column or a normal data column; on the right
of the name is the column data type. e column data type is important for assess-
ing type compatibility from source to destination. e data type designations can be
toggled by the Show Data Types check box at the top of the sub-window.
Mapping Diagram – e mapping diagram area is located between the source and des-
tination column lists. e colored lines represent the connections between columns
and will be drawn automatically when mappings are created.
Mappings List – Once column-to-column mappings are made, you can select and de-
lete them from this list when desired. e colors of the mappings in the list correspond
to the color mapping lines on the mapping diagram.
Delete Button – e Delete button is used to delete a selected mapping from the map-
ping list.
Clear All Button – e Clear All button deletes all mappings from the mapping list.
Accept Button – e Accept button saves the current mappings and closes the sub-
window. If there are destination columns that do not currently have a mapping, the
Default Value sub-window (discussed later in this section) will open and allow you to
select default values for those columns.
Cancel Button – e Cancel button closes the sub-window without saving any changes
to the mappings.
Key/Auto Columns – e Key and Auto columns will be present only if the destination
database is a Sybase or Oracle database. It is necessary to mark primary key and auto-
increment columns.
Creating a Mapping
e following are the two methods for creating a mapping between a source and destination
column:
Select the desired column from both column lists and click the Add button.
OR
- Command Translator 1
- Contents 4
- Part II Taskbuilder 5
- Appendix 145 6
- Introduction 8
- Translator Web Interface 9
- Translator 12
- In this chapter 14
- Logging In 14
- Menu Bar 15
- Context-sensitive Help 15
- Logging Out 16
- Job List Page 2 18
- Job Status Summary 19
- Job List 19
- Adding and Configuring Jobs 20
- Information Bar 21
- Figure 2.6 – History Section 22
- Figure 2.7 – Tasks Section 24
- Figure 2.8 – Events Section 25
- Notifications 27
- Services 28
- Service List 29
- Add Service 30
- Service Information 30
- Properties 32
- Figure 2.20 – Notifications 33
- Users Page 3 34
- User List 35
- Edit User 35
- New User 36
- 36 CHAPTER 3 USERS PAGE 37
- Routes Page 4 38
- Routes Page 39
- Route Toolbar 40
- Deleting Routes 41
- Exporting Route Definitions 41
- Copying a Route 41
- Editing a Route 42
- Route Configuration 43
- Display Options 43
- Zoom Options 44
- 44 CHAPTER 4 ROUTES PAGE 45
- Figure 4.10 – Remove Segment 46
- Adding Assets to a Group 47
- Figure 4.14 – Add Asset 48
- 48 CHAPTER 4 ROUTES PAGE 49
- Figure 4.16 – Asset Tab 50
- Assigning Assets to Segments 51
- Travel Points 52
- Route Data and Overrides 53
- Figure 4.20 – Override Tab 54
- Figure 4.21 – Task Pattern 54
- Setting Up Route Database 55
- System Page 5 58
- Status Tab 59
- Information 61
- Mail Settings 61
- Job Settings 61
- Reclaim Memory Interval 61
- Support Tab 62
- Notifications Tab 63
- Collectors Tab 64
- Journal Tab 65
- Tasks Tab 65
- Import Tasks 66
- Export Tasks 66
- TaskBuilder Tab 67
- Help Page 6 68
- User Guide Tab 69
- License Agreement Tab 69
- CHAPTER 6 HELP PAGE 69 70
- TaskBuilder 72
- TaskBuilder User Interface 7 74
- TaskBuilder User Interface 75
- Menu and Toolbar Buttons 76
- Options Menu 77
- Help Menu 77
- Debug Menu 77
- Component List 78
- Main Task Window 79
- Properties Area 80
- Creating a New Task 82
- Opening an Existing Task 83
- Figure 8.2 – Task Manager 84
- Exporting a Task 85
- Importing a Task 86
- Working with Multiple Tasks 87
- Adding Components to a Task 87
- Adding Actions to a Task 87
- Moving Components or Actions 89
- Copying Components or Actions 91
- Cutting Components or Actions 91
- Copying an Entire Task 92
- Executing a Task 92
- Debugging a Task 94
- Using Third-Party Editors 95
- Changing Task Execution 95
- Depth-first Execution 96
- Breadth-first Execution 96
- TaskBuilder Components 9 98
- Database (DB) 99
- Figure 9.2 – Data Component 100
- Figure 9.3 – XML Component 100
- Figure 9.4 – Email Component 101
- Figure 9.5 – HTML Component 102
- Figure 9.6 – PDF Component 103
- Figure 9.7 – Text Component 103
- File Name Placeholders 104
- Trip Time 105
- Advanced Trip Time 106
- Figure 9.13 – Route Component 107
- TaskBuilder Actions 10 108
- Database-to-Database Action 109
- Database-to-Data Action 109
- Data-to-Database Action 110
- $column3 111
- Data-to-XML Action 112
- Data-to-Text Action 112
- Data-to-3 Card Action 113
- XML-to-Data Action 114
- XML-to-XML Action 115
- XML-to-Text Action 115
- XML-to-HTML Action 116
- XML-to-PDF Action 116
- [File]-to-Email Action 117
- Text-to-Data Action 117
- Text-to-XML Action 118
- FTP-to-[File] Action 119
- [File]-to-FTP 119
- Data-to-Trip-Time Action 120
- Trip-Time-to-XML Action 120
- TaskBuilder Sub-windows 11 122
- Figure 11.1 – DB Conversion 123
- Creating a Mapping 124
- Default Values 125
- Sybase and Oracle Databases 126
- Mapping Sub-window 127
- Mapping Sub-window Elements 128
- Trip Time Mapping Sub-window 129
- Trip Time Template Sub-window 131
- Trip Time Sub-window 133
- SmartSensor Trip Times 135
- Add Component Sub-window 136
- Creating Properties 137
- Add Action Sub-window 138
- Settings Tab 140
- Components Tab 142
- Editors Tab 143
- Databases Tab 144
- Translator Hosts Tab 144
- Appendix 146
- 146 APPENDIX 147
- APPENDIX 147 148
- Database Table to XML File 149
- APPENDIX 149 150
- Figure A.6 – Database-to-XML 150
- Figure A.7 – File to Email 150
- Basic SELECT Query 151
- APPENDIX 151 152
- Renaming Columns 153
- APPENDIX 153 154
© 2020, manymanuals.es. Todos los derechos reservados | 0.016 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales