Sometimes we may need to upload a lot of information into attachments because we are converting from a previous system or because we want to have all this detail information in JDE. In one of our recent projects, we were converting from World Software, and we decided to store some World information in E1 attachments.

Does JDE have a standard functionality for uploading attachments? Unfortunately, no. But JDE has a MBF which can be used in a custom process to upload attachments related to any application.

The MBF is B90CA892 (Function to Migrate Long Text to Media Object).

It has the following parameters (D90CA00TXT):

• Start time (Audit)
• End time (Audit)
• Text that the MBF will convert to BLOB (NOTESTXT).
• Attachment type (szNameObject). Example: GT1701
• Key (Master id / transaction id) (GenericTextKey). Example: 15200002
• Attached file name (NotesKeyword).

Based on this MBF, we developed a batch to upload attachment information from a csv file.

One of the attachment types we uploaded was for the Equipment master in the P1701 application.

We have prepared this CSV file (with hundreds of equipment and thousands of rows):

The first column contains the equipment number and the second column the text information we want to upload to the attachment.

Of course, the equipment must exist previously in the equipment master.

Some parameters have been included in the processing option of the process to know where the file with the information we want to upload is located, in what format and what will be the name of the attachment we are going to create in JDE.

The batch generates a PDF with the results of the upload, including any errors.

After running the batch, the attachments are uploaded to JDE linked with the equipment: