Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-4340

Import Manager: Map WHMCS contacts state field

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.1.0
    • Component/s: None
    • Labels:
      None

      Description

      Currently, when importing contacts from WHMCS, we pull in the state field. In our experience, the field from WHMCS is inconsistent. Sometimes the field contains the ISO state code (e.g. CA) but sometimes it contains the full state name (e.g. California). In the latter case we simply truncate the content to the first 3 characters. Instead we should:

      • Get the list of states from Blesta using States::getList()
      • Check if the field matches any of the state codes
      • If the field doesn't match, try mapping the field using the 'name' and 'code' columns
      • If there is no matching 'name', truncate the field to 3 characters (make sure this is multibyte compatible)

        Activity

        jonathan Jonathan Reissmueller created issue -
        jonathan Jonathan Reissmueller made changes -
        Field Original Value New Value
        Rank Ranked higher
        jonathan Jonathan Reissmueller made changes -
        Story Points 3
        jonathan Jonathan Reissmueller made changes -
        Fix Version/s Short Term [ 10800 ]
        jonathan Jonathan Reissmueller made changes -
        Description Currently, when importing contacts from WHMCS, we pull in the state field. In our experience, the field from WHMCS is inconsistent. Sometimes the field contains the ISO state code (e.g. CA) but sometimes it contains the full state name (e.g. California). In the latter case we simply truncate the content to the first 3 characters. Instead we should first attempt to map the full state name to the ISO code. We can this using States::getList(). Currently, when importing contacts from WHMCS, we pull in the state field. In our experience, the field from WHMCS is inconsistent. Sometimes the field contains the ISO state code (e.g. CA) but sometimes it contains the full state name (e.g. California). In the latter case we simply truncate the content to the first 3 characters. Instead we should:
        * Get the list of states from Blesta using States::getList()
        * Check if the field matches any of the state codes
        * If the field doesn't match, try mapping the field using the 'name' and 'code' columns
        * If there is no matching 'name', truncate the field to 3 characters (make sure this is multibyte compatible)
        jonathan Jonathan Reissmueller made changes -
        Fix Version/s 5.1.0 [ 11712 ]
        Fix Version/s Short Term [ 10800 ]
        jonathan Jonathan Reissmueller made changes -
        Sprint 5.2.0 Sprint 1 [ 137 ]
        jonathan Jonathan Reissmueller made changes -
        Rank Ranked lower
        jonathan Jonathan Reissmueller made changes -
        Rank Ranked higher
        abdy Abdy Franco made changes -
        Assignee Abdy Franco [ abdy ]
        abdy Abdy Franco made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        abdy Abdy Franco made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 25 minutes [ 1500 ]
        Worklog Id 15052 [ 15052 ]
        abdy Abdy Franco made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        abdy Abdy Franco made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        jonathan Jonathan Reissmueller made changes -
        Sprint 5.2.0 Sprint 1 [ 137 ] 5.1.0-b2 Sprint 1 [ 136 ]
        jonathan Jonathan Reissmueller made changes -
        Rank Ranked higher
        abdy Abdy Franco made changes -
        Time Spent 25 minutes [ 1500 ] 4 hours, 35 minutes [ 16500 ]
        Worklog Id 15058 [ 15058 ]
        abdy Abdy Franco made changes -
        Status In Progress [ 3 ] In Review [ 5 ]
        Resolution Fixed [ 1 ]
        jonathan Jonathan Reissmueller made changes -
        Status In Review [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            abdy Abdy Franco
            Reporter:
            jonathan Jonathan Reissmueller
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              6/Jul/21

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 4 hours, 35 minutes
              4h 35m

                Agile