Update bs/balance_sheet_csv_to_json_converter.py

bs/balance_sheet_csv_to_json_converter.py

@@ -3,6 +3,7 @@ import json
 import os
 import re
 import logging
+import sys
 from datetime import datetime
 from typing import Dict, List, Any, Optional, Union
 from pydantic import BaseModel, Field, ValidationError
@@ -355,6 +356,10 @@ class FinancialCSVMapper:
 
 # Usage
 if __name__ == "__main__":
-    mapper = FinancialCSVMapper(settings.csv_folder_path)
-    output_file = mapper.save_to_json(settings.output_json)
-    logger.info(f"Clean financial JSON created: {output_file}")
+    try:
+        mapper = FinancialCSVMapper(settings.csv_folder_path)
+        output_file = mapper.save_to_json(settings.output_json)
+        logger.info(f"Clean financial JSON created: {output_file}")
+    except Exception as e:
+        logger.error(f"CSV to JSON conversion failed: {e}")
+        sys.exit(1)