Introduction
Hey everyone! We recently figured out how to import lots of Work Orders into Remedy 8.1 using a CSV file and BMC's Data Import Tool. This document aims to show you a quick method that requires some light customization of new objects (no modification of OOTB objects). Also, this doc is a lighter version of what I actually built in our Remedy environment, so please provide feedback if you get stuck, so I or the Community can help. I've seen some articles on Communities asking to do this, so I hope this Document (at the very least) serves to point folks in the right direction.
As always, test this in dev/test environment first
Special thanks to Jason Miller for encouraging me to create this doc.
Step 1. Re-create the WOI:WorkOrderInterface_Create OOTB filters
Re-create the following 27 filters with a Merge execution, instead of Submit. I try not to modify OOTB filters where possible, so I chose to create new ones.
WOI:WIC:CreateWorkOrder_040_SetReqByPersonId_WhenNull
WOI:WIC:CreateWorkOrder_043_SetReqForPersonId_WhenNull
WOI:WIC:CreateWorkOrder_045_SetRequestedForIfMissing
WOI:WIC:CreateWorkOrder_090_SetWOINumber`!
WOI:WIC:CreateWorkOrder_095_AssocCIGetProdDatasetId
WOI:WIC:CreateWorkOrder_091_CheckRequestedFor
WOI:WIC:CreateWorkOrder_091_CheckRequestedBy
WOI:WIC:CreateWorkOrder_092_SetRequestedForWhenNull
WOI:WIC:CreateWorkOrder_092_CheckForTemplate01
WOI:WIC:CreateWorkOrder_092_SetRequestedForEmail
WOI:WIC:CreateWorkOrder_092_SetRequestedForPhone
WOI:WIC:CreateWorkOrder_093_CheckForTemplate02_CallSetFieldsGuide
WOI:WIC:CreateWorkOrder_093_CheckLocationInformation_Company
WOI:WIC:CreateWorkOrder_094_CheckLocationInformation_Region
WOI:WIC:CreateWorkOrder_095_CheckLocationInformation_SiteGroup
WOI:WIC:CreateWorkOrder_98_AssocServiceCI_SetInfo
WOI:WIC:CreateWorkOrder_096_CheckLocationInformation_Site
WOI:WIC:CreateWorkOrder_097_CheckLocationInformation_NotFound_SetFromReqFor
WOI:WIC:CreateWorkOrder_SetPriority
WOI:WIC:CreateWorkOrder_SetWorkOrderType
WOI:WIC:CreateWorkOrder_100`!
WOI:WIC:PermissionGroups_SetID
WOI:WIC:CreateWorkOrder_105_UpdateRequest
WOI:WIC:CreateWO_125_WorklogSetID
WOI:WIC:CreateWO_126_WorklogSetAccessFlag
WOI:WIC:CreateWO_127_WorklogSecureFlag
WOI:WIC:CreateWO_130_CreateWorklogCG
Step 2. Modify the new WOI:WIC:CreateWorkOrder_090_SetWOINumber`! filter you created
Remove the Set Field action that sets WorkOrder_ID = $LASTID$. Leave the Push Action alone.
Step 3. Modify the new WOI:WIC:CreateWorkOrder_100`! filter you created
- Uncheck "Matching Ids" checkbox in the Push Action
- Select "Auto Map..." button in the Push Action
- Select "Match Ids" radio button. Select OK
- Add the following field and value row to the Push Action: Work Order ID = $LASTID$
Now, you're probably wondering why we're bothering with adding Work Order ID = $LASTID$ instead of allowing the WOI:WIC:CreateWorkOrder_090_SetWOINumber`! filter take care of the number generation. I ran into complications of workflow when the Work Order ID was set to the WOI:WorkOrderInterface_CREATE form...so I decided to simply not include it in the initial Set Fields. Instead, the workflow still requests for a new Work Order ID to be created in the WOI:WIC:CreateWorkOrder_090_SetWOINumber`! filter, but we just push the new Work Order ID using the $LASTID$ keyword in the Push Action of the WOI:WIC:CreateWorkOrder_100`! filter.
Step 4. Prepare your .CSV file
Prepare your .CSV file by adding the columns you want to import into the WOI:WorkOrderInterface_Create form, and ultimately push to WOI:WorkOrder to create a Work Order. The two sections below are the bare minimum I could identify that you need to add to your spreadsheet without causing errors or processing issues. You can certainly add more stuff as you wish, but just be aware that some fields may have workflow behind them as they hit the Create form.
Each column of your CSV is a field and must be the exact field name that's contained on the WOI:WorkOrderInterface_Create form. Each row is a single Work Order that will be created. You must contain data in each cell. BMC's Import Tool doesn't like Null values.
You will need the following columns if you want to create a simple Work Order without a worknote
Company
Location Company
Customer Company
Customer First Name
Customer Last Name
Detailed Description
Summary
Request Manager Company
Manager Support Organization
Manager Support Group Name
Request Manager
Support Company
Support Organization
Support Group Name
Request Assignee
Submitter
RequesterLoginID
Work Order Type
You will need the following columns if you want to create a simple Work Order with a single Work Details worknote
Company
Location Company
Customer Company
Customer First Name
Customer Last Name
Detailed Description
Summary
Request Manager Company
Manager Support Organization
Manager Support Group Name
Request Manager
Support Company
Support Organization
Support Group Name
Request Assignee
z1D_WorklogDetails
z1D_Details
z1D_Summary
Secure Work Log
z1D_ActivityDate_tab
Submitter
RequesterLoginID
Work Order Type
Step 5. Import your .CSV file using BMC's Data Import Tool
Note: I'm using BMC Remedy Data Import Version: 8.1.00. Also assumes you're using default settings.
- Select "Create a new mapping file"
- Select your Source Data File (which is your awesome new .CSV file filled with lots of nifty work orders waiting to be created)
- Select the "Contains Field Titles" checkbox
- Select your Target Server.
- Select the WOI:WorkOrderInterface_Create form in the "Target Form Name"
- Select "Auto Map" button
- Select "Start Importing Records from the Import File"
- Go verify your Work Orders were created once the job is done
Other Items of Note
For our system, it takes about 2 seconds to create each Work Order. That's quick!
Records on the WOI:WorkOrderInterface_Create form are deleted automatically from a combination of the following filters:
INT:FNDSRS:WOI:CLNDelWorkOrderInterface_725
WOI:WIC:DeleteInterfaceRecord_500
Be aware that you may receive a LOT of email notifications as you import. We opted to customize some of the notifications to fail with the Work Order import process, so our staff wouldn't get bombarded with emails. Keep it in mind.
Enjoy and good luck!
-Matt
Comments