Integration Framework : Application Import and Export & Change status

This feature supports the import and export of data directly from applications, such as PO orWork Orders. This allows users to perform import and export of data without having to having access to the I-F External System application 

 

      User can just export the application and do the required  modification in the application without approaching  I-f external system

 

      New functionality allows the user to export the data to a formatted file that can be maintained in an Excel spreadsheet. The user can apply changes across one or more rows of data in the spreadsheet and when completed, the data can be imported back into Maximo.

 

      The application-based import and export functionality relies on the object structure component of the integration framework to define the data content and any processing classes (Java) that are needed to facilitate the exporting and importing of data. No other integration framework components (such as publish channels, JMS queues & end points) need to be configured. Administrator will enable the integration for an application using a provided object structure or by creating a new object structure.

 

         

Use the following steps to duplicate the MXPO object structure:

 

 

1 . From the Maximo Admin Console select ‘Go To’ -> ‘Integration’ > Object Structures’

2 . Click on the ‘Object Structure’ tab

3 . Type ‘MXPO’ in the ‘Find’ dialog.

4 . Press Return. The MXPO Object Structure will be displayed.

5 . In the ‘Select Action’ drop down box, choose ‘Duplicate Object Structure’.

6 . Assuming you duplicated MXPO and created NEWMXPO, based on your user’s requirements, you could delete all the objects except PO

 

 

7 . Once that is done your user may also want to limit the number of Po fields that are available. PO , by default has over 80 fields in the object and having a spreadsheet with that many columns can be difficult to maintain.Your user may only want/need to use up to 20 fields.

8 . To support this, the object structure application has a Select Action, Include/Exclude Fields, that allows the administrator to define which persistent and non-persistent fields are to be included in the data that is exported and imported.

9 . If you are exporting in flatfiles file formate the go for Add/Modify Alias of select action , to assign unique field name where there are currently duplicates..

10 . From Select Action, click on Add/Modify Application Export Support, that allows you to enable exporting to an application            

11 . In the dialog (above), select New Row and the application will default to an application that has a main object that is the same as PO . The Default File Type can be set so that your user will not have to select this object structure each time.

 

 

12 . Select Action, Add/Modify Application Import Support, that allows you to enable importing to an application (save the object structure before using this Select Action).

13 . In the dialog (above), select New Row and the application will default to an application that has a main object that is the same as PO . The Default File Type can be set so that your user will not have to select this object structure each time. So if your users will primarily use the data in a spreadsheet you should select Flat File.

 

 

 

Use the following steps to Grant Security access:

1. From the Maximo Admin console select ‘Go To’ -> ‘Security Groups’

2. Select ‘Application’ tag

3. Select ‘Asset’ Application

4. Select ‘Application Import’ and application export

 

5. Check the ‘Grant Access’ box

6. Select the ‘Save’ icon

7. logout and login

8. you can see import and export icons in your applications

 

Steps to follow while exporting :

 

1 . Select new record and fill all the required values

 

 

2 . Save the record

3 . Now click export application icon to export the data and fill the details .such as name of object structure which we have created and configuration format 

  

4 . Save the downloaded xml file 

 

 

 

5 . Open the downloaded xml file in edit++  Let us change the status of record to approve and any other updates  let it be description 

 

 

Steps to follow while importing :

 

6 .Now we need to import the xml modified by us

7 . Open po and click on application import .select the object structure and import configuration

 

 

 

8 . Click ok to start importing

9 . You can see th changes by opening the  po 1009 status as appr and description as purchase order for my organization 

 

 

  ALL the best