Panatrack ParseData Function- required for pre/post eConnect stored procedures

Panatrack ParseData Function- required for pre/post eConnect stored procedures

This is the source for the [Panatrack_ParseData} SQL Function that must exist if you're using Dynamics GP pre or post eConnect stored procedures

  1. /****** Object: UserDefinedFunction [dbo].[Panatrack_ParseData] Script Date: 8/8/2022 1:51:50 PM ******/
  2. SET ANSI_NULLS ON
  3. GO

  5. SET QUOTED_IDENTIFIER ON
  6. GO

  8. CREATE FUNCTION [dbo].[Panatrack_ParseData]
  9. (
  10. @Input VARCHAR(8000),
  11. @TagName VARCHAR(30)
  12. )
  13. RETURNS VARCHAR(8000)
  14. AS BEGIN

  16. DECLARE @dataStartPos INT
  17. DECLARE @dataEndPos INT
  18. DECLARE @dataLength INT
  19. DECLARE @result VARCHAR(1000)

  21. DECLARE @startTag VARCHAR(30)
  22. DECLARE @endTag VARCHAR(30)

  24. SET @startTag = '[' + @TagName + ']'
  25. SET @endTag = '[/' + @TagName + ']'

  27. SET @dataStartPos = CHARINDEX(@startTag, @Input)
  28. SET @dataLength = CHARINDEX(@endTag, @Input) - (@dataStartPos + LEN(@startTag))
  29. IF @dataStartPos = 0
  30. SET @result = ''
  31. ELSE
  32. BEGIN
  33. SET @result = SUBSTRING(@Input, (@dataStartPos + LEN(@startTag)), @dataLength)
  34. END

  36. RETURN @result
  37. END
  38. GO

    • Related Articles

    • Panatrack ParseData Function- required for pre/post eConnect stored procedures

      This is the source for the [Panatrack_ParseData} SQL Function that must exist if you're using Dynamics GP pre or post eConnect stored procedures /****** Object: UserDefinedFunction [dbo].[Panatrack_ParseData] Script Date: 8/8/2022 1:51:50 PM ******/ ...

    • Panatrack ParseData Function- required for pre/post eConnect stored procedures

      This is the source for the [Panatrack_ParseData} SQL Function that must exist if you're using Dynamics GP pre or post eConnect stored procedures /****** Object: UserDefinedFunction [dbo].[Panatrack_ParseData] Script Date: 8/8/2022 1:51:50 PM ******/ ...

    • Using Panatrack Flex Fields within eConnect

      When PanatrackerGP submits eConnect transactions, we pass along our flex fields in the event they can be used to update custom data within your GP system. This stored procedure provides a function that can be used to easily pull out a named flex ...

    • Finding modified eConnect procedures

      The eConnect feature of Dynamics GP has great extensibility that allows administrators to customize how data is handled. It offers the capability to "hook" into other systems/tables. This is done through the eConnect "pre" or "post" procedures that ...

    • eConnect Errors that may be encountered when using PanatrackerGP

      "Error 1189: taSopHdrRecalc - Payment total does not match deposits+payments" Error: Payment total does not match deposits+payments entered for the document This error usually occurs when the taSopHdrIvcInsertPre stored procedure has been modified. ...