• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Table Layout to Excel

lstropes

Member
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.
 

vterala

Member
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
 

sean_gilbert

Well Known Member
??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
<vterala@kpmg.com> To: jdeowdevml@jdelist.com
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
 

neil_shepherd

Well Known Member
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
 

Christian Audet

Moderator
Staff member
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)
 

Zoltan_Gyimesi

Legendary Poster
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)
 

njc

Member
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
 

Christian Audet

Moderator
Staff member
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)
 

njc

Member
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
 

Zoltan_Gyimesi

Legendary Poster
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)
 
Top