You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
Turn off Animations
Turn on Animations
SharePoint
Sign In
Use SHIFT+ENTER to open the menu (new window).
To navigate through the Ribbon, use standard browser navigation keys. To skip between groups, use Ctrl+LEFT or Ctrl+RIGHT. To jump to the first Ribbon tab use Ctrl+[. To jump to the last selected command use Ctrl+]. To activate a command, use Enter.
Browse
Tab 1 of 2.
Page
Tab 2 of 2.
Follow
Bluespring Online
Bluespring ProcessView
Bluespring LeanView
BPM5 Documentation
Currently selected
Writing Multiple Records to a Database Table
It looks like your browser does not have JavaScript enabled. Please turn on JavaScript and try again.
Updated Pages
Update Specific Group LDAP Entries
Home
Write Values to a Password-protected Workbook and Worksheet
Write Data Item Values to a Delimited Text File
Update Specific User LDAP Entries
Documents
Welcome & Introduction
Guides
Hardware & Software Requirements (PDF)
Install Guide (PDF)
Activity Reference Guide (PDF)
BPM Designer Topics
Workspace and Solution Topics
Solution Item Topics
Activity Topics
Common Expression Functions
BPM Admin Topics
Process and Activity Monitoring (with Filters)
Service Monitoring
View All Site Content
Recent
Images
Business View Topics
Feedback
Solution Items and Activities
Guides
Home
About
To write multiple records to a database table, complete the following steps:
Check out and open the process you want to edit.
In the
Toolbox
pane, click
Database
. A list of activities is displayed.
Double-click or drag the
Create Database Records
activity into the process.
Link the activity appropriately with other activities.
Right-click the
Create Database Records
activity. A shortcut menu is displayed.
Select
View Properties
. The
Create Database Records
window is displayed.
Click the
Database and Table
tab. The
Database and Table to Add New Records To
section is displayed.
In the
Database
field click the
System Resource
icon. A drop-down list of the ODBC System Resources is displayed.
Select the relevant ODBC System Resource. The selected resource name is displayed in the field.
In the
Table
field, select an editor and set the field to the name of the table in which you want to write a new record.
Note:
The default editor is the
Table Selector Editor
. This editor will display a list of tables available in the database.
Select the relevant database table. The selected table’s name is displayed in the field.
Click the
Data Mappings: Create Records
tab. The corresponding screen is displayed.
Select the
Select Collection Data Item for Mapping
check box.
Click the
Data Item editor
icon. A drop-down list is displayed.
Select the relevant collection data item. The selected collection data item is displayed in the field.
Note:
Data item calculations are read-only. You cannot edit these types of data items.
Select either the automatic or manual option for mapping values to table columns.
Click
OK
. You configured the activity to write multiple records to a database table.
Related Topics
Writing a New Record to a Database Table
Rolling Back and Removing New Records when an Error Occurs
Saving the Identity of a New Database Record to a Data Item
Automatically Determining which Columns to Populate with Data Item Values
Manually Detemining which Columns to Populate with Data Item Values, Expression Results, or Literal Values
Source
BPM Designer Topics
>
Overview of Activities and Activity Topics
>
Database Activities
>
Create Database Records
Last modified at 7/31/2020 12:11 PM
