Importing of values into code field of service call item
Can we import the values for the code field to SD.
The requirement is as follows. Need to import the values(more than 250 items for each field) for the field "Belongs To" & "Attributed To" from the excel sheet for the service call item. Can this be possible from sd_import or any kind of script to import instead of manually add values to it.
Re: Importing of values into code field of service call item
Yes, you can import values to code fiels.
In your example, you have a code field named 'Colour' for service calls. Follow these steps to import data to this custom field. Open the Admin console. Navigate to Data --> Templates --> Colour In the right pane, right click and create a new template with any suitable name. Assign it to a template group/category and save the template record. Now, come to Data exchange tasks. Hope you are well aware of data export process. You may have data in an excel sheet. Configure an ini file to export data from excel to an XML document. In the import mapping, type name, select 'Colour' as your item and select the newly created template as the template for data import. Type in your column name as a value for 'Text' attribute, in the import mapping. Select the same as 'Unique Key' constraint. Start/run the DE task.