A Social Network for PeopleSoft Professionals

Uploading and Reading Excel File

I would like to allow a user to upload a pre-formatted Excel file with data they have entered. This data should then be read, line by line and processed accordingly. For each row processed, I would like to kick off an Oracle stored procedure and place the results in a grid and allow the user to export the results back to Excel. What is the best option available in Peoplesoft?

Tags: excel, import

0 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Stephen Nelson on January 29, 2009 at 8:02pm

Have you considered loading the data using the ExcelToCI Utility that is included as part of the PeopleTools distribution?
It can be found in the Excel folder in the PeopleSoft Home directory.

▶ Reply

Permalink Reply by Carol on February 2, 2009 at 2:14pm

That is the easiest way, plus it will still work after an upgrade!

▶ Reply

Permalink Reply by Carol on February 2, 2009 at 2:16pm

The ExcelToCI Utility easiest way, plus it will still work after an upgrade!

▶ Reply

Permalink Reply by Deb on June 11, 2009 at 9:48am

I'm trying to use the ExcelToCI Utility with Excel 2007. I can fill in the information on the Connect Infromation tab, but the Template tab comes up blanks. The analyst demonstrated these tabs on his computer using Excel 2003 and I saw all kinds of colums appear on the Template tab. He even watched me use ExcelToCI on my computer which runs Excel 2007 and didn't think I had made any mistakes. We are guessing that there must be some changes to the underlying code for this to work using Excel 2007. Does anyone know where I can get a new version?

▶ Reply

Permalink Reply by Susan on February 5, 2009 at 12:31pm

Just FYI...The Excel to CI tool does not work in Tools releases prior to 8.43....and yes, sadly some companies still use that version!

▶ Reply

Permalink Reply by Stephen Nelson on February 5, 2009 at 2:01pm

Can you provide more information in regard to why you believe "The Excel to CI tool does not work in Tools releases prior to 8.43"?

▶ Reply

Permalink Reply by Susan on February 5, 2009 at 2:15pm

There are many things that do not work in Tools 8.42.12 (which came as the baseline for HCM 8.8) because of documented Tools bugs. The company that I support now has never upgraded or patched Tools since they went to 8.8, and learned a couple of years ago that this is one of the bugs. Another one is the failure of the Job Notification feature in Process Scheduler.

Lesson learned - keep your patches up to date!! 8.42x hasn't been supported for a few years now, and that's definitely a risk we have to be aware of until the next upgrade.

hope that helps...

▶ Reply

Permalink Reply by Larry on February 8, 2009 at 11:06pm

You can use Java object as well to do file processing. I saw good tips at www.itwisesolutions.com/PsftTips.html website. Here is the snippet, how we can use Java

Local JavaObject &javaFile;&javaFile = CreateJavaObject("java.io.File", "c:\temp\mytextfile.txt");
&javaFile.delete();

-larry