I am looking for tips on batch automation business rules. Currently when our scheduled trial balances are loaded the whole upload will fail if one transformation mapping error is present. As you can imagine this can slow the close process down significantly. Does anyone have any suggestions on how to allow the batch to load the validated accounts and only error out the transformation errors?
","kudosSumWeight":0,"postTime":"2021-12-10T16:33:36.007-08:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuM3wyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:Admin","text":"Admin","time":"2023-05-02T07:07:10.441-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:3508_2"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":4062},"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"body":"I am looking for tips on batch automation business rules. Currently when our scheduled trial balances are loaded the whole upload will fail if one transformation mapping error is present. As you can imagine this can slow the close process down significantly. Does anyone have any suggestions on how to allow the batch to load the validated accounts and only error out the transformation errors?
","customFields":[]},"Conversation:conversation:3508":{"__typename":"Conversation","id":"conversation:3508","solved":true,"topic":{"__ref":"ForumTopicMessage:message:3508"},"lastPostingActivityTime":"2023-05-02T07:22:26.033-07:00","lastPostTime":"2022-10-05T10:43:13.147-07:00","unreadReplyCount":5,"isSubscribed":false},"ModerationData:moderation_data:3508":{"__typename":"ModerationData","id":"moderation_data:3508","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:3508_2":{"__typename":"Revision","id":"revision:3508_2","lastEditTime":"2023-05-02T07:22:26.033-07:00"},"ForumReplyMessage:message:11863":{"__typename":"ForumReplyMessage","id":"message:11863","conversation":{"__ref":"Conversation:conversation:3508"},"author":{"__ref":"User:user:2111"},"revisionNum":1,"uid":11863,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Rules"},"subject":"Re: Batch Automation Uploads","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:11863"},"parent":{"__ref":"ForumTopicMessage:message:3508"},"body":"Would you have an example of that rule you are using to do that?
","body@stringLength":"71","rawBody":"Would you have an example of that rule you are using to do that?
","kudosSumWeight":0,"repliesCount":1,"postTime":"2022-10-05T08:56:36.306-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:11863_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":3416},"visibilityScope":"PUBLIC","isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"customFields":[],"replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"ForumReplyMessage:message:11875"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:theme:customTheme1-1746700453432":{"__typename":"CachedAsset","id":"theme:customTheme1-1746700453432","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"50%","collections":["default"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"OneStream_Symbol_Black-1728623750904.png","imageLastModified":"1728623754994","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"Community_Logo_V2-1728623741343.png","imageLastModified":"1728623745056","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1500px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"0","borderRadius":"0","borderRadiusLg":"0","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"12px","paddingXLg":"16px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"400","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-body-color)","primaryBgHoverColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","secondaryTextColor":"var(--lia-bs-white)","secondaryTextHoverColor":"var(--lia-bs-white)","secondaryTextActiveColor":"var(--lia-bs-white)","secondaryBgColor":"var(--lia-bs-body-color)","secondaryBgHoverColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.85))","secondaryBgActiveColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.7))","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","tertiaryTextColor":"var(--lia-bs-body-color)","tertiaryTextHoverColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-gray-400-h), var(--lia-bs-gray-400-s), var(--lia-bs-gray-400-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-gray-400-h), var(--lia-bs-gray-400-s), var(--lia-bs-gray-400-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"LIGHT","sideContent":"LIGHT","radiusSm":"3px","radius":"5px","radiusLg":"9px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08), 0 3px 0 -1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08)","sm":"0 2px 4px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.06)","md":"0 5px 15px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","lg":"0 10px 30px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"#5564FF","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","defaultMessageFontFamily":"var(--lia-bs-font-family-base)","forumColor":"#5564FF","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#00985B","blogColor":"#6E26C1","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#FF8FB4","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FFCB11","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#B6BDFF","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#333333","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#949494","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#373737","secondary":"#333333","bodyText":"#000000","bodyBg":"#F7F7F7","info":"#409AE2","success":"#41C5AE","warning":"#FCC844","danger":"#D13A1F","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#5564FF","#FF0000","#0099AA","#3D65C9","#0033FF","#660099"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"email":null,"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"OneStream Sans","fontStyle":"NORMAL","fontWeight":"400","h1FontSize":"34px","h2FontSize":"32px","h3FontSize":"28px","h4FontSize":"24px","h5FontSize":"20px","h6FontSize":"16px","lineHeight":"1.3","subHeaderFontSize":"11px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"var(--lia-bs-border-radius-sm)","borderRadius":"var(--lia-bs-border-radius)","borderRadiusLg":"var(--lia-bs-border-radius-lg)","formTextMarginTop":"4px","textAreaBorderRadius":"var(--lia-bs-border-radius)","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"#5564FF","hoverColor":"#5564FF","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":"","imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"20px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"30px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"20px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"30px","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"OneStream Sans","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"16px","fontSizeXxs":"11px","fontSizeXs":"12px","fontSizeSm":"14px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[{"source":"SERVER","name":"OneStream Sans","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"}],"assetNames":["OneStreamSans-normal-400.woff2","OneStreamSans-normal-500.woff2"],"__typename":"CustomFont"}],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1746664278000","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:onestream.prod:pages/forums/ForumMessagePage:board:Rules-1746725504762":{"__typename":"CachedAsset","id":"quilt:onestream.prod:pages/forums/ForumMessagePage:board:Rules-1746725504762","value":{"id":"ForumMessagePage","container":{"id":"Common","headerProps":{"backgroundImageProps":null,"backgroundColor":null,"addComponents":null,"removeComponents":["community.widget.bannerWidget"],"componentOrder":null,"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"footerProps":null,"footerComponentProps":null,"items":[{"id":"message-list","layout":"MAIN_SIDE","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"MainSideQuiltSection","columnMap":{"main":[{"id":"messages.widget.topicWithThreadedReplyListWidget","className":"lia-topic-with-replies","props":{"editLevel":"CONFIGURE"},"__typename":"QuiltComponent"}],"side":[{"id":"messages.widget.relatedContentWidget","className":null,"props":null,"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1746664278000","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-pages/forums/ForumMessagePage-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1746664278000","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived"},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1746664278000","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:quiltWrapper:onestream.prod:Common:1746700400008":{"__typename":"CachedAsset","id":"quiltWrapper:onestream.prod:Common:1746700400008","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":true,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"mainLinks":[{"children":[{"linkType":"INTERNAL","id":"app-build","params":{"boardId":"AppBuild","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"workflow-d-i","params":{"boardId":"WorkflowDI","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"rules","params":{"boardId":"Rules","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"reporting","params":{"boardId":"Reporting","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"solution-exchange","params":{"categoryId":"SolutionExchange"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"french-language-forum","params":{"boardId":"FrenchLanguageForum","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"academicalliances","params":{"boardId":"academicalliances","categoryId":"your-community"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"your-community","params":{"categoryId":"your-community"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"welcome","params":{"boardId":"welcome","categoryId":"resources"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"blog","params":{"boardId":"blog","categoryId":"resources"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"bulletins-1","params":{"categoryId":"technicaldocuments"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"tech-talks","params":{"boardId":"TechTalks","categoryId":"NewsAndViews"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"podcast","params":{"boardId":"Podcast","categoryId":"NewsAndViews"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"bulletins","params":{"categoryId":"Bulletins"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"financial-close-compliance-ideas","params":{"boardId":"FinancialCloseComplianceIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"planning-analysis-ideas","params":{"boardId":"PlanningAnalysisIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"advanced-analytics-ideas","params":{"boardId":"AdvancedAnalyticsIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"productivity-ideas","params":{"boardId":"ProductivityIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"market-place-core-ideas","params":{"boardId":"MarketPlaceCoreIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"platform-core","params":{"boardId":"PlatformCore","categoryId":"Ideas"},"routeName":"IdeaBoardPage"}],"linkType":"INTERNAL","id":"ideas","params":{"categoryId":"Ideas"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"platformupgrades","params":{"groupHubId":"platformupgrades"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"taxprovision","params":{"groupHubId":"taxprovision"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"p-a-b","params":{"groupHubId":"PAB"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"customer-advisory-board","params":{"groupHubId":"CustomerAdvisoryBoard"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"sensibleml","params":{"groupHubId":"sensibleml"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"e-s-g-focus-group","params":{"groupHubId":"ESGFocusGroup"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"partner-a-i-services","params":{"groupHubId":"PartnerAIServices"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"projectlongship","params":{"groupHubId":"projectlongship"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"boatlaunchdevelopers","params":{"groupHubId":"boatlaunchdevelopers"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"cpmexpress","params":{"groupHubId":"cpmexpress"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"privatepreview-journalentrymanager-link","params":{"groupHubId":"privatepreview-journalentrymanager"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"n-a-c-a-b-link","params":{"groupHubId":"NACAB"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"e-m-e-a-c-a-b-link","params":{"groupHubId":"EMEACAB"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-south-africa-user-group-link","params":{"groupHubId":"south-africa-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-esg-private-preview-link","params":{"groupHubId":"esg-private-preview"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-north-america-user-group-leaders-link","params":{"groupHubId":"north-america-user-group-leaders"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-atlanta-user-group-link","params":{"groupHubId":"atlanta-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-dfw-user-group-link","params":{"groupHubId":"dfw-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-florida-user-group-link","params":{"groupHubId":"florida-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-michigan-user-group-link","params":{"groupHubId":"michigan-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-minnesota-user-group-link","params":{"groupHubId":"minnesota-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-philadelphia-user-group-link","params":{"groupHubId":"philadelphia-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-socal-user-group-link","params":{"groupHubId":"socal-user-group"},"routeName":"GroupHubPage"}],"linkType":"INTERNAL","id":"advanced","params":{"categoryId":"Advanced"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"partner-1","params":{"boardId":"Partner","categoryId":"Partner"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"summit-webinar-materials","params":{"boardId":"SummitWebinarMaterials","categoryId":"Partner"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"onestreamtaxprovisionpartners","params":{"boardId":"onestreamtaxprovisionpartners","categoryId":"Partner"},"routeName":"TkbBoardPage"}],"linkType":"INTERNAL","id":"partner","params":{"categoryId":"Partner"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"wave","params":{"boardId":"Wave","categoryId":"internal"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"internalforum","params":{"boardId":"internalforum","categoryId":"internal"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"internal","params":{"categoryId":"Internal"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"abuse-reports","params":{"boardId":"abuse-reports","categoryId":"community-management"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"filter-notifications","params":{"boardId":"filter-notifications","categoryId":"community-management"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"moderation-archive","params":{"boardId":"moderation-archive","categoryId":"community-management"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"moderation-k-b","params":{"boardId":"ModerationKB","categoryId":"community-management"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"Common-ideastream-archive-link","params":{"boardId":"ideastream-archive","categoryId":"community-management"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"introduce","params":{"boardId":"Introduce","categoryId":"community-management"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"community-management","params":{"categoryId":"community-management"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"Common-wave-link","params":{"boardId":"Wave","categoryId":"internal"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"Common-internalforum-link","params":{"boardId":"internalforum","categoryId":"internal"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"internal-link","params":{"categoryId":"internal"},"routeName":"CategoryPage"}]},"className":"QuiltComponent_lia-component-edit-mode__0nCcm","style":{"boxShadow":"var(--lia-bs-box-shadow-sm)","linkFontWeight":"400","controllerHighlightColor":"hsla(30, 100%, 50%)","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkFontSize":"15px","linkBoxShadowHover":"none","backgroundOpacity":0.8,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","linkTextBorderBottom":"none","hamburgerColor":"var(--lia-nav-controller-icon-color)","brandLogoHeight":"80px","linkLetterSpacing":"normal","linkBgHoverColor":"transparent","collapseMenuDividerOpacity":0.16,"paddingBottom":"10px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"1px solid var(--lia-bs-border-color)","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","linkJustifyContent":"center","linkColor":"var(--lia-bs-body-color)","collapseMenuDividerBg":"var(--lia-nav-link-color)","dropdownPaddingTop":"10px","controllerHighlightTextColor":"var(--lia-yiq-dark)","controllerTextColor":"var(--lia-nav-controller-icon-color)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-body-color)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"2px solid var(--lia-bs-gray-800)","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","linkPaddingX":"10px","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","paddingTop":"0px","linkPaddingY":"5px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkBgColor":"transparent","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-body-color)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-body-color)"},"showSearchIcon":true,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":null,"__typename":"QuiltComponent"},{"id":"community.widget.bannerWidget","props":{"backgroundColor":"transparent","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"backgroundImageProps":{"assetName":"community-widget-bannerWidget-1730266943818.jpg","backgroundSize":"COVER","lastModified":"1730266947000","backgroundPosition":"CENTER_CENTER","backgroundRepeat":"NO_REPEAT"},"fontColor":"var(--lia-bs-body-color)"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"var(--lia-bs-body-color)","items":[{"id":"custom.widget.Footer","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:component:custom.widget.Footer-en-us-1746700462818":{"__typename":"CachedAsset","id":"component:custom.widget.Footer-en-us-1746700462818","value":{"component":{"id":"custom.widget.Footer","template":{"id":"Footer","markupLanguage":"HTML","style":null,"texts":{},"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Footer","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"TEXTHTML","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1746664278000","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1746664278000","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons","messageArchived":"This post was archived on {date}","relatedUrl":"View Related Content","relatedContentText":"Showing related content","archivedContentLink":"View Archived Content"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1746664278000","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solution","movedMessagePlaceholder.BLOG":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.TKB":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.FORUM":"{count, plural, =0 {This reply has been} other {These replies have been} }","movedMessagePlaceholder.IDEA":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.OCCASION":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholderUrlText":"moved.","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageDeepLink-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageDeepLink-1746664278000","value":{"viewFullDiscussion@board:FORUM":"View Full Discussion ({repliesCount} Replies)","viewFullDiscussion@board:BLOG":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:TKB":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:IDEA":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:OCCASION":"View Full Discussion ({repliesCount} Comments)","showParents@board:FORUM":"Show Parent Replies","showParents@board:BLOG":"Show Parent Comments","showParents@board:TKB":"Show Parent Comments","showParents@board:IDEA":"Show Parent Comments","showParents@board:OCCASION":"Show Parent Comments"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1746664278000","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"CachedAsset:text:en_US-components/messages/RelatedContentWidget-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/RelatedContentWidget-1746664278000","value":{"title":"Related Content","emptyDescription":"No content to show"},"localOverride":false},"Forum:board:welcome":{"__typename":"Forum","id":"board:welcome","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:blog":{"__typename":"Blog","id":"board:blog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:AppBuild":{"__typename":"Forum","id":"board:AppBuild","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:WorkflowDI":{"__typename":"Forum","id":"board:WorkflowDI","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"entityType":"FORUM","displayId":"WorkflowDI","nodeType":"board","depth":2,"conversationStyle":"FORUM","title":"Workflow and Data Integration","shortTitle":"Workflow and Data Integration","parent":{"__ref":"Category:category:your-community"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":null,"description":"Discuss data loading and processing into the application","eventPath":"category:your-community/community:otqon28567board:WorkflowDI/"},"Forum:board:Reporting":{"__typename":"Forum","id":"board:Reporting","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Advanced":{"__typename":"Category","id":"category:Advanced","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Bulletins":{"__typename":"Category","id":"category:Bulletins","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:taxprovision":{"__typename":"GroupHub","id":"grouphub:taxprovision","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"entityType":"GROUP_HUB","displayId":"taxprovision","nodeType":"grouphub","depth":2,"title":"OneStream Tax Provision","shortTitle":"OneStream Tax Provision"},"Forum:board:FrenchLanguageForum":{"__typename":"Forum","id":"board:FrenchLanguageForum","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:TechTalks":{"__typename":"Forum","id":"board:TechTalks","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:Podcast":{"__typename":"Forum","id":"board:Podcast","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:platformupgrades":{"__typename":"GroupHub","id":"grouphub:platformupgrades","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:technicaldocuments":{"__typename":"Category","id":"category:technicaldocuments","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"entityType":"CATEGORY","displayId":"technicaldocuments","nodeType":"category","depth":2,"title":"Technical Documents","shortTitle":"Technical Documents"},"Rank:rank:19":{"__typename":"Rank","id":"rank:19","position":18,"name":"New Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:2111":{"__typename":"User","id":"user:2111","uid":2111,"login":"Ando","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-7.svg?time=0"},"rank":{"__ref":"Rank:rank:19"},"email":"","messagesCount":12,"biography":null,"topicsCount":6,"kudosReceivedCount":0,"kudosGivenCount":3,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-04-06T09:20:49.095-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":0},"ModerationData:moderation_data:11863":{"__typename":"ModerationData","id":"moderation_data:11863","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:11863_1":{"__typename":"Revision","id":"revision:11863_1","lastEditTime":"2022-10-05T08:56:36.306-07:00"},"Rank:rank:16":{"__typename":"Rank","id":"rank:16","position":15,"name":"Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:268":{"__typename":"User","id":"user:268","uid":268,"login":"RobDessureault","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-11-04T05:51:41.974-07:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-3.svg?time=0"},"rank":{"__ref":"Rank:rank:16"},"messagesCount":219,"kudosGivenCount":19,"kudosReceivedCount":13,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":3,"entityType":"USER","eventPath":"community:otqon28567/user:268"},"Tkb:board:taxprovisiontkb-board":{"__typename":"Tkb","id":"board:taxprovisiontkb-board","entityType":"TKB","displayId":"taxprovisiontkb-board","nodeType":"board","depth":3,"conversationStyle":"TKB","title":"OneStream Tax Provision Articles","shortTitle":"Knowledge Base","parent":{"__ref":"GroupHub:grouphub:taxprovision"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":null,"description":"","eventPath":"grouphub:taxprovision/category:Advanced/community:otqon28567board:taxprovisiontkb-board/"},"TkbTopicMessage:message:28432":{"__typename":"TkbTopicMessage","uid":28432,"subject":"Sample Workflow Upload Template","id":"message:28432","revisionNum":5,"repliesCount":0,"author":{"__ref":"User:user:268"},"depth":0,"hasGivenKudo":false,"helpful":null,"board":{"__ref":"Tkb:board:taxprovisiontkb-board"},"conversation":{"__ref":"Conversation:conversation:28432"},"contentWorkflow":{"__typename":"ContentWorkflow","state":"PUBLISH","scheduledPublishTime":null,"scheduledTimezone":null,"shortScheduledTimezone":null,"userContext":{"__typename":"MessageWorkflowContext","canSubmitForReview":null,"canEdit":false,"canRecall":null,"canSubmitForPublication":null,"canReturnToAuthor":null,"canPublish":null,"canReturnToReview":null,"canSchedule":false}},"moderationData":{"__ref":"ModerationData:moderation_data:28432"},"teaser":"","postTime":"2024-01-12T11:46:15.102-08:00","lastPublishTime":"2024-02-20T11:19:33.053-08:00","readOnly":false,"introduction":"","metrics":{"__typename":"MessageMetrics","views":737},"placeholder":false,"originalMessageForPlaceholder":null,"entityType":"TKB_ARTICLE","eventPath":"grouphub:taxprovision/category:Advanced/community:otqon28567board:taxprovisiontkb-board/message:28432"},"Conversation:conversation:28432":{"__typename":"Conversation","id":"conversation:28432","solved":false,"topic":{"__ref":"TkbTopicMessage:message:28432"},"lastPostingActivityTime":"2024-02-20T11:19:33.053-08:00","lastPostTime":"2024-01-12T11:46:15.102-08:00"},"ModerationData:moderation_data:28432":{"__typename":"ModerationData","id":"moderation_data:28432","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:28432":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:28432","relatedMessage":{"__ref":"TkbTopicMessage:message:28432"}},"User:user:3053":{"__typename":"User","id":"user:3053","uid":3053,"login":"cons1","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-07-31T22:37:06.162-07:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-5.svg?time=0"},"rank":{"__ref":"Rank:rank:18"},"messagesCount":16,"kudosGivenCount":4,"kudosReceivedCount":1,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:otqon28567/user:3053"},"ForumTopicMessage:message:30690":{"__typename":"ForumTopicMessage","uid":30690,"subject":"Batch posting of journals","id":"message:30690","revisionNum":2,"repliesCount":5,"author":{"__ref":"User:user:3053"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Rules"},"conversation":{"__ref":"Conversation:conversation:30690"},"moderationData":{"__ref":"ModerationData:moderation_data:30690"},"postTime":"2024-02-26T11:51:13.025-08:00","lastPublishTime":"2024-02-27T00:12:25.746-08:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":1776},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:Rules/message:30690"},"Conversation:conversation:30690":{"__typename":"Conversation","id":"conversation:30690","solved":true,"topic":{"__ref":"ForumTopicMessage:message:30690"},"lastPostingActivityTime":"2024-12-16T07:37:42.657-08:00","lastPostTime":"2024-12-16T07:37:42.657-08:00"},"ModerationData:moderation_data:30690":{"__typename":"ModerationData","id":"moderation_data:30690","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:30690":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:30690","relatedMessage":{"__ref":"ForumTopicMessage:message:30690"}},"User:user:3976":{"__typename":"User","id":"user:3976","uid":3976,"login":"Ricardo_Mil","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-10-21T03:17:22.249-07:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-9.svg?time=0"},"rank":{"__ref":"Rank:rank:19"},"messagesCount":6,"kudosGivenCount":2,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:otqon28567/user:3976"},"ForumTopicMessage:message:13794":{"__typename":"ForumTopicMessage","uid":13794,"subject":"Automation to upload files from Sharefolder to OS","id":"message:13794","revisionNum":1,"repliesCount":2,"author":{"__ref":"User:user:3976"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:WorkflowDI"},"conversation":{"__ref":"Conversation:conversation:13794"},"moderationData":{"__ref":"ModerationData:moderation_data:13794"},"postTime":"2022-11-24T09:32:17.277-08:00","lastPublishTime":"2022-11-24T09:32:17.277-08:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":2147},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:WorkflowDI/message:13794"},"Conversation:conversation:13794":{"__typename":"Conversation","id":"conversation:13794","solved":true,"topic":{"__ref":"ForumTopicMessage:message:13794"},"lastPostingActivityTime":"2022-11-25T02:06:55.667-08:00","lastPostTime":"2022-11-25T02:06:55.667-08:00"},"ModerationData:moderation_data:13794":{"__typename":"ModerationData","id":"moderation_data:13794","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:13794":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:13794","relatedMessage":{"__ref":"ForumTopicMessage:message:13794"}},"Rank:rank:20":{"__typename":"Rank","id":"rank:20","position":19,"name":"New Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:8688":{"__typename":"User","id":"user:8688","uid":8688,"login":"Andy66","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-02-06T10:53:21.951-08:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-12.svg?time=0"},"rank":{"__ref":"Rank:rank:20"},"messagesCount":15,"kudosGivenCount":1,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:otqon28567/user:8688"},"ForumTopicMessage:message:35370":{"__typename":"ForumTopicMessage","uid":35370,"subject":"DATA UPLOAD","id":"message:35370","revisionNum":1,"repliesCount":1,"author":{"__ref":"User:user:8688"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:WorkflowDI"},"conversation":{"__ref":"Conversation:conversation:35370"},"moderationData":{"__ref":"ModerationData:moderation_data:35370"},"postTime":"2024-06-12T09:24:33.825-07:00","lastPublishTime":"2024-06-12T09:24:33.825-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":690},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:WorkflowDI/message:35370"},"Conversation:conversation:35370":{"__typename":"Conversation","id":"conversation:35370","solved":true,"topic":{"__ref":"ForumTopicMessage:message:35370"},"lastPostingActivityTime":"2024-06-12T09:43:01.779-07:00","lastPostTime":"2024-06-12T09:43:01.779-07:00"},"ModerationData:moderation_data:35370":{"__typename":"ModerationData","id":"moderation_data:35370","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:35370":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:35370","relatedMessage":{"__ref":"ForumTopicMessage:message:35370"}},"Rank:rank:13":{"__typename":"Rank","id":"rank:13","position":12,"name":"Valued Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:5":{"__typename":"User","id":"user:5","uid":5,"login":"OSAdmin","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-07-16T07:44:17.712-07:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/images/dS01LTExMmk1NkQwQkNDQTk1RTAyNDBF"},"rank":{"__ref":"Rank:rank:13"},"messagesCount":1059,"kudosGivenCount":0,"kudosReceivedCount":125,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":15,"entityType":"USER","eventPath":"community:otqon28567/user:5"},"Tkb:board:AcceptedCodeSample":{"__typename":"Tkb","id":"board:AcceptedCodeSample","entityType":"TKB","displayId":"AcceptedCodeSample","nodeType":"board","depth":3,"conversationStyle":"TKB","title":"Accepted Code Samples","shortTitle":"Accepted Code Samples","parent":{"__ref":"Category:category:technicaldocuments"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":null,"description":"OneStream approved sample code snippets and examples to help everyone write rules.","eventPath":"category:technicaldocuments/category:Bulletins/community:otqon28567board:AcceptedCodeSample/"},"TkbTopicMessage:message:6915":{"__typename":"TkbTopicMessage","uid":6915,"subject":"Extender: automate Import, Validate, Load","id":"message:6915","revisionNum":2,"repliesCount":0,"author":{"__ref":"User:user:5"},"depth":0,"hasGivenKudo":false,"helpful":null,"board":{"__ref":"Tkb:board:AcceptedCodeSample"},"conversation":{"__ref":"Conversation:conversation:6915"},"contentWorkflow":{"__typename":"ContentWorkflow","state":"PUBLISH","scheduledPublishTime":null,"scheduledTimezone":null,"shortScheduledTimezone":null,"userContext":{"__typename":"MessageWorkflowContext","canSubmitForReview":null,"canEdit":false,"canRecall":null,"canSubmitForPublication":null,"canReturnToAuthor":null,"canPublish":null,"canReturnToReview":null,"canSchedule":null}},"moderationData":{"__ref":"ModerationData:moderation_data:6915"},"teaser":"","postTime":"2022-04-25T05:18:24.314-07:00","lastPublishTime":"2023-09-27T09:36:35.078-07:00","readOnly":true,"introduction":"","metrics":{"__typename":"MessageMetrics","views":1901},"placeholder":false,"originalMessageForPlaceholder":null,"entityType":"TKB_ARTICLE","eventPath":"category:technicaldocuments/category:Bulletins/community:otqon28567board:AcceptedCodeSample/message:6915"},"Conversation:conversation:6915":{"__typename":"Conversation","id":"conversation:6915","solved":false,"topic":{"__ref":"TkbTopicMessage:message:6915"},"lastPostingActivityTime":"2023-09-27T09:36:35.078-07:00","lastPostTime":"2022-04-25T05:18:24.314-07:00"},"ModerationData:moderation_data:6915":{"__typename":"ModerationData","id":"moderation_data:6915","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:6915":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:6915","relatedMessage":{"__ref":"TkbTopicMessage:message:6915"}},"QueryVariables:MessageSolutions":{"__typename":"QueryVariables","id":"MessageSolutions","value":{"first":10,"constraints":{"topicId":{"eq":"message:3508"},"solution":{"eq":true}},"sorts":{"postTime":{"direction":"ASC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":false,"useBody":true,"useKudosCount":false,"useTimeToRead":false,"useMedia":true,"useRepliesCount":false,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":true,"useTags":false,"useUserHoverCard":false,"useNodeHoverCard":false,"usePreviewSubjectModal":false,"useMessageStatus":false}},"ROOT_MUTATION":{"__typename":"Mutation"},"QueryVariables:ReplyList:message:13672:1":{"__typename":"QueryVariables","id":"ReplyList:message:13672:1","value":{"id":"message:13672","first":10,"sorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"CachedAsset:text:en_US-components/community/Navbar-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1746664278000","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","migrated-link-9":"Support ","reports":"Application Build","migrated-link-7":"News","accepted-code-sample":"Accepted Code Samples","migrated-link-8":"Groups","advanced":"Groups","Common-internalforum-link":"Internal Consultants (PIE)","migrated-link-1":"Internal","Common-wave-link":"WAVE Content","migrated-link-2":"Partners","rules":"Rules","migrated-link-0":"Hubs","o-h":"Implementation Q&A Archive","migrated-link-5":"Resources","blog":"Community Blog","migrated-link-6":"IdeaStream","pie":"PIE","migrated-link-3":"Developer Network","wave-presentations":"WAVE Presentations","migrated-link-4":"Forums","partner-1":"Partner Forum","your-community":"Forums","internal-link":"Internal","Common-philadelphia-user-group-link":"Philadelphia User Group","privatepreview-journalentrymanager-link":"Private Preview: Journey Entry Manager","planning-analysis-ideas":"Planning & Analysis","welcome":"Community Announcements","Common-ideastream-archive-link":"IdeaStream Archive","filter-notifications":"Filter Notifications","Common-north-america-user-group-leaders-link":"North America User Group Leaders","partner-a-i-services":"Partner AI Services","foundational-design-guides":"Foundational Design Guides","platformupgrades":"Platform v8+ Upgrades","sensibleml":"Sensible ML","ideas":"IdeaStream","academicalliances":"Academic Alliances","market-place-core-ideas":"OneStream Solutions","news-and-views":"Internal","e-s-g-focus-group":"ESG Focus Group","Common-michigan-user-group-link-1":"Michigan User Group","foundationaldesign":"Foundational Design Guides","community-management":"Moderate","Common-south-africa-user-group-link":"South Africa User Group","Common-florida-user-group-link":"Florida User Group","community-announcements":"Community Announcements","internal":"Internal","workflow-d-i":"Workflow and Data Integration","abuse-reports":"Abuse Reports","internalforum":"Internal Consultants (PIE)","productivity-":"Productivity","Common-esg-private-preview-link":"ESG Private Preview","Common-socal-user-group-link":"SoCal User Group","customer-advisory-board":"Customer Advisory Board- CAB","platform":"Platform","wave":"WAVE Content","planning-":"Planning & Analysis","Common-minnesota-user-group-link":"Minnesota User Group","Common-dfw-user-group-link":"DFW User Group","reports-1":"Application Build","app-build":"Application Build","financial-close-compliance-ideas":"Financial Close & Consolidations","Common-michigan-user-group-link":"Michigan User Group","podcast":"The OneStream Podcast: Continue the Conversation","moderation-archive":"Moderation Forum Archive","technical-documents":"Technical Documents","p-a-b":"Partner Advisory Board","data-workflow--integration-":"Data Workflow & Integration","moderation-k-b":"Moderation KB Archive","reporting":"Reporting","bulletins":"Resources","cpmexpress":"CPM Express","summit-":"Summit + Webinar Materials","introduce":"Introduce Yourself","community-blog":"Community Blog","solution-exchange":"Solutions","productivity-ideas":"Productivity","partner-discussions":"Partner Forum","tech-talks":"OneStream Tech Talks: Continue the Conversation","bulletins-1":"Technical Documents","advanced-analytics-ideas":"Advanced Analytics & AI","boatlaunchdevelopers":"Boat Launch","Common-atlanta-user-group-link":"Atlanta User Group","platform-core":"Platform","summit-webinar-materials":"Summit and Webinar Materials","onestream-community-resources":"OneStream Community Resources","partner":"Partners","e-m-e-a-c-a-b-link":"EMEA Customer Advisory Board","french-language-forum":"French Language Forum","projectlongship":"Project Longship","taxprovision":"Tax Provision","n-a-c-a-b-link":"NA Customer Advisory Board","onestreamtaxprovisionpartners":"OneStream Tax Provision"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1746664278000","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1746664278000","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1746664278000","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1746664278000","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1746664278000","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1746664278000","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1746664278000","value":{"escalationMessage":"Escalated to Salesforce by {username} on {date}","viewDetails":"View Details","modalTitle":"Case Details","escalatedBy":"Escalated by: ","escalatedOn":"Escalated on: ","caseNumber":"Case Number: ","status":"Status: ","lastUpdateDate":"Last Update: ","automaticEscalation":"automatic escalation","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1746664278000","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1746664278000","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1746664278000","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1746664278000","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1746664278000","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1746664278000","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1746664278000","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1746664278000","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1746664278000","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolutionList-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolutionList-1746664278000","value":{"emptyDescription":"No has been message solutions yet"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1746664278000","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved","topicAlreadySolvedErrorTitle":"Solution Already Exists","topicAlreadySolvedErrorDesc":"Refresh the browser to view the existing solution"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1746664278000","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"ForumReplyMessage:message:13672":{"__typename":"ForumReplyMessage","id":"message:13672","customFields":[],"revisionNum":1,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"parent":{"__ref":"ForumTopicMessage:message:2898"},"repliesCount":0,"replies":{"__typename":"MessageConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:337":{"__typename":"User","id":"user:337","deleted":false,"uid":337,"login":"JZamorski","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-11-10T12:21:46.342-08:00"}},"ForumTopicMessage:message:2898":{"__typename":"ForumTopicMessage","uid":2898,"id":"message:2898","revisionNum":2,"author":{"__ref":"User:user:337"},"readOnly":false,"repliesCount":5},"User:user:44":{"__typename":"User","id":"user:44","uid":44,"login":"tsandi","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-10-13T07:19:43.755-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-7.svg?time=0"},"entityType":"USER","eventPath":"community:otqon28567/user:44"},"ModerationData:moderation_data:3541":{"__typename":"ModerationData","id":"moderation_data:3541","status":"UNMODERATED","rejectReason":null},"AssociatedImage:{\"url\":\"https://community.onestreamsoftware.com/t5/s/otqon28567/images/bS0zNTQxLTEwMzNpMTJBQzFFMTE0QzYwRjE4Mg?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/images/bS0zNTQxLTEwMzNpMTJBQzFFMTE0QzYwRjE4Mg?revision=1","title":"tsandi_0-1639413092489.png","associationType":"BODY","width":2239,"height":269,"altText":null},"AcceptedSolutionMessage:message:3541":{"__typename":"AcceptedSolutionMessage","author":{"__ref":"User:user:44"},"id":"message:3541","revisionNum":1,"uid":3541,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Rules"},"parent":{"__ref":"ForumTopicMessage:message:3508"},"conversation":{"__ref":"Conversation:conversation:3508"},"subject":"Re: Batch Automation Uploads","moderationData":{"__ref":"ModerationData:moderation_data:3541"},"body":"You can create a mask for unmapped values across every dimension and use the Order to make sure that will be the last rule applied, but it is a VERY BAD IDEA since the whole purpose of a data quality layer is to make sure the whole dataset gets loaded. If your customer has data quality issues and you want to use OneStream to analyze that data you can use a Blend load with Garbage mask rules, allows the users to review the transactions in blend and create a second load with the updated mappings.
If the source GL data has additional metadata that needs to be created you can include the metadata creation in the connector rule itself so loads will find the appropriate members when loading data.
","body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"203","postTime":"2021-12-13T08:34:32.218-08:00","lastPublishTime":"2021-12-13T08:34:32.218-08:00","images":{"__typename":"AssociatedImageConnection","edges":[{"__typename":"AssociatedImageEdge","cursor":"MjUuM3wyLjF8b3wyNXxfTlZffDE","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.onestreamsoftware.com/t5/s/otqon28567/images/bS0zNTQxLTEwMzNpMTJBQzFFMTE0QzYwRjE4Mg?revision=1\"}"}}],"totalCount":1,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"solution":true,"metrics":{"__typename":"MessageMetrics","views":4041},"placeholder":false,"originalMessageForPlaceholder":null,"videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"isEscalated":null,"entityType":"FORUM_REPLY","eventPath":"category:your-community/community:otqon28567board:Rules/message:3508/message:3541","customFields":[]},"User:user:545":{"__typename":"User","id":"user:545","uid":545,"login":"Gidon_Albert","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-11-23T08:06:21.051-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-12.svg?time=0"},"entityType":"USER","eventPath":"community:otqon28567/user:545","rank":{"__ref":"Rank:rank:16"}},"ModerationData:moderation_data:3837":{"__typename":"ModerationData","id":"moderation_data:3837","status":"UNMODERATED","rejectReason":null},"AcceptedSolutionMessage:message:3837":{"__typename":"AcceptedSolutionMessage","author":{"__ref":"User:user:545"},"id":"message:3837","revisionNum":1,"uid":3837,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Rules"},"parent":{"__ref":"ForumTopicMessage:message:3508"},"conversation":{"__ref":"Conversation:conversation:3508"},"subject":"Re: Batch Automation Uploads","moderationData":{"__ref":"ModerationData:moderation_data:3837"},"body":"
We use the TransfromationEventHandler to either add new members under \"Unmapped_Members\" parent if the we are using one-to-one mapping, or map them to an \"Unmapped_Members\" base level member if we are using many-to-one mapping. The rule captures the name of the new members that are added and sends an e-mail to the admin to let them know that new members were added. Admin still has to move the new members or update the maps as needed, but at least the load process doesn't fail.
","body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"203","postTime":"2022-01-03T10:28:22.137-08:00","lastPublishTime":"2022-01-03T10:28:22.137-08:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"solution":true,"metrics":{"__typename":"MessageMetrics","views":4009},"placeholder":false,"originalMessageForPlaceholder":null,"videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"isEscalated":null,"entityType":"FORUM_REPLY","eventPath":"category:your-community/community:otqon28567board:Rules/message:3508/message:3837","customFields":[]},"QueryVariables:ReplyList:message:11863:1":{"__typename":"QueryVariables","id":"ReplyList:message:11863:1","value":{"id":"message:11863","first":10,"sorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1746664278000","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1746664278000","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1746664278000","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1746664278000","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1746664278000","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1746664278000","value":{"errorMessage":"Error rendering component id: {customComponentId}","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"ModerationData:moderation_data:11875":{"__typename":"ModerationData","id":"moderation_data:11875","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:11875":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:545"},"id":"message:11875","revisionNum":1,"uid":11875,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Rules"},"parent":{"__ref":"ForumReplyMessage:message:11863"},"conversation":{"__ref":"Conversation:conversation:3508"},"subject":"Re: Batch Automation Uploads","moderationData":{"__ref":"ModerationData:moderation_data:11875"},"body":"The rule we use to dynamically update members is highly customized and specific to our application. It will require some work to make it work for your needs.
OneStream has a MarketPlace solution called ACM that can update new members during data load. It works well and is easy to configure. It is also free!
Let me know if the ACM doesn't work for you and I'll be happy to share our TransformationEventHandler.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-10-05T10:43:13.147-07:00","lastPublishTime":"2022-10-05T10:43:13.147-07:00","metrics":{"__typename":"MessageMetrics","views":3409},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:your-community/community:otqon28567board:Rules/message:3508/message:11875","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeIcon-1746664278000","value":{"contentType":"Content Type {style, select, FORUM {Forum} BLOG {Blog} TKB {Knowledge Base} IDEA {Ideas} OCCASION {Events} other {}} icon"},"localOverride":false},"QueryVariables:ReplyList:message:23675:1":{"__typename":"QueryVariables","id":"ReplyList:message:23675:1","value":{"id":"message:23675","first":10,"sorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ForumReplyMessage:message:23675":{"__typename":"ForumReplyMessage","id":"message:23675","customFields":[],"revisionNum":1,"parent":{"__ref":"ForumTopicMessage:message:23638"},"repliesCount":0,"replies":{"__typename":"MessageConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:2459":{"__typename":"User","id":"user:2459","deleted":false,"uid":2459,"login":"vijay","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-05-24T15:09:31.143-07:00"}},"ForumTopicMessage:message:23638":{"__typename":"ForumTopicMessage","uid":23638,"id":"message:23638","revisionNum":1,"author":{"__ref":"User:user:2459"},"readOnly":false,"repliesCount":1}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"Rules","messageSubject":"batch-automation-uploads","messageId":"3508","replyId":"11863"},"buildId":"-gVUpXaWnPcjlrLJZ92B7","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"onestream","openTelemetryServiceVersion":"25.3.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/messages/RelatedContentWidget/RelatedContentWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx","../shared/client/components/common/List/UnstyledList/UnstyledList.tsx","./components/messages/MessageView/MessageView.tsx","./components/messages/MessageView/MessageViewInline/MessageViewInline.tsx","./components/customComponent/CustomComponentContent/HtmlContent.tsx","./components/customComponent/CustomComponentContent/CustomComponentScripts.tsx"],"appGip":true,"scriptLoader":[]}