Sorry for the late reply.
Thank you for the advice yes it did work....
1. but as I did have couple of same surnames - I got the error message .....attachment \"Book11\"// tab \"Importing report\"
2. so I just copied the working sheet in a new tab ..... \" .... same surname\"...you can see it in the attachment \"Book11\"
* deleted the records that been successfully imported
* amended the Client’s Cards surnames by adding the \"/ \" to some ...also updated it in MYOB
* processed the import as per usual.....but....it did not work - please see the importlog report attached :
a) my confusion regarding the report:
*I had only 9 records to be imported .....but the importlog report states \"63 records skipped\"
* \" Error -25: Invalid amount.\" .......why .......i use the same spreadsheet, same columns, same amounts as in my first attempt, I only deleted the records that been successfully imported in he first attempt.
Could you please help me with this , what have i missed or did wrong ...I am doing it for the first time ....you advice it will be greatly appreciated.
Thank you
Anastasia
Hi Komal,
Sorry for the late reply.
Thank you for the advice yes it did work....
1. but as I did have couple of same surnames - I got the error message .....attachment \"Book11\"// tab \"Importing report\"
2. so I just copied the working sheet in a new tab ..... \" .... same surname\"...you can see it in the attachment \"Book11\"
* deleted the records that been successfully imported
* amended the Client’s Cards surnames by adding the \"/ \" to some ...also updated it in MYOB
* processed the import as per usual.....but....it did not work - please see the importlog report attached :
a) my confusion regarding the report:
*I had only 9 records to be imported .....but the importlog report states \"63 records skipped\"
* \" Error -25: Invalid amount.\" .......why .......i use the same spreadsheet, same columns, same amounts as in my first attempt, I only deleted the records that been successfully imported in he first attempt.
Could you please help me with this , what have i missed or did wrong ...I am doing it for the first time ....you advice it will be greatly appreciated.
Thank you
Anastasia
Hi AnastasiaBostan , if I may comment, the text file has a large number of lines below the data which contain nothing except multiple tab characters. The import errors refer to these rows. You may have deleted the contents of the rows, but you need to delete all the rows in your spreadsheet below the actual data, down as far as the shaded rows, then save the file as a text file.
To delete rows, highlight the row number/s and right-click, select Delete.
I think the actual data imported successfully?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"213","kudosSumWeight":2,"repliesCount":2,"postTime":"2020-07-05T08:39:41.688+10:00","lastPublishTime":"2020-07-05T08:39:41.688+10:00","metrics":{"__typename":"MessageMetrics","views":1187},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:657797/message:661140","customFields":[],"readOnly":true,"editFrozen":false,"body@stringLength":"848","rawBody":"Hi
To delete rows, highlight the row number/s and right-click, select Delete.
I think the actual data imported successfully?
","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:661140_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:657797"},"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-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1743747860431","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1743747860431","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-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1743747860431","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1743747860431","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1743747860431","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-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1743747860431","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1743747860431","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1743747860431","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-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1743747860431","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1743747860431","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-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolutionList-1743747860431","value":{"emptyDescription":"No has been message solutions yet"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1743747860431","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-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1743747860431","value":{"loadMore":"Show More"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1743747860431","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-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1743747860431","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"Revision:revision:661140_1":{"__typename":"Revision","id":"revision:661140_1","lastEditTime":"2020-07-05T08:39:41.688+10:00"},"Revision:revision:658020_1":{"__typename":"Revision","id":"revision:658020_1","lastEditTime":"2020-06-29T12:20:47.661+10:00"},"Revision:revision:658042_1":{"__typename":"Revision","id":"revision:658042_1","lastEditTime":"2020-06-29T12:46:07.544+10:00"},"Attachment:{\"id\":\"attachment:message661137AttachmentNumber1\",\"url\":\"https://community.myob.com/t5/s/myob/attachments/myob/Sales_and_Purchases/69450/1/Book11.xlsx\"}":{"__typename":"Attachment","id":"attachment:message661137AttachmentNumber1","filename":"Book11.xlsx","filesize":185928,"contentType":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","url":"https://community.myob.com/t5/s/myob/attachments/myob/Sales_and_Purchases/69450/1/Book11.xlsx"},"Attachment:{\"id\":\"attachment:message661137AttachmentNumber2\",\"url\":\"https://community.myob.com/t5/s/myob/attachments/myob/Sales_and_Purchases/69450/2/importlog.txt\"}":{"__typename":"Attachment","id":"attachment:message661137AttachmentNumber2","filename":"importlog.txt","filesize":2710,"contentType":"text/plain","url":"https://community.myob.com/t5/s/myob/attachments/myob/Sales_and_Purchases/69450/2/importlog.txt"},"Revision:revision:661137_1":{"__typename":"Revision","id":"revision:661137_1","lastEditTime":"2020-07-05T06:56:09.205+10:00"},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1743747860431","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1743747860431","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1743747860431","value":{"errorTitle":"Failed!","previewFile":"Preview File","downloadFile":"Download File {name}","removeFile":"Remove File {name}","errorBadExtension":"This file does not have a valid extension. \"{extensions}\" are the valid extensions.","errorFileEmpty":"This file is empty or does not exist.","errorTooLarge":"The maximum file size is: {maxFileSize}.","errorTooMany":"Too many attachments. The maximum number of attachments per message is: {maxAttachmentCount, number, integer}.","errorDuplicate":"This file is already attached."},"localOverride":false},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1743747860431":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1743747860431","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"autoScroll":"true","topicRepliesSort":"postTimeDesc","boardId":"sales_and_purchases","messageSubject":"service-sales-importing---must-be-no-gst","messageId":"657797"},"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","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/attachments/AttachmentView/AttachmentView.tsx","./components/attachments/AttachmentView/AttachmentViewChip/AttachmentViewChip.tsx","./components/customComponent/CustomComponentContent/CustomComponentScripts.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx"],"appGip":true,"scriptLoader":[]}