Skip to Content
Former Member
Nov 25, 2011 at 05:38 AM

Validating Master Data from upload File


Hi Experts,

We have a business process, where the user will be given a template to upload the Budget data.

In the template the user enters the description of the members instead of Dimension memebr ID's. For Ex. The Dimension member ID for Salary Account "100000", and the description is "Salary", the user enters "Salary" in the P_Acct Column which we will converted during the upload through a conversion file.

Once the data is entered, he will have to upload the file(using data upload option), Execute the transformation file to validate the data, and upload the file using the Data Manager.

We just want to know whether we can validate the file even before the File is uploaded to the server. As this will help the user to upload the file once for all. Otherwise, he may have to upload it multiple times, if any records were rejected during the validation step(As he has to make suitable changes to the file and upload it again).

We would be gald to know if there is some way to validate the file before(before the first step). Please let me know if any further information is required on this.