Is your feature request related to a problem? Please describe.
Grab information (TCB, SR, TC, City, State, Agencies, Service Stations) from IF.Data

Describe the solution you'd like
Extract data from IF.Data

Swagger
Docs

Add data from SFA - Open Finance

Documenation of the file format.

Contributing

Here is a step-by-step on how to add a new source of data to the merge tool:

• Check out MergeTool.
• Open VS, VS Code, Rider, or your favorite IDE / Code Editor for .NET projects.
• Load the project (currently, it is in C# .NET 8.0).
• Add the required URLs to the Constants.cs file.
• Add a new enum item in the Source.cs file. Please use the source system acronyms whenever possible.
• Add a new method in the Reader.cs called Load[NewSystemAcronym]. This should do all the heavy job of grabbing the information from the remote source.
• Follow the other methods patterns to extract the PDF information from the file if the new source provides a PDF file.
• Implements the data extraction the way you prefer if it is not a PDF file.
• Add the RegExp to the Patterns.cs file if you need to use RegExp to extract data.
• Add the new field(s) to the Bank.cs file.
• In the Seeder.cs file, implement the method Merge[NewSystemAcronym] to merge the new data with the existing ones. I prefer to filter the data by ISPB and then Document to check for existing data. Rely on the existing list, DO NOT ADD new bank to the list if it is not present with COMPE, ISPB, Document, and Name at least. These are mandatory fields, if you have all this information, and you did not find the bank on the existing list, feel free to add it to the list. (Let me know this in the PR comment).
• Call the new methods (Load[NewSystemAcronym]r and Merge[NewSystemAcronym]) in the AcquireData method inside the Program.cs file.
• On the Writer.cs file, edit the following methods, mapping the new field(s):
  • SaveCsv
  • SaveMarkdown
  • SaveSql
• Test it 🧪
• Commit and submit a PR 🎉

Testing

• You can run the application locally without submitting any changes to this repository.
• Run how many times you need, it will only generate some files in the output directory inside result directory.

Summary

Errors per input

Errors in README.md

• [404] https://www2.nuclea.com.br/SAP/CTC.pdf | Failed: Network error: Not Found
• [404] https://www.bcb.gov.br/content/estabilidadefinanceira/spi/participantes-spi-20240101.csv | Failed: Network error: Not Found
  Full Github Actions output

Describe the bug
Split products based in , (comma) and also in e (and in Portuguese) and not only in , (comma).
Currently, in the CTC parser it only splits the values based on a comma (,), but the last item is always separated by a e (the equivalent of and in PT_BR, the language of the document).

Expected behaviour
Troca de Modalidade e Capital de Giro

These 2 items should be split, instead of being only one.

Screenshots

The fix should be addressed to Reader.ParseLineCtc to not only split in , pattern, but also e pattern (the e should be prefixed and suffixed by a space, and should only occur once, as the last split pattern).

Description

Create a new project under /Tests/ directory named BancosBrasileiros.MergeTool.Tests.csproj with the following nuget packages:

• xUnit
• coverlet.msbuild
• nsubstitute
• fluentassertions

Tech notes

No response

Screenshots or Diagrams

No response

Additional information

No response

Is your feature request related to a problem? Please describe.
Grab taxes and levies from the BCB page for all banks

Describe the solution you'd like
BCB publishes the taxes/levies for each bank based on ISPB at this page:

• Personal: https://www.bcb.gov.br/fis/tarifas/htms/00000000.asp?seg=&frame=1
• Corporate: https://www.bcb.gov.br/fis/tarifas/htms/00000000a.asp?seg=&frame=1

The 00000000 is the ISPB
The a after the ISPB in the corporate URL is how it identifies a corporate instead of a personal.

Call this page for each bank with ISPB and extract the information to a JSON file separated of banks files.

Add data from SFA - Open Finance

Documenation of the file format.

Contributing

Here is a step-by-step on how to add a new source of data to the merge tool:

• Check out MergeTool.
• Open VS, VS Code, Rider, or your favorite IDE / Code Editor for .NET projects.
• Load the project (currently, it is in C# .NET 8.0).
• Add the required URLs to the Constants.cs file.
• Add a new enum item in the Source.cs file. Please use the source system acronyms whenever possible.
• Add a new method in the Reader.cs called Load[NewSystemAcronym]. This should do all the heavy job of grabbing the information from the remote source.
• Follow the other methods patterns to extract the PDF information from the file if the new source provides a PDF file.
• Implements the data extraction the way you prefer if it is not a PDF file.
• Add the RegExp to the Patterns.cs file if you need to use RegExp to extract data.
• Add the new field(s) to the Bank.cs file.
• In the Seeder.cs file, implement the method Merge[NewSystemAcronym] to merge the new data with the existing ones. I prefer to filter the data by ISPB and then Document to check for existing data. Rely on the existing list, DO NOT ADD new bank to the list if it is not present with COMPE, ISPB, Document, and Name at least. These are mandatory fields, if you have all this information, and you did not find the bank on the existing list, feel free to add it to the list. (Let me know this in the PR comment).
• Call the new methods (Load[NewSystemAcronym]r and Merge[NewSystemAcronym]) in the AcquireData method inside the Program.cs file.
• On the Writer.cs file, edit the following methods, mapping the new field(s):
  • SaveCsv
  • SaveMarkdown
  • SaveSql
• Test it 🧪
• Commit and submit a PR 🎉

Testing

• You can run the application locally without submitting any changes to this repository.
• Run how many times you need, it will only generate some files in the output directory inside result directory.

Is your feature request related to a problem? Please describe.
Track changed properties of a bank when updating it.

Describe the solution you'd like
Implement a tracking system in the DTO.

IChangeTracking
What would be the best way to implement change tracking on an object

Add data from SFA - Open Finance

Documenation of the file format.

Contributing

Here is a step-by-step on how to add a new source of data to the merge tool:

• Check out MergeTool.
• Open VS, VS Code, Rider, or your favorite IDE / Code Editor for .NET projects.
• Load the project (currently, it is in C# .NET 8.0).
• Add the required URLs to the Constants.cs file.
• Add a new enum item in the Source.cs file. Please use the source system acronyms whenever possible.
• Add a new method in the Reader.cs called Load[NewSystemAcronym]. This should do all the heavy job of grabbing the information from the remote source.
• Follow the other methods patterns to extract the PDF information from the file if the new source provides a PDF file.
• Implements the data extraction the way you prefer if it is not a PDF file.
• Add the RegExp to the Patterns.cs file if you need to use RegExp to extract data.
• Add the new field(s) to the Bank.cs file.
• In the Seeder.cs file, implement the method Merge[NewSystemAcronym] to merge the new data with the existing ones. I prefer to filter the data by ISPB and then Document to check for existing data. Rely on the existing list, DO NOT ADD new bank to the list if it is not present with COMPE, ISPB, Document, and Name at least. These are mandatory fields, if you have all this information, and you did not find the bank on the existing list, feel free to add it to the list. (Let me know this in the PR comment).
• Call the new methods (Load[NewSystemAcronym]r and Merge[NewSystemAcronym]) in the AcquireData method inside the Program.cs file.
• On the Writer.cs file, edit the following methods, mapping the new field(s):
  • SaveCsv
  • SaveMarkdown
  • SaveSql
• Test it 🧪
• Commit and submit a PR 🎉

Testing

• You can run the application locally without submitting any changes to this repository.
• Run how many times you need, it will only generate some files in the output directory inside result directory.

Is your feature request related to a problem? Please describe.
Replace the dependency of iTextSharp.

Describe the solution you'd like
The solution should be based on the result of this POC-dotnet-ExtractPdfContent

Is your feature request related to a problem? Please describe.
When creating a new release of the package in the main repository, add to release notes the respective changelog.

Describe the solution you'd like
Create a release-notes.txt in the end of execution to be used in the release notes.

Is your feature request related to a problem? Please describe.
Add the system name responsible for a given change in the changelog list.

Describe the solution you'd like
Currently, the changelog contains the bank COMPE, name and document and a list of changes per field/property.
Add in the list the system that triggered the change on that field/property.

Describe the bug
When the change is in a property of type Array, it shows the type in the changelog instead of the information.

ChangeLog.md

Expected behaviour
It should join the content of the array, using a comma (,) when detecting the property is an array of strings.

Description

Add the list of PCR/PCRP to the bank's lists.

Tech notes

Parse the following document and extract the list of banks from PCR/PCPR
List

Additional information

Source issue: guibranco/BancosBrasileiros#360

Add CodeClimate coverage report based on appveyor.yml

Is your feature request related to a problem? Please describe.
Update the code to .NET 8.0

Update the STR source URL

Current: http://www.bcb.gov.br/pom/spb/estatistica/port/ParticipantesSTRport.csv

Correct: https://www.bcb.gov.br/content/estabilidadefinanceira/str1/ParticipantesSTR.csv