Bug ID 702296: Importing the LocalDB csv file fails after editing with Microsoft Excel

Last Modified: May 01, 2019

Bug Tracker

Affected Product:  See more info
BIG-IP APM(all modules)

Known Affected Versions:
13.1.0, 13.1.0.1, 13.1.0.2, 13.1.0.3, 13.1.0.4, 13.1.0.5, 13.1.0.6, 13.1.0.7, 13.1.0.8, 13.1.1, 13.1.1.1, 13.1.1.2, 13.1.1.3, 13.1.1.4, 13.1.1.5

Fixed In:
14.0.0

Opened: Jan 17, 2018
Severity: 2-Critical

Symptoms

Using the Excel sheet to edit and save the LocalDB CSV breaks the Import functionality.

Impact

File saved using Excel Sheet cannot be used for Import

Conditions

Admin Exports the LocalDB CSV file ( Access->Authentication->Local User DB->Users -> Export to CSV) Admin edits the file using Excel Sheet and saves it Admin Imports the CSV file

Workaround

Dont use excel sheet to edit the file. Use a simple text editor (like Textpad , vim) to edit and save the file.

Fix Information

Now Microsoft Excel can be used to edit the APM LocalDB database file in CSV format.

Behavior Change