
To leverage the AI capabilities of Synerise, personalize communication, and explore numerous other possibilities, you need a seamless method of importing your customer profiles. Whether you're migrating from another system or starting from scratch, our Imports feature, available in Data Modeling Hub, offers a streamlined process for importing profiles into our platform. Unlock the complete potential of your customer data with Synerise and gain invaluable insights to drive your business forward. By utilizing the Imports feature, you can conveniently upload and integrate customer data in CSV files, ensuring a smooth transition and accurate representation of your customer base. 

In this use case, you will import customers' data to Synerise using a `.csv` file in a seamless and efficient manner.

## Prerequisites 
---
- Prepare a `.csv` file that contains one of the following profile identifiers: (the list contains recommended column names, if you use different names you will be able to map data during the process):
    - `email`,
    - `uuid`,
    - `clientID`,
    - or `customID`. 

    This is the only required column, the rest is optional.

   <div class="admonition admonition-warning"><div class="admonition-icon"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2.5"><path stroke-linecap="round" stroke-linejoin="round" d="M12 9v2m0 4h.01m-6.938 4h13.856c1.54 0 2.502-1.667 1.732-2.5L13.732 4c-.77-.833-1.964-.833-2.732 0L4.082 16.5c-.77.833.192 2.5 1.732 2.5z" /></svg></div><div class="admonition-body"><div class="admonition-content">

   If you choose an email as an identifier, pay attention to the correct format of emails. Otherwise, your import will fail.

   </div></div></div>


  <div class="admonition admonition-note"><div class="admonition-icon"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2.5"><path stroke-linecap="round" stroke-linejoin="round" d="M13 16h-1v-4h-1m1-4h.01M21 12a9 9 0 11-18 0 9 9 0 0118 0z" /></svg></div><div class="admonition-body"><div class="admonition-content">

  In this case, we will use data from a sample file, which can be downloaded during the [Select the file for import](#select-the-file-for-import) step, using the **Get Sample File** button.

  </div></div></div>

- `.CSV` files must be UTF-8 encoded, spaces and special characters in the column headers are not allowed. Check [tips for preparing a CSV file](/docs/assets/imports/importing-clients#tips-for-preparing-a-csv-file).

## Select the file for import
---
In this part of the process, you will upload a file from your device.

1. Go to **Data Modeling Hub > Imports> New import**.
2. As the data type for import, select **Profiles**.
3. As the import method, to import a single `.csv` file to Synerise, select **Import a local file**.
4. To upload the `.csv` file, click the **+ Upload file or drag one here field** .
5. Optionally, you can customize the file metacharacters by clicking the arrow down icon next to **Customize file markup**.
    1. From the **Delimiter** dropdown, select the character that marks the end of a column.
    2. From the **Quotation mark** dropdown list, select the characters that contain the text.
    3. From the **Escape character** dropdown lists, select the character which changes the default interpretation of a character or a string followed by the escape character.
6. You can preview the data output by clicking **Preview data**.
7. Click the **Next** button to upload the file.
8. When the file is uploaded, click **Next** to proceed.

<figure>
<img src="/api/docs/image/54176ad07f146575310749eba44b7c2f42c1b327/use-cases/all-cases/_gfx/import-profiles.png" alt="The view of the Import Profiles configuration"  class="large">
<figcaption>Import Profiles configuration</figcaption>
</figure> 

## Mapping the columns with parameters in Synerise
---
In this part of the process, you will connect the columns from the file with their counterparts (the existing attributes) in Synerise. This way, you will point which parameters in Synerise will contain the profile information from the imported file.
You can also exclude parameters from the import. 
<!-- During the mapping process, you can’t add new columns to the imported file. -->

On the user interface, you will be presented with two columns - the left column displays the names of the columns from the imported file, the other contains dropdown lists with the parameters available in Synerise. The dropdown lists indicate required parameters for a successful import.

If you skip mapping the non-required parameters, the name of these parameters will be the same as the names from the imported file. If parameters don't exist in Synerise, they will be imported as new parameters.

1. Next to the file column name, from the dropdown list, select the corresponding parameter in Synerise. Perform this step for all columns in your file.

    
   <div class="admonition admonition-note"><div class="admonition-icon"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2.5"><path stroke-linecap="round" stroke-linejoin="round" d="M13 16h-1v-4h-1m1-4h.01M21 12a9 9 0 11-18 0 9 9 0 0118 0z" /></svg></div><div class="admonition-body"><div class="admonition-content">

   In our case, we do not need to map the parameters, because the uploaded file meets all the requirements from the prerequisites.

   </div></div></div>


2. To exclude a parameter from import, next to the column name, click this icon: <img src="/api/docs/image/54176ad07f146575310749eba44b7c2f42c1b327/use-cases/all-cases/_gfx/remove.png" alt="Exclude paramater icon" class="icon">

    <figure>
    <img src="/api/docs/image/54176ad07f146575310749eba44b7c2f42c1b327/use-cases/all-cases/_gfx/profilesmapping.png" alt="The view of the mapping process"  class="large">
    <figcaption>Mapping</figcaption>
    </figure> 

3. To proceed to the summary of the import, click **Next**.  
**Result:** The summary of the import is displayed.

    <figure>
    <img src="/api/docs/image/54176ad07f146575310749eba44b7c2f42c1b327/use-cases/all-cases/_gfx/importsumm.png" alt="The view of the import summary"  class="large">
    <figcaption>Import summary</figcaption>
    </figure> 

4. After checking the import summary, to start the import, click **Run import**.
5. You can monitor the status of your import and potential errors due to incorrect data in the **Imports List**.

## Read more
---

- [Imports](/docs/assets/imports/introduction-to-imports)
