====== Using the Client Import and Export Utility ======

The Client **Import/Export** utility can be used to import accounts laid out in a CSV file format, or it can export already existing accounts into a CSV file format. This is great for people who quickly need their account information exported to import into another program such as MailChimp for marketing purposes, or who need to import client information from another consignment software.

===== How To Import Client Information =====

  - From within the Inventory Module select **Activities > Accounts > CSV Import/Export**. \\ {{accountmanagement1:clientimportexport1_image34.png|image34.png}} \\ The Client **Import/Export** Utility Dialog Box will open. \\ {{accountmanagement1:clientimportexport1_image24.png|image24.png}} \\ To import a list of new clients, you will first need to create a CSV file with the customer information. The information will need to be laid out in this order. \\ {{accountmanagement1:clientimportexport1_image29.png|image29.png}} 

Note: If you export your data from another program and it puts the First and Last name in the same column, you will need to leave the **Last Name** column out. See below on how this affects the import. \\ {{accountmanagement1:clientimportexport1_image14.png|image14.png}}
      * **Account #** : This is the account number that will be assigned to the account. If that account number has already been used, then the account will not be imported. The number in the CSV file will need to be changed to a different number.
      * **First Name** : This is the first name of the account holder.
      * **Last Name** : This is the last name of the account holder.
      * **Address 1** : This is usually the street address of the account holder
      * **Address 2** : This might be the name of an apartment complex or subdivision of a larger community.
      * **City** : this is the city in which the account holder lives.
      * **State** : This is the state of the Address.
      * **Zip** : This is the **Zip** associated with the Address.
      * **Phone #** : This is the phone number of the account holder.
      * **Payable Balance** : If you are importing current clients who are owed money, enter the amount they are owed here. This balance will be reflected in the Inventory Module.
      * **Store Credit:** If a Client has any store credit, enter the amount in this field.
      * **Company:** This is the Company associated with the account (if applicable).
      * **User Fields 2-5:** Custom fields that can be used for additional information specific to your store. These may include things like referral info, alternate contact numbers, or preferences.
  - Select the Navigate button to upload your CSV file. \\ {{accountmanagement1:clientimportexport1_image31.png|image31.png}}
  - Once you find your file, select the **Open** Button. \\ {{accountmanagement1:clientimportexport1_image21.png|image21.png}} \\ Your data will be loaded into the **Import** Utility. \\ {{accountmanagement1:clientimportexport1_image33.png|image33.png}} \\ Accounts with a Green Indicator means the account is set to be uploaded without issue. Accounts with a Red indicator indicate there is an issue and can not be uploaded. \\ {{accountmanagement1:clientimportexport1_image32.png|image32.png}} \\ Notice the import button is grayed out. You will either need to fix all issues with accounts that have a red indicator, or you can select the option to **Skip Invalid Accounts** and those accounts will not be uploaded until fixed. \\ {{accountmanagement1:clientimportexport1_image22.png|image22.png}} \\ If you used actual headers for your .csv file, you can tell the import utility to ignore that row. \\ {{accountmanagement1:clientimportexport1_image28.png|image28.png}} \\ Once checked, it will hide that row. \\ {{accountmanagement1:clientimportexport1_image12.png|image12.png}} \\ If first and last name are within the same column, be sure to check off **First And Last Names Are In The Same Column**. \\ {{accountmanagement1:clientimportexport1_image13.png|image13.png}} \\ Note: When this is checked off, it adds the **Last Name** Column and separates out the last name into the **Last Name** Column. However it also moves all other data over by one column. It is recommended if there is a mixture of of accounts with last name in with the first name, and last name in the last name column, to leave it and manually fix it in Liberty, or cancel the import, and manually fix the import file. \\ {{accountmanagement1:clientimportexport1_image3.png|image3.png}}
  - When ready, select the **Import** button. \\ {{accountmanagement1:clientimportexport1_image18.png|image18.png}} \\ If there are any errors during the import process, they will be displayed. \\ {{accountmanagement1:clientimportexport1_image6.png|image6.png}} \\ If you want to avoid these errors, select **Ignore Errors During Import**. \\ {{accountmanagement1:clientimportexport1_image1.png|image1.png}}
  - Any accounts imported, will look similar to this. \\ {{accountmanagement1:clientimportexport1_image11.png|image11.png}}

===== How To Export Client Information =====

  - From within the Inventory Module select **Activities > Export Contacts > CSV Import/Export**. \\ {{accountmanagement1:clientimportexport1_image5.png|image5.png}} \\ The Client **Import**/**Export** Utility Dialog Box will open. \\ {{accountmanagement1:clientimportexport1_image27.png|image27.png}}
  - When the Client **Import**/**Export** Utility Dialog Box will opens select the **Export** tab. \\ {{accountmanagement1:clientimportexport1_image10.png|image10.png}}
  - From this screen you can see the steps that you can go through to do an export. You can click on and individual step, or select the **Next** button at the bottom of the screen. \\ {{accountmanagement1:clientimportexport1_image8.png|image8.png}}
  - Selecting filters will open a list of filters to choose from. Put a checkbox in the filters you wish to use and select the **OK** button. \\ {{accountmanagement1:clientimportexport1_image25.png|image25.png}}
  - This will add the filter. Each filter can be modified to fit the criteria you are looking for. If you wish to delete the filter, click the red X in the upper right corner. \\ {{accountmanagement1:clientimportexport1_image20.png|image20.png}}
  - If you wish to save this list, you can click on the **Browse** button. \\ {{accountmanagement1:clientimportexport1_image4.png|image4.png}}
  - This will open the **Manage Saved Export Criteria** dialog box. \\ {{accountmanagement1:clientimportexport1_image23.png|image23.png}}
  - Select the **Save Current List** button to save the list you just created. \\ {{accountmanagement1:clientimportexport1_image16.png|image16.png}}
  - You will be prompted to name the current list.Enter a Name and select the **OK** button. \\ {{accountmanagement1:clientimportexport1_image2.png|image2.png}}
  - You will see your created list in the **Manage Saved Export Criteria** dialogue box. You can highlight and select the **Rename** button to change the name of you can highlight a list and select the **Delete** button to remove it. Select the **OK** button when done. \\ {{accountmanagement1:clientimportexport1_image7.png|image7.png}}
  - Once your list is saved, you can click the Drop Down selection to open that list. \\ {{accountmanagement1:clientimportexport1_image9.png|image9.png}} \\ Checking off either of these buttons will hide the appropriate accounts. \\ {{accountmanagement1:clientimportexport1_image17.png|image17.png}}
  - When done select the next step or Select the **Next** button to continue to the next screen. \\ {{accountmanagement1:clientimportexport1_image15.png|image15.png}}
  - From this screen we can manually add and remove accounts. Highlight the account on either side and press the **Left or Right Arrow** button to move them left or right. Selecting the **Triple Arrow** buttons will move **All** the accounts left or right. Select the **Next** button or click the **Next** step in the list to continue. Select the **Back** button or Previous step if you feel you made a mistake. \\ {{accountmanagement1:clientimportexport1_image26.png|image26.png}}
  - On the final step we can Highlight and copy all the data and past it into another file, or we can select the **Export** button. \\ {{accountmanagement1:clientimportexport1_image19.png|image19.png}}
  - At the top select where on your computer you wish to save the file. At the bottom name the file. The select the **Save** button when done. \\ {{accountmanagement1:clientimportexport1_image30.png|image30.png}}
==== Next Article In Section ====

Click the following link to move to the next article in this section: \\ [[:accountmanagement1:deletecldata|Delete a Client's Data From Consignor Login]]

==== Related Topics ====

[[accountmanagement1:clientimportexport1]]
[[accountmanagement1:addnotesacct]]
[[accountmanagement1:addressphonenumber]]
[[accountmanagement1:applygroupdeduct]]
[[accountmanagement1:bulkchangepc]]
[[accountmanagement1:creatingnewmaint]]
[[accountmanagement1:customizeaccount]]
[[accountmanagement1:deactivatingacct]]
[[accountmanagement1:deletecldata]]
[[accountmanagement1:editaccountinfo]]
[[accountmanagement1:editingreminders]]