Regarding scientific notation in transaction_begin_date and transaction_end_date, before saving as CSV in Excel, do this ...

 

  1. Select the entire begin date and end date columns
  2. Press Ctrl-1 on your keyboard to open the "Format Cells" dialog
  3. Select the "Number" tab in the dialog (it is probably already selected)
  4. Under "Category", select "Number"
  5. Set "Decimal places" to 0 (zero)
  6. Do NOT check the "Use 1000 Separator" box
  7. Select "-1234.10" as the format for "Negative numbers" (it is probably already selected)
  8. Click the OK button

 

Now, when you save the CSV, the dates will not be in scientific notation.

 

If you open the CSV to edit it again, you'll need to follow the same procedures above.  You'll need to do this any time you open the CSV in Excel and plan to save any changes.