We are trying to create a search field using the LONG data type in PeopleSoft. Can someone tell us if this be done?

Hello All,

First time i am going to write Conversion Program using SQR to load data from .CSV to Peoplesoft Tables.

I have two question.

1- What is the best file format to load the data into Peoplesoft.

2- Can any body post SQR code for loading data from .csv or any format to load into Peoplesoft tables using SQR ,if anybody have written the code.

I would really appreciate for the help.

Thanks
Ananth

Hi,

I am trying to hide a cancel button in a DOMODEL page. Any one pls help me

Thanks,
Hari

HI

How to view the employees from particular country in peoplesoft?
The employess should be the hired in that particular country only. Please give me the query if anybody have idea on that.

Thanks in advance

Regards,
Tammy

Is there any way to disable the Advanced Search Link or the ability to Save Search Criteria for a component? If so can it be done for specific users? We have a specific userid that we don't want to be able to save search criteria and that option appears after you go to Advanced Search for the Component. I am currently on PeopleTools 8.49.

Hi All,
I have a requirement where in I need to list all files in a directory on Unix server to be displayed to the peoplesoft user online.The user select the Server(NT or UNIX) and directory name from where he wants to view the file .
I am using the EXEC function to list the files from the directory and then moving them to a file. I will read the file through a application engine process and then move the contents to a record which i will display to the user on the grid.

hi all,
Can any one please tell the steps to set up export process in payroll interface from people soft system to adp payroll.
where can we change the file format to xml for payroll interface.

Hi all -
I have the need to pass another SMTP Server value when running an Application Engine program. Since this value says "Dynamic change allowed", it seems like this might be possible? Has anyone done this??

; Dynamic change allowed for SMTPServer
SMTPServer=mail.server.com

Thanks in advance!!
Emily

Hi

we have customized one PI interface Page and ,there are three grids on the page.
Column labels in Two grids are showing Hyperlinks when i open in PIA
But on One grid the Column Labels are not showing up with underline
how to get the Grid Column labes with Underline
Is there any property is there ,where i need to change this on grid

Please help me on this

Thanks,
radha

Hello,

Would you like to help me in this regard?

There is an issue with Date format in filelayouts using App Engine program.

Here are the Details:
1)When we are using the the date format as DD/MM/YYYY the App engine (through CI) is running to success and data is loading into the Database.

Sample csv with valid date format : 011060K|03|ITA|S|N||RONAL|LEE|||||||||||||Y|||N|24/05/1985|||