Import/export template > Module CRM activities > Import/export template OPPCRM (CRM Projects) 

Use this template to import Customer relation (CRM) project data from any third party product into Sage X3 and to export from Sage X3. You can also use this template to delete project data.

Import is authorized in modification mode, provided that the functional rules are complied with.

Mandatory fields in the template

The template is based on the screen and classes.

The mandatory fields are defined in the project classes.

On creation:

  • Before-sales stages must be included in the import data if defined in the import template.
    Before-sales stages created automatically for the transaction based on the setup are deleted.
  • After-sales stages should be included in the import data if defined in the import template.
    After-sales stages created automatically for the transaction (outside the standard process) are deleted.

Special features

Header/Project

You must include all mandatory fields.

Competitors

When running the import in modification mode, the Competitor - CPP value is searched against the collection.

  • If this value is not found, a new line is created.
  • If the value is found, the corresponding line is modified.

Before-sales stages

When running the import in modification mode, the Date - ENDDAT and Step - STE values are searched against the collection.

  • If this association of values is not found, a new line is created.
  • If it is found, the corresponding line is modified.

After-Sales stages

When running the import in modification mode, the Date - ENDDATX and Step - STEX values are searched against the collection.

  • If this association of values is not found, a new line is created.
  • If it is found, the corresponding line is modified.

Associated projects

When running the import in modification mode, the Code - SBBPJ value is searched against the collection.

  • If this value is not found, a new line is created.
  • If the value is found, the corresponding line is modified.

Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

ATEXTRA [AXX]

Texts to translate

AUTILIS [AUS]

Users

BPARTNER [BPR]

Business partner

BPCUSTOMER [BPC]

Customers

CMARKETING [CMG]

Marketing campaign

CONTACT [CNT]

Contacts

CONTACTCRM [AIN]

Contact relationships

MAILING [OMM]

Mass mailing

MEDIA [OMN]

Media campaign

OPPOR [OPP]

Project

OPPORCPP [OCP]

Project competitor

OPPORCRM [OPPCRM]

CRM project

OPPORSBB [OBB]

Sub-project

OPPORSTA [OSA]

Project after-sales steps

OPPORSTB [OSB]

Project pre-sales steps

PHONING [OMP]

Phone campaign

PIMPL [PIM]

Project link

SALESREP [REP]

Sales rep

SERREQUEST [SRE]

Service requests

SQUOTE [SQH]

Quote header

TABCUR [TCU]

Currency table

TRADESHOW [OMT]

Professional trade shows