Re: One World Data Selections

eric_yeh

Member
Re: One World Data Selections

This is a multi-part message in MIME format.

------=_NextPart_000_0083_01C095E3.8FE9C170
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: base64

SGksDQogICAgeW91IGNhbiB1c2UgYW55IGJhdGNoIHZlcnNpb25zIHJwdCB0byBvdXRwdXQgZGF0
YSB0byBDU1YgZm9ybWF0LCB0aGlzIGZvcm1hdCBjYW4gYmUgaW1wb3J0ZWQgdG8gZXhjZWwgdmVy
eSBlYXN5Lg0KICAgIE90aGVyIHdheSwgeW91IGNhbiB1c2UgdGhlIHRjIGFuZCBjaGFuZ2UgdGhl
IGRlZmF1bHQgT0RCQyB0byBleGNlbCBkcml2ZXIuDQoNCg0KICAtLS0tLSBPcmlnaW5hbCBNZXNz
YWdlIC0tLS0tIA0KICBGcm9tOiBBbm5hbGlzYSBDaGlvdmluaSANCiAgVG86IGpkZWxpc3RtbEBq
ZGVsaXN0LmNvbSANCiAgU2VudDogRnJpZGF5LCBGZWJydWFyeSAwOSwgMjAwMSA1OjUxIFBNDQog
IFN1YmplY3Q6IE9uZSBXb3JsZCBEYXRhIFNlbGVjdGlvbnMNCg0KDQoNCg0KDQogICAgICAgIEhl
bGxvIExpc3QhDQoNCiAgICAgICAgSXMgaXQgcG9zc2libGUgdG8gbWFrZSBhIGRvd25sb2FkIHRv
IGV4Y2VsIG9mIHRoZSBkZWZpbmVkIERhdGEgU2VsZWN0aW9ucyBsaW5rZWQgdG8gYmF0Y2ggdmVy
c2lvbnMgKGZvciBkb2N1bWVudGF0aW9uIHB1cnBvc2VzKT8NCg0KICAgICAgICBUaGFua3MgZm9y
IHJlcGx5ICEhDQoNCiAgICAgICAgUmVnYXJkcywNCg0KICAgICAgICBBbm5hbGlzYSANCiAgICAg
ICAgICAgICAgIA0KICAgICAgIA0KICBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fDQogIEluY3JlZGlNYWlsIC0gRW1haWwgaGFzIGZpbmFsbHkgZXZvbHZl
ZCAtIENsaWNrIEhlcmUgDQo=

------=_NextPart_000_0083_01C095E3.8FE9C170
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: base64

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv
L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgaHR0cC1lcXVpdj1Db250ZW50LVR5cGUgY29udGVu
dD0idGV4dC9odG1sOyBjaGFyc2V0PWlzby04ODU5LTEiPg0KPE1FVEEgY29udGVudD0iTVNIVE1M
IDUuNTAuNDEzNC42MDAiIG5hbWU9R0VORVJBVE9SPg0KPFNUWUxFPjwvU1RZTEU+DQo8L0hFQUQ+
DQo8Qk9EWSBzdHlsZT0iQkFDS0dST1VORC1QT1NJVElPTjogMHB4IDBweDsgTUFSR0lOOiAwcHg7
IEZPTlQtRkFNSUxZOiBBcmlhbCIgDQpiZ0NvbG9yPSNmZmZmZmYgYmFja2dyb3VuZD0iIiBzY3Jv
bGw9eWVzIE9SR1lQT1M9IjAiPg0KPERJVj48Rk9OVCBzaXplPTI+SGksPC9GT05UPjwvRElWPg0K
PERJVj48Rk9OVCBmYWNlPSYjMjM0MzU7JiMyMDMwNzsgc2l6ZT0yPiZuYnNwOyZuYnNwOyZuYnNw
OyB5b3UgY2FuIHVzZSBhbnkgYmF0Y2ggdmVyc2lvbnMgcnB0IA0KdG8gb3V0cHV0IGRhdGEgdG8g
Q1NWIGZvcm1hdCwgdGhpcyBmb3JtYXQgY2FuIGJlIGltcG9ydGVkIHRvIGV4Y2VsIHZlcnkgDQpl
YXN5LjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT0mIzIzNDM1OyYjMjAzMDc7IHNpemU9
Mj4mbmJzcDsmbmJzcDsmbmJzcDsgT3RoZXIgd2F5LCB5b3UgY2FuIHVzZSB0aGUgdGMgYW5kIA0K
Y2hhbmdlIHRoZSBkZWZhdWx0IE9EQkMgdG8gZXhjZWwgZHJpdmVyLjwvRk9OVD48L0RJVj4NCjxE
SVY+PEZPTlQgZmFjZT0mIzIzNDM1OyYjMjAzMDc7IHNpemU9Mj48L0ZPTlQ+Jm5ic3A7PC9ESVY+
DQo8RElWPjxGT05UIGZhY2U9JiMyMzQzNTsmIzIwMzA3OyBzaXplPTI+PC9GT05UPiZuYnNwOzwv
RElWPg0KPEJMT0NLUVVPVEUgDQpzdHlsZT0iUEFERElORy1SSUdIVDogMHB4OyBQQURESU5HLUxF
RlQ6IDVweDsgTUFSR0lOLUxFRlQ6IDVweDsgQk9SREVSLUxFRlQ6ICMwMDAwMDAgMnB4IHNvbGlk
OyBNQVJHSU4tUklHSFQ6IDBweCI+DQogIDxESVYgc3R5bGU9IkZPTlQ6IDlwdCAmIzIzNDM1OyYj
MjAzMDc7Ij4tLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tIDwvRElWPg0KICA8RElWIHN0eWxl
PSJCQUNLR1JPVU5EOiAjZTRlNGU0OyBGT05UOiA5cHQgJiMyMzQzNTsmIzIwMzA3OzsgZm9udC1j
b2xvcjogYmxhY2siPjxCPkZyb206PC9CPiANCiAgPEEgdGl0bGU9YWNoaW92aW5AY2FwZ2VtaW5p
Lml0IGhyZWY9Im1haWx0bzphY2hpb3ZpbkBjYXBnZW1pbmkuaXQiPkFubmFsaXNhIA0KICBDaGlv
dmluaTwvQT4gPC9ESVY+DQogIDxESVYgc3R5bGU9IkZPTlQ6IDlwdCAmIzIzNDM1OyYjMjAzMDc7
Ij48Qj5Ubzo8L0I+IDxBIHRpdGxlPWpkZWxpc3RtbEBqZGVsaXN0LmNvbSANCiAgaHJlZj0ibWFp
bHRvOmpkZWxpc3RtbEBqZGVsaXN0LmNvbSI+amRlbGlzdG1sQGpkZWxpc3QuY29tPC9BPiA8L0RJ
Vj4NCiAgPERJViBzdHlsZT0iRk9OVDogOXB0ICYjMjM0MzU7JiMyMDMwNzsiPjxCPlNlbnQ6PC9C
PiBGcmlkYXksIEZlYnJ1YXJ5IDA5LCAyMDAxIDU6NTEgUE08L0RJVj4NCiAgPERJViBzdHlsZT0i
Rk9OVDogOXB0ICYjMjM0MzU7JiMyMDMwNzsiPjxCPlN1YmplY3Q6PC9CPiBPbmUgV29ybGQgRGF0
YSBTZWxlY3Rpb25zPC9ESVY+DQogIDxESVY+PEJSPjwvRElWPg0KICA8VEFCTEUgaWQ9SU5DUkVE
SU1BSU5UQUJMRSBjZWxsU3BhY2luZz0wIGNlbGxQYWRkaW5nPTIgd2lkdGg9Ijk1JSIgYm9yZGVy
PTA+DQogICAgPFRCT0RZPg0KICAgIDxUUj4NCiAgICAgIDxURCBpZD1JTkNSRURJVEVYVFJFR0lP
TiBzdHlsZT0iUEFERElORy1SSUdIVDogN3B4OyBQQURESU5HLUxFRlQ6IDdweCIgDQogICAgICB3
aWR0aD0iMTAwJSI+DQogICAgICAgIDxESVY+Jm5ic3A7PC9ESVY+DQogICAgICAgIDxESVY+Jm5i
c3A7PC9ESVY+DQogICAgICAgIDxESVY+Jm5ic3A7PC9ESVY+DQogICAgICAgIDxESVY+SGVsbG8g
TGlzdCE8L0RJVj4NCiAgICAgICAgPERJVj4mbmJzcDs8L0RJVj4NCiAgICAgICAgPERJVj5JcyBp
dCBwb3NzaWJsZSB0byBtYWtlIGEgZG93bmxvYWQgdG8gZXhjZWwgb2YgdGhlIGRlZmluZWQgRGF0
YSANCiAgICAgICAgU2VsZWN0aW9ucyBsaW5rZWQgdG8gYmF0Y2ggdmVyc2lvbnMgKGZvciBkb2N1
bWVudGF0aW9uIHB1cnBvc2VzKT88L0RJVj4NCiAgICAgICAgPERJVj4mbmJzcDs8L0RJVj4NCiAg
ICAgICAgPERJVj5UaGFua3MgZm9yIHJlcGx5ICEhPC9ESVY+DQogICAgICAgIDxESVY+Jm5ic3A7
PC9ESVY+DQogICAgICAgIDxESVY+UmVnYXJkcyw8L0RJVj4NCiAgICAgICAgPERJVj4mbmJzcDs8
L0RJVj4NCiAgICAgICAgPERJVj5Bbm5hbGlzYTwvRElWPjwvVEQ+PC9UUj4NCiAgICA8VFI+DQog
ICAgICA8VEQgaWQ9SU5DUkVESUZPT1RFUiB3aWR0aD0iMTAwJSI+DQogICAgICAgIDxUQUJMRSBj
ZWxsU3BhY2luZz0wIGNlbGxQYWRkaW5nPTAgd2lkdGg9IjEwMCUiPg0KICAgICAgICAgIDxUQk9E
WT4NCiAgICAgICAgICA8VFI+DQogICAgICAgICAgICA8VEQgd2lkdGg9IjEwMCUiPjwvVEQ+DQog
ICAgICAgICAgICA8VEQgaWQ9SU5DUkVESVNPVU5EIHZBbGlnbj1ib3R0b20gYWxpZ249bWlkZGxl
PjwvVEQ+DQogICAgICAgICAgICA8VEQgaWQ9SU5DUkVESUFOSU0gdkFsaWduPWJvdHRvbSANCiAg
ICAgIGFsaWduPW1pZGRsZT48L1REPjwvVFI+PC9UQk9EWT48L1RBQkxFPjwvVEQ+PC9UUj48L1RC
T0RZPjwvVEFCTEU+PFNQQU4gDQogIGlkPUluY3JlZGlTdGFtcD48U1BBTiBkaXI9bHRyPjxGT05U
IGZhY2U9IkFyaWFsLCBIZWx2ZXRpY2EsIHNhbnMtc2VyaWYiIA0KICBzaXplPTI+X19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXzxCUj48Rk9OVCANCiAgZmFj
ZT0iQ29taWMgU2FucyBNUyIgc2l6ZT0yPjxJPkluY3JlZGlNYWlsPC9JPiAtIDxCPkVtYWlsIGhh
cyBmaW5hbGx5IA0KICBldm9sdmVkPC9CPiAtIDwvRk9OVD48QSBocmVmPSJodHRwOi8vd3d3Lmlu
Y3JlZGltYWlsLmNvbS9pbXN0YW1wYS5odG1sIj48Rk9OVCANCiAgZmFjZT0iVGltZXMgTmV3IFJv
bWFuIiBzaXplPTM+PEI+PFU+Q2xpY2sgDQogIEhlcmU8L1U+PC9CPjwvRk9OVD48L0E+PC9TUEFO
PjwvU1BBTj48L0ZPTlQ+IDwvQkxPQ0tRVU9URT48L0JPRFk+PC9IVE1MPg0K

------=_NextPart_000_0083_01C095E3.8FE9C170--
 
Re: One World Data Selections

Ciao Annalisa,

I don't know of a way to do that, but you could always take a screen shot
of the Data Selection (if you are using Windows98,NT or Win2K by holding
down "Ctrl" (or "ALT") Key and "Print Screen" Key at the same time. This
combination of keys takes a snapshot of your screen. Then go to
Start-Pograms-Accessories -> Paint. Click inside the white box and then hold
down "Ctrl" and "V" keys together. This will paste the screenshot into MS
Paint application, where you can save it.

Saluti! Ho lavorato con i tuoi soci di CapGemini qui ad un cliente che si
chiama "GardenBurger" a Portland, OR., USA. Bravi!
- John Bartolucci.

(JDE System Admin.)B733.2 SP11.3 Ora8.1.5 IntelNT.
diretto: ([email protected]).

PS: Ma C'e' JDE nell'Italia?

>From: "Annalisa Chiovini" <[email protected]>
>Reply-To: [email protected]
>To: "[email protected]" <[email protected]>
>Subject: One World Data Selections
>Date: Fri, 9 Feb 2001 10:51:45 +0100 (ora solare Europa occ.)
>
>
>
>
>Hello List!
>
>Is it possible to make a download to excel of the defined Data Selections
>linked to batch versions (for documentation purposes)?
>
>Thanks for reply !!
>
>Regards,
>
>Annalisa

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
 
Re: One World Data Selections

Just 2.5 addition.

1.) If you use the ScreenShot method:
1.a) Use the ALT+PrintScreen key combination for Copy to ClipBoard. In this case only the active window will be Copied instead the whole screen.
1.b) Paste from the ClipBoard into a Word document instead of into a Paint file. Try it and compare the size of files (supposly approx. 40K vs. 4MB)

2.) Copying Sequencing / Selection into an Excel:
* Click into the field on the left-upper corner
* Scroll with the scrollbars to access the right-lower field
* Shift-Right-Click into the right-lower field (the entire range have to be selected - turned blue)
* Hit CTRL-C to copy to the ClipBoard
* On an Excel sheet hit CTRL-V to paste from the clipboard
The only problem will be that Ascending/Descending and No/Yes will be translated into 0/1 for Data Sequencing.

I tried it on one of our platforms/configurations and worked well. Hopefully it will work on your configuration too but it could depend on your:
* OpSys type and version
* OpSys SP level
* version of Office (Ecel/Word/etc.)
* version of your OneWorld software
* etc.
... all these informations that you have forgotten to share with us :))

Good luck,
Zoltán



B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Re: One World Data Selections

If you want to keep the documentation in OW itself try the following. The version must be checked out first. Open the data Selection screen. Click in the box to the left of the WHERE clause and hold down on the mouse button dragging it down to the last line. Do CTRL and C on the keyboard. Close data selection and go to Version Detail. Move cursor to Version Detail field and do CTRL and V on the keyboard. If you have data selection that has a list of values with more than about 4 you will have to type the rest in to see them.
example after CTRL V
Where BC Status Code W.O. (F4801) is equal to "40"
And BC Categories - Work Order 01 (F4801) is not equal to "A4,AA,AJ,MOD,..."
And BC User Reserved Code (F4801) is equal to "PP"
And BC Drawing Size (F4101) is not equal to "M"
And BC Sales Category Code 5 (F4101) is not equal to "N"
Or BC Branch (F4801) is equal to " STK"
And BC Status Code W.O. (F4801) is equal to "40"
And BC User Reserved Code (F4801) is equal to "PP"
And BC Drawing Size (F4101) is not equal to "M"




B733.2 SP11.2
AS400 Central Objects
 
Back
Top