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 Reissmueller
created issue -
Jonathan Reissmueller
made changes -
Field | Original Value | New Value |
---|---|---|
Rank | Ranked higher |
Jonathan Reissmueller
made changes -
Story Points | 3 |
Jonathan Reissmueller
made changes -
Fix Version/s | Short Term [ 10800 ] |
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 Reissmueller
made changes -
Fix Version/s | 5.1.0 [ 11712 ] | |
Fix Version/s | Short Term [ 10800 ] |
Jonathan Reissmueller
made changes -
Sprint | 5.2.0 Sprint 1 [ 137 ] |
Jonathan Reissmueller
made changes -
Rank | Ranked lower |
Jonathan Reissmueller
made changes -
Rank | Ranked higher |
Abdy Franco
made changes -
Assignee | Abdy Franco [ abdy ] |
Abdy Franco
made changes -
Status | Open [ 1 ] | In Progress [ 3 ] |
Abdy Franco
made changes -
Remaining Estimate | 0 minutes [ 0 ] | |
Time Spent | 25 minutes [ 1500 ] | |
Worklog Id | 15052 [ 15052 ] |
Abdy Franco
made changes -
Status | In Progress [ 3 ] | Open [ 1 ] |
Abdy Franco
made changes -
Status | Open [ 1 ] | In Progress [ 3 ] |
Jonathan Reissmueller
made changes -
Sprint | 5.2.0 Sprint 1 [ 137 ] | 5.1.0-b2 Sprint 1 [ 136 ] |
Jonathan Reissmueller
made changes -
Rank | Ranked higher |
Abdy Franco
made changes -
Time Spent | 25 minutes [ 1500 ] | 4 hours, 35 minutes [ 16500 ] |
Worklog Id | 15058 [ 15058 ] |
Abdy Franco
made changes -
Status | In Progress [ 3 ] | In Review [ 5 ] |
Resolution | Fixed [ 1 ] |
Jonathan Reissmueller
made changes -
Status | In Review [ 5 ] | Closed [ 6 ] |