Wavetronix Command Translator (CMD-DT) - User Guide Manual de usuario Pagina 109
- Pagina / 156
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
108 CHAPTER 10 TASKBUILDER ACTIONS
tor as well as their corresponding properties.
Database-to-Database Action
e Database-to-Database (DB-to-DB) action (see Figure 10.1) performs a data copy op-
eration from a table in the source database to a table in the destination database. By default,
this action copies all available data in the source table and adds it to the destination table. If
any data in the source dataset has the same primary key as existing data in the destination
table, the system will overwrite the existing data with the new data.
Figure 10.1 – Database-to-Database Action
Note
The DB-to-DB action only supports single, table-to-table conversions. For multiple
table copies, create multiple actions from the start and end Database components.
e DB-to-DB action has the following property:
Database Mapping (Value—DBMap) – e Database Mapping property contains all
necessary information to transfer data from one table to another. is includes which
column maps to which destination column, and any default values to insert into the
table.
e Database Mapping property cannot be edited directly from the main TaskBuilder
screen. To create and edit the mapping information, click the Edit button in the prop-
erty box to open the DB Conversion sub-window. Details of the Database Conversion
sub-window will be discussed in Chapter 11.
Database-to-Data Action
e Database-to-Data action (see Figure 10.2) copies the contents of a table in the source
database into memory. By default, this will keep the source schema and all data from the
original table. Using a SQL Query le, you have the capability to make changes to the data
copied into memory, which includes selecting a subset of data columns, making column
name changes, or returning only data rows that meet certain qualications.
- 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.122 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales