Answer Question
Is this possible to upload 80 different fields in web from a excel containing only minimum fields?
We are using a people soft database for storing customers information. We will have a spreadsheet containing the information of a customer where we need to upload the same in our database. The current process is that, we will enter manually all the details in people.
What i want is that, we shall create a specific spreadsheet where it will have all the customer information in a specific format. One field in that sheet needs to be updated in various text fields in people soft customer database.
Once the customer information has been updated in that spreadsheet and by clicking of a button will all the fields mentioned in that spreadsheet will get uploaded in the peoplesoft database in there respective fields?
For eg, date on which the customer is getting added into our database will get updated in their customer info screen as well as credit profile screen, But the spreadsheet will have only one field namded Date added. By clicking of a button the date added field in spreadsheet will get uploaded in both customer info screen and credit profile screen automatically. Likewise, we have around 80 fields to be updated.
TEXT
Uploading file and scanning for virus...
Please Wait