Wavetronix Command Translator (CMD-DT) - User Guide Manual de usuario Pagina 146
- Pagina / 156
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
In the appendix
Appendix A – Guide to Common Tasks
Appendix B – Writing SQL Queries
12
Appendix A – Guide to Common Tasks
is section has step-by-step instructions on how to create common tasks within TaskBuilder.
One Database Table to One Database Table
e steps below describe how to copy all or part of one table in a database into a table in
another database:
1 Create a new task.
2 Drag two DB components to the task window and connect them with an action (see
Figure A.1).
Figure A.1 – One Database Table to One Database Table
3 Fill in the appropriate properties for each DB component, including Database Type
(SQL Server, Sybase, etc.), Host Name or IP Address, User Name and Password.
4 Select the action; the Database Mapping property will appear in the properties area
Appendix
- 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.012 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales