3784573 - Rule CSV Export via Import and Export Data Displays Incorrectly When Opened

• When exporting Rules via Import and Export Data → Export Data, the resulting CSV file displays incorrectly in some cases.
• Some rules render correctly across multiple columns, while others show all data consolidated in column A, making the file appear malformed.

1. Go to Admin Center → Import and Export Data → Export Data.
2. Select Generic Object: Rule.
3. Click Export and download the resulting CSV file.
4. Open the CSV file directly by double-clicking (default Excel open behavior).
5. Observe that some rule records display all fields in column A instead of being separated into individual columns.

This is not an export defect. The exported file is a standard, valid CSV.

The display issue is caused by how the tool (e.g., Excel, when opened by double-click) parses the CSV when the data contains large CLOB (Character Large Object) values. These large text fields interfere with the default parsing behavior, causing the columns to not split correctly.

1. Open Excel.

2. Go to the Data tab → click From Text/CSV.

3. Select the exported CSV file.

4. In the preview dialog:

1. • Set Delimiter = Comma
   • Set File Origin / Encoding = UTF-8

5. Click Load.

The data will now display correctly with each field in its respective column.

Note: The export file itself is valid and complete. This workaround addresses only the display/parsing issue on the client side.

KBA2651822 - How to Export Business Rules

CSV, Rule Export, Import and Export Data, Display Issue, CLOB, Excel, UTF-8, Delimiter, Generic Object, MDF, Parsing Issue , KBA , LOD-SF-MDF-IMP , Import and Export Issues , LOD-SF-EC-JOB-RUL , Job Info Business Rules , Problem