Customizing CSV upload

OnePart allows you to customize the Search by CSV upload feature. This feature allows users to upload a csv file to search for a list of parts. If you need to change the default separator to a semi-colon instead of a comma. You must edit the CustomConfigs configuration as follows.

Note: You can edit the XML configuration files manually as described below or use the API Console available at http://<HOSTNAME>:<BASEPORT+1>/api-ui

  1. Edit the file <ONEPART_INSTALLDIR>\datadir\config\CustomConfigs.xml
  2. Edit the separator used by OnePart default set to ',' in separatorChar :
    • <bee:KeyValue key="separatorChar" value=";"></bee:KeyValue>
  3. Manually apply the product configuration. 
<CustomConfig name="CSVUploadConfiguration" xmlns="exa:com.exalead.mercury.mami.master.v10" xmlns:bee="exa:exa.bee">
<!-- A sample default configuration for the CSV upload feature -->
<bee:KeyValue key="separatorChar" value=","></bee:KeyValue>
<bee:KeyValue key="quoteChar" value="""></bee:KeyValue>
<bee:KeyValue key="escapeChar" value="\"></bee:KeyValue>
<bee:KeyValue key="maxCols" value="5"></bee:KeyValue>
<bee:KeyValue key="maxLines" value="1000"></bee:KeyValue>
</CustomConfig>
Important: This configuration uses the comma "," as the delimiter set in the separatorChar key.