Live Data Connector changed Modified Date/Time?

James Keuning
James Keuning ✭✭✭✭✭
edited 06/14/22 inAdd Ons and Integrations

I use the Live Data Connector (LDC) to pull data into an Access database. I wasn't seeing some recent changes, so I wrote a query to find the MAX of MODIFIED, and I was surprised to see the MODIFIED field through the LDC hadn't happened yet! It's 10:30 AM here (USA Central) and the LDC is telling me that my records were modified at 4:30 PM.

Does Smartsheet display the time in the Pacific time zone, and the LDC use GMT?

· Share on Facebook Share on Twitter

Best Answer

Answers

Categories

@warrena<\/a> Sometimes the test function can be a little wonky. It's hard to say for sure why its not showing up because your setup looks right. If it was me, I would apply to global update to only one project and then investigate. Just make sure when you go to the next step you only check one project to update.<\/p>"},{"commentID":385993,"body":"

@warrena<\/a> <\/p>

the screen after you do the test is this<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>

When you hit apply update it will take you to the next and final screen and there will be the option to select the projects you want to apply the update to. Select only one and hit apply. <\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

This is after you do the test<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":65721,"type":"question","name":"Live Data Connector to SAGE accounting","excerpt":"I was reading up on data connectors to 3rd party platforms such as Excel, Access, etc. but didn't see any information about accounting systems such as Sage or Quickbooks. Has anyone ever linked an accounting systems to Smartsheet? I am assuming it is possible, but I want to gather other's experiences if they have. Thanks!","snippet":"I was reading up on data connectors to 3rd party platforms such as Excel, Access, etc. but didn't see any information about accounting systems such as Sage or Quickbooks. Has…","categoryID":343,"dateInserted":"2020-02-03T18:53:46+00:00","dateUpdated":"2022-06-14T14:36:40+00:00","dateLastComment":"2023-07-17T15:46:19+00:00","insertUserID":35371,"insertUser":{"userID":35371,"name":"tye.gardner35371","url":"https:\/\/community.smartsheet.com\/profile\/tye.gardner35371","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-02-27T20:42:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":21126,"lastUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-07-17T15:44:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":1237,"score":null,"hot":3270369005,"url":"https:\/\/community.smartsheet.com\/discussion\/65721\/live-data-connector-to-sage-accounting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65721\/live-data-connector-to-sage-accounting","format":"Rich","lastPost":{"discussionID":65721,"commentID":385580,"name":"Re: Live Data Connector to SAGE accounting","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385580#Comment_385580","dateInserted":"2023-07-17T15:46:19+00:00","insertUserID":21126,"insertUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-07-17T15:44:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-04T12:58:50+00:00","dateAnswered":"2020-02-04T07:52:54+00:00","acceptedAnswers":[{"commentID":238948,"body":"

Hi Tye,<\/p>

If I'm not misstaken, @JeremiahHorstick<\/a> has done this previously. <\/p>

I hope that helps!<\/p>

Have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/p>

Workflow Consultant \/ CEO @ WORK BOLD<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":95065,"type":"question","name":"Date with Time uploading in Data Shuttle comes only with Date","excerpt":"Hi Everyone, I'm uploading Input excel having column value \"6\/1\/2022 1:22:23 AM\". But after uploading into SmartSheet, it comes only date \"2022-06-01\". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P","snippet":"Hi Everyone, I'm uploading Input excel having column value \"6\/1\/2022 1:22:23 AM\". But after uploading into SmartSheet, it comes only date \"2022-06-01\". I need exact format which…","categoryID":343,"dateInserted":"2022-09-06T04:45:49+00:00","dateUpdated":"2022-09-19T13:55:39+00:00","dateLastComment":"2023-07-17T05:45:57+00:00","insertUserID":140679,"insertUser":{"userID":140679,"name":"Sandhiya07","url":"https:\/\/community.smartsheet.com\/profile\/Sandhiya07","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-19T10:31:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":150538,"lastUserID":160587,"lastUser":{"userID":160587,"name":"jchalig","url":"https:\/\/community.smartsheet.com\/profile\/jchalig","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYoEMnTBzhn1aYHnoptj2Qx2vDwz2e68_hYghUB=s96-c","dateLastActive":"2023-07-17T07:20:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":200,"score":null,"hot":3352018306,"url":"https:\/\/community.smartsheet.com\/discussion\/95065\/date-with-time-uploading-in-data-shuttle-comes-only-with-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95065\/date-with-time-uploading-in-data-shuttle-comes-only-with-date","format":"Rich","tagIDs":[474],"lastPost":{"discussionID":95065,"commentID":385501,"name":"Re: Date with Time uploading in Data Shuttle comes only with Date","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385501#Comment_385501","dateInserted":"2023-07-17T05:45:57+00:00","insertUserID":160587,"insertUser":{"userID":160587,"name":"jchalig","url":"https:\/\/community.smartsheet.com\/profile\/jchalig","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYoEMnTBzhn1aYHnoptj2Qx2vDwz2e68_hYghUB=s96-c","dateLastActive":"2023-07-17T07:20:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-19T12:13:48+00:00","dateAnswered":"2022-09-09T10:19:47+00:00","acceptedAnswers":[{"commentID":342967,"body":"

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

Smartsheet Date columns can only house Dates, there currently isn't a Time function in Smartsheet. (System Columns can include timestamps, however these cannot be updated by Data Shuttle). <\/p>

If you need to see the time, make sure to map this column to a Text\/Number<\/strong> column in Smartsheet so that all of the text will appear. <\/p>

Let me know if that works for you!<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&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":624,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Why is my global update to add profile data coming in blank in tests?

    Hi all, I'm trying to make a global update to add a new profile data point (created date) to metadata and summaries. I've tried doing it with both the system created date column and a helper column replicating the created date column (read in another discussion that I should try that). Both result in an incomplete data row…

  • Live Data Connector to SAGE accounting

    I was reading up on data connectors to 3rd party platforms such as Excel, Access, etc. but didn't see any information about accounting systems such as Sage or Quickbooks. Has anyone ever linked an accounting systems to Smartsheet? I am assuming it is possible, but I want to gather other's experiences if they have. Thanks!

  • Date with Time uploading in Data Shuttle comes only with Date

    Hi Everyone, I'm uploading Input excel having column value "6/1/2022 1:22:23 AM". But after uploading into SmartSheet, it comes only date "2022-06-01". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video