Inserting XMLP File Definitions into Projects March 12, 2008Posted by Tipster in PeopleTools.
There have been a couple of occasions where the file definition (the template file behind the XMLP Report Definition) has become out of sync with what is in the project.
This may be because the file was inserted into the Project, and then a subsequent change made to the template and uploaded into PeopleSoft. In this case, the updated Report Definition and Template Definition would be migrated, but the new file wouldn’t be in the project so it wouldn’t be taken across. Unfortunately this leads to a really rather nasty message in the PIA.
The solution is clearly to re-add the File Definition in to he project, but it’s not always straightforward. You can select it as a related definition when you insert the template, but sometimes this inserts the old (overwritten file). To be sure you have the file inserted, you have to add it manually. The only issue is the insert file definition dialogue box is not helpful.
The search field only allows you to search on the long alphanumeric string, not the actual filename so you end up scrolling through the full list attempting to spot the file you’re after. As more reports get developed, the list will get longer.
The alternative is to use some SQL:
WHERE USERFILENAME = '<filename>'
This gives you the File ID, which is what the dialogue box searches on, enabling you to find your template file a lot quicker.