Re: Conversion from legacy system

[Chris Bennett <chris@SYMBIOINC.COM>]

SQR is indeed what most people use for this purpose.  As someone else
suggested, reading through the supplied PeopleSoft SQRs is a good way to
get ideas on how to do what you want.  The biggest problem with loading
data from SQRs is that you need to do a lot of analysis to make sure you
are inserting the proper values in each field, but this approach does give
you the most flexibility.

As far your question about other tools that could be used instead of SQR,
I would suggest looking at the delivered Import Manager is you are using
7.x.  The nice thing about Import Manager is that it performs much of the
data validation for you.  As far as I can tell, it has disappeared into
8.x though.

What PeopleSoft would prefer you do at this point is write an App Engine
that uses PeopleCode's new ability to read files, and then you could store
the data using the new component interfaces.  This would be really great
in that it would completely take care of data validation for you, but it
is not the easiest thing in the world to do.  I have yet to see anyone
actually use this approach for importing data from a legacy system,
though.  But you could be the first :)  There is PeopleSoft mailing list
you can ask for help on if you decide to investigate this.

Overall I'd suggest SQR for most cases.  Its quick and easy.  Unless
you're loading data into one of the really complicated data structures in
PeopleSoft-- then I'd investigate the App Engine/Component Interface
route.

Chris

P.S. Don't worry about what Allen said... while there were recently a few
rather strange posts that were a bit over the top, some people apparently
just have trouble dealing with constructive criticism and their injuries
are largely imagined.


On Wed, 2 Oct 2002, kadevari madhukethan wrote:

> Hello SQR Gurus,
>
> I am working on conversion of data from legacy system
> into peoplesoft
> systems and what i thought of using SQR for conversion
> or Interface
> for exracting data from legacy system.Now my question
> is can any of
> the gurus share there idea as how to begin writing SQR
> Conversion
> program or any sample conversion program is greatly
> appreciated to my
> email OR is there any other tool used in conversion or
> interface
> instead of SQR to make my job easy.please help me
> ASAP.
>
> THANKS IN ADVANCE
>
> Madhu
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
>