Method | Description | |
---|---|---|
CalcCreateDate ( int loadNumber, ILookup>.IDictionary |
Just generates the current datetime. Parameters are described at DataMigration.TransformMethod
|
|
CalculateActiveFlag ( int loadNumber, ILookup>.IDictionary |
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 ( int loadNumber, ILookup>.IDictionary |
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
|
|
DefaultToUSCountryId ( int loadNumber, ILookup>.IDictionary |
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
|
|
EnsureEmailIsNotInMembersTable ( ILookup>.IDictionary |
Ensure the email does not exist in member table already. Parameters and return are described at DataMigration.LitmusTest
|
|
EnsureEmailUniqueWithinFeed ( ILookup>.IDictionary |
Ensures the email has not been seen in the feed so far. Parameters and return are described at DataMigration.LitmusTest
|
|
EnsureEmailWasntInFirstPass ( ILookup>.IDictionary |
Ensures that the email wasn't in there the first time we processed it.
|
|
EnsureValidEmail ( ILookup>.IDictionary |
Ensures the email is properly formed. Parameters and return are described at DataMigration.LitmusTest
|
|
EnsureValidEmailPassThroughBlanks ( ILookup>.IDictionary |
||
EnsureValidSubscriptionDates ( ILookup>.IDictionary |
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.
|
|
MakeFullName ( int loadNumber, ILookup>.IDictionary |
This function combines first and last name. Parameters are described at DataMigration.TransformMethod
|
|
MemberIdFromEmail ( int loadNumber, ILookup>.IDictionary |
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
|
|
OnlyPassThroughValidEmail ( int loadNumber, ILookup>.IDictionary |
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 ( int loadNumber, ILookup>.IDictionary |
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
|
|
ResolveLitmusTest ( String litmusTestName ) : LitmusTest |
Given a Litmus Test name, returns the actual delegate method.
|
|
ResolvePostRowProcessor ( string postRowProcessorName ) : PostRowProcessor | ||
ResolveTransformationMethod ( String xformName ) : TransformMethod |
Given a transformation name, returns the actual delegate method.
|
|
UnixTimeToDateTime ( int loadNumber, ILookup>.IDictionary |
This is for making sure we only pass through valid dates or blanks. Parameters are described at DataMigration.TransformMethod
|
|
UseCreateDate ( int loadNumber, ILookup>.IDictionary |
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
|
|
UseLoadNum ( int loadNumber, ILookup>.IDictionary |
Just returns the load number passed in. Parameters are described at DataMigration.TransformMethod
|
|
ValidateDateTolerateBlanks ( int loadNumber, ILookup>.IDictionary |
This is for making sure we only pass through valid dates or blanks. Parameters are described at DataMigration.TransformMethod
|
|
ValidateEmail ( int loadNumber, ILookup>.IDictionary |
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
|
Method | Description | |
---|---|---|
DateValidatorHelper ( string dateString ) : bool |
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 ( string expireDateString ) : DateTime? |
GetDateHelper tries to parse date for you, and returns null if it can't.
|
|
ValidateEmailHelper ( string email ) : string |
Helper function that checks various busines rules for emails.
|
public static CalcCreateDate ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public static CalculateActiveFlag ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public static CalculateExpireDate ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public static DefaultToUSCountryId ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public static EnsureEmailIsNotInMembersTable ( ILookup>.IDictionary |
||
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
arguments | IList |
|
return | bool |
public static EnsureEmailUniqueWithinFeed ( ILookup>.IDictionary |
||
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
arguments | IList |
|
return | bool |
public static EnsureEmailWasntInFirstPass ( ILookup>.IDictionary |
||
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
arguments | IList |
|
return | bool |
public static EnsureValidEmail ( ILookup>.IDictionary |
||
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
arguments | IList |
|
return | bool |
public static EnsureValidEmailPassThroughBlanks ( ILookup>.IDictionary |
||
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
arguments | IList |
|
return | bool |
public static EnsureValidSubscriptionDates ( ILookup>.IDictionary |
||
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
arguments | IList |
|
return | bool |
public static MakeFullName ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public static MemberIdFromEmail ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public static OnlyPassThroughValidEmail ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public static PassThroughUserName ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public ResolveLitmusTest ( String litmusTestName ) : LitmusTest | ||
litmusTestName | String | Litmus test name. |
return | LitmusTest |
public ResolvePostRowProcessor ( string postRowProcessorName ) : PostRowProcessor | ||
postRowProcessorName | string | |
return | PostRowProcessor |
public ResolveTransformationMethod ( String xformName ) : TransformMethod | ||
xformName | String | Xform name. |
return | TransformMethod |
public static UnixTimeToDateTime ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public static UseCreateDate ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public static UseLoadNum ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public static ValidateDateTolerateBlanks ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |
public static ValidateEmail ( int loadNumber, ILookup>.IDictionary |
||
loadNumber | int | |
lookups | ILookup>.IDictionary | |
existenceObjects | IExistence>.IDictionary | |
rowInProgress | string>.IDictionary | |
arguments | IList |
|
return | string |