IRP Shopper
Common Tasks (1)
Open
Interventions (1)
Open
Languages (1)
Open
Questions & Answers (1)
Open
Reviews (1)
Open
Site Scripts (1)
Open
Web Services (1)
Open
Training Videos
Peer Support

Overview - New (Integration)

You can find this section under Integration > Overview - New in the IRP Admin left navigation menu.

The page presents you with an overview of ‘dynamic’ integrations on the IRP. The page also provides you with summary log files that show what integration actions have been carried out and when they occurred, whether or not those actions were successful and details such as the name of the IRP Admin users who performed the integrations.

This is useful information because, if you notice that some data has been incorrectly formatted or that it is wrong in some way or other on your website, you need to know when the integration was carried out and by whom. You can then proceed to contact the user for more details, if necessary. You can then go on to correct the errors.

IntegrationOverview.aspx page

The main dynamic integration page (IntegrationOverview.aspx) appears as follows (note that what you see here depends on what integrations have taken place and so your page may not look exactly like the screen capture that follows):

IRP Admin image

The page includes the following summary information:

  • Last Integrated: This is the date and time when this integration was last run.
  • Integration Type: This is the type of this integration or the main database tables it performs operations on (products, stock levels, orders, pricing or other).
  • Integration File Last Uploaded: This is the date and time when data was last uploaded for this integration.
  • Integration Data Last Staged: This is the date and time that data was last staged to the database as part of this integration.
  • Integration SQL Set Up: This indicates whether the SQL query has been set up for this integration.
  • Automation Enabled: This indicates whether automation is allowed for this integration.
  • Data Manipulation Steps: This is the number of data manipulation steps that have been set up as part of the data staging step in this integration.
  • Rows in Staging Table: This is the number of rows in this integration’s staging database table.
  • Has Automation URL: This specifies whether this integration has a URL enabling it to be automated via a common task.
  • Historical Files: This is the number of history log entries made against this integration.

Note: If previous integrations have been carried out, you can click the Download Latest File button on the IntegrationEdit.aspx page to download the latest uploaded integration file

You can use the following buttons to edit the integration details or carry out the integration:

  • Edit: Click this button to go to the IntegrationEdit.aspx page for the integration. From here you can modify many of the integration details that were defined when the integration was created.
  • Perform: Click this button to manually execute the integration.

You can add dynamic integrations by clicking the Add New Integration button at the top of the page. Also you can click the Legacy Integrations button to go to the Legacy Integrations Overview page, as described in the Legacy Integrations help topic.

You can add Integrations by clicking the Add New Integration button at the top of the page.

Also you can click the Legacy Integrations button to go to the main UniversalIntegrationOverview.aspx page where you can see an overview of legacy Integrationintegrations, as described in the Legacy Integrations help topic.

History log

Click the History Log button at the top of the page to see the following summary information. You can use the search bar to find particular files and if you expand Other Options under the Search bar, you can search by Integration or Admin User:

  • ID: This shows the ID of the entry in the log file.
  • User: This shows the username of the IRP Admin user who carried out the integration.
  • Integration: This shows the name of the integration.
  • Notes: This shows a description of the integration operation, for example 'Integration Updated', 'Custom Manipulation Data Manipulation Step Added', 'Automated Integration Attempted but No Data Sent in Communication', etc .
  • Success: This shows whether the action was successful (True) or unsuccessful (False).
  • TimeStamp: This shows the date and time when the user carried out the action.

Application Settings for integrations

You can use the following Application Settings for Integrations (these are located in the 'Integration' grouping):

  • Universal Integration Custom File Has Column Names: Set to true if the Stock file uploaded using the Universal Stock Integration has column headers.
  • Universal Integration Custom Integration Query: The Stock Integration SQL Query for Integrating Stock using the Universal Stock Integration functionality.
  • Universal Integration Stock File Has Column Names: Set to true if the Stock file uploaded using the Universal Stock Integration has column headers.
  • Universal Integration Stock Integration Query: The Stock Integration SQL Query for Integrating Stock using the Universal Stock Integration functionality.
  • Universal Integration Stock Levels File Has Column Names: Set to true if the Stock Levels file uploaded using the Universal Stock Levels Integration has column headers.
  • Universal Integration Stock Levels Integration Query: The Stock Levels Integration SQL Query for Integrating Stock Levels using the Universal Stock Level Integration functionality.

How To Guides (1)

Close
Open
How To Add a Dynamic Integration

Copyright © 2020 IRP Commerce. Use of this website constitutes acceptance of the IRP World Terms of Use, IRP Privacy Policy and IRP Cookie Policy

IRP Commerce Limited, Concourse 3, Catalyst, BT3 9DT, UK. Company Number: NI 041856. VAT Number: GB 888249658
A Deloitte Fast 50 Company seven times: 2010, 2011, 2012, 2013, 2014, 2018 & 2019