SmartSheet Integration is now compatible with 2021 R2

  • 2 February 2022
  • 9 replies
  • 253 views

Userlevel 5
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


9 replies

Userlevel 5
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 1

any updates for 22R1? Thank you

Userlevel 5
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 5
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 1

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,

 

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 1
Badge

Will there be a 2022 R1 version?

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 4
Badge +1

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

 

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 — 2022  Acumatica, Inc. All rights reserved