WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

2020-07-25T02:34:23Z

Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"

2020-07-15T11:46:18Z

Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Bgrenon: Published

2020-06-08T14:25:58Z

Published

New page

{{Article
|Standalone=No
|DisplayName=Import Specification Files
|TocName=Import Specification Files
|Context=Learn how to apply a specification file to a contact list.
|ComingSoon=No
|Platform=PureEngage
|Role=Administrator
|Application=CX Contact
|Section={{Section
|alignment=Vertical
|structuredtext=If you don't want to apply a {{Link-SomewhereInThisManual|topic=DataMapping|anchor=top|display text=data mapping schema}} to a contact list being imported into CX Contact, you can use a specification file.

An input specification file (*.spc) is a text file used to identify the location of the fields in your data that are needed to populate your contact list. For example, if the First Name field starts at the seventh position in your data format, that information is included in the input specification file. Using the specification file, you can selectively extract some of the fields from your data while ignoring the ones you don't need. Here's an example:

[[File:CXC_SampleSPC.png|400px|center]]

The topics covered on this page are as follows:

*{{Link-SomewhereInThisManual|topic=ListsSpecFiles|anchor=ImportSpecFiles|display text=Import a specification file}}
*{{Link-SomewhereInThisManual|topic=ListsSpecFiles|anchor=SpecKeywords|display text=Specification file keywords}}
*{{Link-SomewhereInThisManual|topic=ListsSpecFiles|anchor=SpecDBTable|display text=Specification files and contact list database tables}}
|Status=No
}}{{Section
|sectionHeading=Import a Specification File
|anchor=ImportSpecFiles
|alignment=Vertical
|structuredtext=Once you have created the specification file, use the following steps to import the file:

#On the Specification Files page, click '''New'''.
#In the Type field, leave the '''Input''' option.
#Click '''Select File''' to locate the file on your PC or network. Input specification files must be text files with an spc extension.
#Specify a name (required) and description (optional) for the specification file.
#Click '''Import Specification'''.

{{NoteFormat|If you attempt to upload a specification file that is not formatted correctly, the system will return an error and the file will fail to upload.}}

All specification files appear in a table on the main Specification Files page. The table contains the following information for each specification file:

{{{!}}
{{!}}-
{{!}}'''Name'''
{{!}}The name of the specification file.
{{!}}-
{{!}}'''Description'''
{{!}}A description of the specification file (if you provided one.
{{!}}-
{{!}}'''Type'''
{{!}}The type of specification file. The default is Input.
{{!}}-
{{!}}'''Last Modified Date'''
{{!}}The date the specification file was last modified.
{{!}}-
{{!}}'''Created Date'''
{{!}}The date the specification file was initially imported.
{{!}}-
{{!}}}

Once you import a specification file, you can use the tools in the Actions menu to do any of the following:

{{{!}}
{{!}}-
{{!}}'''Edit'''
{{!}}Click the pencil icon to edit any of the specification file's properties.
{{!}}-
{{!}}'''Download'''
{{!}}Click the download icon to download a specification file.
{{!}}-
{{!}}'''Delete'''
{{!}}Click the trash can icon to delete a specification file.
{{!}}-
{{!}}}
|Status=No
}}{{Section
|sectionHeading=Specification File Keywords
|anchor=SpecKeywords
|alignment=Vertical
|structuredtext=The following table lists specification file keywords and the corresponding {{Link-SomewhereInThisManual|topic=AboutLists|anchor=ListFields|display text=contact list fields}} they map to.
{{{!}}
!Keyword
!Contact List Field
{{!}}-
{{!}}
*fname
*first name
*firstname
{{!}}c_first_name
{{!}}-
{{!}}
*lname
*last name
*lastname
*name
{{!}}c_last_name
{{!}}-
{{!}}
*company
{{!}}c_company
{{!}}-
{{!}}
*other1-otherN
{{!}}c_other1
(applies to other1-otherN)
{{!}}-
{{!}}
*clientid
*client id
{{!}}c_client_id
{{!}}-
{{!}}
*tz
*time_zone
*timezone
{{!}}c_tz_uid
{{!}}-
{{!}}
*zip
*zip_code
*zip code
*postal_code
*postal code
{{!}}c_postal_code
{{!}}-
{{!}}
*country
*country_code
*country code
{{!}}c_country_code_iso
{{!}}-
{{!}}
*state
*region
{{!}}c_state_code
{{!}}-
{{!}}}
|Status=No
}}{{Section
|sectionHeading=Specification Files and Contact List Database Tables
|anchor=SpecDBTable
|alignment=Vertical
|structuredtext=If you use a specification file before uploading contact data into CX Contact and you use user-defined fields in the specification file, CX Contact will store the user-defined data for fields Other1-Other20 in the main calling list table, and it will store user-defined fields from Other21 and onward in the secondary table.

{{AnchorDiv|SpecExample}}
Here is an example specification file:

<pre>
FirstName:s/<CSV>/$1/
LastName:s/<CSV>/$2/
ClientID:s/<CSV>/$3/
HomePhone:s/<CSV>/$4/
WorkPhone:s/<CSV>/$5/
CellPhone:s/<CSV>/$6/
Other1:s/<CSV>/$7/
Other2:s/<CSV>/$8/
Other3:s/<CSV>/$9/
Other4:s/<CSV>/$(10)/
Other25:s/<CSV>/$(11)/
Other28:s/<CSV>/$(12)/
</pre>

That yields the following input file:
<pre>"John","Snow","540-18-4455","+16504661200","+19252381988","+14159873456","O1value","O2value","O3value","O4value","O25value","O28value" </pre>

Now here are the contact list tables that are created from this file:

[[File: CXC_ListTableFromSpec.png|center]]
|Status=No
}}{{Section
|sectionHeading=Related Topics
|anchor=RelatedTopics
|alignment=Vertical
|structuredtext=*{{Link-SomewhereInThisManual|topic=DataMapping|anchor=top|display text=Create a Data Mapping Schema}}
|Status=No
}}
}}

@@ Line 5: / Line 5: @@
 |Context=Learn how to apply a specification file to a contact list.
 |ComingSoon=No
-|Platform=GenesysEngage-onpremises
+|Platform=GenesysEngage-cloud
 |Role=Administrator
 |Application=CX Contact

PEC-OU/Current/CXContact/ListsSpecFiles - Revision history

WikiSysop: Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Bgrenon: Published

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"