数据穿梭不添加净新条目

kelceyg
kelceyg ✭✭✭
编辑04/11/23 添加插件和集成

你好!我已经设置了Data Shuttle,目的是项目的PM可以附加她从我们的IT部门收到的每日发行日志,她的工作表将自动更新。她从IT部门收到的文档是一个。xlsx电子表格。

我注意到,随着每一个新的附件,现有的数据将相应更新,但新的问题没有被添加到Smartsheet。我联系了公司里的其他几家中小企业,但我们都被难住了。

我以为我发现了一些可能是罪魁祸首的东西——有时IT人员会在他们的Excel文档中添加第二个选项卡,或者他们会添加或删除列。不幸的是,情况似乎并非如此……我操纵了我所有的Excel文档,使它们都是1选项卡,所有的列都匹配。然后,我从零开始创建了一个Smartsheet,并在Data Shuttle中创建了一个全新的上传工作流。我给了它一个测试,我仍然没有得到新的条目添加到我的表!

如果有人有什么见解,我们将不胜感激。

下面的设置;我在这个工作流中没有过滤器或表达式:

2023 - 04 - 06 - _15 - 39 - 00. jpg
2023 - 04 - 06 - _15 - 39 - 18. jpg
2023 - 04 - 06 - _15 - 39 - 34. jpg
2023 - 04 - 06 - _15 - 39 - 46. jpg
2023 - 04 - 06 - _15 - 39 - 59. jpg


最佳答案

  • kelceyg
    kelceyg ✭✭✭
    ✓回答

    你好!只是为了结束这个循环-原来在我提供的Excel电子表格中有隐藏的选项卡。当我运行数据穿梭时,它正在读取隐藏选项卡上的信息,而不是我看到/需要的选项卡。一旦我删除了隐藏的标签,数据穿梭工作如预期!

答案

  • 吉纳维芙P。
    吉纳维芙P。 员工管理

    @kelceyg

    所有的设置看起来都是正确的!

    “在添加到源文件时添加行”复选框应该启用新行独特的在你的号码栏里找到你的ID,然后靠边停车。

    此时我能想到的唯一一件事是,如果新行在Number列中有重复的内容,那么它就不会被视为新的唯一行。这可能吗?

    欢呼,

    吉纳维芙

  • kelceyg
    kelceyg ✭✭✭
    ✓回答

    你好!只是为了结束这个循环-原来在我提供的Excel电子表格中有隐藏的选项卡。当我运行数据穿梭时,它正在读取隐藏选项卡上的信息,而不是我看到/需要的选项卡。一旦我删除了隐藏的标签,数据穿梭工作如预期!

Hi @ker9<\/a> <\/p>

That limit is specific to bulk-uploading the emails into the group, to ensure that the request is processed successfully. I don't believe there's currently a hard limit for the number of users that can be in a group. I have seen some groups with around 10,000 contacts, if that helps. <\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106596,"type":"question","name":"Changing a font in a dashboard","excerpt":"I have a dashboard using reports and metrics widgets, using sheet summaries and grid data, but the font is too large. How do I change that? In the screenshot, the red dot and the blue dot show the data that is coming from the grid data of a sheet. Is there any way of changing the font of the blue dot?","categoryID":321,"dateInserted":"2023-06-19T13:37:23+00:00","dateUpdated":"2023-06-19T13:49:50+00:00","dateLastComment":"2023-06-19T14:36:05+00:00","insertUserID":128842,"insertUser":{"userID":128842,"name":"Karen Bruer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Bruer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5MPAuTrWZX4!elHDp9qhGX4!HMSKFvshvfI","dateLastActive":"2023-06-19T14:33:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-20T13:18:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":52,"score":null,"hot":3374370208,"url":"https:\/\/community.smartsheet.com\/discussion\/106596\/changing-a-font-in-a-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106596\/changing-a-font-in-a-dashboard","format":"Rich","lastPost":{"discussionID":106596,"commentID":381155,"name":"Re: Changing a font in a dashboard","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381155#Comment_381155","dateInserted":"2023-06-19T14:36:05+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-20T13:18:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HHR250SXIUPY\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T14:35:02+00:00","dateAnswered":"2023-06-19T14:34:51+00:00","acceptedAnswers":[{"commentID":381154,"body":"

OMG, I didn't click on the widget box, now I see the edit option. Thanks so much, this is going to be a game changer for me!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106489,"type":"question","name":"Why can't I add a template to a dashboard?","excerpt":"I've created a template that I want to make available to team members. When I edit the dashboard and select option to add a shortcut, the template I created doesn't show up in the selection list.","categoryID":321,"dateInserted":"2023-06-15T12:48:33+00:00","dateUpdated":null,"dateLastComment":"2023-06-20T12:14:15+00:00","insertUserID":155470,"insertUser":{"userID":155470,"name":"trenner","url":"https:\/\/community.smartsheet.com\/profile\/trenner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T14:02:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":155470,"lastUser":{"userID":155470,"name":"trenner","url":"https:\/\/community.smartsheet.com\/profile\/trenner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T14:02:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":44,"score":null,"hot":3374098968,"url":"https:\/\/community.smartsheet.com\/discussion\/106489\/why-cant-i-add-a-template-to-a-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106489\/why-cant-i-add-a-template-to-a-dashboard","format":"Rich","lastPost":{"discussionID":106489,"commentID":381260,"name":"Re: Why can't I add a template to a dashboard?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381260#Comment_381260","dateInserted":"2023-06-20T12:14:15+00:00","insertUserID":155470,"insertUser":{"userID":155470,"name":"trenner","url":"https:\/\/community.smartsheet.com\/profile\/trenner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T14:02:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-20T12:14:21+00:00","dateAnswered":"2023-06-20T12:14:15+00:00","acceptedAnswers":[{"commentID":381260,"body":"

I figured that might be the case, but wanted to make sure I wasn't missing something. Thanks for the clarification...much appreciated.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5388,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势