The following attribute data was missing from my most recent STORM install. This may get fixed in later releases but for anyone else missing Project priority, Task priority, Task category, Currency, or Country values, here they are:


INSERT INTO stormattribute (domain, akey, avalue, weight) VALUES
('Project priority', '4-urgent', 'urgent', 3),
('Project priority', '3-high', 'high', 2),
('Project priority', '2-normal', 'normal', 1),
('Project priority', '1-low', 'low', 0);

INSERT INTO stormattribute (domain, akey, avalue, weight) VALUES
('Task priority', '4-urgent', 'Urgent', 3),
('Task priority', '3-high', 'high', 2),
('Task priority', '2-normal', 'normal', 1),
('Task priority', '1-low', 'low', 0);

INSERT INTO stormattribute (domain, akey, avalue, weight) VALUES
('Task category', 'bug', 'bug', 0),
('Task category', 'feature request', 'feature request', 1),
('Task category', 'support', 'support', 2),
('Task category', 'task', 'task', 3);

Note: I believe it's by design to not have Currency or Country values but for those who wish, I've included them anyway. These are official ISO names and codes for countries. BTW - why doesn't Drupal have a countries table? So many modules need this!

INSERT INTO stormattribute (domain, akey, avalue, weight) VALUES
('Currency', 'USD', 'US Dollar', 0),
('Currency', 'EUR', 'Euro', 0),
('Currency', 'GBP', 'British Pound', 0),
('Currency', 'JPY', 'Japanese Yen', 0),
('Currency', 'CHF', 'Swiss Franc', 0);

INSERT INTO stormattribute (domain, akey, avalue, weight) VALUES
('Country', 'US', 'United States of America', 0),
('Country', 'AD', 'Andorra', 1),
('Country', 'AE', 'United Arab Emirates', 1),
('Country', 'AF', 'Afghanistan', 1),
('Country', 'AG', 'Antigua and Barbuda', 1),
('Country', 'AI', 'Anguilla', 1),
('Country', 'AL', 'Albania', 1),
('Country', 'AM', 'Armenia', 1),
('Country', 'AN', 'Netherlands Antilles', 1),
('Country', 'AO', 'Angola', 1),
('Country', 'AR', 'Argentina', 1),
('Country', 'AS', 'American Samoa', 1),
('Country', 'AT', 'Austria', 1),
('Country', 'AU', 'Australia', 1),
('Country', 'AW', 'Aruba', 1),
('Country', 'AX', 'Åland Islands', 1),
('Country', 'AZ', 'Azerbaijan', 1),
('Country', 'BA', 'Bosnia and Herzegovina', 1),
('Country', 'BB', 'Barbados', 1),
('Country', 'BD', 'Bangladesh', 1),
('Country', 'BE', 'Belgium', 1),
('Country', 'BF', 'Burkina Faso', 1),
('Country', 'BG', 'Bulgaria', 1),
('Country', 'BH', 'Bahrain', 1),
('Country', 'BI', 'Burundi', 1),
('Country', 'BJ', 'Benin', 1),
('Country', 'BL', 'Saint-Barthélemy', 1),
('Country', 'BM', 'Bermuda', 1),
('Country', 'BN', 'Brunei Darussalam', 1),
('Country', 'BO', 'Bolivia', 1),
('Country', 'BR', 'Brazil', 1),
('Country', 'BS', 'Bahamas', 1),
('Country', 'BT', 'Bhutan', 1),
('Country', 'BW', 'Botswana', 1),
('Country', 'BY', 'Belarus', 1),
('Country', 'BZ', 'Belize', 1),
('Country', 'CA', 'Canada', 1),
('Country', 'CD', 'Democratic Republic of the Congo', 1),
('Country', 'CF', 'Central African Republic', 1),
('Country', 'CG', 'Congo', 1),
('Country', 'CH', 'Switzerland', 1),
('Country', 'CI', 'Côte d''Ivoire', 1),
('Country', 'CK', 'Cook Islands', 1),
('Country', 'CL', 'Chile', 1),
('Country', 'CM', 'Cameroon', 1),
('Country', 'CN', 'China', 1),
('Country', 'CO', 'Colombia', 1),
('Country', 'CR', 'Costa Rica', 1),
('Country', 'CU', 'Cuba', 1),
('Country', 'CV', 'Cape Verde', 1),
('Country', 'CY', 'Cyprus', 1),
('Country', 'CZ', 'Czech Republic', 1),
('Country', 'DE', 'Germany', 1),
('Country', 'DJ', 'Djibouti', 1),
('Country', 'DK', 'Denmark', 1),
('Country', 'DM', 'Dominica', 1),
('Country', 'DO', 'Dominican Republic', 1),
('Country', 'DZ', 'Algeria', 1),
('Country', 'EC', 'Ecuador', 1),
('Country', 'EE', 'Estonia', 1),
('Country', 'EG', 'Egypt', 1),
('Country', 'EH', 'Western Sahara', 1),
('Country', 'ER', 'Eritrea', 1),
('Country', 'ES', 'Spain', 1),
('Country', 'ET', 'Ethiopia', 1),
('Country', 'FI', 'Finland', 1),
('Country', 'FJ', 'Fiji', 1),
('Country', 'FK', 'Falkland Islands (Malvinas)', 1),
('Country', 'FM', 'Micronesia, Federated States of', 1),
('Country', 'FO', 'Faeroe Islands', 1),
('Country', 'FR', 'France', 1),
('Country', 'GA', 'Gabon', 1),
('Country', 'GB', 'United Kingdom of Great Britain and Northern Ireland', 1),
('Country', 'GD', 'Grenada', 1),
('Country', 'GE', 'Georgia', 1),
('Country', 'GF', 'French Guiana', 1),
('Country', 'GG', 'Guernsey', 1),
('Country', 'GH', 'Ghana', 1),
('Country', 'GI', 'Gibraltar', 1),
('Country', 'GL', 'Greenland', 1),
('Country', 'GM', 'Gambia', 1),
('Country', 'GN', 'Guinea', 1),
('Country', 'GP', 'Guadeloupe', 1),
('Country', 'GQ', 'Equatorial Guinea', 1),
('Country', 'GR', 'Greece', 1),
('Country', 'GT', 'Guatemala', 1),
('Country', 'GU', 'Guam', 1),
('Country', 'GW', 'Guinea-Bissau', 1),
('Country', 'GY', 'Guyana', 1),
('Country', 'HK', 'Hong Kong Special Administrative Region of China', 1),
('Country', 'HN', 'Honduras', 1),
('Country', 'HR', 'Croatia', 1),
('Country', 'HT', 'Haiti', 1),
('Country', 'HU', 'Hungary', 1),
('Country', 'ID', 'Indonesia', 1),
('Country', 'IE', 'Ireland', 1),
('Country', 'IL', 'Israel', 1),
('Country', 'IM', 'Isle of Man', 1),
('Country', 'IN', 'India', 1),
('Country', 'IQ', 'Iraq, Republic of', 1),
('Country', 'IR', 'Iran, Islamic Republic of', 1),
('Country', 'IS', 'Iceland', 1),
('Country', 'IT', 'Italy', 1),
('Country', 'JE', 'Jersey', 1),
('Country', 'JM', 'Jamaica', 1),
('Country', 'JO', 'Jordan', 1),
('Country', 'JP', 'Japan', 1),
('Country', 'KE', 'Kenya', 1),
('Country', 'KG', 'Kyrgyzstan', 1),
('Country', 'KH', 'Cambodia', 1),
('Country', 'KI', 'Kiribati', 1),
('Country', 'KM', 'Comoros', 1),
('Country', 'KN', 'Saint Kitts and Nevis', 1),
('Country', 'KP', 'Democratic People''s Republic of Korea', 1),
('Country', 'KR', 'Republic of Korea', 1),
('Country', 'KW', 'Kuwait', 1),
('Country', 'KY', 'Cayman Islands', 1),
('Country', 'KZ', 'Kazakhstan', 1),
('Country', 'LA', 'Lao People''s Democratic Republic', 1),
('Country', 'LB', 'Lebanon', 1),
('Country', 'LC', 'Saint Lucia', 1),
('Country', 'LI', 'Liechtenstein', 1),
('Country', 'LK', 'Sri Lanka', 1),
('Country', 'LR', 'Liberia', 1),
('Country', 'LS', 'Lesotho', 1),
('Country', 'LT', 'Lithuania', 1),
('Country', 'LU', 'Luxembourg', 1),
('Country', 'LV', 'Latvia', 1),
('Country', 'LY', 'Libyan Arab Jamahiriya', 1),
('Country', 'MA', 'Morocco', 1),
('Country', 'MC', 'Monaco', 1),
('Country', 'MD', 'Moldova', 1),
('Country', 'ME', 'Montenegro', 1),
('Country', 'MF', 'Saint-Martin (French part)', 1),
('Country', 'MG', 'Madagascar', 1),
('Country', 'MH', 'Marshall Islands', 1),
('Country', 'MK', 'The former Yugoslav Republic of Macedonia', 1),
('Country', 'ML', 'Mali', 1),
('Country', 'MM', 'Myanmar', 1),
('Country', 'MN', 'Mongolia', 1),
('Country', 'MO', 'Macao Special Administrative Region of China', 1),
('Country', 'MP', 'Northern Mariana Islands', 1),
('Country', 'MQ', 'Martinique', 1),
('Country', 'MR', 'Mauritania', 1),
('Country', 'MS', 'Montserrat', 1),
('Country', 'MT', 'Malta', 1),
('Country', 'MU', 'Mauritius', 1),
('Country', 'MV', 'Maldives', 1),
('Country', 'MW', 'Malawi', 1),
('Country', 'MX', 'Mexico', 1),
('Country', 'MY', 'Malaysia', 1),
('Country', 'MZ', 'Mozambique', 1),
('Country', 'NA', 'Namibia', 1),
('Country', 'NC', 'New Caledonia', 1),
('Country', 'NE', 'Niger', 1),
('Country', 'NF', 'Norfolk Island', 1),
('Country', 'NG', 'Nigeria', 1),
('Country', 'NI', 'Nicaragua', 1),
('Country', 'NL', 'Netherlands', 1),
('Country', 'NO', 'Norway', 1),
('Country', 'NP', 'Nepal', 1),
('Country', 'NR', 'Nauru', 1),
('Country', 'NU', 'Niue', 1),
('Country', 'NZ', 'New Zealand', 1),
('Country', 'OM', 'Oman', 1),
('Country', 'PA', 'Panama', 1),
('Country', 'PE', 'Peru', 1),
('Country', 'PF', 'French Polynesia', 1),
('Country', 'PG', 'Papua New Guinea', 1),
('Country', 'PH', 'Philippines', 1),
('Country', 'PK', 'Pakistan', 1),
('Country', 'PL', 'Poland', 1),
('Country', 'PM', 'Saint Pierre and Miquelon', 1),
('Country', 'PN', 'Pitcairn', 1),
('Country', 'PR', 'Puerto Rico', 1),
('Country', 'PS', 'Occupied Palestinian Territory', 1),
('Country', 'PT', 'Portugal', 1),
('Country', 'PW', 'Palau', 1),
('Country', 'PY', 'Paraguay', 1),
('Country', 'QA', 'Qatar', 1),
('Country', 'RE', 'Réunion', 1),
('Country', 'RO', 'Romania', 1),
('Country', 'RS', 'Serbia', 1),
('Country', 'RU', 'Russian Federation', 1),
('Country', 'RW', 'Rwanda', 1),
('Country', 'SA', 'Saudi Arabia', 1),
('Country', 'SB', 'Solomon Islands', 1),
('Country', 'SC', 'Seychelles', 1),
('Country', 'SD', 'Sudan', 1),
('Country', 'SE', 'Sweden', 1),
('Country', 'SG', 'Singapore', 1),
('Country', 'SH', 'Saint Helena', 1),
('Country', 'SI', 'Slovenia', 1),
('Country', 'SJ', 'Svalbard and Jan Mayen Islands', 1),
('Country', 'SK', 'Slovakia', 1),
('Country', 'SL', 'Sierra Leone', 1),
('Country', 'SM', 'San Marino', 1),
('Country', 'SN', 'Senegal', 1),
('Country', 'SO', 'Somalia', 1),
('Country', 'SR', 'Suriname', 1),
('Country', 'ST', 'Sao Tome and Principe', 1),
('Country', 'SV', 'El Salvador', 1),
('Country', 'SY', 'Syrian Arab Republic', 1),
('Country', 'SZ', 'Swaziland', 1),
('Country', 'TC', 'Turks and Caicos Islands', 1),
('Country', 'TD', 'Chad', 1),
('Country', 'TG', 'Togo', 1),
('Country', 'TH', 'Thailand', 1),
('Country', 'TJ', 'Tajikistan', 1),
('Country', 'TK', 'Tokelau', 1),
('Country', 'TL', 'Timor-Leste', 1),
('Country', 'TM', 'Turkmenistan', 1),
('Country', 'TN', 'Tunisia', 1),
('Country', 'TO', 'Tonga', 1),
('Country', 'TR', 'Turkey', 1),
('Country', 'TT', 'Trinidad and Tobago', 1),
('Country', 'TV', 'Tuvalu', 1),
('Country', 'TZ', 'United Republic of Tanzania', 1),
('Country', 'UA', 'Ukraine', 1),
('Country', 'UG', 'Uganda', 1),
('Country', 'UY', 'Uruguay', 1),
('Country', 'UZ', 'Uzbekistan', 1),
('Country', 'VA', 'Holy See', 1),
('Country', 'VC', 'Saint Vincent and the Grenadines', 1),
('Country', 'VE', 'Venezuela (Bolivarian Republic of)', 1),
('Country', 'VG', 'British Virgin Islands', 1),
('Country', 'VI', 'United States Virgin Islands', 1),
('Country', 'VN', 'Viet Nam', 1),
('Country', 'VU', 'Vanuatu', 1),
('Country', 'WF', 'Wallis and Futuna Islands', 1),
('Country', 'WS', 'Samoa', 1),
('Country', 'YE', 'Yemen', 1),
('Country', 'YT', 'Mayotte', 1),
('Country', 'ZA', 'South Africa', 1),
('Country', 'ZM', 'Zambia', 1),
('Country', 'ZW', 'Zimbabwe', 1);

Comments

amariotti’s picture

Version: 6.x-1.x-dev » 5.x-1.9

Thanks for putting this together. It fixed the issue I ran into on the 5.x version as well. The Project Priority dropdown was there, but there was nothing in the list and no where that I could see to add to it. Please commit...

Anonymous’s picture

Shouldn't these be editable through the Drupal Admin UI?

txcrew

defconjuan’s picture

yes, but you'd have to enter each manually. this is just an easy way of inserting them until they're included in the distro as they should be.

flickerfly’s picture

heads up, the currency query isn't quite right. All but the last ; in that query should be a ,.

flickerfly’s picture

Version: 5.x-1.9 » 6.x-1.14
Category: support » bug
Priority: Normal » Critical

Holler if I'm overstepping my bounds, but usually bug triaging is appreciated. I just ran into this issue on 6.x-1.14 and I think it is more properly a bug report since it is a degredation of a feature. I'm marking it critical because this is info that needs to be in place before the module can be used, sure it can be done easily enough, but the only place we figure that out is once we start digging into the issue queue.

The file that needs to be changed appears to be stormattribute/stormattribute.install

I believe a stormattribute_update_2() function needs to be written with these changes. Do they also need to be implemented in stormattribute_install() or do the updates get run at install automatically?

If all it is is translating the SQL queries into PHP arrays within that one function, I could probably handle that and post a patch. The stormattribute_update_1() could be used as a template. I'd just like some confirmation that this is the proper direction to go before I do it as it will be time consuming.

On the side note of a drupal country table, has anyone seen an issue for that in core? Seems like a good idea. Maybe it could alternatively be a simple contrib module to depend on.

flickerfly’s picture

Title: Missing Attribute Values » task priority search also missing

I'm also noticing that "task priority search" stuff is missing.

flickerfly’s picture

Title: task priority search also missing » Missing Attribute Values
Roberto Gerola’s picture

I have committed to cvs a fix for the autocomplete of domains on stormattribute.
The default domains will be always present in the list.

I'm going to integrate the list of attributes provided above also.

Thanks, Roberto

flickerfly’s picture

Thanks Roberto!

Roberto Gerola’s picture

Status: Active » Fixed

Fixed and committed on cvs

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

defconjuan’s picture

Issue summary: View changes

Fixed currency query per comment.