SQR exports incomplete information from PeopleSoft

Asked By LeilaReyes 0 points N/A Posted on - 10/02/2011

On a monthly basis, a SQR runs and captures all information entered in peoplesoft and exports them into a .DAT file. This file is sent to our vendors and they use it to copy all the employee information captured from our PeopleSoft Database. I have manually entered 50 new employees in PeopleSoft recently. I have entered their last, first and middle names however, in the file exported by the SQR the last names of the employee are not there. What could be the problem?

• Status: Open
• Question Views: 774
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Development Software

Answered By Michelle Bang 55 points N/A #84986

SQR exports incomplete information from PeopleSoft

First see in which type of format the data is being used in the .Dat format.

1. Is it a comma separated values?
2. Is it space separated values?
3. Is it a CGS?

In first case you have to define that it is a CSV when you are trying to import it in the SQR because sometimes the software indicates it as an anonymous column values and don't bother to add it in your database. Also check any kind of relationships if it exists.

If it is space separated, then first make it the CSV format and then perform the same steps as above.

If it is a CGS then simply open it in notepad. See if you can differentiate those 50 names that you entered and put commas manually. Now import it in SQR and you won’t have any problem.

About Michelle Bang

Questions
2

Answers
515

Best Answers
73

• Vote Up 0 Vote Down

• Posted on - 02/12/2012
• Question Category: Development Software