Closed (fixed)
Project:
Storm
Version:
6.x-1.14
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Reporter:
Created:
4 Sep 2008 at 14:00 UTC
Updated:
18 Jul 2012 at 06:30 UTC
Jump to comment: Most recent
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
Comment #1
amariotti commentedThanks 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...
Comment #2
Anonymous (not verified) commentedShouldn't these be editable through the Drupal Admin UI?
txcrew
Comment #3
defconjuan commentedyes, 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.
Comment #4
flickerfly commentedheads up, the currency query isn't quite right. All but the last ; in that query should be a ,.
Comment #5
flickerfly commentedHoller 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.
Comment #6
flickerfly commentedI'm also noticing that "task priority search" stuff is missing.
Comment #7
flickerfly commentedComment #8
Roberto Gerola commentedI 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
Comment #9
flickerfly commentedThanks Roberto!
Comment #10
Roberto Gerola commentedFixed and committed on cvs
Comment #11
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.
Comment #11.0
defconjuan commentedFixed currency query per comment.