• 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!

Media Objects

We are in the process of moving legacy data to JDE. I need to populate the
F00165, Media Objects Storage, with a text attachment using a Table
Conversion. Anyone out there had any success with this?

Thanks Mark
 

owguru

Well Known Member
Mark,

I looked around a little and I don't think you're going to get what you need
with just a table conversion. In ube and appl development, there used to be
system functions in er that allowed you to manipulate the media object
attachment (ie, F00165 table) that I thought might help. But these system
functions don't seem to be there anymore and definitely aren't available in
table conversions OR in named event rules (NER) business functions.

I'm sure if you're into this project, you already know your main problem is
the blob field in the F00165 table...with the added joy of building the key
field from the key of the table the attachment goes with.

Your best bet is to write a c business function to call in your table
conversion. Take heart because there are a few existing business functions
to study and steal from. Check out the code for B0500047 -
ConvertNarrativeText (which was written to convert world attached text to
oneworld) and B9816DCV - TransferF0016DToF00165 (another conversion program
from when the F00165 table was first created). Finally, the B9100165 -
GetTextFromF00165 appears to being doing the exact opposite of what you
want. My motto is never reinvent the wheel!



Good Luck


>From: Mark_Teindl <Mark_Teindl@trail.cominco.com>
>Reply-To: jdelist@jdelist.com
>To: jdelistml@jdelist.com
>Subject: Media Objects ~~0:1428
>Date: Mon, 20 Nov 2000 08:54:01 -0800 (PST)
>
>We are in the process of moving legacy data to JDE. I need to populate the
>F00165, Media Objects Storage, with a text attachment using a Table
>Conversion. Anyone out there had any success with this?
>
>Thanks Mark
>
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=1428
>*************************************************************
>This is the JDEList One World / XE Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.



owguru (at least I'm trying :)
>all versions
>all platforms
 

jde6966

Member
I have the same problem, try to load text from World to one world F00165. Can you tell me how to use B0500047, there is no documentation for that BF.
 

Christian Audet

Moderator
Staff member
Mark,

I did the same thing that you are looking for (with table conversion). And it's working fine. Look in the archive for "PO text" this topic was discus a lot on the forum.

Christian

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