Home » Developer & Programmer » Forms » Data loading from text file (merged 2 by MC) (Forms, 11g, windows)
Data loading from text file (merged 2 by MC) [message #658828] Wed, 28 December 2016 03:04 Go to next message
AyeshaSaad
Messages: 16
Registered: December 2016
Junior Member
Dear All
I have developed my application in Forms11g and configured weblogic server, my remote users are using application successfully.
Now my problem is, in our company sales team send us their orders through text files which I want to load into my system and generate invoices against these orders.
In our Forms6i application we are using SQLLDR but I don't know how to use SQLLDR in forms11g?

Please guide me.

Thanks in advance.
Data loading from text file [message #658830 is a reply to message #658828] Wed, 28 December 2016 03:35 Go to previous messageGo to next message
AyeshaSaad
Messages: 16
Registered: December 2016
Junior Member
Dear All
I have created my application in Forms11g and configured weblogic server now my remote users (outside/inside city) are using application.
My problem, our sales team send text files through email which we have to load in our system and generate invoices against these orders.

In our Forms6i application we were using SQLLDR but how to load text files data on daily basis in Forms11g?

Please advise.

Thanks in advance
Re: Data loading from text file [message #658843 is a reply to message #658830] Wed, 28 December 2016 07:45 Go to previous messageGo to next message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why do you repost the same question?
The only result will be you'll make people angry and get no answer.
Wait, this is a cooperative forum, you pay nothing, no one owe you an answer; in addition, maybe the one who knows the answer is 12 hours or more away from you and will read your question when you'll be asleep.

Re: Data loading from text file [message #658865 is a reply to message #658843] Wed, 28 December 2016 22:24 Go to previous messageGo to next message
AyeshaSaad
Messages: 16
Registered: December 2016
Junior Member
Sorry for the dual posting, I wanted to delete my first post but unable to find post delete option.
Re: Data loading from text file [message #658867 is a reply to message #658865] Thu, 29 December 2016 00:12 Go to previous messageGo to next message
Littlefoot
Messages: 21559
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How did you run SQL*Loader in your Forms 6i application? Was it by the HOST built-in which called a .BAT script which ran SQLLDR? If so, it still exists (at least, I believe so, I don't have Forms 11g to check) but operates on the server machine. Therefore, create a (shared) folder on the application server so that users could put text files in there. Modify the .BAT script so that it sees those files. Call it from a form, as usual.
Re: Data loading from text file [message #658871 is a reply to message #658867] Thu, 29 December 2016 02:45 Go to previous message
AyeshaSaad
Messages: 16
Registered: December 2016
Junior Member
Thanks Littlefoot, I will try and then update you.
Previous Topic: help menu
Next Topic: Forms 6.0 Runtime Failure & Forms 6.0 runtime error-please help me (merged)
Goto Forum:
  


Current Time: Tue May 26 13:34:57 CDT 2020