SmartSheet Integration is now compatible with 2021 R2

  • 2 February 2022
  • 18 replies
  • 665 views

Userlevel 6
Badge

Product update: our SmartSheet integration available on GitHub is is now compatible with 2021R2. This update also includes a fix for the issue of retrieving an incomplete list of SmartSheet templates.

Follow the GitHub link to access the project: https://github.com/Acumatica/Acumatica-Smartsheet


18 replies

Do you know which 2021 R2 version it’s compatible with? We’ve got it loaded on version 21.205.0063. When attempting to upgrade our Acumatica instance to latest version, 21.210.0030, the validation of customizations is throwing off an error. Smartsheet is our only published customization.

Here’s the customization validation error. Though I’m not asking to resolve error...just which latest version of 2021 R2 Smartsheet supports, or where to find that information on GitHub.

Error: “The selected update is not compatible with the customization published on the website. The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.”

Thank you!

Userlevel 6
Badge

@mfrench - the compatibility testing was performed against 21.207.0045. Is it publishing for you or are you getting that error while trying to publish the customization?

Userlevel 2
Badge

Will there be a 2022 R1 version?

Userlevel 6
Badge

@mikeschmitt81 we are looking into compatibility for this but don’t have an ETA. Please stay tuned, an update will be posted announcing compatibility.

Userlevel 2
Badge

Hi all - @mikeschmitt81 and @Omar Ghazi , not just me then :)

 

If it helps, when I tried to publish I get the following on validation (using Build 22.105.0031 + ):-

AcumaticaSmartsheetIntegration21R1

No errors or warnings have been found during validation. Validation has completed successfully.

File | Bin\NLog.dll Validation has completed successfully.

File | Bin\PX.SmartSheetIntegration.dll Validation has completed successfully.

File | Bin\smartsheet-csharp-sdk.dll Validation has completed successfully.

File | Pages\SS\SS501000.aspx Validation has completed successfully.

File | Pages\SS\SS501000.aspx.cs Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Attribute | SmartSheetIntegration.ListPMTaskAttribute Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.EPEmployeeSSExt

SmartSheetIntegration.EPEmployeeSSExt extends cache PX.Objects.EP.EPEmployee

Bin\PX.SmartSheetIntegration.dll | Cache | SmartSheetIntegration.EPUsersListSS Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.EmployeeMaintExtSS Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.PMProjectSSExt

SmartSheetIntegration.PMProjectSSExt extends cache PX.Objects.PM.PMProject

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.PMSetupSSExt

SmartSheetIntegration.PMSetupSSExt extends cache PX.Objects.PM.PMSetup

Bin\PX.SmartSheetIntegration.dll | Cache | SmartSheetIntegration.PMSSMapping Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Cache | SmartSheetIntegration.PMSubTask Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.PMTaskSSExt

SmartSheetIntegration.PMTaskSSExt extends cache PX.Objects.PM.PMTask

Bin\PX.SmartSheetIntegration.dll | Cache | SmartSheetIntegration.PMTemplateListSS Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.ProjectEntrySmartsheetExt Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.ProjectEntry_WorkflowSmartsheetExt Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.SetupMaintExt Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.TemplateTaskMaintExt Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.SmartsheetConstants/ActionsNames Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.SmartsheetConstants/Messages Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.SmartsheetConstants/TableNames Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.SmartsheetConstants/ViewName Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.SmartsheetConstants/ColumnMapping Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph | SmartSheetIntegration.SmartsheetSyncProcess Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.AccessUsersSSIExt Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.UsersSSExt SmartSheetIntegration.UsersSSExt extends cache PX.SM.Users

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.MyProfileMaintExt Validation has completed successfully.

Page | pages\ep\ep203000.aspx Validation has completed successfully.

Page | pages\pm\pm101000.aspx Validation has completed successfully.

Page | pages\pm\pm208010.aspx Validation has completed successfully.

Page | pages\pm\pm301000.aspx Validation has completed successfully.

Page | pages\sm\sm203010.aspx Validation has completed successfully.

SiteMapNode | Synchronize Smartsheet | SS501000 Validation has completed successfully.

Sql | EPUsersListSS Validation has completed successfully.

Sql | PMSSMapping Validation has completed successfully.

Sql | PMSubTask Validation has completed successfully.

Sql | PMTemplateListSS Validation has completed successfully.

Table | Contract Validation has completed successfully.

Table | EPEmployee Validation has completed successfully.

Table | PMSetup Validation has completed successfully.

Table | PMTask Validation has completed successfully.

Table | Users Validation has completed successfully.

 

Could not resolve interface type PX.Owin.IConditionalOwinConfigurationPart when enumerating interfaces of SmartSheetIntegration.SSAuthenticationHandler

 

Could not resolve interface type PX.Owin.ISessionDependentOwinConfigurationPart when enumerating interfaces of SmartSheetIntegration.SSAuthenticationHandler

 

At a guess I’m wondering if its something to do with OAUTH implementation, but as my coding skills are based in a time period before chips evolved legs I’m chancing my arm with that comment ...

 

As per comments from @mfrench, not necessarily looking for a fix as not able to contribute much towards it, however happy to test and have a (copied) live environment I can use for that if it helps at all.

 

Also very interested to see how many others in the community are using this product - for ourselves, ProCore is not the lead in UK Construction market (Oracle Primavera P6 is) so for construction implementations until Acumatica have planning board available for Project within the core we’re somewhat reliant on the continued use of this integration. @tleppek would you care to comment on Smartsheet use from your region?

 

Thanks for listening all,

Userlevel 2
Badge

any updates for 22R1? Thank you

Userlevel 2
Badge

I guess that is because in newer version  IOwinConfigurationPart replaced that 2 interfaces.

Hi all - @mikeschmitt81 and @Omar Ghazi , not just me then :)

 

If it helps, when I tried to publish I get the following on validation (using Build 22.105.0031 + ):-

AcumaticaSmartsheetIntegration21R1

No errors or warnings have been found during validation. Validation has completed successfully.

File | Bin\NLog.dll Validation has completed successfully.

File | Bin\PX.SmartSheetIntegration.dll Validation has completed successfully.

File | Bin\smartsheet-csharp-sdk.dll Validation has completed successfully.

File | Pages\SS\SS501000.aspx Validation has completed successfully.

File | Pages\SS\SS501000.aspx.cs Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Attribute | SmartSheetIntegration.ListPMTaskAttribute Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.EPEmployeeSSExt

SmartSheetIntegration.EPEmployeeSSExt extends cache PX.Objects.EP.EPEmployee

Bin\PX.SmartSheetIntegration.dll | Cache | SmartSheetIntegration.EPUsersListSS Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.EmployeeMaintExtSS Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.PMProjectSSExt

SmartSheetIntegration.PMProjectSSExt extends cache PX.Objects.PM.PMProject

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.PMSetupSSExt

SmartSheetIntegration.PMSetupSSExt extends cache PX.Objects.PM.PMSetup

Bin\PX.SmartSheetIntegration.dll | Cache | SmartSheetIntegration.PMSSMapping Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Cache | SmartSheetIntegration.PMSubTask Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.PMTaskSSExt

SmartSheetIntegration.PMTaskSSExt extends cache PX.Objects.PM.PMTask

Bin\PX.SmartSheetIntegration.dll | Cache | SmartSheetIntegration.PMTemplateListSS Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.ProjectEntrySmartsheetExt Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.ProjectEntry_WorkflowSmartsheetExt Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.SetupMaintExt Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.TemplateTaskMaintExt Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.SmartsheetConstants/ActionsNames Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.SmartsheetConstants/Messages Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.SmartsheetConstants/TableNames Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.SmartsheetConstants/ViewName Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.SmartsheetConstants/ColumnMapping Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph | SmartSheetIntegration.SmartsheetSyncProcess Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.AccessUsersSSIExt Validation has completed successfully.

Bin\PX.SmartSheetIntegration.dll | Class | SmartSheetIntegration.UsersSSExt SmartSheetIntegration.UsersSSExt extends cache PX.SM.Users

Bin\PX.SmartSheetIntegration.dll | Graph extension | SmartSheetIntegration.MyProfileMaintExt Validation has completed successfully.

Page | pages\ep\ep203000.aspx Validation has completed successfully.

Page | pages\pm\pm101000.aspx Validation has completed successfully.

Page | pages\pm\pm208010.aspx Validation has completed successfully.

Page | pages\pm\pm301000.aspx Validation has completed successfully.

Page | pages\sm\sm203010.aspx Validation has completed successfully.

SiteMapNode | Synchronize Smartsheet | SS501000 Validation has completed successfully.

Sql | EPUsersListSS Validation has completed successfully.

Sql | PMSSMapping Validation has completed successfully.

Sql | PMSubTask Validation has completed successfully.

Sql | PMTemplateListSS Validation has completed successfully.

Table | Contract Validation has completed successfully.

Table | EPEmployee Validation has completed successfully.

Table | PMSetup Validation has completed successfully.

Table | PMTask Validation has completed successfully.

Table | Users Validation has completed successfully.

 

Could not resolve interface type PX.Owin.IConditionalOwinConfigurationPart when enumerating interfaces of SmartSheetIntegration.SSAuthenticationHandler

 

Could not resolve interface type PX.Owin.ISessionDependentOwinConfigurationPart when enumerating interfaces of SmartSheetIntegration.SSAuthenticationHandler

 

At a guess I’m wondering if its something to do with OAUTH implementation, but as my coding skills are based in a time period before chips evolved legs I’m chancing my arm with that comment ...

 

As per comments from @mfrench, not necessarily looking for a fix as not able to contribute much towards it, however happy to test and have a (copied) live environment I can use for that if it helps at all.

 

Also very interested to see how many others in the community are using this product - for ourselves, ProCore is not the lead in UK Construction market (Oracle Primavera P6 is) so for construction implementations until Acumatica have planning board available for Project within the core we’re somewhat reliant on the continued use of this integration. @tleppek would you care to comment on Smartsheet use from your region?

 

Thanks for listening all,

 

Userlevel 6
Badge

The 22R1 compatibility for Smartsheet is in the backlog and being prioritized. We don’t have an ETA at this moment but we will create a post once the compatibility update is available. 

Userlevel 6
Badge +2

Hi Everyone,

We’re conducting a short survey around the Smartsheet Integration and would love your feedback!  Please follow the link below to help Acumatica gather information.  Thank You.

https://www.surveymonkey.com/r/YW28PWD

 

Product update: our SmartSheet integration available on GitHub is is now compatible with 2021R2. This update also includes a fix for the issue of retrieving an incomplete list of SmartSheet templates.

Follow the GitHub link to access the project: https://github.com/Acumatica/Acumatica-Smartsheet

 

I apologize for this question if it is obvious, but I just integrated Smartsheet with Acumatica.  I can see how you integrate it with the projects, but I am also looking to Smartsheet pulling account balances by branch into Smartsheet.  I want to create a budget vs actual at the account level by branch.  Can someone point me to a video or something?

Userlevel 6
Badge

@jdawson97 The integration allow for time/project/tasks from Acumatica to SmartSheet to be sent as well as project task progress (percent completed from SmartSheet back to Acumatica) only. Will you please clarify what you meant by account balances? No financial data is transferred between the two systems, currently.

@Omar Ghazi that answers my question.  If no financial data can be transferred between the two systems then I will stop searching for the answer!  Thank you!

Userlevel 7
Badge +10

@Omar Ghazi Any update on the ETA for the 2022 R1 integration?  We have customers wanting to upgrade to 2022 R1 and this is holding us back.

Userlevel 6
Badge

@meganfriesen37  thank you for the feedback. We don’t have an ETA on the 2022R1/R2 compatibility yet for this community-supported Github solution at the moment. 

 

For more information about the various types of integrations, compatibility, and support, please review this Acumatica Integration Framework Guide.

Userlevel 3
Badge +1

is smartsheet compatiable with 2022R1 and where to get it?

Userlevel 6
Badge

@mikeschmitt81 @woodyg84 @meganfriesen37 @phillipmarotta  - SmartSheet Integration is now compatible with 2022 R1 and 2022 R2

Userlevel 2
Badge

Hi. When will the integration be available for 2023 R1?

Userlevel 7
Badge +3

@LungileNjakazi37 Please see https://community.acumatica.com/acumatica-news-updates-2/smartsheet-2023-r1-and-2023-r2-compatibility-upgrade-and-deprecation-notice-19996 for updates on 2023 R1, 2023 R2, and the announcement of how future upgrades can be managed.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved