C# Class DataMigration.CompiledXforms

Just generates the current datetime. Parameters are described at DataMigration.TransformMethod

CalculateActiveFlag looks at the Subscription Status column first; if value is Life it sets ActiveFlag to true, if Cancelled, then false, if neither, it checks the expiryDate. If it's parseble and in the past, it returns false. If none of these cases apply, it returns true. Parameters are described at DataMigration.TransformMethod

CalculateExpireDate makes sure we can parse the expire date into a valid date, otherwise, it returns null. If user is a LIFE member, then they also get a null expire date. If the subStatus is CANCELLED, we set expire date to NOW. Technically this is unnecessary if this is an initial import; CalculateActiveFlag will set the subscription to inactive. But in the case of a subscription changing from Regular or Life to Cancelled, this is important as we rely on the offline recurring billing task to actually set the ActiveFlag to 0, and it does this by looking for expired subscriptions. Parameters are described at DataMigration.TransformMethod

This function attempts to get a valid country id for the row, but if the data is incomplete, or we don't have a row for it, will use US. Parameters are described at DataMigration.TransformMethod

Ensure the email does not exist in member table already. Parameters and return are described at DataMigration.LitmusTest

Ensures the email has not been seen in the feed so far. Parameters and return are described at DataMigration.LitmusTest

Ensures that the email wasn't in there the first time we processed it.

Ensures the email is properly formed. Parameters and return are described at DataMigration.LitmusTest

The spreadsheet for BAM Magazine-only subscriptions has some rows that are messed up; there's no way we can process those rows. This litmus test in particular will try to parse out dates from three columns we have to have; they may be blank, but if they have non-blank non-date data in them, then we're hopelessly lost with processing this row.

This function combines first and last name. Parameters are described at DataMigration.TransformMethod

This function is for the scenario where we want to create a subscription for the person, but not a row in the member table, if their email is already in the member table. We're going to look up their id from the member table, stick it in the Staging table, and therefore refrain from doing a member table insertion in post processing. Parameters are described at DataMigration.TransformMethod

This function is for the scenario where we want to keep the row, even if it has an invalid email. If the email *is* invalid, we're going to null it out, though. Parameters are described at DataMigration.TransformMethod

PassThroughUserName. It just looks for empty strings or null, and returns null, otherwise passing through the username with whitespace trimmed off both ends. Parameters are described at DataMigration.TransformMethod

Given a Litmus Test name, returns the actual delegate method.

Given a transformation name, returns the actual delegate method.

This is for making sure we only pass through valid dates or blanks. Parameters are described at DataMigration.TransformMethod

Uses the create date created earlier. Has a PreCondition that it comes after a transformMap with a destColumn of "CreateDateTime". Parameters are described at DataMigration.TransformMethod

Just returns the load number passed in. Parameters are described at DataMigration.TransformMethod

This is for making sure we only pass through valid dates or blanks. Parameters are described at DataMigration.TransformMethod

This function ensures that an email string exists, that it doesn't exceed our table length, and that it has an '@' sign in it. It throws BadRowExceptions if the provided email fails. Parameters are described at DataMigration.TransformMethod

Returns true for blank string, or parseable date, false otherwise. This is for detecting rows where the columns are messed up, and the dates are not where they're supposed to be.

GetDateHelper tries to parse date for you, and returns null if it can't.

Helper function that checks various busines rules for emails.