Table Layout to Excel

vterala

Member
Is there a way to get table layouts(alias,description,length,etc..) into Excel ?

Thank You,
Venkat
 
Yes. Bring up the layout you need. Right click and choose Export.
Then you can choose Excel. The program will ask you to highlight what
you want to export. After you have selected what you need then click
Continue. Have fun.
 
Re: RE: Table Layout to Excel

Hello ...Thanks for the reply
Did you mean to do that on Table Design Aid ? I don't think that is possible.. Please explain...

Venkat
 
??Helping the competition is that allowed?? :)

Yes,

Use the utility SABridge.exe found in \b7\system\bin32

1. SABridge.exe
2. OneWorld SignON
3. Find your table
4. File > Export
It will prompt you to enter two file names to export to.
5. enter destination and excel file name for header definition
6. enter destination and excel file name for Table definition

Sean Gilbert
JDEdwards Consultant
PricewaterhouseCoopers
Montreal

Tel: 514.205.5000 x3619
Fax: 450.655.0163



vterala
<[email protected]> To: [email protected]
Sent by: cc:
owner-jdeowdevml@j Subject: Table Layout to Excel
delist.com


06/05/2001 04:15
PM
Please respond to
jdeowdev






Is there a way to get table layouts(alias,description,length,etc..) into
Excel ?

Thank You,
Venkat


--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
=&Board=OWDEV&Number=12202


XE SP15, Solaris, Oracle8.0.6, JAS NT, WebSphere3.5
 
Hi Venkat,

Just a note regarding the field sizes returned by SABridge as they can be misleading (certainly under B733x, and I imagine XE).
SABridge works by reading the tables .h, the C header file. This means that:
Strings - Will have a size equal the the DD value +1 (the +1 is from a null character \0 used to indicate the end of the string.
Numerics - are all declared as MATH_NUMERIC with a size of 49
Dates - have a correct size of 6
Characters - have a correct size of 1

Regards

Neil.

OW B733.2, SP 11.1
Sun Solaris/UNIX
 
Hi Venkat,
Hi Sean,

Sarting in Xe there is a new way to have table definition without the MATH_NUMERIC field size error.

Use application P80010, Give the table name and that's it.

It's simple to use and it will also let you extract data to excel.

Only one special thing about this application, it's not working in demo version since it's using the "Central Object Relational Database (RDB)" that are not populated in demo.

Try the application in your live environnement and give me some new about it.

Christian Audet

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 
Venkat, Christian

Venkat, what is your system configuration?
If it is XE then you can use P80010 as Christian has suggested already but you have to make some OCM mappings to get it work properly. Please, checkout the ott-00-0058 documentation from the Knowledge Garden for the required prerequisites.

Further you can investigate this application with FDA how does it retrieve the informations, so you will be able with these knowledge to create your own application(s) which best suits to your needs.

Zoltán
P.S.: Place your system configuration informations in your signature.

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
May I add a twist to this conversation?

Thanks to your suggestions, I tried SABridge and it worked great! However, I would also like to get the long glossary description to download, either with the same file or separately and I can match it from there. Is this possible?

Thanks,
... Natalie

Natalie Chlop
Xe, AS/400, Central objects,
Citrix
 
Natalie,

since your are on Xe, you will have the required info in P80010.

Remember, it's only available in Xe and it's not working in demo.

Like Zoltan said, download document ott-00-0058 from the knoledge Garden and you will find explanation on P80010.

Christian Audet


Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 
Christian ...

I must be doing something wrong. When I use P80010, the glossary is a row exit. I can go to and from the glossary, but when I do the export, the glossary data does not come with it. Am I missing a step?

Thanks,
... Natalie
PS - I have the ott-00-0058, but it doesn't help with the export.

Natalie Chlop
Xe, AS/400, Central objects,
Citrix
 
Natalie,

You can only Select the Glossary on the screen and Copy/Paste to an other location (e.g. texteditor).

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Back
Top