Overview
The BettrData.io Builder is the application that allows you to map and transform the incoming data from its original format to the selected Output Schema format. Mapping fields, dropping records and normalizing data values are some of the common operations that can be performed in the Builder.
High Level Builder Process Flow
Once you’ve created Source Routes for one or more owners, the system can now begin to access and process data and you can begin to manage files for each owner.
➤ Go to Files > Manage Files page. Any files that the system is aware of from Owners where you have either Enabled the route or have manually downloaded a file from List Files will be represented on the Files list.
➤ For any files in Unidentified, Select an Output Schema for the file.
➤ As the file processes, it will move into the status of Waiting to Convert, click on the Waiting to Convert link in the Status column.
➤ The BettrData.io Builder will display.
To learn more about Files go to Data Ops.
The BettrData.io Builder allows you to map and prepare to transform incoming data from its original format to the selected Output Schema mapping.
➤ From the Builder page, click the Build New Convert button. The BettrData.io Builder will display.
➤ Make a selection for each column to identify and confirm the Output Fields.
➤ Click on any red icons that may display in a column once a selection is made to address Date Format or Map Incoming Values to the output field.
➤ Check the gray bar for any convert issues that may occur during the build. The red icon corresponds to errors and the yellow to warnings.
➤ Click Save when you feel the build is accurate and complete.
To learn more about the Builder and creating a New Convert, see Creating a New Convert from Scratch.
You are now ready to transform the data from its original format into a standardized output.
➤ From the gray bar on the BettrData.io Builder, select >>Run.
➤ Select Test from the Environment field on the Run Convert screen to run the file for the first time and then select the Run button.
➤ Once the file proceeds through the Run Convert, click on View Report.
➤ The Report page will display enabling you to view Run results and make any needed adjustments and/or corrections before making the final Run for Production.
➤ Select the Save & Validate button as corrections are made, the Save & Validate button will turn green when clicked. Click Close to return to the Run Convert screen.
➤ You can now run the file in Production. Select Production from the Environment field and click Run. Once the report has Run again, select Review Complete at the top of the screen.
To learn more about transforming the data from its original format into a standardized output, see Run and View Report.