[Tutor] Tutor Digest, Vol 169, Issue 17

[Alan Gauld]

First, please don't repost the entire digest - we've all seen
the messages before and some people pay by the byte. Secondly
it makes finding the relevant message pertaining to your
question much harder to find.

Delete all the irrelevant stuff.

The other problem with the digest is that it tends to
break the threading of messages for those reading tools that
support it.

Anyway...

On 23/03/18 16:31, David Holland via Tutor wrote:

> I mean Oracle forms which using in Oracle financials, 

It's been nearly 10 years since I worked with OF and things
are likely to have changed but back then there were two variants
 - a pure HTML client that used simple HTML forms and a
thick client that was a Java applet. Is that still the case?

Assuming you have access to a pure HTML client then you need
to use standard web scraping technologies and techniques.
You might find a package like selenium useful. However, like
any kind of robotic UI scraping be prepared for a lot of trial
and error(do you have a test bed that you can try things on?
You don't want to be doing this on your production
database!)

If you only have a Java client then things get much more messy.
But the modern move seems to e away from Java clients to rich
HTML5 so I'm guessing Oracle are heading that way too.

The final thing to check is that you don't have an import
option for CSV files. We used to use OF for our travel expenses
and for those of us who travelled a lot(*) we could fill in
an Excel spreadsheet while on the road then upload it to
OF when we got back. It saved a lo9t of time. It was just
a menu option somewhere in OF - I can't recall where.
But that might be worth asking your IT dept about...

(*)I mean a lot as in, my travel expenses often came
to twice my monthly salary... ouch! The joy of being a
consultant.

-- 

Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.amazon.com/author/alan_gauld
Follow my photo-blog on Flickr at:
http://www.flickr.com/photos/alangauldphotos