Hideously OT - Function Key assignment in XP
in [UK Mac]
|
Prev: Mapping Alt Gr key on (IBM Model M) keyboard to Command function
Next: [iPhone] Anyone seen a website listing new apps announced each day?
From: Pd on 14 Jul 2008 17:50 Woody <usenet(a)alienrat.co.uk> wrote: > Pd <peterd.news(a)gmail.invalid> wrote: > > > I'm doing a project at the moment that involves massive amounts of copy > > data from an Excel spreadsheet, and pasting it into an Oracle database > > accessed through Internet Explorer. > Does it have to be done this way? If you save the excel spreadsheet as > an xml file, it is the cleanest of all the office XML formats (ok, that > doesn't say that much, but it is). I'm afraid it does have to be done this way. I spent many years extracting data from various systems and importing into databases, and this one is such that the simplest way to do it is manual copy and paste, because it's a limited chunk of data that needs to be processed during a cutover. If nothing else, it would be much simpler if I could take my MBP in and connect to the company network, but you can imagine how the IT dept responded to that suggestion. -- Pd
From: Adrian C on 14 Jul 2008 18:19 Pd wrote: > > The stupid Ctrl-C Ctrl-V combination is crippling my little finger - > never realised how nice it is using the Command key to do this on a Mac. On Windows you can also use Ctrl-Insert for copy, Shift-Insert for paste. I find that more natural - well, I now have permanent markings on my fore finger.... The shortcuts do does work between IE and Excel and most other applications. Interestingly these were an idea originally inspired from Apple (as is the rest of creation :-) http://en.wikipedia.org/wiki/Common_User_Access -- Adrian C
From: Adrian C on 14 Jul 2008 18:56 Pd wrote: > I'm afraid it does have to be done this way. I spent many years > extracting data from various systems and importing into databases, and > this one is such that the simplest way to do it is manual copy and > paste, because it's a limited chunk of data that needs to be processed > during a cutover. In days of old, database applications as new strangers spoke to each other through a specially written driver that may have had it's data communicated through copy and paste activity within a managed keyboard buffer - it was as crude at that. Then someone wrote ODBC... (and for "Open" read "Microsoft") Now with internet browser based application frontends we are finding ourselves back to the grind of working out automated cut and paste again. :-( There are wonderful applications used in testing and financial circles that can do that sort of thing under control of a script. A friend works for a company that produces a really neat visual solution for this. Then again with a bit of XSLT and crazy paved VB one could do wonders as well, but whatever remains with either method - the $64,000 task is to get the script properly written to intelligently cope with exceptions in the original data, but thinking about all those exceptions, ouch .... Well, it may be quicker for a highly paid human to do cut and paste for a day ... Been there, climbed the walls and got out :-) -- Adrian C
From: Woody on 14 Jul 2008 19:35 Pd <peterd.news(a)gmail.invalid> wrote: > Woody <usenet(a)alienrat.co.uk> wrote: > > > Pd <peterd.news(a)gmail.invalid> wrote: > > > > > I'm doing a project at the moment that involves massive amounts of copy > > > data from an Excel spreadsheet, and pasting it into an Oracle database > > > accessed through Internet Explorer. > > > Does it have to be done this way? If you save the excel spreadsheet as > > an xml file, it is the cleanest of all the office XML formats (ok, that > > doesn't say that much, but it is). > > I'm afraid it does have to be done this way. I spent many years > extracting data from various systems and importing into databases, and > this one is such that the simplest way to do it is manual copy and > paste, because it's a limited chunk of data that needs to be processed > during a cutover. > > If nothing else, it would be much simpler if I could take my MBP in and > connect to the company network, but you can imagine how the IT dept > responded to that suggestion. I can - been there, suggested that! -- Woody www.alienrat.com
From: Pd on 15 Jul 2008 01:10
Adrian C <email(a)here.invalid> wrote: > the $64,000 task is to get the script properly written to intelligently > cope with exceptions in the original data, but thinking about all those > exceptions, ouch .... Well, it may be quicker for a highly paid human to > do cut and paste for a day ... Perfectly summarised. In a nutshell, one might say. -- Pd |