Retran 1.0.0

Retran \ Exporting - Converting

Retran is a package that has various file conversion processes, allows you to import data from api in the file format you specify, and also creates ( CSV, JSON, EXCEL ) files, speeds up and simplifies work.You can connect to the database and transfer it as a (JSON, CSV or EXCEL) file.

- File Conversions Operations

• It is a module where you can perform file conversion operations. You can perform various translation operations on your JSON, CSV and EXCEL files.

Note: To use the methods, You need to add the following namespace.

using Retran.Convert;

• JsonToCsv
  • It is a method by which you can convert csv files to json files. -_{Example method usage is as follows.}

  Note: The parameters you need to pay attention to when using the ^{RetranJsonToCsv} class are; The first parameter represents the file location you will convert to, the second parameter represents the target file location..

RetranConvert.RetranJsonToCsv(@"C:\alierguc\retran_files\example.json", @"C:\alierguc\retran_files\example.csv");

• CsvToJson
  • It is a method by which you can convert json files to csv files. -_{Example method usage is as follows.}

  Note: The parameters you need to pay attention to when using the RetranCsvToJson class are; The first parameter represents the file location you will convert to, the second parameter represents the target file location..

RetranConvert.RetranCsvToJson(@"C:\Users\alier\Desktop\retran_files\example.csv", @"C:\Users\alier\Desktop\retran_files\example.json");

• JsonToExcel
  • It is a method by which you can convert json files to excel files. -_{Example method usage is as follows.}

  Note: The parameters you need to pay attention to when using the JsonToExcel class are; The first parameter represents the file location you will convert to, the second parameter represents the target file location.

RetranConvert.RetranJsonToExcel(@"C:\Users\alier\Desktop\retran_files\json_output\output_json_file\output_20221011174754.json",@"C:\Users\alier\Desktop\retran_files\excel_output\output_\output_20221011174754.xlsx");

- Database Export Operations

• It allows you to transfer the data in your database to your JSON, CSV and Excel files by establishing a database connection.

Note: To use the methods, You need to add the following namespace.

using Retran.DBExport;

• MssqlDbToLocalJsonFile
  • This method allows you to transfer data to the JSON file location you specified by making a database connection. The database it uses is MSSQL. -_{Example method usage is as follows.}

RetranDBExport.MssqlDbToLocalJsonFile("server_name","user_id","uyser_password", "database_name", "table_name", @"C:\alierguc\Retran\json_output\output_json_file\output_20221011174318.json");
;

• MssqlDbToLocalCsvFile
  • This method allows you to transfer data to the CSV file location you specified by making a database connection. The database it uses is MSSQL. -_{Example method usage is as follows.}

RetranDBExport.MssqlDbToLocalCsvFile("server_name","user_id","uyser_password", "database_name", "table_name", @"C:\alierguc\Retran\json_output\output_csv_file\output_20221011174318.csv");

• MssqlDbToExcelFile
  • This method allows you to transfer data to the EXCEL file location you specified by making a database connection. The database it uses is MSSQL. -_{Example method usage is as follows.}

RetranDBExport.MssqlDbToExcelFile("server_name","user_id","uyser_password", "database_name", "table_name", @"C:\alierguc\Retran\excel_output\output_excel_file\output_20221011174318.xlsx");

- File Process Operations

• This method does file and folder creation operations. It allows you to generate JSON or CSV File and folders optionally. Returns the directory of the file it creates.

Note: To use the methods, You need to add the following namespace.

using Retran.FileProcess;

• RetranCreateJSONFile
  • Generates JSON file to specified directory. -_{Example method usage is as follows.}

var newCreatedJsonPath = RetranFile.RetranCreateJSONFile(@"target_created_json_path");

• newCreatedCSVPath
  • Generates CSV file to specified directory. -_{Example method usage is as follows.}

var newCreatedCSVPath = RetranFile.RetranCreateCSVFile(@"target_created_csv_path");

- HTTP Export Operations

• It receives the data according to the HTTP ( GET ) request, transfers the specified file type ( JSON, CSV, EXCEL).

Note: To use the methods, You need to add the following namespace.

using Retran.HttpExport;

• GET_ExportApiToLocalExcelFile
  • This method receives the data by making an HTTP request and writes to the specified excel file. -_{Example method usage is as follows.}

Dictionary<string, object> httpParams = new Dictionary<string, object>();
httpParams.Add("postId", 1);

Dictionary<string, object> httpHeaders = new Dictionary<string, object>();
httpHeaders.Add("Content-Type", "application/x-www-form-urlencoded");
httpHeaders.Add("User-Agent", "application/json");

RetranHttpExport.GET_ExportApiToLocalExcelFile("https://jsonplaceholder.typicode.com", "/comments",
    @"target_excel_folder_path\output_20221011174754.xlsx",
    httpParams,
    httpHeaders);

• GET_ExportApiToLocalCsvFile
  • This method receives the data by making an HTTP request and writes to the specified CSV file.. -_{Example method usage is as follows.}

Dictionary<string, object> httpParams = new Dictionary<string, object>();
httpParams.Add("postId", 1);

Dictionary<string, object> httpHeaders = new Dictionary<string, object>();
httpHeaders.Add("Content-Type", "application/x-www-form-urlencoded");
httpHeaders.Add("User-Agent", "application/json");

RetranHttpExport.GET_ExportApiToLocalCsvFile("https://jsonplaceholder.typicode.com", "/comments",
    @"target_csv_folder_path\output_20221011174754.csv",
    httpParams,
    httpHeaders);

• GET_ExportApiToLocalJsonFile
  • This method receives the data by making an HTTP request and writes to the specified JSON file.. -_{Example method usage is as follows.}

Dictionary<string, object> httpParams = new Dictionary<string, object>();
httpParams.Add("postId", 1);

Dictionary<string, object> httpHeaders = new Dictionary<string, object>();
httpHeaders.Add("Content-Type", "application/x-www-form-urlencoded");
httpHeaders.Add("User-Agent", "application/json");

RetranHttpExport.GET_ExportApiToLocalJsonFile("https://jsonplaceholder.typicode.com", "/comments",
    @"target_json_folder_path\output_20221011174754.json",
    httpParams,
    httpHeaders);

- BENCHMARKING

BenchmarkDotNet=v0.13.2, OS=Windows 10 (10.0.19043.2130/21H1/May2021Update)
Intel Core i7-8550U CPU 1.80GHz (Kaby Lake R), 1 CPU, 8 logical and 4 physical cores
.NET SDK=6.0.302
  [Host]     : .NET 6.0.7 (6.0.722.32202), X64 RyuJIT AVX2  [AttachedDebugger]
  DefaultJob : .NET 6.0.7 (6.0.722.32202), X64 RyuJIT AVX2