Arcadi Burria

Tag: ER Import

  • Electronic Reporting: The Callback

    Electronic Reporting: The Callback

    There is an ER pattern called ‘The Callback‘ for data exporting, followed by adding data to tables or entities in the system. This pattern is typically used to mark certain records as exported. I also use it sometimes to add the export timestamp. I learned about this pattern a few years ago, but I couldn’t…

  • Extending Electronic Reporting Sources: Integration with OneDrive (II/II)

    Extending Electronic Reporting Sources: Integration with OneDrive (II/II)

    To implement the logic, we will create the following classes: TST2 One DriveInbound File: This class defines a custom inbound file and implements the interface ERIImportFile. TST2 One DriveInbound FileSource: This class is intended to read and import files. However, we will use it primarily to call TST2 OneDriveAPI, ensuring a better separation of concerns.…

  • Extending Electronic Reporting Sources: Integration with OneDrive (I)

    Extending Electronic Reporting Sources: Integration with OneDrive (I)

    In this series, I will explain how to extend ER (Electronic Reporting) sources to import from non-default origins (beyond the default options like manual imports or SharePoint). This will also enable us to program batch jobs for continuous integrations. Specifically, I will guide you step by step on how to integrate with a third-party OneDrive,…

  • Import a CSV file with Electronic Reporting (III) [Legacy]

    Import a CSV file with Electronic Reporting (III) [Legacy]

    These steps are not necessary, as a better method for importing a CSV with escape characters is explained at the end of part 2. Nonetheless, I’m leaving it here because it might be helpful for importing other file types, such as EDI files. In the first two entries of this series, we saw the standard…

  • Import a CSV file with Electronic Reporting (II)

    Import a CSV file with Electronic Reporting (II)

    This article is the second in a series of three about importing CSV files into the system. We will explore the format, the format mapping, escaping characters and how to test the development. Once we have the model and the mapping with the status completed, we can continue by creating an import format under our…

  • Import a CSV file with Electronic Reporting (I)

    Import a CSV file with Electronic Reporting (I)

    In this series, I’m going to show an example of importing a CSV file using Electronic Reporting (ER). This guide assumes you have basic knowledge of ER. If you are just starting, I recommend reading the series on ER export first, as it is more step-by-step and explains the basic concepts of ER. In an…

  • Integrating Electronic Reporting import messages into the UI

    Integrating Electronic Reporting import messages into the UI

    Following my previous article, ‘Integrating ER Export Formats into the UI’, let’s now take a look at import messages. I’m starting with a very simple model, an import format and an import mapping (direction to destination). In the mapping, there are two user input parameters, ‘string1’ and ‘string2’. These parameters serve as the keys for…