The user creates an item saved search with a custom field of type multiple select included in the Results tab. This multiple select field contains numeric values equal to year. Example: 2007, 2008, 2009, 2010, 2011, 2012. When the user exports the saved search result to CSV, the values for year show as 200,720,082,009.
To illustrate the scenario, please perform the following steps:
A. Create a custom list.1. Navigate to Customization > Lists, Records, & Fields > Lists > New.
2. Enter a Name for the list. (Ex. Model Year List)
3. Enter the values under the Value column. (2007, 2008, 2009, 2010, 2011, 2012)
4. Save.
B. Create custom item field.
1. Navigate to Customization > Lists, Records, & Fields > Item Fields > New.
2. Enter a name in the Label field. (Ex. Model Year)
3. Set Type to Multiple Select.
4. Select the custom list created in step A (Model Year List) in the List/Record field.
5. Check the Inventory Item check box on the Applies To tab.
6. Save.
C. Assign value to the custom item field on several items.
1. Navigate to Lists > Accounting > Items.
2. Edit an item.
3. Click on the Custom tab.
4. Select at least 2 values in the Model Year field.
5. Save.
6. Perform steps 1 to 5 to at least 2 item records.
D. Create an item saved search.
1. Navigate to Lists > Search > Saved Searches > New.
2. Click Item.
3. Select Model Year (Custom) under the Filter column on the Criteria tab.
4. Select all values excluding - None - so the criteria will be Model Year (Custom) includes any of 2007, 2008, 2009, 2010, 2011, 2012.
5. Click on the Results tab.
6. Under the Field column on the Columns tab, select Model Year (Custom).
7. Click Add.
8. Click Preview.
9. Click Export to CSV.
Result: The values under the Model Year column on the CSV file is treated as one numeric value. For example 2007, 2008, 2009 is treated as 200,720,082,009.
The resolution to the problem is to export it using Excel.
No comments:
Post a Comment