New Data Source second page (for file import) field descriptions

Last Updated : Oct 28, 2025 |

Use this page to create a data source using the File Import option. After selecting the File option and adding other relevant information on the New Data Source first page, POM displays the New Data Source second page with the options listed in the following table:

Note:

Ensure that the SFTP service is enabled on the server where data source file is located. By default, the SFTP service is enabled on Experience Portal Manager.

Field or Button

Description

Create Data Source Using

Use option button to select import from:

  • Local File Import

  • SFTP File Import

    Note:

    You can upload contacts using SFTP only for files up to 1 GB in size.

  • Browse File

Note:

This field is unavailable for editing after you save the data source.

Local File Import

Use if the source file is located on the local machine. In Upload Contacts From File, you must mention the Local path on the POM server (Including file name) as the path from where the file uploads. The following is the Recommended path: /opt/Avaya/avpom/POManager/public/default/contactlistimport/

To import a file, ensure that the avayavp user must have read permission on the file and all its parent directories. The root user can enable or disable the permissions by using the command chmod 455.

For example, to import a file called contacts.csv from the location,/home/craft/Contacts/Files/Today/contacts.csv, ensure that you assign READ permission to all directories individually in the path, using chmod command.

You can import files having either ANSI or UTF-8 w/o BOM format.

You cannot use the following characters:

  • ^

  • ~

  • `

  • !

  • '

  • ;

  • #

  • $

  • %

  • @

  • |

  • :

  • <

  • >

  • ?

  • *

  • \

Important:

For 8.1.1 and later versions of Avaya Experience Portal, when a user copies a file to the POM system with the Local File Import option, the owner and group values of the user id are assigned. All the permissions (read, write, and execute) for other users are removed. Therefore, you cannot copy a file with the Local File Import option as other users.

To enable local file import for 8.1.1 and later versions of Avaya Experience Portal, do one of the following:

  • Make avayavp the owner of the file.

  • Include the user in the avayavp group.

  • Enable read permission for the other users for the file.

Note:

The following is applicable only if you select the Exclude Contacts option.

If you want to exclude contacts for specific number of days, use EXC_DNC_UNTIL_X_DAYS column in the file.

For example,

ID,EXC_DNC_UNTIL_X_DAYS
1,10
2,5
3,
4,
5,2

When datasource configured with this file will run, contact record with ID 1 will be excluded for 10 days, record with ID 2 for 5 days, record with ID 5 for 2 days.

For ID 3 and 4, no value is specified, hence these 2 records will be excluded permanently.

EXC_DNC_UNTIL_X_DAYS column is optional and should be used only if you want to exclude contacts for specific number of days. If this column is not specified in the file then contacts will be excluded permanently.

SFTP File Import

To import using the Secure File Transfer Protocol (SFTP).

Note:

For SFTP server, if the PasswordAuthentication is set to No in the /etc/ssh/sshd_config file, you might get Auth Fail error. By default, the PasswordAuthentication value is set to No. Ensure you set the PasswordAuthentication to Yes. If you change the PasswordAuthentication value, then restart the sshd service for the changes to take effect.

Specify the following parameters:

  • Secured: Enable this option to use a secure file transfer protocol for import.

  • SFTP Host name: Specify the hostname or IP address of the SFTP server.

    Note:
    You cannot use the following characters:

    • ^

    • ~

    • `

    • !

    • '

    • ;

    • #

    • $

    • "

    • <

    • >

  • User Name: Specify the username to connect to the SFTP server.

    Note:

    • POM does not support Anonymous user.

    • You cannot use the following characters:

      • ^

      • ~

      • `

      • !

      • '

      • ;

      • #

      • $

      • "

      • <

      • >

  • Password: Specify the password to connect to the SFTP server.

  • Remote Path: Specify the remote location of the data source file.

    Note:

    • POM uses standard port 22 for SFTP.

    • You cannot use the following characters:

      • ^

      • ~

      • `

      • !

      • '

      • ;

      • #

      • $

      • %

      • @

      • |

      • :

      • <

      • >

      • ?

      • *

      • \

Note:

The following is applicable only if you select the Exclude Contacts option.

If you want to exclude contacts for specific number of days, use EXC_DNC_UNTIL_X_DAYS column in the file.

For example,

ID,EXC_DNC_UNTIL_X_DAYS
1,10
2,5
3,
4,
5,2

When datasource configured with this file will run, contact record with ID 1 will be excluded for 10 days, record with ID 2 for 5 days, record with ID 5 for 2 days.

For ID 3 and 4, no value is specified, hence these 2 records will be excluded permanently.

EXC_DNC_UNTIL_X_DAYS column is optional and should be used only if you want to exclude contacts for specific number of days. If this column is not specified in the file then contacts will be excluded permanently.

Browse File

Use to upload contacts in the selected contact list or exclude contacts from the selected contact list, using a .csv file. After uploading contacts, POM creates a data source record. You cannot edit or schedule this data source. You can only delete the data source. POM creates this data source entry for upload contacts.

Note:

The following is applicable only if you select the Exclude Contacts option.

If you want to exclude contacts for specific number of days, use EXC_DNC_UNTIL_X_DAYS column in the file.

For example,

ID,EXC_DNC_UNTIL_X_DAYS
1,10
2,5
3,
4,
5,2

When datasource configured with this file will run, contact record with ID 1 will be excluded for 10 days, record with ID 2 for 5 days, record with ID 5 for 2 days.

For ID 3 and 4, no value is specified, hence these 2 records will be excluded permanently.

EXC_DNC_UNTIL_X_DAYS column is optional and should be used only if you want to exclude contacts for specific number of days. If this column is not specified in the file then contacts will be excluded permanently.

Maximum allowed file size is 50 MB.

How are fields separated from each other?
Use to specify the separators used in the file for separating fields. The separators can be:

  • Comma (,)

  • Tab

  • Colon (:)

  • Semi colon (;)

  • Pipe (|)

  • Other

    The following are the other separators you can use:

    1. #

    2. $

    3. &

    4. %

    5. .

    6. /

    7. \\

Note:

If the contact data contains the selected delimiter, then you need to manually append double quotes to the data which has the same delimiters.

For example,


Contact List Attributes - id, name, address, age
Two contacts are:
1,Alex,'This is my address',45
2,Oanh,'This, is, Jane's, address',35
Now let's consider we have exported this list so that we will get data like below after export,
1,Alex,This is my address,45
2,Oanh,This, is, Jane's, address,35

The data should be in the following format if it contains the delimiter:

2, Oanh, "This, is, Jane's, address", 35

Note here that the second record contains delimiter(,). Therefore, this data is encapsulated in double quotes ('').

Finish

Use this to complete the data import wizard.
Related information
Adding data sources