This is a continuation of Part 1, here.
So far we have:
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.
Should you have questions or need help with with a similar situation, leave comments, email me at jwickham@bramasol.com and/or follow me on twitter @JudsonOnDemand.
Have a great long weekend!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |