7
S

Add 'Select All' option to View map > Mapping details > Text qualifier

Sunil Garg on 6/28/2019 1:32:38 PM

Currently the 'Text qualifier' checkbox need to be marked manually on each entity field. It would be useful to have a 'Select All' option - or something similar - so the user doesn't need to mark them field by field. When working with csv files, we need the text qualifier added to all fields. If it is not in the file, and there is a comma in a field value, the import will fail. Steps: 1. Go to Data management workspace 2. Click Export and create a new export project 3. Add an entity, select CSV as target format 4. On the line click on the View map function 5. Open Mapping details and check Text qualifier field

Category: Data Management
STATUS DETAILS
Needs Votes
Ideas Administrator

Administrator on 7/30/2019 9:16:17 PM

 
As you probably are aware that we are working on data feeds which will be allow for formatting and transformations to be applied outside of Finance and Operations. This will provide the flexibility to the consumer of the data feed to apply any formatting as needed. The scenario discussed here will be addressed as a result. 

Thanks 

Sunil

Microsoft.

Comments

S

S

RE: Add 'Select All' option to View map > Mapping details > Text qualifier

Maroua MRABET on 1/31/2025 11:43:11 AM

You can add the text qualifier to all entity fields without having to browse them all by doing the following :Select all of the lines in the mapping details formClick on the three points in the right of the grid (from where we're used to insert new columns)Click on "Edit selected rows"Select the field "Text qualifier" and "Yes" as a value Click on the "Apply" buttonSave your changesI hope this will be helpful for those who are still facing this problem.

Category: Data Management