Guided Tour

This guided tour will walk you through the Ledger Wizard pages using the sample data which comes with all pasTransfer installations.

From the Start Menu navigate to the pasTransfer folder and select pasTransfer - Ledger Wizard.

The first time the program launches you will see a Welcome page and be offered the opportunity to skip that page in the future. Click Next to continue.

Notice that the Configuration page contains color-coded sections. Sections bordered in green are intended to gather or communicate generic information about the ETL process. Sections bordered in blue are specific to the data source. Sections bordered in gold are specific to the data destination. Shared Configuration Mode is checked by default and allows you to share configurations with other users. Set the Source and Destination Configurations to {Default}. Click Next to continue.

You will now select your Source and Destination Connections. For the purpose of this guided tour we will set the Source Connection to Sample Source and the Destination Connection to Sample Destination. Click Next to continue.

You will now select your Source and Destination Culture & Currency. Culture and Currency are used to define how dates and currencies are formatted. Both values default to English (United States). Change the Destination Culture & Currency to German (Germany) 1.234.567,89 €. Now that the source and destination are different the application will allow you to enter a conversion rate if desired. For the purpose of this guided tour we will leave the conversion rate at 1.0. If you had selected a different Source Connection, you would be asked to provide the path of your source file. However, the Sample Source does not require an external data file. Click Next to continue.

Notice that the border is now entirely blue, indicating that you are working with source settings. You will now be given the option to override pasTransfer's default behavior when reading data from the source connection. You will also be able to adjust your fiscal period settings. To illustrate how this can be useful, change the Amount Processing Style to Reversed and change the Day Fiscal Year Starts On to October 1. Click Next to continue.

Data has now been imported from the source connection (in this case it is embedded within the application) and the extraction phase is complete. The application reports that 13 total journal lines have been processed. In this sample scenario there were nine lines that came from the source data plus an MCR entry which was created to offset any multi-currency rounding and an OFF entry which was created to balance the data. The original balance from the source was a two-thousand-dollar credit value. Because we set Amount Processing Style to Reversed and we changed the destination culture and currency the converted balance from the source is a two-thousand-euro debit value. We also see that no problems occurred with our source data. If problems had occurred, detailed information would be listed here. Click Next to continue.

Now that source processing has completed, the border color has changed to gold to indicate that you are working with destination settings. Based on the source data pasTransfer has decided an appropriate offset transaction date would be for the MCR and OFF entries. Here you will select your audit level and choose your mapping and lookup provider. Set your Audit Level to Basic and your Mapping and Lookup Provider to Auto Balance. Auto Balance copies source account values over to destination account values. pasPortal mappings will typically be used to map accounts. For details on mapping see Working with Mapping. Click Next to continue.

The data has now been mapped successfully. You can see that of our 13 total journal lines, 12 journal line items had a non-zero amount, and zero journal lines had any problems. Click Next to continue.

You will now export the transformed data to a text file and export XML audit log which details the actions that transformed your data. Set your Output File to C:\OUTPUT.TXT and your Audit File to C:\AUDIT.XML. Click Next to create the files and continue.

You have now successfully transformed the source data to a destination text file. You now have the option to save your settings and either close or restart the wizard at the beginning to process another file. Click Finish to save your settings and close the wizard.

This is the most basic example of pasTransfer capabilities. Explore other source and destination combinations on your own to view other product capabilities. Further details on the individual pages shown may be accessed from the application by pressing F1 while on a specific page.

Send comments on this topic.