Dataload macros
Date: Thu, 2 Sep 1999 06:16:07 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Need Dataload Macros!
Hi All,
I was wondering if someone out there can send me the
dataload macro for GL (Account Values, Balances),
Fixed Assets and AP Vendors or point me to the site
from where I can download the macro. We are on Apps
10.7 Character mode and GUI mode. Not NCA.
Kindly help.
Siddharth
Date: Thu, 02 Sep 1999 09:27:31 -0400
From: "Rusty Kimbrell" RKimbrel@pgahq.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Need Dataload Macros!
Siddarth
I will look for the one that will ad segment values for you if that what
you need. But I have never been able to create the one to load vendors as
the macro will only load on site and has trouble going from zone to zone .
So if you have to load multiple sites or change accounting form the header
to the site level it never works.
But Ill send the other one if thats what you need.
Rusty
Date: Thu, 2 Sep 1999 08:51:55 -0500
From: "Krzes, Joe" JKrzes@smith.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Need Dataload Macros!
We use 10.7 character and I just use cut and paste from Excel. It works
great. Put data in each cell, flexfield data all goes in one cell. You can
even use navigation keys such as \zn (zone next) and \ss (screen save).
I've used it on all kinds of forms like entering gl code combos, entering
new assets, entering new vendors, etc.. It has save a lot of time when we
setup a new company (aquisition) and had to enter new account segments and
descriptions. Since they had a chart of accounts in electronic form with
values and descriptions, I just imported it into Excel, moved it around a
little and used cut and paste to enter it with zero typos. Worth playing
around with!
Joe Krzes
Houston, TX
Date: Thu, 02 Sep 1999 10:00:17 -0400
From: "Anand Gonsalves" agonsalves@glenraven.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Need Dataload Macros!
Hey Siddharth
If U already have a data file of vendors which U would like to upload U can
do
it thru sqlload.
Since Oracle does not have a standard interface for this U have to do it via
Sqlload and load data directly to
vendor tables.We did this about a year back and have had no problems so
far.So
if U would be interested in getting that script do let me know and I'll send
it
to U.Cause as Rusty says a macro is not useful if U have to load multiple
sites
Thanks
Anand
Date: Thu, 02 Sep 1999 10:19:07 -0400
From: "Rusty Kimbrell" RKimbrel@pgahq.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Need Dataload Macros!
Hey Anand
I would really appreciatte the laoder script for the vendor uplaod, It
nevers hurts to have it at the ready as we have tons of vendor sto load on
regular intervals. Does your script control the sequential numbering( I
realize that is a stupid question but when I wrote the loader sc ript I
couldnt get the numbering part down)
Thanks for the help
Date: Thu, 2 Sep 1999 10:21:29 -0400
From: "Sheets, Toni" toni.sheets@lgeenergy.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Need Dataload Macros!
Since we are talking about Excel dataload macros, I have a question. I have
several macros I use to load request groups, responsibility exclusions, etc.
I always have to watch for values that have parenthesis, (). The macro is
looking at these as commands. Does anyone have a way to make an excel macro
treat () as text? I haven't found anyone who knew how to do this (even out
on the Microsoft Help Web Site).
I've tried all the tricks I can think of from other applications: Putting
special characters in front of the parenthesis, Repeating the parenthesis,
etc.. Nothing seems to work.
If anyone can tell me how to do this, I would bow down before you and
worship at your feet.
Thanks in advance.
Toni
Toni Sheets
Oracle System Administration
E-Mail: Toni.Sheets@LGEEnergy.com
Work Phone: (502)627-4343 Pager: (502)621-1976
Work Hours: 7:00am - 3:30 pm
Date: Thu, 2 Sep 1999 10:30:47 -0400
From: "Sankala, Dinesh" Dinesh.Sankala@lgeenergy.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Need Dataload Macros!
HI aNAND CAN u SEND ME THE SCRIPT
MANY THANKS
KUMAR
Date: Thu, 02 Sep 1999 10:49:07 -0400
From: "Anand Gonsalves" agonsalves@glenraven.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Need Dataload Macros!
Hey Rusty
Well I have two stages in the vendor upload.In the first stage I load the
data
from the data file to a temporary table using SQLLOAD.And then from the
temporary table I load data to the Oracle apps tables using sqlplus
program.I'll
send the files to ur address.
Thanks
Anand
Date: Thu, 2 Sep 1999 11:21:41 -0500
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Need Dataload Macros
Absolutely Joe. I just used this for a conversion on 10.7 character. I still
have Excel templates for creating new vendors. Since every company is
different, the templates will have to be modified for your specific
situation. I will be happy to provide a sample to anyone who is interested.
Stan
Date: Sat, 4 Sep 1999 13:32:58 +0100
From: "Jonathan Stuart" jdstuart@globalnet.co.uk
To: oraapps-l@cpa.qc.ca
Subject: Re: Need Dataload Macros!
Toni,
Certain characters, including (), are significant to the VB SendKeys
function, which is used by the macro to send characters to Oracle. In order
to send these characters you need to enclose them in braces {}, otherwise
SendKeys will ignore the special characters and all you will see is that
certain characters didn't get send to Oracle. The following is an excerpt
from Microsoft's SendKeys help text, which explains this further:
The plus sign (+), caret (^), percent sign (%), tilde (~), and parentheses
) have special meanings to SendKeys. To specify one of these characters,
enclose it within braces ({}). For example, to specify the plus sign, use
{+}. Brackets ([ ]) have no special meaning to SendKeys, but you must
enclose them in braces. In other applications, brackets do have a special
meaning that may be significant when dynamic data exchange (DDE) occurs. To
specify brace characters, use {{} and {}}.
I hope this helps.
Jonathan Stuart.
Date: Sat, 4 Sep 1999 13:37:14 +0100
From: "Jonathan Stuart" jdstuart@globalnet.co.uk
To: oraapps-l@cpa.qc.ca
Subject: Re: Need Dataload Macros!
Steve,
The following web site contains downloads for the DataLoad programs
themselves plus example spreadsheets to load and documentation and help on
using DataLoad:
http://www.users.globalnet.co.uk/~jdstuart/nca_load.htm
If you need further help I support these tools via email as time permits. If
you have any questions or issues please feel free to email me directly at:
jdstuart@globalnet.co.uk
Jonathan Stuart, DataLoad author.
Data General Aviion Series
Date: Thu, 2 Sep 1999 10:24:09 -0500
From: "Michael" BMRBUK@msn.com
To: "Multiple recipients of list" oraapps-l@cpa.qc.ca
Subject: Data General Aviion Series
I am trying to find information on know problems with Data General Aviion
hardware. We are currently experiencing problems with system stability. We
are running Apps 10.7 SC and 8.0.5 database, if you have any information or
know where one might find information please e-mail me with your comments at
bmrbuk@msn.com .
Thanks in advance,
Mike Buchanan, Principal
Technology Solutions Company
Oracle South Central
Excel Macro commands
Date: Thu, 2 Sep 1999 12:47:44 -0400
From: "Granacher, Betsy S." GranBS@jea.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Cc: "Reid, Linda B." ReidLB@jea.com,
Subject: Cut and Paste Excel Macro for Loading Data Through Screen Emulati
Looking for documentation on the Excel macro written by Oracle Consultants,
and referred to in spring conference paper entitled "Project Shortcuts".
This white paper notes there are 16 different commands that can be sent to a
form, to assist with loading data via cut and paste and screen emulation.
Paper says this macro has been frequently circulated around the user forums.
Any documentation would be appreciated.
Betsy S. Granacher
JEA
Phone (904) 665-6419
FAX (904) 714-4895
granbs@jea.com
Date: Thu, 2 Sep 1999 18:45:00 -0700
From: "Deb Burgess" dburgess@burcon-group.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Cut and Paste Excel Macro for Loading Data Through Screen
Emulati
I would be more than happy to send the 10.7 and 11. version. Are you
comfortable getting an attachment from a "stranger"? If not give me a call
and I will try to answer your questions. Then you can decide if you want it
sent. I love the 10.7 version. I dislike the 11 version (it is not as
robust [love that word]). I have a technical consultant adding some error
checking to it. That should help a little.
Have A Great Day!
Deb Burgess, The Burcon Group
562.420.6288 (Office)
310.898.8520 (VM/Pager)
310.488.7608 (Mobile)
Date: Fri, 03 Sep 1999 23:52:22 +0200
From: "Dina Rotem (h)" dinar@rafael.co.il
To: Ora OraApps-L@cpa.qc.ca
Subject: RE: Cut and Paste Excel Macro for Loading Data Through Screen
Several months ago I had found a good source for that functionality, by
a person named Jonathan Stuart. He is offering several versions of his
programs, and updating it every couple of months.
You may try and download it from the following web site:
http://www.users.globalnet.co.uk/~jdstuart/nca_load.htm
Dina
Date: Sat, 4 Sep 1999 13:48:33 +0100
From: "Jonathan Stuart" jdstuart@globalnet.co.uk
To: oraapps-l@cpa.qc.ca
Subject: Re: Cut and Paste Excel Macro for Loading Data Through Screen
Emulati
Deb,
The R11 (NCA) version of the macro is no less robust than 10.7 (10SC)
version, rather it is harder to load into NCA than 10SC. The macro for
loading into 11 is in essence identical to that for 10.7, with changes to
ensure the Control, Alt and Shift keys and the remapped shortcuts still
work. The problems come about because the forms behaviour in NCA is not
always as consistent as in 10SC and keystrokes can't be sent as quickly to
NCA forms without the forms being 'overloaded' or keystrokes getting lost.
For that reason user definable delays were added in the NCA versions of the
macro. You can add further error checking to the macro but at the end of the
day this will just give you better error messages rather than make the load
more stable.
For best stability I suggest you don't use the macro for loading into NCA
but use the DataLoad 4 program instead. This does the same job as the macro
but from a standalone Windows program which can control the load better than
is possible with the macro. Feedback I have received indicates the
standalone V4 is much more reliable, performant and stable than macro
versions.
All versions of DataLoad, example spreadsheets and supporting documentation
can be downloaded from:
http://www.users.globalnet.co.uk/~jdstuart/nca_load.htm
Jonathan Stuart, DataLoad author.
Excel Macros to upload data on NT environ
Date: Thu, 9 Sep 1999 14:32:06 +0800
From: "Stankevicius, Jon" Jon.Stankevicius@health.wa.gov.au
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: AP: Excel Macros To Upload Data - Windows NT
We have a copyright Excel Macro that will populate an Oracle Form (such as,
say the distribution lines on a Payables Invoice) directly on-screen.
This is a tremendously useful feature that can save a whole heap of manual
keying.
However, I note that this macro tends to go out of sync or loose its place
under our newer Compaq PC's under Windows NT. The macro works just fine
under Windows 95 on our slower machines.
We've tried altering the pause time on TAB commands between the fields as it
proceeds along each line because we thought the newer machines were going
too fast. But the macro just seem to trip up at random locations, though
sometimes worked OK.
I'm raising this point to (a) increase awareness of the existence of such
macros and their usefulness. Eg., they have a role in conversion data and
the input is validated by Oracle as the data is entered; and (b) to ask if
anyones else has had problems with the NT environment in this regard.
JonS
Jon STANKEVICIUS
Coordinator Financial Systems
Corporate Finance Branch
Finance and Resource Management Division
HEALTH DEPARTMENT OF WESTERN AUSTRALIA
AUSTRALIA
Tel: +61 8 9222 2315
Fax: +61 8 9222 2259
Email: jon.stankevicius@health.wa.gov.au
Date: Thu, 9 Sep 1999 08:25:40 -0400
From: "Sikora, John M (TRANS)" John.Sikora@trans.ge.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Excel Macros To Upload Data - Windows NT
I have run macros on NT and non-NT PC's and found that the NT's act
differently. However, I have restructured them so they run on both types of
PC's and I don't remember the differences.
I use SPACE command whenever possible and stay away from ENT.
Also, do you have the following in your macro? My understanding is that it
will 'slow down' the macro. I'm not sure.
Application.SendKeys Content & Sep, True ' Send to
Oracle Applications, wait for processing
John M. Sikora
Phone: 814.875.3780
E-mail: jsikora@msx.trans.ge.com
Date: Thu, 9 Sep 1999 18:56:08 +0100
From: "Jonathan Stuart" jdstuart@globalnet.co.uk
To: oraapps-l@cpa.qc.ca
Subject: Re: Excel Macros To Upload Data - Windows NT
John,
Using the 'True' option with SendKeys will help with load stability because
SendKeys will wait for OS operations to complete before continuing. I found
this makes the load more reliable but it doesn't do enough to slow down
loads to a rate that NCA Applications can keep up. That's why on the NCA
macros the delay options were added as well as the NCA specific code.
Jonathan.
DataLoad web site:
http://www.users.globalnet.co.uk/~jdstuart/nca_load.htm
Excel Macro Commands Query 2
From: Shah, Sandeep V [SMTP:svshah@kpmg.com]
Sent: Tuesday, March 30, 1999 11:01 PM
Subject: Urgent:Question on Excel Macro!!
Hi all,
I am currently in process of loading Tax Exemptions in AR through Excel
Macro. However, I am not able to use excel macro commands to go to the
previous block in the form. The equivalent command in Excel Macro to do
this task is
SendKeys "+{PGUP}" -- Oracle Application is not recognizing this
command(shift+page up)
Are there any other commands I can use to do this? We need to insert
approximately 8,000 exemptions. Does anyone know any other way of loading
tax exemptions?
We are using Rel 11 AR.
Regards & Thanks,
Sandeep Shah
Senior Consultant
KPMG
Oracle Applications Practice
973-912-6532
svshah@kpmg.com
Date: Wed, 31 Mar 1999 11:58:15 +0930 Excel to Oracle - Send Keys issues
Date: Wed, 30 Jun 1999 14:23:18 -0400
Date: Wed, 30 Jun 1999 17:15:32 -0400 Development Tools other than D2K
Date: Thu, 9 Sep 1999 11:21:57 -0400
Date: Thu, 9 Sep 1999 10:43:11 -0500
Date: Thu, 9 Sep 1999 09:41:54 -0600
Date: Thu, 9 Sep 1999 10:40:20 -0500
Date: Thu, 9 Sep 1999 11:35:15 -0500
Date: Thu, 9 Sep 1999 12:42:39 -0400
Date: Thu, 9 Sep 1999 09:05:59 -0800
Date: Thu, 9 Sep 1999 12:16:29 -0500
From: "Savory, Aaron"
Subject: RE: Urgent:Question on Excel Macro!!
Try the following (have not tried this on Rel 11)
Case "*NB"
Sep = "%GB"---------------- ' Next Block
Content = ""
Case "*PB"
Sep = "%GV"--------------- ' Previous Block
Content = ""
Regards
Aaron Savory
AR/OE Implementation Project Leader
F2000 WASANT Region
Phone: 08 9333 3645
Mobile: 0419 932 227
Fax: 08 9333 3677
From: "Sarah E Scott" sscott@paychex.com
Subject: Send Keys Help
Hi,
Has anyone ever used the SendKeys method in Excel to input data to
Oracle Payables (10.7 Character)?
When I send the END, PGUP, & PGDN keys, I can not get them to work in
Oracle. It seems to acknowledge a keystroke but not the appropriate
one.
Also, does anyone know of any other way to close a text box (such as a
description box) in Oracle other than the END key?
Any input would be appreciated!!!
Thank you!!!
Sarah
From: "Farber, Andy" farban@consumer.org
Subject: RE: Send Keys Help
Sara,
I had alot of trouble with SendKeys, until I figured out that Excel needed
to be told to wait until the keys were received:
SendKeys "+{end}", True
sends ShiftEnd, and then waits for the keys to be sent before moving on.
You need ", TRUE" after every SendKey to make it make sense...
Andy
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
From: "Kelly.Newman" Kelly.Newman@plpit.fishersci.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: development tools
Hi all,
What toolset is common for development, other than D2K? We've been using
the freeware version of TOAD, and are pleased with it. However, we're
looking at purchasing something, and would like to see what else is out
there, and what the rest of the world is using.
thanks
From: "Bivens, Jerry" jdbivens@sbec.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: development tools
Quest has SQL Navigator, and some SQL tuning tools that are nice. We bought
the licensed version of TOAD and are using it also.
From: "Kossmann, Bill" BKossmann@mail.dthr.ab.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: development tools
SQL*Navigator is also popular. We evaluated it and found it a very capable
tool, but we couldn't argue with the price of TOAD. In spite of that,
however, I'd like to purchase TOAD so that I get the full range of the
tool's functionality.
Bill
From: Kim Bauman kbauman@midcom-inc.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: development tools
We have been using the freeware version of TOAD as well and really like it.
Can you tell me what you paid for the licensed version? How would you
compare SQL Navigator to TOAD?
From: bradyj@mapcocoal.com
To: oraapps-l@cpa.qc.ca
Subject: Re: development tools
There is another, similiar to TOAD called Golden Retriever or Golden32 by
Benthic Software. It has some similarities to TOAD but our SQL Developer
prefers it.
From: "Bartoletti, Mike" BartolMi@rf.suny.edu
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: development tools
We use a toolkit called hummingbird. It is pretty costly though but is very
good.
Michael Bartoletti
Applications Development
Research Foundation of SUNY
ph:(518)434-7204
fx:(518)434-7211
work: mailto:bartolmi@rfsuny.org
From: Amos Gingerich agingerich@gci.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: development tools
You may be aware that TOAD is not also owned by Quest (SQL Navigator)
Amos
From: "Bivens, Jerry" jdbivens@sbec.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: development tools
Toad version VI is marketed and owned by Quest.