search

kbss-cvut / fta-fmea-ui

GNU General Public License v3.0
6 stars 6 forks source link

FMEA export table unreadable and difficult to use in Excel #105

Open lalisand opened 1 year ago

lalisand commented 1 year ago

When the FTA/FMEA tool generates FMEA table in CSV using non-readable characters and putting the entire row into a single cell. Ideal would be to

  1. generate readable characters and
  2. exporting the FMEA table as a proper table (1:1 cell to cell, i.e. not multiple cells from FTA/FMEA tool into a single in CSV)

FMEA_export

blcham commented 1 year ago

2) is problem at your site ... you are importing CSV incorrectly to excel (use delimiter=, and quote-character=")

Matthew-Kulich commented 1 year ago
  1. I tried to export and it seems working. (Tip: if you paste the text to excel, there is a highlighted button and you select delimiter-> solves 2.)
image image

@lalisand

Matthew-Kulich commented 1 year ago

@lalisand I recommend setting UTF-8 by these steps:

  1. Open Excel, search "Get Data From Text" to open a wizard when you want to open a CSV file.
  2. Go to the location of the CSV file, that you want to import.
  3. Choose Delimited, set the character encoding to 65001: Unicode (UTF-8) from the dropdown list.
  4. Check My data has headers. You have to use it because the first row of CSV file has column names.
  5. Click next to display the second step of Text Import Wizard.
  6. Because our data is separated by commas, set the delimiter to a comma.
  7. Click next to move to the third step.
  8. Select the General column and then Finish.
  9. Keep the default values inside the Import Data window and click OK.

Let me know if it works