It's been a little while, but I do recall having the option to choose between tab delimited and comma delimited data format when importing, I had a quick read (and watch) of this article and that confirmed the data format selector options: Importing data
Although I do remember that anyone that has a .csv file it can't be seen by ARL by default, from memory you just need to change the File Type selector in the bottom-right of the File Browser to say "All Types" to be able to pick up the .csv file.
In terms of a null value, as I understand it; if there's a field that has no data it should be left empty in the import data. IIRC it will be considered an empty string. Or you can leave the field out altogether to avoid that scenario.
I am not up to speed on if there is a bug with null values on imports, did a quick search and couldn't see anything specific pop up. Is that what you're referring to?
And for having commas in the Description text in a comma-separated data import, you should be able to just surround the text with double quotations in the relevant description field to import it. Is this not working on your data imports?
It's been a little while, but I do recall having the option to choose between tab delimited and comma delimited data format when importing, I had a quick read (and watch) of this article and that confirmed the data format selector options: Importing data
Although I do remember that anyone that has a .csv file it can't be seen by ARL by default, from memory you just need to change the File Type selector in the bottom-right of the File Browser to say "All Types" to be able to pick up the .csv file.
In terms of a null value, as I understand it; if there's a field that has no data it should be left empty in the import data. IIRC it will be considered an empty string. Or you can leave the field out altogether to avoid that scenario.
I am not up to speed on if there is a bug with null values on imports, did a quick search and couldn't see anything specific pop up. Is that what you're referring to?
And for having commas in the Description text in a comma-separated data import, you should be able to just surround the text with double quotations in the relevant description field to import it. Is this not working on your data imports?
Out-effing-standing! CSV's should be the default option for Imorting field based data (in my opinion). The option to solve all my problems WAS an option all along, I just had to disregard all the current documentation and I'm good to go.
The article you and I both read, advised: "you'll need to export the data you want from the program you’ve used to create the data and save it in a tab-delimited or comma-separated text file."
But I thank you for providing information that should have been made readily available to anyone looking to import data.
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
"}},"componentScriptGroups({\"componentId\":\"custom.widget.Custom_Footer\"})":{"__typename":"ComponentScriptGroups","scriptGroups":{"__typename":"ComponentScriptGroupsDefinition","afterInteractive":{"__typename":"PageScriptGroupDefinition","group":"AFTER_INTERACTIVE","scriptIds":[]},"lazyOnLoad":{"__typename":"PageScriptGroupDefinition","group":"LAZY_ON_LOAD","scriptIds":[]}},"componentScripts":[]},"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/community/NavbarDropdownToggle\"]})":[{"__ref":"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/EscalatedMessageBanner\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/users/UserLink\"]})":[{"__ref":"CachedAsset:text:en_US-components/users/UserLink-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserRank\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserRank-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageTime\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageTime-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSolvedBadge\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSubject\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSubject-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageBody\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageBody-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageCustomFields\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageCustomFields-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageReplyButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageReplyButton-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSolutionList\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSolutionList-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/AcceptedSolutionButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/common/Pager/PagerLoadMore\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/customComponent/CustomComponent\"]})":[{"__ref":"CachedAsset:text:en_US-components/customComponent/CustomComponent-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageView/MessageViewInline\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1743051948212"}],"message({\"id\":\"message:668967\"})":{"__ref":"AcceptedSolutionMessage:message:668967"},"message({\"id\":\"message:670663\"})":{"__ref":"ForumReplyMessage:message:670663"},"messages({\"constraints\":{\"solution\":{\"eq\":true},\"topicId\":{\"eq\":\"message:668644\"}},\"first\":10,\"sorts\":{\"postTime\":{\"direction\":\"ASC\"}}})":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8aXwxMHwzOToxfGludCw2Njg5NjcsNjY4OTY3","node":{"__ref":"AcceptedSolutionMessage:message:668967"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null},"totalCount":1},"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserAvatar\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1743051948212"}],"cachedText({\"lastModified\":\"1743051948212\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/ranks/UserRankLabel\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1743051948212"}]},"CachedAsset:pages-1742490376534":{"__typename":"CachedAsset","id":"pages-1742490376534","value":[{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"BlogViewAllPostsPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId/all-posts/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"CreateGroupHubPage","type":"GROUP_HUB","urlPath":"/groups/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"CaseViewPage","type":"CASE_DETAILS","urlPath":"/case/:caseId/:caseNumber","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"InboxPage","type":"COMMUNITY","urlPath":"/inbox","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"HelpFAQPage","type":"COMMUNITY","urlPath":"/help","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"IdeaMessagePage","type":"IDEA_POST","urlPath":"/idea/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"IdeaViewAllIdeasPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/all-ideas/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"LoginPage","type":"USER","urlPath":"/signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"BlogPostPage","type":"BLOG","urlPath":"/category/:categoryId/blogs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ThemeEditorPage","type":"COMMUNITY","urlPath":"/designer/themes","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"TkbViewAllArticlesPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId/all-articles/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"OccasionEditPage","type":"EVENT","urlPath":"/event/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"OAuthAuthorizationAllowPage","type":"USER","urlPath":"/auth/authorize/allow","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"PageEditorPage","type":"COMMUNITY","urlPath":"/designer/pages","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"PostPage","type":"COMMUNITY","urlPath":"/category/:categoryId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ForumBoardPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"TkbBoardPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"EventPostPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"UserBadgesPage","type":"COMMUNITY","urlPath":"/users/:login/:userId/badges","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"GroupHubMembershipAction","type":"GROUP_HUB","urlPath":"/membership/join/:nodeId/:membershipType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"MaintenancePage","type":"COMMUNITY","urlPath":"/maintenance","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"IdeaReplyPage","type":"IDEA_REPLY","urlPath":"/idea/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"UserSettingsPage","type":"USER","urlPath":"/mysettings/:userSettingsTab","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"GroupHubsPage","type":"GROUP_HUB","urlPath":"/groups","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ForumPostPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"OccasionRsvpActionPage","type":"OCCASION","urlPath":"/event/:boardId/:messageSubject/:messageId/rsvp/:responseType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"VerifyUserEmailPage","type":"USER","urlPath":"/verifyemail/:userId/:verifyEmailToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"AllOccasionsPage","type":"OCCASION","urlPath":"/category/:categoryId/events/:boardId/all-events/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"EventBoardPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"TkbReplyPage","type":"TKB_REPLY","urlPath":"/kb/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"IdeaBoardPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"CommunityGuideLinesPage","type":"COMMUNITY","urlPath":"/communityguidelines","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ForgotPasswordPage","type":"USER","urlPath":"/forgotpassword","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"IdeaEditPage","type":"IDEA","urlPath":"/idea/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"TagPage","type":"COMMUNITY","urlPath":"/tag/:tagName","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"BlogBoardPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"OccasionMessagePage","type":"OCCASION_TOPIC","urlPath":"/event/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ManageContentPage","type":"COMMUNITY","urlPath":"/managecontent","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ClosedMembershipNodeNonMembersPage","type":"GROUP_HUB","urlPath":"/closedgroup/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"CommunityPage","type":"COMMUNITY","urlPath":"/","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ForumMessagePage","type":"FORUM_TOPIC","urlPath":"/discussions/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"IdeaPostPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"BlogMessagePage","type":"BLOG_ARTICLE","urlPath":"/blog/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"RegistrationPage","type":"USER","urlPath":"/register","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"EditGroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ForumEditPage","type":"FORUM","urlPath":"/discussions/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ResetPasswordPage","type":"USER","urlPath":"/resetpassword/:userId/:resetPasswordToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"TkbMessagePage","type":"TKB_ARTICLE","urlPath":"/kb/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"BlogEditPage","type":"BLOG","urlPath":"/blog/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ManageUsersPage","type":"USER","urlPath":"/users/manage/:tab?/:manageUsersTab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ForumReplyPage","type":"FORUM_REPLY","urlPath":"/discussions/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"PrivacyPolicyPage","type":"COMMUNITY","urlPath":"/privacypolicy","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"NotificationPage","type":"COMMUNITY","urlPath":"/notifications","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"UserPage","type":"USER","urlPath":"/users/:login/:userId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"HealthCheckPage","type":"COMMUNITY","urlPath":"/health","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"OccasionReplyPage","type":"OCCASION_REPLY","urlPath":"/event/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ManageMembersPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/manage/:tab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"SearchResultsPage","type":"COMMUNITY","urlPath":"/search","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"BlogReplyPage","type":"BLOG_REPLY","urlPath":"/blog/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"GroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"TermsOfServicePage","type":"COMMUNITY","urlPath":"/termsofservice","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"CategoryPage","type":"CATEGORY","urlPath":"/category/:categoryId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"ForumViewAllTopicsPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/all-topics/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"TkbPostPage","type":"TKB","urlPath":"/category/:categoryId/kbs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742490376534,"localOverride":null,"page":{"id":"GroupHubPostPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"}],"localOverride":false},"CachedAsset:text:en_US-components/context/AppContext/AppContextProvider-0":{"__typename":"CachedAsset","id":"text:en_US-components/context/AppContext/AppContextProvider-0","value":{"noCommunity":"Cannot find community","noUser":"Cannot find current user","noNode":"Cannot find node with id {nodeId}","noMessage":"Cannot find message with id {messageId}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-0":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-0","value":{"title":"Loading..."},"localOverride":false},"User:user:-1":{"__typename":"User","id":"user:-1","uid":-1,"login":"Anonymous","email":"","avatar":null,"rank":null,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":"ANONYMOUS","registrationTime":null,"confirmEmailStatus":false,"registrationAccessLevel":"VIEW","ssoRegistrationFields":[]},"ssoId":null,"profileSettings":{"__typename":"ProfileSettings","dateDisplayStyle":{"__typename":"InheritableStringSettingWithPossibleValues","key":"layout.friendly_dates_enabled","value":"true","localValue":"true","possibleValues":["true","false"]},"dateDisplayFormat":{"__typename":"InheritableStringSetting","key":"layout.format_pattern_date","value":"dd-MM-yyyy","localValue":"MM-dd-yyyy"},"language":{"__typename":"InheritableStringSettingWithPossibleValues","key":"profile.language","value":"en-US","localValue":null,"possibleValues":["en-US"]}},"deleted":false},"Theme:customTheme1":{"__typename":"Theme","id":"customTheme1"},"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi0zNTAtT25CV1B3?image-coordinates=0%2C0%2C320%2C320\"}":{"__typename":"AssociatedImage","url":"https://community.myob.com/t5/s/myob/images/bi0zNTAtT25CV1B3?image-coordinates=0%2C0%2C320%2C320","mimeType":"image/png"},"Category:category:AccountRight":{"__typename":"Category","id":"category:AccountRight","entityType":"CATEGORY","displayId":"AccountRight","nodeType":"category","depth":2,"title":"MYOB AccountRight","shortTitle":"MYOB AccountRight","parent":{"__ref":"Category:category:Support"},"categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:top":{"__typename":"Category","id":"category:top","displayId":"top","nodeType":"category","depth":0,"title":"Top","entityType":"CATEGORY","shortTitle":"Top"},"Category:category:Support":{"__typename":"Category","id":"category:Support","displayId":"Support","nodeType":"category","depth":1,"parent":{"__ref":"Category:category:top"},"title":"Product Help & Ideas","entityType":"CATEGORY","shortTitle":"Product Help & Ideas","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:Sales_and_Purchases":{"__typename":"Forum","id":"board:Sales_and_Purchases","entityType":"FORUM","displayId":"Sales_and_Purchases","nodeType":"board","depth":3,"conversationStyle":"FORUM","title":"AccountRight: Sales and Purchases","description":"Chat about sales and purchasing in AccountRight.","avatar":{"__ref":"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi0zNTAtT25CV1B3?image-coordinates=0%2C0%2C320%2C320\"}"},"profileSettings":{"__typename":"ProfileSettings","language":null},"parent":{"__ref":"Category:category:AccountRight"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:myob"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:Support"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:AccountRight"}}]},"userContext":{"__typename":"NodeUserContext","canAddAttachments":true,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"boardPolicies":{"__typename":"BoardPolicies","canPublishArticleOnCreate":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","key":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","args":[]}}},"shortTitle":"AccountRight: Sales and Purchases","repliesProperties":{"__typename":"RepliesProperties","sortOrder":"LIKES","repliesFormat":"threaded"},"eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/","tagProperties":{"__typename":"TagNodeProperties","tagsEnabled":{"__typename":"PolicyResult","failureReason":null}},"requireTags":false,"tagType":"FREEFORM_AND_PRESET"},"Rank:rank:177":{"__typename":"Rank","id":"rank:177","position":58,"name":"Cover User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:163295":{"__typename":"User","id":"user:163295","uid":163295,"login":"HVE","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-11.svg?time=0"},"rank":{"__ref":"Rank:rank:177"},"email":"","messagesCount":2,"biography":null,"topicsCount":1,"kudosReceivedCount":3,"kudosGivenCount":0,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2017-04-12T16:28:16.049+10:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:163295"},"ForumTopicMessage:message:668644":{"__typename":"ForumTopicMessage","uid":668644,"subject":"Importing professional sales","id":"message:668644","revisionNum":1,"repliesCount":2,"author":{"__ref":"User:user:163295"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"conversation":{"__ref":"Conversation:conversation:668644"},"readOnly":true,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:668644"},"body":"
Why isn't there an option to import csv in MYOB? Who made the decision to put that project in the too hard basket? Do you want me to fix it for you?
Does anyone have a resolution to null value fields for a tab delimited txt file?
I want to import a sales invoice with commas in the description field. What are the options?
","body@stringLength":"360","rawBody":"
Why isn't there an option to import csv in MYOB? Who made the decision to put that project in the too hard basket? Do you want me to fix it for you?
Does anyone have a resolution to null value fields for a tab delimited txt file?
I want to import a sales invoice with commas in the description field. What are the options?
","kudosSumWeight":1,"postTime":"2020-07-29T22:07:46.759+10: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":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:668644_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":857},"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,"searchSnippet":"Why isn't there an option to import csv in MYOB? Who made the decision to put that project in the too hard basket? Do you want me to fix it for you? Does anyone have a resolution to null value fie...","replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"AcceptedSolutionMessage:message:668967"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"Conversation:conversation:668644":{"__typename":"Conversation","id":"conversation:668644","solved":true,"topic":{"__ref":"ForumTopicMessage:message:668644"},"lastPostingActivityTime":"2020-08-10T17:34:29.444+10:00","lastPostTime":"2020-08-10T17:34:29.444+10:00","unreadReplyCount":2,"isSubscribed":false},"ModerationData:moderation_data:668644":{"__typename":"ModerationData","id":"moderation_data:668644","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:668644_1":{"__typename":"Revision","id":"revision:668644_1","lastEditTime":"2020-07-29T22:07:46.759+10:00"},"CachedAsset:theme:customTheme1-1742490376064":{"__typename":"CachedAsset","id":"theme:customTheme1-1742490376064","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":"10px","collections":["custom"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"Favicon-1710285586777.png","imageLastModified":"1710285589142","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"logo2-1710285458800.png","imageLastModified":"1710285462029","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1350px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"100vw","borderRadius":"100vw","borderRadiusLg":"100vw","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"12px","paddingXLg":"16px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"700","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-primary)","primaryBgHoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-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-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","secondaryTextColor":"var(--lia-bs-gray-900)","secondaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","secondaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","secondaryBgColor":"var(--lia-bs-gray-200)","secondaryBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","secondaryBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","tertiaryTextColor":"var(--lia-bs-gray-900)","tertiaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-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-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-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":"DARK","sideContent":"DARK","radiusSm":"6px","radius":"10px","radiusLg":"18px","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":"var(--lia-bs-link-color)","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","forumColor":"#EC0677","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":"#18AD31","blogColor":"#8118CD","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":"#430071","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":"#FF8000","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":"#D13A1F","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":"#A130F5","secondary":"#333333","bodyText":"#333333","bodyBg":"#FFFFFF","info":"#409AE2","success":"#41C5AE","warning":"#FCC844","danger":"#D13A1F","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#C497FE","#7B14EF","#EBDCFD","#232428","#FFF854","#070708"],"__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":{"link":{"color":"#0069D4","hoverColor":"#0061c2","decoration":"none","hoverDecoration":"underline","__typename":"EmailLinkSettings"},"border":{"color":"#e4e4e4","__typename":"EmailBorderSettings"},"buttons":{"borderRadiusLg":"5px","paddingXLg":"16px","paddingYLg":"7px","fontWeight":"700","primaryTextColor":"#ffffff","primaryTextHoverColor":"#ffffff","primaryBgColor":"#0069D4","primaryBgHoverColor":"#005cb8","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","__typename":"EmailButtonsSettings"},"panel":{"borderRadius":"5px","borderColor":"#e4e4e4","__typename":"EmailPanelSettings"},"__typename":"EmailThemeSettings"},"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"Inter","fontStyle":"NORMAL","fontWeight":"500","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":"100vw","borderRadius":"100vw","borderRadiusLg":"100vw","formTextMarginTop":"4px","textAreaBorderRadius":"18px","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":"var(--lia-bs-primary)","hoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) - 10%))","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":"4px","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":"4px","__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":"'Segoe UI', 'Helvetica Neue', Helvetica, Roboto, Arial, sans-serif","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":[],"__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-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1743051948212","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:myob.prod:pages/forums/ForumMessagePage:board:Sales_and_Purchases-1742490374169":{"__typename":"CachedAsset","id":"quilt:myob.prod:pages/forums/ForumMessagePage:board:Sales_and_Purchases-1742490374169","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":"var(--lia-bs-gray-200)","showTitle":false,"showDescription":false,"textPosition":"CENTER","textColor":"var(--lia-bs-body-color)","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":"custom.widget.Start_a_post","className":null,"props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":true,"title":"Looking for something else?","lazyLoad":false},"__typename":"QuiltComponent"},{"id":"custom.widget.Online_Help_SME","className":null,"props":{"customComponentId":"custom.widget.Online_Help_SME","customComponentProps":[]},"__typename":"QuiltComponent"},{"id":"custom.widget.MYOB_Academy","className":null,"props":{"customComponentId":"custom.widget.MYOB_Academy","customComponentProps":[]},"__typename":"QuiltComponent"},{"id":"messages.widget.relatedContentWidget","className":null,"props":{"hideIfEmpty":true,"enablePagination":false,"useTitle":true,"listVariant":{"type":"unstyled","props":{"listItemSpacing":"md"}},"instanceId":"1706573650217","pageSize":8,"style":"compact","pagerVariant":{"type":"none"},"viewVariant":{"type":"inline","props":{"useRepliesCount":false,"useMedia":false,"useAuthorRank":false,"useNode":false,"boardIconSize":"24","useAuthorLoginLink":true,"useNodeLink":true,"usePreviewMedia":true,"timeStampType":"postTime","useTextBody":true,"useSolvedBadge":false,"subjectAs":"h6","renderPostTimeBeforeAuthor":true,"useAvatar":true,"useVideoPreview":false,"portraitClampBodyLines":3,"useCompactSpacing":true,"useTimeToRead":false,"useSpoilerFreeBody":true,"useKudosCount":false,"useViewCount":false,"useBody":false,"useTags":false,"clampSubjectLines":1,"useBoardIcon":false,"useMessageTimeLink":true,"useAuthorLogin":true}},"lazyLoad":false,"panelType":"bubble"},"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1743051948212","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-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1743051948212","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","section.FvIRbP.title":"Forum Discussion","section.message-list.description":"","section.FvIRbP.description":""},"localOverride":false},"CachedAsset:quiltWrapper:myob.prod:Common:1742490239511":{"__typename":"CachedAsset","id":"quiltWrapper:myob.prod:Common:1742490239511","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"var(--lia-bs-gray-200)","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":true,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"mainLinks":[{"children":[{"linkType":"INTERNAL","id":"solo-link","params":{"categoryId":"Solo"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-1","params":{"categoryId":"Business"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-2","params":{"categoryId":"AccountRight"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-3","params":{"categoryId":"NZinfo"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-4","params":{"categoryId":"AdvancedPlatform"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-5","params":{"categoryId":"EntProdHelp"},"routeName":"CategoryPage"}],"linkType":"INTERNAL","id":"migrated-link-0","params":{"categoryId":"Support"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"partner-program-members","params":{"categoryId":"partner-program-members"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-7","params":{"boardId":"AD_Notices","categoryId":"beta"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-8","params":{"boardId":"MYOBAdvisor","categoryId":"beta"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-9","params":{"boardId":"myob-client-accounting","categoryId":"beta"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-10","params":{"boardId":"AETax","categoryId":"beta"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-11","params":{"boardId":"PracticeBAS","categoryId":"beta"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-6","params":{"categoryId":"beta"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-21","params":{"categoryId":"Scholarly"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-22","params":{"categoryId":"Developer"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-23","params":{"boardId":"AccountRightAPIquestions","categoryId":"top"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-24","params":{"categoryId":"MYOBAdvanced"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-25","params":{"categoryId":"enterprisesolutionpartners"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-26","params":{"groupHubId":"Payroll"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"migrated-link-27","params":{"boardId":"AccountEdge","categoryId":"PartnersGroup"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-20","params":{"categoryId":"PartnersGroup"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"Common-welcome-link","params":{"boardId":"Welcome","categoryId":"PurpleLounge"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"Common-community-blog-link","params":{"boardId":"CommunityBlog","categoryId":"PurpleLounge"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"Common-myobconnect-link","params":{"boardId":"myobconnect","categoryId":"PurpleLounge"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"Common-incident-communications-link","params":{"boardId":"incident-communications","categoryId":"PurpleLounge"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"Common-bank-feed-updates-link","params":{"boardId":"bank-feed-updates","categoryId":"PurpleLounge"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"Common-purple-lounge-link","params":{"categoryId":"PurpleLounge"},"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":"14px","linkBoxShadowHover":"none","backgroundOpacity":0.8,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","linkTextBorderBottom":"none","hamburgerColor":"var(--lia-nav-controller-icon-color)","brandLogoHeight":"34px","linkLetterSpacing":"normal","linkBgHoverColor":"transparent","collapseMenuDividerOpacity":0.16,"paddingBottom":"15px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"1px solid var(--lia-bs-border-color)","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","linkJustifyContent":"flex-start","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-gray-200)","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-primary)","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":"15px","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":{"backgroundColor":"transparent","linkHighlightColor":"var(--lia-bs-primary)","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"linkTextColor":"var(--lia-bs-gray-700)"},"__typename":"QuiltComponent"},{"id":"community.widget.bannerWidget","props":{"backgroundColor":"transparent","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"backgroundImageProps":{"backgroundSize":"COVER","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-gray-200)","items":[{"id":"community.widget.footerWidget","props":null,"__typename":"QuiltComponent"},{"id":"custom.widget.Custom_Footer","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1743051948212","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:component:custom.widget.Start_a_post-en-1742490390222":{"__typename":"CachedAsset","id":"component:custom.widget.Start_a_post-en-1742490390222","value":{"component":{"id":"custom.widget.Start_a_post","template":{"id":"Start_a_post","markupLanguage":"HTML","style":null,"texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Start_a_post","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:component:custom.widget.Online_Help_SME-en-1742490390222":{"__typename":"CachedAsset","id":"component:custom.widget.Online_Help_SME-en-1742490390222","value":{"component":{"id":"custom.widget.Online_Help_SME","template":{"id":"Online_Help_SME","markupLanguage":"HTML","style":null,"texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Online_Help_SME","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:component:custom.widget.MYOB_Academy-en-1742490390222":{"__typename":"CachedAsset","id":"component:custom.widget.MYOB_Academy-en-1742490390222","value":{"component":{"id":"custom.widget.MYOB_Academy","template":{"id":"MYOB_Academy","markupLanguage":"HTML","style":null,"texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.MYOB_Academy","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:component:custom.widget.Custom_Footer-en-1742490390222":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer-en-1742490390222","value":{"component":{"id":"custom.widget.Custom_Footer","template":{"id":"Custom_Footer","markupLanguage":"HANDLEBARS","style":".sr-only {\n position: absolute;\n width: 1px;\n height: 1px;\n padding: 0;\n margin: -1px;\n overflow: hidden;\n clip: rect(0, 0, 0, 0);\n border: 0;\n}\n\n.custom-footer-wrapper {\n background-color: #1b2830;\n}\n\n.custom-footer {\n width: 100%;\n padding: 40px var(--lia-bs-grid-gutter-width);\n margin: 0 auto;\n font-size: 14px;\n\n @media (min-width: 576px) {\n max-width: 33.75rem;\n }\n\n @media (min-width: 768px) {\n max-width: 45rem;\n padding: 40px calc(var(--lia-bs-grid-gutter-width) * 0.5);\n }\n\n @media (min-width: 992px) {\n max-width: 60rem;\n }\n\n @media (min-width: 1260px) {\n max-width: var(--lia-container-max-width);\n }\n}\n\n.footer-links-wrapper {\n display: flex;\n justify-content: flex-start;\n flex-wrap: wrap;\n width: 100%;\n color: var(--lia-rte-custom-color-18);\n\n ul {\n list-style: none;\n padding: 0;\n flex: 100%;\n margin-bottom: 0;\n\n li {\n a {\n color: var(--lia-rte-custom-color-18);\n padding: 5px 0;\n display: inline-block;\n }\n }\n }\n\n + .footer-links-wrapper {\n border-top: 1px solid #687480;\n margin-top: 20px;\n padding-top: 20px;\n }\n}\n\n.footer-text-wrapper {\n color: var(--lia-rte-custom-color-18);\n width: 100%;\n}\n\n.footer-text-wrapper p {\n margin-bottom: 0;\n}\n\n.footer-social-wrapper {\n display: flex;\n justify-content: space-between;\n color: var(--lia-rte-custom-color-18);\n border-top: 1px solid var(--lia-rte-custom-color-18);\n margin-top: 20px;\n padding-top: 20px;\n width: 100%;\n}\n\n.footer-links-wrapper .footer-social-wrapper ul li {\n width: auto;\n display: inline-block;\n}\n\n.footer-links-wrapper .footer-social-wrapper ul li a {\n padding: 0;\n margin-right: 0;\n border-radius: 12px;\n}\n\n@media (min-width: 992px) {\n .footer-text-wrapper,\n .footer-social-wrapper {\n width: auto;\n }\n\n .footer-social-wrapper {\n border-top: 0;\n margin-top: 0;\n padding-top: 0;\n width: auto;\n }\n\n .footer-links-wrapper ul {\n flex: auto;\n flex-wrap: wrap;\n }\n\n .footer-links-wrapper ul li {\n display: inline-block;\n }\n\n .footer-links-wrapper ul li a {\n margin-right: 20px;\n }\n\n .footer-links-wrapper-2 {\n justify-content: space-between;\n }\n}\n\n.myob-social-links a:hover .myob-icon {\n fill: #969ea7;\n}\n\n.myob-social-links .myob-icon {\n -webkit-transition: fill 0.2s ease-out;\n transition: fill 0.2s ease-out;\n fill: #687480;\n}\n\n.myob-social-links .myob-icon a {\n -webkit-transition: color 0.2s ease-out;\n transition: color 0.2s ease-out;\n color: #969ea7;\n text-decoration: none;\n}\n\n.myob-footer-copyright {\n color: #687480;\n padding-right: 20px;\n}\n\n.myob-footer-copyright a,\n.myob-footer-copyright a:hover {\n color: var(--lia-rte-custom-color-18);\n}\n\n.myob-social-links {\n margin-bottom: 0;\n}\n\n.myob-social-links li {\n float: left;\n margin-bottom: 0;\n line-height: 0;\n}\n\n.myob-social-links li + li {\n margin-left: 1.25em;\n}\n\n.myob-social-links li a:before {\n content: \" \";\n display: inline-block;\n width: 24px;\n height: 24px;\n background-size: contain;\n background-position: center;\n}\n.myob-social-links .twitter a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 6%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0Zm5.33,10c0,.12,0,.23,0,.35A7.75,7.75,0,0,1,5.4,16.92a5.48,5.48,0,0,0,4-1.13A2.73,2.73,0,0,1,6.89,13.9a2.73,2.73,0,0,0,1.23,0,2.73,2.73,0,0,1-2.19-2.67v0a2.73,2.73,0,0,0,1.23.34,2.73,2.73,0,0,1-.84-3.64,7.74,7.74,0,0,0,5.62,2.85,2.76,2.76,0,0,1-.07-.62,2.73,2.73,0,0,1,4.72-1.86,5.49,5.49,0,0,0,1.73-.66c-.2.64-.23.87-.79,1.21a1.46,1.46,0,0,0,1.34,0A5.8,5.8,0,0,1,17.33,10Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.myob-social-links .googleplus a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 4%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0ZM9,17.5a5.5,5.5,0,1,1,4.1-9.17L11.61,9.67a3.5,3.5,0,1,0,.56,3.84H9v-2h4.47a1,1,0,0,1,1,1.11A5.49,5.49,0,0,1,9,17.5Zm10.5-4v2h-2v-2h-2v-2h2v-2h2v2h2v2Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.myob-social-links .facebook a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 1%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0Zm3.51,12H13.2v7.2h-3V12H8.4V9.58h1.8V8.29A2.61,2.61,0,0,1,13,5.4h2.6V7.77H13.81a.58.58,0,0,0-.61.66V9.58h2.56Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.myob-social-links .linkedin a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 5%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,24A12,12,0,1,0,0,12,12,12,0,0,0,12,24Zm1.82-10.71a1.2,1.2,0,0,0-1.2,1.2v4.2h-3s0-7.2,0-7.8h3v.89A3.72,3.72,0,0,1,15,10.91c1.78,0,3,1.29,3,3.78v4H15v-4.2A1.2,1.2,0,0,0,13.82,13.29ZM6.91,9.69h0A1.47,1.47,0,0,1,5.4,8.2,1.44,1.44,0,0,1,6.93,6.75a1.47,1.47,0,1,1,0,2.94Zm1.51,9h-3v-7.8h3Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.myob-social-links .instagram a:before {\n background: url(\"data:image/svg+xml;base64,PHN2ZyBjbGFzcz0ibXlvYi1pY29uIiB2aWV3Qm94PSIwIDAgMjQgMjQiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+IDxwYXRoIGQ9Ik0xMiAwYzYuNjE3IDAgMTIgNS4zODMgMTIgMTIgMCA2LjYxNi01LjM4MyAxMi0xMiAxMlMwIDE4LjYxNiAwIDEyQzAgNS4zODQgNS4zODMgMCAxMiAwem03IDE2LjE2NlY3LjgzYzAtMS41Ni0xLjI3LTIuODMtMi44MzMtMi44M0g3LjgzM0M2LjI3MSA1IDUgNi4yNyA1IDcuODN2OC4zMzVDNSAxNy43MjkgNi4yNzEgMTkgNy44MzMgMTloOC4zMzRDMTcuNzMgMTkgMTkgMTcuNzMgMTkgMTYuMTY2ek04LjU0NSA5LjUyTDggOS41MjRWNmgxdjIuODgxYy0uMTcyLjE5Ny0uMzIzLjQxLS40NTUuNjM5ek0xNSAxMS41YzAgMS42NTYtMS4zNDQgMy0zIDMtMS42NTcgMC0zLTEuMzQ0LTMtMyAwLTEuNjU3IDEuMzQzLTMgMy0zIDEuNjU2IDAgMyAxLjM0MyAzIDN6bS01LTMuNDQ0VjZoNi4xNjdDMTcuMTc4IDYgMTggNi44MjIgMTggNy44MzF2MS42N2wtMi41NTMuMDA1QzE0Ljc1NCA4LjMxMyAxMy40NzcgNy41IDEyIDcuNWMtLjczMSAwLTEuNDA5LjIxMi0yIC41NTZ6TTE2IDhoMVY3aC0xdjF6TTcgOS41MjRsLTEgLjAwM1Y3LjgzMmMwLS43MS40MDktMS4zMTggMS0xLjYyMnYzLjMxNHoiIGZpbGw9IiM2ODc0ODAiIGZpbGwtcnVsZT0iZXZlbm9kZCIvPiA8L3N2Zz4=\")\n no-repeat;\n}\n","texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Custom_Footer","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":{"css":".custom_widget_Custom_Footer_sr-only_7twck_1 {\n position: absolute;\n width: 0.0625rem;\n height: 0.0625rem;\n padding: 0;\n margin: -0.0625rem;\n overflow: hidden;\n clip: rect(0, 0, 0, 0);\n border: 0;\n}\n\n.custom_widget_Custom_Footer_custom-footer-wrapper_7twck_12 {\n background-color: #1b2830;\n}\n\n.custom_widget_Custom_Footer_custom-footer_7twck_12 {\n width: 100%;\n padding: 2.5rem var(--lia-bs-grid-gutter-width);\n margin: 0 auto;\n font-size: 0.875rem;\n\n @media (min-width: 576px) {\n max-width: 33.75rem;\n }\n\n @media (min-width: 768px) {\n max-width: 45rem;\n padding: 2.5rem calc(var(--lia-bs-grid-gutter-width) * 0.5);\n }\n\n @media (min-width: 992px) {\n max-width: 60rem;\n }\n\n @media (min-width: 1260px) {\n max-width: var(--lia-container-max-width);\n }\n}\n\n.custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 {\n display: flex;\n justify-content: flex-start;\n flex-wrap: wrap;\n width: 100%;\n color: var(--lia-rte-custom-color-18);\n\n ul {\n list-style: none;\n padding: 0;\n flex: 100%;\n margin-bottom: 0;\n\n li {\n a {\n color: var(--lia-rte-custom-color-18);\n padding: 0.3125rem 0;\n display: inline-block;\n }\n }\n }\n\n + .custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 {\n border-top: 1px solid #687480;\n margin-top: 1.25rem;\n padding-top: 1.25rem;\n }\n}\n\n.custom_widget_Custom_Footer_footer-text-wrapper_7twck_69 {\n color: var(--lia-rte-custom-color-18);\n width: 100%;\n}\n\n.custom_widget_Custom_Footer_footer-text-wrapper_7twck_69 p {\n margin-bottom: 0;\n}\n\n.custom_widget_Custom_Footer_footer-social-wrapper_7twck_78 {\n display: flex;\n justify-content: space-between;\n color: var(--lia-rte-custom-color-18);\n border-top: 1px solid var(--lia-rte-custom-color-18);\n margin-top: 1.25rem;\n padding-top: 1.25rem;\n width: 100%;\n}\n\n.custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 .custom_widget_Custom_Footer_footer-social-wrapper_7twck_78 ul li {\n width: auto;\n display: inline-block;\n}\n\n.custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 .custom_widget_Custom_Footer_footer-social-wrapper_7twck_78 ul li a {\n padding: 0;\n margin-right: 0;\n border-radius: 0.75rem;\n}\n\n@media (min-width: 992px) {\n .custom_widget_Custom_Footer_footer-text-wrapper_7twck_69,\n .custom_widget_Custom_Footer_footer-social-wrapper_7twck_78 {\n width: auto;\n }\n\n .custom_widget_Custom_Footer_footer-social-wrapper_7twck_78 {\n border-top: 0;\n margin-top: 0;\n padding-top: 0;\n width: auto;\n }\n\n .custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 ul {\n flex: auto;\n flex-wrap: wrap;\n }\n\n .custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 ul li {\n display: inline-block;\n }\n\n .custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 ul li a {\n margin-right: 1.25rem;\n }\n\n .custom_widget_Custom_Footer_footer-links-wrapper-2_7twck_125 {\n justify-content: space-between;\n }\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 a:hover .custom_widget_Custom_Footer_myob-icon_7twck_130 {\n fill: #969ea7;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_myob-icon_7twck_130 {\n transition: fill 0.2s ease-out;\n fill: #687480;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_myob-icon_7twck_130 a {\n transition: color 0.2s ease-out;\n color: #969ea7;\n text-decoration: none;\n}\n\n.custom_widget_Custom_Footer_myob-footer-copyright_7twck_147 {\n color: #687480;\n padding-right: 1.25rem;\n}\n\n.custom_widget_Custom_Footer_myob-footer-copyright_7twck_147 a,\n.custom_widget_Custom_Footer_myob-footer-copyright_7twck_147 a:hover {\n color: var(--lia-rte-custom-color-18);\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 {\n margin-bottom: 0;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 li {\n float: left;\n margin-bottom: 0;\n line-height: 0;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 li + li {\n margin-left: 1.25em;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 li a:before {\n content: \" \";\n display: inline-block;\n width: 1.5rem;\n height: 1.5rem;\n background-size: contain;\n background-position: center;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_twitter_7twck_179 a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 6%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0Zm5.33,10c0,.12,0,.23,0,.35A7.75,7.75,0,0,1,5.4,16.92a5.48,5.48,0,0,0,4-1.13A2.73,2.73,0,0,1,6.89,13.9a2.73,2.73,0,0,0,1.23,0,2.73,2.73,0,0,1-2.19-2.67v0a2.73,2.73,0,0,0,1.23.34,2.73,2.73,0,0,1-.84-3.64,7.74,7.74,0,0,0,5.62,2.85,2.76,2.76,0,0,1-.07-.62,2.73,2.73,0,0,1,4.72-1.86,5.49,5.49,0,0,0,1.73-.66c-.2.64-.23.87-.79,1.21a1.46,1.46,0,0,0,1.34,0A5.8,5.8,0,0,1,17.33,10Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_googleplus_7twck_184 a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 4%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0ZM9,17.5a5.5,5.5,0,1,1,4.1-9.17L11.61,9.67a3.5,3.5,0,1,0,.56,3.84H9v-2h4.47a1,1,0,0,1,1,1.11A5.49,5.49,0,0,1,9,17.5Zm10.5-4v2h-2v-2h-2v-2h2v-2h2v2h2v2Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_facebook_7twck_189 a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 1%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0Zm3.51,12H13.2v7.2h-3V12H8.4V9.58h1.8V8.29A2.61,2.61,0,0,1,13,5.4h2.6V7.77H13.81a.58.58,0,0,0-.61.66V9.58h2.56Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_linkedin_7twck_194 a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 5%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,24A12,12,0,1,0,0,12,12,12,0,0,0,12,24Zm1.82-10.71a1.2,1.2,0,0,0-1.2,1.2v4.2h-3s0-7.2,0-7.8h3v.89A3.72,3.72,0,0,1,15,10.91c1.78,0,3,1.29,3,3.78v4H15v-4.2A1.2,1.2,0,0,0,13.82,13.29ZM6.91,9.69h0A1.47,1.47,0,0,1,5.4,8.2,1.44,1.44,0,0,1,6.93,6.75a1.47,1.47,0,1,1,0,2.94Zm1.51,9h-3v-7.8h3Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_instagram_7twck_199 a:before {\n background: url(\"data:image/svg+xml;base64,PHN2ZyBjbGFzcz0ibXlvYi1pY29uIiB2aWV3Qm94PSIwIDAgMjQgMjQiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+IDxwYXRoIGQ9Ik0xMiAwYzYuNjE3IDAgMTIgNS4zODMgMTIgMTIgMCA2LjYxNi01LjM4MyAxMi0xMiAxMlMwIDE4LjYxNiAwIDEyQzAgNS4zODQgNS4zODMgMCAxMiAwem03IDE2LjE2NlY3LjgzYzAtMS41Ni0xLjI3LTIuODMtMi44MzMtMi44M0g3LjgzM0M2LjI3MSA1IDUgNi4yNyA1IDcuODN2OC4zMzVDNSAxNy43MjkgNi4yNzEgMTkgNy44MzMgMTloOC4zMzRDMTcuNzMgMTkgMTkgMTcuNzMgMTkgMTYuMTY2ek04LjU0NSA5LjUyTDggOS41MjRWNmgxdjIuODgxYy0uMTcyLjE5Ny0uMzIzLjQxLS40NTUuNjM5ek0xNSAxMS41YzAgMS42NTYtMS4zNDQgMy0zIDMtMS42NTcgMC0zLTEuMzQ0LTMtMyAwLTEuNjU3IDEuMzQzLTMgMy0zIDEuNjU2IDAgMyAxLjM0MyAzIDN6bS01LTMuNDQ0VjZoNi4xNjdDMTcuMTc4IDYgMTggNi44MjIgMTggNy44MzF2MS42N2wtMi41NTMuMDA1QzE0Ljc1NCA4LjMxMyAxMy40NzcgNy41IDEyIDcuNWMtLjczMSAwLTEuNDA5LjIxMi0yIC41NTZ6TTE2IDhoMVY3aC0xdjF6TTcgOS41MjRsLTEgLjAwM1Y3LjgzMmMwLS43MS40MDktMS4zMTggMS0xLjYyMnYzLjMxNHoiIGZpbGw9IiM2ODc0ODAiIGZpbGwtcnVsZT0iZXZlbm9kZCIvPiA8L3N2Zz4=\")\n no-repeat;\n}\n","tokens":{"sr-only":"custom_widget_Custom_Footer_sr-only_7twck_1","custom-footer-wrapper":"custom_widget_Custom_Footer_custom-footer-wrapper_7twck_12","custom-footer":"custom_widget_Custom_Footer_custom-footer_7twck_12","footer-links-wrapper":"custom_widget_Custom_Footer_footer-links-wrapper_7twck_40","footer-text-wrapper":"custom_widget_Custom_Footer_footer-text-wrapper_7twck_69","footer-social-wrapper":"custom_widget_Custom_Footer_footer-social-wrapper_7twck_78","footer-links-wrapper-2":"custom_widget_Custom_Footer_footer-links-wrapper-2_7twck_125","myob-social-links":"custom_widget_Custom_Footer_myob-social-links_7twck_130","myob-icon":"custom_widget_Custom_Footer_myob-icon_7twck_130","myob-footer-copyright":"custom_widget_Custom_Footer_myob-footer-copyright_7twck_147","twitter":"custom_widget_Custom_Footer_twitter_7twck_179","googleplus":"custom_widget_Custom_Footer_googleplus_7twck_184","facebook":"custom_widget_Custom_Footer_facebook_7twck_189","linkedin":"custom_widget_Custom_Footer_linkedin_7twck_194","instagram":"custom_widget_Custom_Footer_instagram_7twck_199"}},"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1743051948212","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1743051948212","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/RelatedContentWidget-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/RelatedContentWidget-1743051948212","value":{"title":"Related Content","emptyDescription":"No content to show","title@instance:1706573650217":"Related content","title@instance:ozpMun":"Related content"},"localOverride":false},"CachedAsset:text:en_US-components/community/FooterWidget-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/community/FooterWidget-1743051948212","value":{"homeLink":"Community Home","topOfPage":"Top of Page","buildHash":"Build Hash:","buildNumber":"Build Number:","buildTime":"Build Time:","privacyPolicy":"Privacy Policy","helpLink":"Help"},"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}}},"Category:category:NZinfo":{"__typename":"Category","id":"category:NZinfo","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:beta":{"__typename":"Category","id":"category:beta","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:PurpleLounge":{"__typename":"Category","id":"category:PurpleLounge","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:AccountEdge":{"__typename":"Forum","id":"board:AccountEdge","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:AccountRightAPIquestions":{"__typename":"Forum","id":"board:AccountRightAPIquestions","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:CommunityBlog":{"__typename":"Blog","id":"board:CommunityBlog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:AETax":{"__typename":"Forum","id":"board:AETax","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:AD_Notices":{"__typename":"Forum","id":"board:AD_Notices","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:MYOBAdvisor":{"__typename":"Forum","id":"board:MYOBAdvisor","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Business":{"__typename":"Category","id":"category:Business","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"entityType":"CATEGORY","displayId":"Business","nodeType":"category","depth":2,"title":"MYOB Business","shortTitle":"MYOB Business"},"Category:category:PartnersGroup":{"__typename":"Category","id":"category:PartnersGroup","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:AdvancedPlatform":{"__typename":"Category","id":"category:AdvancedPlatform","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:Payroll":{"__typename":"GroupHub","id":"grouphub:Payroll","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Scholarly":{"__typename":"Category","id":"category:Scholarly","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:PracticeBAS":{"__typename":"Forum","id":"board:PracticeBAS","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:myobconnect":{"__typename":"Forum","id":"board:myobconnect","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:EntProdHelp":{"__typename":"Category","id":"category:EntProdHelp","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:myob-client-accounting":{"__typename":"Forum","id":"board:myob-client-accounting","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:incident-communications":{"__typename":"Forum","id":"board:incident-communications","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Solo":{"__typename":"Category","id":"category:Solo","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:bank-feed-updates":{"__typename":"Forum","id":"board:bank-feed-updates","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Rank:rank:189":{"__typename":"Rank","id":"rank:189","position":64,"name":"Contributing User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:209798":{"__typename":"User","id":"user:209798","uid":209798,"login":"Rob48","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-08-14T12:04:01.755+10:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-8.svg?time=0"},"rank":{"__ref":"Rank:rank:189"},"messagesCount":7,"kudosGivenCount":1,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:209798"},"ForumTopicMessage:message:815298":{"__typename":"ForumTopicMessage","uid":815298,"subject":"Importing Sales","id":"message:815298","revisionNum":1,"repliesCount":1,"author":{"__ref":"User:user:209798"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"conversation":{"__ref":"Conversation:conversation:815298"},"moderationData":{"__ref":"ModerationData:moderation_data:815298"},"postTime":"2023-05-13T09:52:08.176+10:00","lastPublishTime":"2023-05-13T09:52:08.176+10:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":485},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:815298"},"Conversation:conversation:815298":{"__typename":"Conversation","id":"conversation:815298","solved":true,"topic":{"__ref":"ForumTopicMessage:message:815298"},"lastPostingActivityTime":"2023-05-13T13:43:58.558+10:00","lastPostTime":"2023-05-13T13:43:58.558+10:00"},"ModerationData:moderation_data:815298":{"__typename":"ModerationData","id":"moderation_data:815298","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:815298":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:815298","relatedMessage":{"__ref":"ForumTopicMessage:message:815298"}},"Rank:rank:175":{"__typename":"Rank","id":"rank:175","position":57,"name":"Contributing Cover User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:125704":{"__typename":"User","id":"user:125704","uid":125704,"login":"Camelkathy","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2014-11-11T10:49:29.781+11:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-1.svg?time=0"},"rank":{"__ref":"Rank:rank:175"},"messagesCount":5,"kudosGivenCount":0,"kudosReceivedCount":2,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:125704"},"ForumTopicMessage:message:802095":{"__typename":"ForumTopicMessage","uid":802095,"subject":"Importing sales error -25","id":"message:802095","revisionNum":1,"repliesCount":7,"author":{"__ref":"User:user:125704"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"conversation":{"__ref":"Conversation:conversation:802095"},"moderationData":{"__ref":"ModerationData:moderation_data:802095"},"postTime":"2023-02-02T14:29:10.674+11:00","lastPublishTime":"2023-02-02T14:29:10.674+11:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":1048},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:802095"},"Conversation:conversation:802095":{"__typename":"Conversation","id":"conversation:802095","solved":true,"topic":{"__ref":"ForumTopicMessage:message:802095"},"lastPostingActivityTime":"2023-02-07T16:13:16.895+11:00","lastPostTime":"2023-02-07T16:13:16.895+11:00"},"ModerationData:moderation_data:802095":{"__typename":"ModerationData","id":"moderation_data:802095","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:802095":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:802095","relatedMessage":{"__ref":"ForumTopicMessage:message:802095"}},"Rank:rank:187":{"__typename":"Rank","id":"rank:187","position":63,"name":"Experienced User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:202753":{"__typename":"User","id":"user:202753","uid":202753,"login":"Bern458","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-06-17T12:52:23.323+10:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-3.svg?time=0"},"rank":{"__ref":"Rank:rank:187"},"messagesCount":16,"kudosGivenCount":0,"kudosReceivedCount":2,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":1,"entityType":"USER","eventPath":"community:myob/user:202753"},"ForumTopicMessage:message:697591":{"__typename":"ForumTopicMessage","uid":697591,"subject":"Importing sales Invoices","id":"message:697591","revisionNum":1,"repliesCount":3,"author":{"__ref":"User:user:202753"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"conversation":{"__ref":"Conversation:conversation:697591"},"moderationData":{"__ref":"ModerationData:moderation_data:697591"},"postTime":"2021-03-15T16:32:12.096+11:00","lastPublishTime":"2021-03-15T16:32:12.096+11:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":1830},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:697591"},"Conversation:conversation:697591":{"__typename":"Conversation","id":"conversation:697591","solved":true,"topic":{"__ref":"ForumTopicMessage:message:697591"},"lastPostingActivityTime":"2021-03-16T15:43:01.520+11:00","lastPostTime":"2021-03-16T15:43:01.520+11:00"},"ModerationData:moderation_data:697591":{"__typename":"ModerationData","id":"moderation_data:697591","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:697591":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:697591","relatedMessage":{"__ref":"ForumTopicMessage:message:697591"}},"Rank:rank:173":{"__typename":"Rank","id":"rank:173","position":56,"name":"Experienced Cover User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:113747":{"__typename":"User","id":"user:113747","uid":113747,"login":"MCSydney","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2014-07-16T12:34:42.885+10:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-1.svg?time=0"},"rank":{"__ref":"Rank:rank:173"},"messagesCount":22,"kudosGivenCount":2,"kudosReceivedCount":2,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":1,"entityType":"USER","eventPath":"community:myob/user:113747"},"ForumTopicMessage:message:886201":{"__typename":"ForumTopicMessage","uid":886201,"subject":"Professional Invoices crashing in MYOB Accounting 2024.11","id":"message:886201","revisionNum":1,"repliesCount":5,"author":{"__ref":"User:user:113747"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"conversation":{"__ref":"Conversation:conversation:886201"},"moderationData":{"__ref":"ModerationData:moderation_data:886201"},"postTime":"2025-01-06T10:27:08.984+11:00","lastPublishTime":"2025-01-06T10:27:08.984+11:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":65},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:886201"},"Conversation:conversation:886201":{"__typename":"Conversation","id":"conversation:886201","solved":true,"topic":{"__ref":"ForumTopicMessage:message:886201"},"lastPostingActivityTime":"2025-01-10T15:14:26.177+11:00","lastPostTime":"2025-01-10T15:14:26.177+11:00"},"ModerationData:moderation_data:886201":{"__typename":"ModerationData","id":"moderation_data:886201","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:886201":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:886201","relatedMessage":{"__ref":"ForumTopicMessage:message:886201"}},"User:user:218529":{"__typename":"User","id":"user:218529","uid":218529,"login":"Graham1","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2020-01-16T16:47:05.584+11:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-4.svg?time=0"},"rank":null,"messagesCount":3,"kudosGivenCount":3,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:218529"},"ForumTopicMessage:message:626963":{"__typename":"ForumTopicMessage","uid":626963,"subject":"Importing Item Sales Pricing error","id":"message:626963","revisionNum":1,"repliesCount":6,"author":{"__ref":"User:user:218529"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"conversation":{"__ref":"Conversation:conversation:626963"},"moderationData":{"__ref":"ModerationData:moderation_data:626963"},"postTime":"2020-01-16T16:51:13.480+11:00","lastPublishTime":"2020-01-16T16:51:13.480+11:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":2338},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:626963"},"Conversation:conversation:626963":{"__typename":"Conversation","id":"conversation:626963","solved":true,"topic":{"__ref":"ForumTopicMessage:message:626963"},"lastPostingActivityTime":"2020-01-17T11:31:02.412+11:00","lastPostTime":"2020-01-17T11:31:02.412+11:00"},"ModerationData:moderation_data:626963":{"__typename":"ModerationData","id":"moderation_data:626963","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:626963":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:626963","relatedMessage":{"__ref":"ForumTopicMessage:message:626963"}},"User:user:142361":{"__typename":"User","id":"user:142361","uid":142361,"login":"AmandaRobertsC","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2016-01-12T14:34:18.601+11:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/images/dS0xNDIzNjEtMzY0MTBpM0JEQzc5ODZEMDhEMkMwNg"},"rank":{"__ref":"Rank:rank:173"},"messagesCount":46,"kudosGivenCount":1,"kudosReceivedCount":1,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:142361"},"ForumTopicMessage:message:767819":{"__typename":"ForumTopicMessage","uid":767819,"subject":"Importing Sales Orders rather than Invoices","id":"message:767819","revisionNum":2,"repliesCount":11,"author":{"__ref":"User:user:142361"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"conversation":{"__ref":"Conversation:conversation:767819"},"moderationData":{"__ref":"ModerationData:moderation_data:767819"},"postTime":"2022-07-06T14:23:24.762+10:00","lastPublishTime":"2022-07-06T14:52:33.496+10:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":1169},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:767819"},"Conversation:conversation:767819":{"__typename":"Conversation","id":"conversation:767819","solved":true,"topic":{"__ref":"ForumTopicMessage:message:767819"},"lastPostingActivityTime":"2022-07-29T12:23:54.904+10:00","lastPostTime":"2022-07-29T12:23:54.904+10:00"},"ModerationData:moderation_data:767819":{"__typename":"ModerationData","id":"moderation_data:767819","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:767819":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:767819","relatedMessage":{"__ref":"ForumTopicMessage:message:767819"}},"User:user:309062":{"__typename":"User","id":"user:309062","uid":309062,"login":"SL_2023","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-08-23T15:55:57.064+10:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-6.svg?time=0"},"rank":null,"messagesCount":3,"kudosGivenCount":0,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:309062"},"ForumTopicMessage:message:832395":{"__typename":"ForumTopicMessage","uid":832395,"subject":"Importing Item Sales with Non Inventoried Items","id":"message:832395","revisionNum":1,"repliesCount":8,"author":{"__ref":"User:user:309062"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"conversation":{"__ref":"Conversation:conversation:832395"},"moderationData":{"__ref":"ModerationData:moderation_data:832395"},"postTime":"2023-08-23T16:33:40.398+10:00","lastPublishTime":"2023-08-23T16:33:40.398+10:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":644},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:832395"},"Conversation:conversation:832395":{"__typename":"Conversation","id":"conversation:832395","solved":true,"topic":{"__ref":"ForumTopicMessage:message:832395"},"lastPostingActivityTime":"2023-11-10T11:05:04.783+11:00","lastPostTime":"2023-11-10T11:05:04.783+11:00"},"ModerationData:moderation_data:832395":{"__typename":"ModerationData","id":"moderation_data:832395","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:832395":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:832395","relatedMessage":{"__ref":"ForumTopicMessage:message:832395"}},"User:user:252991":{"__typename":"User","id":"user:252991","uid":252991,"login":"amanpreetk","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-07-16T10:40:52.652+10:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-12.svg?time=0"},"rank":{"__ref":"Rank:rank:189"},"messagesCount":8,"kudosGivenCount":0,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:252991"},"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi04MjAtQkJUc2V4?image-coordinates=0%2C0%2C320%2C320\"}":{"__typename":"AssociatedImage","url":"https://community.myob.com/t5/s/myob/images/bi04MjAtQkJUc2V4?image-coordinates=0%2C0%2C320%2C320","mimeType":"image/png"},"Forum:board:Bus-Sales":{"__typename":"Forum","id":"board:Bus-Sales","entityType":"FORUM","displayId":"Bus-Sales","nodeType":"board","depth":3,"conversationStyle":"FORUM","title":"MYOB Business: Sales and Purchases","shortTitle":"MYOB Business: Sales and Purchases","parent":{"__ref":"Category:category:Business"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":true,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":{"__ref":"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi04MjAtQkJUc2V4?image-coordinates=0%2C0%2C320%2C320\"}"},"description":"","eventPath":"category:Business/category:Support/community:myobboard:Bus-Sales/"},"ForumTopicMessage:message:842737":{"__typename":"ForumTopicMessage","uid":842737,"subject":"MYOB Business Pro Sale and Purchase Import","id":"message:842737","revisionNum":1,"repliesCount":3,"author":{"__ref":"User:user:252991"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Bus-Sales"},"conversation":{"__ref":"Conversation:conversation:842737"},"moderationData":{"__ref":"ModerationData:moderation_data:842737"},"postTime":"2023-10-23T11:50:17.171+11:00","lastPublishTime":"2023-10-23T11:50:17.171+11:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":442},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:Business/category:Support/community:myobboard:Bus-Sales/message:842737"},"Conversation:conversation:842737":{"__typename":"Conversation","id":"conversation:842737","solved":true,"topic":{"__ref":"ForumTopicMessage:message:842737"},"lastPostingActivityTime":"2023-10-24T10:31:06.531+11:00","lastPostTime":"2023-10-24T10:31:06.531+11:00"},"ModerationData:moderation_data:842737":{"__typename":"ModerationData","id":"moderation_data:842737","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:842737":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:842737","relatedMessage":{"__ref":"ForumTopicMessage:message:842737"}},"QueryVariables:TopicReplyList:message:668644:1":{"__typename":"QueryVariables","id":"TopicReplyList:message:668644:1","value":{"id":"message:668644","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":true,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-components/community/Navbar-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1743051948212","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":"MYOB Client Accounting","migrated-link-7":"Admin Tasks & General Discussions","Common-community-blog-link":"MYOB Announcements","migrated-link-8":"MYOB Practice Manager / Document Manager","Common-purple-lounge-link":"MYOB Community Hub","Common-incident-communications-link":"Incident Communications","migrated-link-1":"MYOB Business","migrated-link-21":"Students & Educators","migrated-link-2":"MYOB AccountRight","migrated-link-22":"Developers","Common-bank-feed-updates-link":"Bank Feed Updates","onboarding-hub":"Installing the app","migrated-link-0":"Product Help & Ideas","migrated-link-20":"Other Groups & Software","migrated-link-5":"MYOB EXO","migrated-link-6":"Accountants & Bookkeepers","migrated-link-3":"NZ Payroll and Tax","migrated-link-4":"MYOB Acumatica","migrated-link-18":"Contacts - manage you customers and suppliers","migrated-link-19":"Categories - organise your transactions","migrated-link-16":"Invoicing - get paid faster","migrated-link-17":"Expenses - stay on top of your spending","migrated-link-14":"Share your ideas","migrated-link-15":"Early access program news","migrated-link-12":"EAP Hub","migrated-link-13":"Getting set up","partner-program-members":"Partner Program Members","Common-myobconnect-link":"MYOB Community Connect","migrated-link-10":"MYOB AU Tax","migrated-link-11":"MYOB Online Tax AU","solo-link":"Solo by MYOB","help":"Ask a question","migrated-link-27":"Other MYOB software","migrated-link-25":"MYOB Enterprise Solutions Partners","town-square---soloists":"Soloist Town Square","migrated-link-26":"Payroll Hub","migrated-link-23":"MYOB Business API","migrated-link-24":"MYOB Acumatica Partners","Common-welcome-link":"Welcome to the Community"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1743051948212","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1743051948212","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1743051948212","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1743051948212","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1743051948212","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-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1743051948212","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1743051948212","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solved","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/ThreadedReplyList-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1743051948212","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},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1743051948212","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-shared/client/components/common/QueryHandler-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1743051948212","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/BuildInformation-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/BuildInformation-1743051948212","value":{"buildHash":"Build Hash: {buildHash}","buildNumber":"Build Number: {buildNumber}","buildTime":"Build Time: {buildTime}"},"localOverride":false},"CachedAsset:text:en_US-components/community/KhorosLogo-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/community/KhorosLogo-1743051948212","value":{"alt":"Powered By Khoros"},"localOverride":false},"Rank:rank:195":{"__typename":"Rank","id":"rank:195","position":7,"name":"MYOB Product Team","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:180487":{"__typename":"User","id":"user:180487","uid":180487,"login":"Haydes","biography":"Ex MYOB Support (2015 - 2019). \r\nCurrently working in the engine room.","registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2018-02-28T16:21:26.997+11:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/images/dS0xODA0ODctMjc1MjFpRDg2N0RBRkFCRURERUU3OA"},"rank":{"__ref":"Rank:rank:195"},"entityType":"USER","eventPath":"community:myob/user:180487"},"ModerationData:moderation_data:668967":{"__typename":"ModerationData","id":"moderation_data:668967","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AcceptedSolutionMessage:message:668967":{"__typename":"AcceptedSolutionMessage","uid":668967,"id":"message:668967","revisionNum":1,"author":{"__ref":"User:user:180487"},"readOnly":true,"repliesCount":1,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"parent":{"__ref":"ForumTopicMessage:message:668644"},"conversation":{"__ref":"Conversation:conversation:668644"},"subject":"Re: Importing professional sales","moderationData":{"__ref":"ModerationData:moderation_data:668967"},"body":"
It's been a little while, but I do recall having the option to choose between tab delimited and comma delimited data format when importing, I had a quick read (and watch) of this article and that confirmed the data format selector options: Importing data
\n
\n
Although I do remember that anyone that has a .csv file it can't be seen by ARL by default, from memory you just need to change the File Type selector in the bottom-right of the File Browser to say \"All Types\" to be able to pick up the .csv file.
\n
\n
In terms of a null value, as I understand it; if there's a field that has no data it should be left empty in the import data. IIRC it will be considered an empty string. Or you can leave the field out altogether to avoid that scenario.
\n
I am not up to speed on if there is a bug with null values on imports, did a quick search and couldn't see anything specific pop up. Is that what you're referring to?
\n
\n
And for having commas in the Description text in a comma-separated data import, you should be able to just surround the text with double quotations in the relevant description field to import it. Is this not working on your data imports?
It's been a little while, but I do recall having the option to choose between tab delimited and comma delimited data format when importing, I had a quick read (and watch) of this article and that confirmed the data format selector options: Importing data
\n
\n
Although I do remember that anyone that has a .csv file it can't be seen by ARL by default, from memory you just need to change the File Type selector in the bottom-right of the File Browser to say \"All Types\" to be able to pick up the .csv file.
\n
\n
In terms of a null value, as I understand it; if there's a field that has no data it should be left empty in the import data. IIRC it will be considered an empty string. Or you can leave the field out altogether to avoid that scenario.
\n
I am not up to speed on if there is a bug with null values on imports, did a quick search and couldn't see anything specific pop up. Is that what you're referring to?
\n
\n
And for having commas in the Description text in a comma-separated data import, you should be able to just surround the text with double quotations in the relevant description field to import it. Is this not working on your data imports?
","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:668967_1"},"latestVersion":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":[]}}},"body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"213","videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:670663":{"__typename":"ModerationData","id":"moderation_data:670663","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:670663":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:163295"},"id":"message:670663","revisionNum":1,"uid":670663,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"parent":{"__ref":"AcceptedSolutionMessage:message:668967"},"conversation":{"__ref":"Conversation:conversation:668644"},"subject":"Re: Importing professional sales","moderationData":{"__ref":"ModerationData:moderation_data:670663"},"body":"
Out-effing-standing! CSV's should be the default option for Imorting field based data (in my opinion). The option to solve all my problems WAS an option all along, I just had to disregard all the current documentation and I'm good to go.
The article you and I both read, advised: \"you'll need to export the data you want from the program you’ve used to create the data and save it in a tab-delimited or comma-separated text file.\"
But I thank you for providing information that should have been made readily available to anyone looking to import data.
Out-effing-standing! CSV's should be the default option for Imorting field based data (in my opinion). The option to solve all my problems WAS an option all along, I just had to disregard all the current documentation and I'm good to go.
The article you and I both read, advised: \"you'll need to export the data you want from the program you’ve used to create the data and save it in a tab-delimited or comma-separated text file.\"
But I thank you for providing information that should have been made readily available to anyone looking to import data.
","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:670663_1"},"latestVersion":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":[]}}}},"QueryVariables:MessageSolutions":{"__typename":"QueryVariables","id":"MessageSolutions","value":{"first":10,"constraints":{"topicId":{"eq":"message:668644"},"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}},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1743051948212","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1743051948212","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-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1743051948212","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1743051948212","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1743051948212","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-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1743051948212","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1743051948212","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1743051948212","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-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1743051948212","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1743051948212","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-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolutionList-1743051948212","value":{"emptyDescription":"No has been message solutions yet"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1743051948212","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-shared/client/components/common/Pager/PagerLoadMore-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1743051948212","value":{"loadMore":"Show More"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1743051948212","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},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1743051948212","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"Revision:revision:670663_1":{"__typename":"Revision","id":"revision:670663_1","lastEditTime":"2020-08-10T17:34:29.444+10:00"},"Revision:revision:668967_1":{"__typename":"Revision","id":"revision:668967_1","lastEditTime":"2020-07-31T07:46:20.843+10:00"},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1743051948212","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1743051948212":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1743051948212","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"sales_and_purchases","messageSubject":"importing-professional-sales","messageId":"668644"},"buildId":"9FJG2s74-Surmr3HCEDcZ","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"myob","openTelemetryServiceVersion":"25.2.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/customComponent/CustomComponent/CustomComponent.tsx","./components/messages/RelatedContentWidget/RelatedContentWidget.tsx","./components/community/FooterWidget/FooterWidget.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/messages/ThreadedReplyList/ThreadedReplyList.tsx","./components/community/FooterWidgetHelpLink/FooterWidgetHelpLink.tsx","./components/community/KhorosLogo/KhorosLogo.tsx","../shared/client/components/common/List/UnstyledList/UnstyledList.tsx","./components/messages/MessageView/MessageView.tsx","../shared/client/components/common/Pager/PagerLoadMore/PagerLoadMore.tsx","./components/customComponent/CustomComponentContent/HtmlContent.tsx","./components/messages/MessageView/MessageViewInline/MessageViewInline.tsx","./components/customComponent/CustomComponentContent/TemplateContent.tsx","./components/customComponent/CustomComponentContent/CustomComponentScripts.tsx"],"appGip":true,"scriptLoader":[]}
