7

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

 
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.