| Gilles [MSFT] 2005-12-22, 5:55 pm |
| Hello,
>Is there a way to display a date in the BAM Excel spreadsheet? I want to
>show a service date that is in the message.
Add a new DateTime" field to your BAM Activity. Create a BAM view (or use an existing view) and make sure you put the datetime you cerated before.
Now, use the Tracking Profile Editor (TPE) to map the datetime in the activity to the field from your message.
Deploy the BAM infrastructure (the excel spreadsheet), deploy the tracking profile and run some messages through the system.
Now, you can just have excel connect to the primary import database and display rows from the view named "bam_viewname_activityname"
where "view name" is the name of the view and "activity name" is the name of the activity. Your data time will be in there.
Thanks,
-Gilles.
|