EPIC TUTORIAL (Part 2) – Mass load data to extension fields post-implementation
So far we have:
- Created a Global Solution in the FP3.5 Studio
- Enabled Key User
- Created an extension to the Customer BO and added some extension fields
- Created a new BO with Customer ID, and the extension fields to serve as a staging table
- Added an AfterModify script to the staging BO that will move the staged data to the Customer BO
- Created a XML File Upload Service Integration to load data to the staging BO, activated it, and downloaded the .xsd file that is generated upon activation
Let’s finish this thing up!
Open up Excel and in your Developer tab click Source and add that .xsd file.
Now that you have the XML structure in place, you must, and I mean MUST, do two things.
The first is to drag the CreationDateTime element to the top of the Excel file as you see below. I don’t know why, but you’ve got to populate the date to look like this: 2012-05-25T12:00:00.000Z. Weird!
The second thing you MUST do is drag the entire List of your BO’s elements into the Excel sheet. Don’t ask me why. JUST DO IT, OK?
Now you can delete the columns no one cares about. (BTW, the default value for actionCode is Save, so that’s why you don’t need it in this case)
Now populate your spreadsheet with the stuff you intended to migrate during your implementation, but sadly forgot to.
In the Developer tab, export the XML to somewhere.
Then go to Application and User Management, and choose the File Input view. Select Unprocessed Files in the OWL. Upload that XML document and specify the Service Interface we tossed together earlier.
Next, create a Run for this Service Interface in the Active Runs OWL. Save it. Activate it. Close it. Schedule it to run immediately. Monitor the process and notice that it has completed successfully. Love it when that happens.
After all that, you need to enhance the Customer screen to show your extension fields.
Choose the item checked below. It’s the standard ByD Account screen. Trust me on this one.
Select the Details pane, then add the extension fields!
Save and activate the UI. We’re almost done! After that, go into Account Management and select Edit > General for any of our staged customer.
WHOA! Look at the details pane! It’s got our fields, populated with the data we entered!
This is just one example of a post-implementation mass data load. There are possibilities for many more.
In order to see the results in reports, you would need to create a new Data Source on the Customer BO extension, then go into Business Analytics and join it to an Account Data Source. I may cover this in a follow-up post, but for now, rest assured your extension fields contain data.
Imagine creating extension fields as a Key User, then having to manually enter data into thousands of screens. I’m pretty sure the solution here is far superior.
Have a great long weekend!