Answers
Mar 17, 2008 - 10:07 AM
gopmon,
The short answer to your question is "yes". Bet you're glad to hear that!
The biggest problem you're going to have is writing the Business Logic around all of those 80 fields you'll need to insert, but it sounds like you already know what data needs to go where as illustrated by the date example you gave in your question.
If I were doing this task, I would write an aspx page that would read that Excel data as text, preferably CSV text. Reading the file a line at a time can be slow depending on how many records you're dealing with, but you also get the opportunity to act on each line individually which allows you to make sure that the data is exactly the way you want it prior to inserting into the database.
Since you can split the CSV into a string array, you can use pieces of the data more than once, or in a different order, etc, as long as you know the ordinal position of the data you desire.
After that, you can use the proper INSERT syntax into the PeopleSoft database and add any default or "custom" data you need at that point.
If there are specific questions, please let me know - as always, I'm available as a consultant if necessary.
Take care,
Ric Castagna
The short answer to your question is "yes". Bet you're glad to hear that!
The biggest problem you're going to have is writing the Business Logic around all of those 80 fields you'll need to insert, but it sounds like you already know what data needs to go where as illustrated by the date example you gave in your question.
If I were doing this task, I would write an aspx page that would read that Excel data as text, preferably CSV text. Reading the file a line at a time can be slow depending on how many records you're dealing with, but you also get the opportunity to act on each line individually which allows you to make sure that the data is exactly the way you want it prior to inserting into the database.
Since you can split the CSV into a string array, you can use pieces of the data more than once, or in a different order, etc, as long as you know the ordinal position of the data you desire.
After that, you can use the proper INSERT syntax into the PeopleSoft database and add any default or "custom" data you need at that point.
If there are specific questions, please let me know - as always, I'm available as a consultant if necessary.
Take care,
Ric Castagna
Mar 18, 2008 - 04:51 AM
Dear Ric,
Many thanks for the information.
Can you please inform me whether any software needs to be downloaded for proceeding this activity?
If possible, can you please explain me with an example, so that it would be very helpful for me to proceed further? Thanks a lot for your valuable time spending toward my question.
Regards,
K.Gopakumar.
Many thanks for the information.
Can you please inform me whether any software needs to be downloaded for proceeding this activity?
If possible, can you please explain me with an example, so that it would be very helpful for me to proceed further? Thanks a lot for your valuable time spending toward my question.
Regards,
K.Gopakumar.
Mar 04, 2009 - 06:06 AM
The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.
The Quomon Team
The Quomon Team
Add New Comment