xCP2.2: How to provide auto extract email properties while importing email from xCP Application

community

Hi Experts,

May I know, how to extract email properties and set it as properties while importing emails (msg format).

auto extract and populate email properties on xCP import screen.

community

Hi,

I have done this be following procedure.

1. While Import, files are stored at temp location (between you import and click finish button)

2. Execute java service to extract email properties (Input will be above file path, including file name)

3. Output of Java Service will be "Value Object", which holds all email related information

4. Set these values to your custom object type fragment inputs

Swati.Bhatia

You may use Mdmo Message Aspect.

It will not extract and populate on xCP import screen but the same will happen in back-end.

If MDMO aspect attached to Content type, during import, email metadata will be extracted and saved in MDMO aspect attributes.

You will have to install MailApp.dar  onto the repository and use Mdmo Message Aspect  available in the optional library msgtf.messagetypefragment-1.0.0.jar present in in “OptionalLibs” where xCP Designer is  located.

community

Hi Swathi,

Thanks for that Information you given, the steps are already in-place, when email import from xCP, after successfully import, it showing all email related property values when I dump that object.

but my user want to show values while importing itself, is this possible in xCP 2.2 or need any customization,  what is the best way to achieve this requirement.

community

Hi Experts,

Before Import into repository, can I extract email properties using poi API ? I mean in Import widget, while adding files.

DCTM_Guru

Import widget does not read (and process) the file until the import page is filled out.  In order to do this prior to import transaction of being completed, you actually need to get access to the file on the client.  To do that, you need to get around browser security sandbox via applet.

I would speak to the users and really find out the requirement before going down this path.  Its a lot of effort for something that isnt really a requirement.  For example, we had similar requirement to perform anti-virus scan on documents that were getting imported.  It was very difficult to perform the scan as part of the import process, but it was relatively easy to perform it after the document was uploaded to the server AND prior to the entire transaction being committed (via TBO).

community

Thanks Gee,

I have told same to my customer, actually we are replacing D2 with xCP, users are expecting same functionalities as D2, currently D2 have this facility, however D2 handling this in different way.

One more questing, can we filter Folder Content Query Result set ? I mean, user having thousands of documents in a folders, the current result set widget do not have any Filtering function to cut down list of documents in a folder to see, this is a user friendly requirement, otherwise user have to navigate all the pages to find his document in that folder.

Current Resultset Widget have Sort Ascending and Sort Descending, I want add one more text field, so that user can enter some thing to filter that list.

I have posted this in another thread you can replay to that, If you have any idea or workaround.

Thanks,

Jeevan

community

Hi,

I have done this be following procedure.

1. While Import, files are stored at temp location (between you import and click finish button)

2. Execute java service to extract email properties (Input will be above file path, including file name)

3. Output of Java Service will be "Value Object", which holds all email related information

4. Set these values to your custom object type fragment inputs