| Using Dataload to upload data into Oracle Applications [message #193041] |
Thu, 14 September 2006 11:38  |
Debanjan_chat
Messages: 16
Registered: August 2006
|
Junior Member |
|
|
Hi,
Can someone please let me know the steps which I need to do in order to upload data from excel into Oracle Applications using DataLoad?
I have some HR data and some Projects data. I have installed the DataLoad on my desktop, but not sure how to go ahead using it. I guess I need to create some dld files which are individual form specific and then load the data into it.
But how do I create such dld files? Also can I upload data without opening up the Application, ie by providing database connect string, etc.?
Regards.
|
|
|
|
| Re: Using Dataload to upload data into Oracle Applications [message #193160 is a reply to message #193041] |
Fri, 15 September 2006 02:01  |
vin_odks
Messages: 153
Registered: July 2006
Location: -
|
Senior Member |
|
|
Hi,
DATALOADER is a tool used to upload data though the front -end.
Basically it is like using a macro.
Basic steps
1) Navigate to the Application screen and rehearse the Key strokes and Data entry.
2) Create a similar Key strokes commands in the data loader file.
3) There two kinds of columns in Data loader - Data columns and Key definition (Key Strokes) columns.
4) Once the definition is made, Copy the data from Excel and paste it into the relevant data columns of the Dataloader.
5) Open the application screen. Select the Name of the screen in the data loader Source field and then start the upload.
For more info on key strokes, go to the help menu of the data loader.
Regards
Vinod
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Using Dataload to upload data into Oracle Applications [message #193318 is a reply to message #193208] |
Fri, 15 September 2006 12:17 |
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
|
Senior Member |
|
|
| Debanjan_chat wrote on Fri, 15 September 2006 11:17 |
Can I upload data into Oracle Applications through DataLoad, without opening up the Applicatios, ie maybe be providing the connect string, etc.?
|
I am not quite sure why you are asking this question. Is it because when you use DataLoad Classic to do an upload, you cannot use the PC to do anything else at the same time, and sometimes it can take a long time?
If that is the case, you might want to take a look at DataLoad Professional. First, you use DataLoad Professional to make Oracle Forms create a "record" file of two or three example records, which allows DataLoad Professional to work out what you are doing. You then open the "record" file using DataLoad Professional and it creates a much simpler spreadsheet than DataLoad Classic. You then add as many new records as you like  to the spreadsheet and save the result as a "playback" file. You then tell DataLoad Professional to play back, which makes Oracle Forms read the "playback" file (on the server) and process it (on the server). Because the real work is being done on the server, all the PC is doing is providing the display, not processing the data. This means that DataLoad Professional processes data at about 20 times the speed of DataLoad Classic and does not tie up your PC while it does so. I have used DataLoad Professional to load Cross-segment Validation Rules Elements at a rate of over 1700 per hour, or over 2 per second, while I have been reading email, posting answers on this forum and even doing updates in the Oracle Applications on the same PC.
Earlier on, I said that "You then add as many new records as you like". Well, that is true when you have bought a licence for DataLoad Professional. The Classic (free) version will allow you to record and play back, but it is limited to a file size of only five records, which is ideal for a proof-of-concept, but not for production work. This means that you can try it out for free, and if it works, and you like it, then you can pay the licence fee. If you don't like it, all it has cost you is your time. If you can't get it to work, then browse the DataLoad Forum to see if somebody has solved the same problem before. If not, then post an entry on the forum and somebody (probably me, as a DataLoad Forum Moderator) will do their best to help you.
 HTH
David.
|
|
|
|
| Re: Using Dataload to upload data into Oracle Applications [message #193566 is a reply to message #193318] |
Mon, 18 September 2006 05:22 |
Debanjan_chat
Messages: 16
Registered: August 2006
|
Junior Member |
|
|
Thanks a lot David. You detailed replies gave me a very good understanding of Data Loader.
Yes currently I am using the Classic version of DataLoad for some Proof of Concepts.
The main reason why I enquired whether I could upload data into Oracle Applications through DataLoad, without opening up the Applications - is because in the Production environment, we would have access only to the Database and not to the Application.
So I was just trying to understand whether DataLoader (Classic or Professional) could upload data without Oracle Applications forms remaining open. ie I am comparing between Data Loader and ADIs.
Regards.
|
|
|
|
| Re: Using Dataload to upload data into Oracle Applications [message #193621 is a reply to message #193566] |
Mon, 18 September 2006 08:54 |
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
|
Senior Member |
|
|
| Debanjan_chat wrote on Mon, 18 September 2006 11:22 |
..... The main reason why I enquired whether I could upload data into Oracle Applications through DataLoad, without opening up the Applications - is because in the Production environment, we would have access only to the Database and not to the Application.
|
I am intrigued. Why would you not have access to the Applications in Production? Maybe I shouldn't ask.
Still, I am glad that I have been able to help, and if I can be of further assistance, please do not hesitate to ask.
David.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
I hate to be pernickety, but actually there are three kinds of columns. You forgot the Commands, such as TAB, ENT, *SAVE, *SP, *SL and many more.
Sorry, Vinod! My comment was meant to be taken light-heartedly. No offence intended, honest!