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

Write OLE info to F00165 System H92 OneWorld XE

erichz

Active Member
I need to create a F00165 record to
indicate that an OLE Attachment link exists (e.g. an scanned
invoice image residing on the network needs to be attached
to an invoice F03B11 record)...so I would think we need to
pass the name and location of the linked object as
parameters?"
I would like an API to put OLE media object information
into the F00165 tables.
The reason client needs this API is that they have up to
50,000 attachments (images) that they will be upload-
ing every night, and they need the ability to link these
attachments to specific JDE documents, so that they can then
drill down to these images via the OLE object attachments
(paperclip). Do you have recommendations on the best way to
accomplish this with current version of OneWorld?
 

magnelus

Member
I have a similar situation. JDE help line came back
saying that no facility exists as yet that can help to
automate the process other than we attaching the
zillion images manually.

In my case I have created a routine that captures all
the filenames of the images on the network and has the
key values for the specific datastructure to be used
in the F00165 table. The only missing link is a
function that would populate the BLOB field for the
record. The media object queue name and image filename
is known at this point.

If you know of any work arounds please let me know.
thnx

One World XE B7333 SP 14.1
Enterprise Server AS400


--- erichz <jdedwards@infinito.it> wrote:
> I need to create a F00165 record to
> indicate that an OLE Attachment link exists (e.g. an
> scanned invoice image residing on the network needs
to be attached to an invoice F03B11 record)...so I
would think we need to pass the name and location of
the linked object as parameters?"
> I would like an API to put OLE media object
> information into the F00165 tables.
> The reason client needs this API is that they have
> up to 50,000 attachments (images) that they will be
> upload- ing every night, and they need the ability
to link these attachments to specific JDE documents,
so that they can then drill down to these images via
the OLE object attachments (paperclip). Do you have
recommendations on the best way to accomplish this
with current version of OneWorld?
>
>
>
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Number=7466
>
> + - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - +
> This is the JDEList One World / XE Developers
> Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> + - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - +
>


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
 
Call Orchestrations From Excel – The Easy Way to Make the Orchestrator Work for You.

KevinCourtney

Active Member
Hello,

I'm also writing a UBE that reads through a series of filenames of images and I need to add their URL links to the F00165 table...

Did you ever get the "The only missing link is a function that would populate the BLOB field for the record." piece to work?

Thanks,
 

Jaguar

Member
Hello,

I attach my document into F00165, by standard jde update and insert function.
But there is a blob in f00165 then I must use the JDE api to connect F00165 and it only exist with interactive application.

Xe / Oracle
 

Adam (DF)

Active Member
Eric,

If you're still out there, how is the Attachment Manager software working out for you?

Adam
 
Top