Write OLE info to F00165 System H92 OneWorld XE

[erichz]

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]

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 <[email protected]> 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/

 

[erichz]

Could you send me a copy from your routine that captures all
the filenames of the images on the network
Please send me this to [email protected]
Thanks

 

[erichz]

Help

 

[KevinCourtney]

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,

 

[Alex_Pastuhov]

We have this routine available commercially.

BTW, Erich is now using it.

 

[Jaguar]

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)]

Eric,

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

Adam