The Member Ranking Sync Extended is used to export extended member information for members in a predetermined member ranking. Compared to the Member Ranking Sync, this file includes more member-related details. This is a cumulative file, not an incremental file. Members with no change to their Ranking Set Level since the previous execution of the sync will not be included in the sync file.
Upon each execution, all current member information is extracted and the completed file is then FTP’d to the predetermined location.
Note: This information is also offered as a PDF for portability. Member Ranking Extended Sync.pdf
|Name||SBMemberRankingSync_MMDDYYYYHHMMSS.txt (single file)
SBMemberRankingSync_####.txt (multiple files)
xxxxx = Member Ranking Set External Reference
#### = File Number
|Contents||All members in the specified member ranking set with their ranking level.|
|Ranking Set External Reference||String(20)|
|Ranking Level External Reference||String(20)|
|Internal Member Id||Integer|
|Member Account Id||String(60)||The most recent active Account Id of the highest rank|
|Member First Name||String(60)|
|Member Last Name||String(60)|
|Member Region Abbreviation||String(8)|
|Member Postal Code||String(14)|
|Member Country Abbreviation||String(2)|
|Member Mobile Phone||String(30)||See Article for Phone Number Formatting|
|Ranking Set||String(20)||ALP SaaS Ranking Set External Reference|
|Ranking Set Level||String(20)||ALP SaaS Ranking Set Level External Reference|
|Ranking Set Level Join Date||String||The date when the member entered the current ranking set level.
|Ranking Member Descriptor Expiration Date||String||If assigned to the configured descriptor, this is the date that the descriptor will expire.
RankingSetExternalReference | RankingLevelExternalReference | InternalMemberId | MemberAccountId | MemberFirstName | MemberLastName | MemberAddress | MemberCity | MemberRegionAbbreviation | MemberPostalCode | MemberCountryAbbreviation | MemberEmail | MemberMobilePhone | RankingSet | RankingSetLevel | RankingSetLevelJoinDate | RankingMemberDescriptorExpirationDate
RS | SILVER | 56075 | 600010023 | John | Smith | 123 Main Street | City | RN | 12345-6789 | US | email@example.com | 1(333) 555-1234 | Gold | 2010-12-25 10:33:15 | 2020-12-31