Skip to main content
Contact a Moderator

Question

5
Replies
2179
Views
 abhishek khanna (abhishekk1931) IHIS Pega Technical Manager
IHIS
SG
abhishekk1931 Member since 2015 7 posts
IHIS
Posted: May 25, 2017
Last activity: October 16, 2018
Posted: 25 May 2017 5:11 EDT
Last activity: 16 Oct 2018 12:03 EDT
Closed
Solved

Migrate External file to Pega DB in Pega 7.2.2

Report

Hi Team, i have requirement that system should able to download the external file to pega DB.

File can be word,xlsx,txt , client needs to migrate the attachments saved for the cases to new system.

Please assist.


**Moderation Team has archived post**


This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Pega Customer Service Low-Code App Development Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 5 years ago
Posted: 26 May 2017 1:09 EDT
Sudhakar Reddy Yaparla (SudhakarReddy) PEGA Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hi,

Please share the information where the files are there, these are in other database or in directory. How these files are associated with cases in existing application.
Posted: 5 years ago
Posted: 9 Jun 2017 21:54 EDT
abhishek khanna (abhishekk1931) IHIS Pega Technical Manager
IHIS
SG

HI Yapas,

As part of data migration from mainframe these data will come to Pega server.

Existind data has path of the file, as part of migration i need to include file in Pega table for future reference.

there no case or work object involved, this pega table will only be used as reference for the old cases and the respective data.

Please let me know if anything else is required

Accepted Solution

Posted: 5 years ago
Posted: 8 Jul 2017 23:24 EDT
abhishek khanna (abhishekk1931) IHIS Pega Technical Manager
IHIS
SG

I was able to achieve the above functionality by following below steps:

1: Create a data type "DATA", which inherits from Data-WorkAttach-File

2: Create a data Type "Profile", which will be referred in place of work class.

3: Create an activity in Profile Class, parse attachment file using Java and do property set to the DATA class Page

4: Call Link Object in Activity with link-Attachment class and DATA  (as mentioned in the image attached)

this will emulate Work - Link - Data  architecture, for display of attachment please change DIsplay HTML to take your "DATA" class and openAttachment

 

Please let me know for any further clarification

 
Posted: 4 years ago
Posted: 1 Nov 2017 7:04 EDT
Santhosh Praneeth Bheema (SanthoshPraneethB) Infosys
Infosys
IN

HI Abhishek,

We have a similar requirement of migrating attachments.

we placed the entire folder in pega server & trying to attach the files to cases.

 

Can you share the entire activity including how to parse in java.

 

thanks
Posted: 4 years ago
Posted: 6 Nov 2017 20:43 EST
abhishek khanna (abhishekk1931) IHIS Pega Technical Manager
IHIS
SG

HI Santhosh, Please use below code for sample and try to use below code for the parsing attachment.

Show More

HI Santhosh, Please use below code for sample and try to use below code for the parsing attachment.

String fileName = StringUtils.encodeCrossOSString(strFileName.substring(lio, strFileName.length()));
java.util.HashMap hmFileInfo = new java.util.HashMap();
PRFile objFile = new PRFile(strFileName);
//some error checking
if (!objFile.exists())
{
         objFile = new PRFile(strFileName);
         if (!objFile.exists())
         {
                throw new PRRuntimeException("Can't continue with file attachment. File \"" + strFileName + "\" doesn't exist");
         }
}
 
if(!objFile.isFile())
{
                throw new PRRuntimeException("Can't continue with file upload. \"" + strFileName + "\" is not a file.");
}
 
if (!objFile.canRead())
{
                throw new PRRuntimeException("Can't continue with file upload. File \"" + strFileName + "\" is unreadable.");
}
 
//read the file into a buffer.
java.io.DataInputStream dis = null;
byte buffer [] = null;
StringBuilder strFileData = null;
oLog.infoForced("7");
try
{    
                dis = new java.io.DataInputStream(new PRInputStream(objFile));
                // Make sure this buffer is (Multiple of 3) + 1
  int bufferSize = 2048001;
                int fileSize = dis.available();
  // This is important, An incorrect initial size can have adverse effects for big files
                strFileData = new StringBuilder((int) (fileSize * 1.4));
                int noOfIterations = fileSize / bufferSize;
  for (int j = 0; j < noOfIterations; j++) {
                                buffer= new byte[bufferSize];                                                  
                                dis.read(buffer, 0, bufferSize);
                                strFileData.append(Base64Util.encodeToString(buffer));
                }
 
                // Put remaining
                int remaining = fileSize % bufferSize;
                buffer = new byte[remaining];                                                  
                dis.read(buffer, 0, remaining);
                strFileData.append(Base64Util.encodeToString(buffer));
                dis.close();
oLog.infoForced("Batman 6 "+strFileData);
if (strFileData == null)
{
throw new PRRuntimeException("Can't continue with file upload. Couldn't encode the file to Base64 so that we can store it on the database");                                           
}

Show Less

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice