> For the complete documentation index, see [llms.txt](https://eohelp.weaver.com.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://eohelp.weaver.com.co/crm/more/import-export.md).

# Import/Export

## 1 List Data

The data displayed in the list is the same as that in the customer list.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FJDLysrAvGL6WhXbcpsfq%2Fimage.png?alt=media&amp;token=c02943c5-fa08-46f9-82a2-d9ee93d4288d" alt=""><figcaption></figcaption></figure>

By clicking on the list, the customer details open directly on the right side of the list, and the user can add contact records, contacts, opportunities, contracts, and new reminders.

## 2 Import

Step 1: In the top-right corner of the page, click "Import".

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FezIeIENCWc2QCZPPJ60y%2Fimage.png?alt=media&amp;token=52b6a8fe-10e0-4ebb-97cd-30ae1960253d" alt=""><figcaption></figcaption></figure>

Step 2: Export the template by clicking on "Export template"

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FKI3va2wxGPyhUCMBfwSi%2Fimage.png?alt=media&amp;token=a1e159a7-10cf-46c2-b45c-246c44df9fe6" alt=""><figcaption></figcaption></figure>

Step 3: Fill up the Excel template

\
Step 4: Select the updated Excel file by double-clicking on the file or click on the file and click "Open".

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FGwZfHpA6OhMT7OIr7XLP%2Fimage.png?alt=media&amp;token=01cac056-5ec2-40f4-ac1d-4eb3e39a3f7b" alt=""><figcaption></figcaption></figure>

Step 5: Select whether you would like to add new data or update the existing data, once done, click on "Start importing" to begin the import.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2Fhlp4sy46j6JgkokhhxxQ%2Fimage.png?alt=media&amp;token=68fb0a7d-681c-495f-9e3c-1b675e3663be" alt=""><figcaption></figcaption></figure>

When the import is complete, an Excel file will be generated to inform the user of the import status of all rows.

### 2.1 Import Success

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FgN7UnXGUpBTH0IQnrbjA%2Fimage.png?alt=media&amp;token=a16ed032-e7f3-4f08-8f45-f1d12674c950" alt=""><figcaption></figcaption></figure>

### 4.2 Import Fail

When the import failed, the system will provide the reason for failure in the import report.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2F3HWDuAflWqE1uiSylwPa%2Fimage.png?alt=media&amp;token=ec237d14-62f2-4c58-bf11-655a3c244a57" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2Fku9U5UPqm3S8B3xTBlYF%2Fimage.png?alt=media&amp;token=0c96eca3-fb94-4c5b-b65a-7c544cf4ead5" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FiYnYv0WhOGggO5s72bzC%2Fimage.png?alt=media&amp;token=a93e7ed7-eb4a-409b-b328-6993d3afacc7" alt=""><figcaption><p>Import Report.xlsx</p></figcaption></figure>

## 3 Export

Step 1: In the top-right corner of the page, click "Export".

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FmierXIlPmaE0wYjToEh8%2Fimage.png?alt=media&amp;token=a3d0d564-9a0b-4a14-8730-39b3bb049ddb" alt=""><figcaption></figcaption></figure>

Step 2: Select or de-select fields to be exported, and click "Confirm" to begin the process.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FlE4zgVo6HaxPwhdxL2D3%2Fimage.png?alt=media&amp;token=08a116bd-9fcf-474b-b43a-f967ab26bccf" alt=""><figcaption></figcaption></figure>

The system will automatically generate and download the exported data in Excel format onto the user's device.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FTA1ca5Pj0C6kbCvwG5tt%2Fimage.png?alt=media&amp;token=780006cf-fa99-47bb-b4fb-2ddfa5f64200" alt=""><figcaption></figcaption></figure>

**Remark:**

* This will export all the data that is shown on the current display list, across all pages. If your settings for the list are set to 10 results per page, the export will still include all existing data.
* The user can also export the desired data by filtering, searching, and applying query conditions before the export.

## 4 Filtering/Searching

### 4.1 Filter

#### 4.1.1 Existing Filter

The filter function allows users to refine or narrow down the data list based on the selected criteria.

Click on "More filters" to view more filtering options available.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FbpZ4Hn5ALC46rvuMtx8W%2Fimage.png?alt=media&amp;token=8857fa20-8582-4aec-b792-32e4b5c9d1c5" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FGxm0Fe9Q5dZjQLEBb10J%2Fimage.png?alt=media&amp;token=1e8741d8-5ef6-41dc-ba10-9e9d9c1d70a3" alt=""><figcaption></figcaption></figure>

#### 4.1.1.2 Create new filter

Users can save their preferred filter by entering/selecting the condition and click "Save" or "Save and Search" to be directed to the result straight away.

Step 1: Click on the ![](https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FoVQuiRteaaA2JsZC9rFm%2Fimage.png?alt=media\&token=6b3561ce-2149-48fd-9d2f-e946bd02ac39)icon next to the search box.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FQAVmS603OJ5mhiGCig5A%2Fimage.png?alt=media&amp;token=44b86a6e-6a70-4a63-b645-49fad9fb87be" alt=""><figcaption></figcaption></figure>

Step 2: Fill in the relevant condition and click on "Save".

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FnOQZhUKxHwANd6o3xLQV%2Fimage.png?alt=media&amp;token=709b8f0f-f771-4ebd-b984-0935277dc775" alt=""><figcaption></figcaption></figure>

A new filter condition will be created.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FFuEcKobvoS4BccF5PSWs%2Fimage.png?alt=media&amp;token=1cde3489-a34f-4721-ad2f-998bbd48a62f" alt=""><figcaption></figcaption></figure>

The filter name can be changed by clicking on ![](https://eohelp.weaverintl.com/~gitbook/image?url=https%3A%2F%2F1526800164-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F50DeL6mO9sNbAZBSEdaN%252Fuploads%252FGiv8FS6GDtry0O9h1y4x%252Fimage.png%3Falt%3Dmedia%26token%3D8fce9755-1bbf-4bcf-a0ed-3df562709353\&width=300\&dpr=4\&quality=100\&sign=40fe3c21\&sv=1)

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2Fl1wjWTP6jRcs0D5Loput%2Fimage.png?alt=media&amp;token=f0323cbe-7cfd-4cdf-a236-490094085a5f" alt=""><figcaption></figcaption></figure>

\
Click on the save icon when completed

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FmOx1d2WRddZHdhtlH5se%2Fimage.png?alt=media&amp;token=0284d0c5-485e-43cf-b9f7-a2c965822a26" alt=""><figcaption></figcaption></figure>

New filter is created.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2F0L0FSe5NwCtgQ2nyZSVq%2Fimage.png?alt=media&amp;token=c4925502-11e2-4ad7-b19c-2c0f7861a775" alt=""><figcaption></figcaption></figure>

In the Advance Search, click on the (X) to delete the filter.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FwPlvM8ISEoB21QRSnybw%2Fimage.png?alt=media&amp;token=b1f82794-d776-4652-aa32-88002f995b78" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FR6usmE1hyfWV5n0DU5a8%2Fimage.png?alt=media&amp;token=e6b42245-e976-4bd2-9933-cf1c6fcd6e71" alt="" width="291"><figcaption></figcaption></figure>

### 4.2 Search

#### 4.2.1 Simple Query

The user is able to search for customers using customer name, contact number, company address, account executive, customer service representative, contact name, contact phone number, and customer creator that are similar to or match the text entered in the search box.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FCrZgfoFGkJv9D8pa1vec%2Fimage.png?alt=media&amp;token=2e7ab9ab-3e10-439f-b5b2-068a3c7ddad2" alt=""><figcaption></figcaption></figure>

#### 4.2.2 Advanced Query

The \[Advance Query] allows the users to create complex searches or filters by specifying detailed conditions and criteria.\
Step 1: Click on the ![](https://eohelp.weaverintl.com/~gitbook/image?url=https%3A%2F%2F1526800164-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F50DeL6mO9sNbAZBSEdaN%252Fuploads%252FnjJDSlZsrXudSlnc2TJ3%252Fimage.png%3Falt%3Dmedia%26token%3Db1563e72-8c52-4583-9815-c9e73c48356d\&width=300\&dpr=4\&quality=100\&sign=2c534acb\&sv=1)icon next to the search box.

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2FtI6RSaSFdFqbLDQQQCZp%2Fimage.png?alt=media&amp;token=d4764fff-8e5d-45c4-8e4b-fa5972c37d25" alt=""><figcaption></figcaption></figure>

Step 2: Fill in the relevant condition and click on "Search".

<figure><img src="https://1526800164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F50DeL6mO9sNbAZBSEdaN%2Fuploads%2F37OKAsYwtKLoHYaBXK4f%2Fimage.png?alt=media&amp;token=06fe54e5-5a0f-4dc7-b769-1ef51df6b3ac" alt=""><figcaption></figcaption></figure>

<br>
