jro_apps/redmine Commit - r9402:910cb8ff06fe

1

# Redmine - project management software

1

# Redmine - project management software

2

3

#

3

#

4

# This program is free software; you can redistribute it and/or

4

# This program is free software; you can redistribute it and/or

5

# modify it under the terms of the GNU General Public License

5

# modify it under the terms of the GNU General Public License

6

# as published by the Free Software Foundation; either version 2

6

# as published by the Free Software Foundation; either version 2

7

# of the License, or (at your option) any later version.

7

# of the License, or (at your option) any later version.

8

#

8

#

9

# This program is distributed in the hope that it will be useful,

9

# This program is distributed in the hope that it will be useful,

10

# but WITHOUT ANY WARRANTY; without even the implied warranty of

10

# but WITHOUT ANY WARRANTY; without even the implied warranty of

11

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

11

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

12

# GNU General Public License for more details.

12

# GNU General Public License for more details.

13

#

13

#

14

# You should have received a copy of the GNU General Public License

14

# You should have received a copy of the GNU General Public License

15

# along with this program; if not, write to the Free Software

15

# along with this program; if not, write to the Free Software

16

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

16

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

17

18

desc 'Mantis migration script'

18

desc 'Mantis migration script'

19

20

require 'active_record'

20

require 'active_record'

21

require 'iconv'

21

require 'iconv'

22

require 'pp'

22

require 'pp'

23

24

namespace :redmine do

24

namespace :redmine do

25

task :migrate_from_mantis => :environment do

25

task :migrate_from_mantis => :environment do

26

27

module MantisMigrate

27

module MantisMigrate

28

29

DEFAULT_STATUS = IssueStatus.default

29

DEFAULT_STATUS = IssueStatus.default

30

assigned_status = IssueStatus.find_by_position(2)

30

assigned_status = IssueStatus.find_by_position(2)

31

resolved_status = IssueStatus.find_by_position(3)

31

resolved_status = IssueStatus.find_by_position(3)

32

feedback_status = IssueStatus.find_by_position(4)

32

feedback_status = IssueStatus.find_by_position(4)

33

closed_status = IssueStatus.find :first, :conditions => { :is_closed => true }

33

closed_status = IssueStatus.find :first, :conditions => { :is_closed => true }

34

STATUS_MAPPING = {10 => DEFAULT_STATUS, # new

34

STATUS_MAPPING = {10 => DEFAULT_STATUS, # new

35

20 => feedback_status, # feedback

35

20 => feedback_status, # feedback

36

30 => DEFAULT_STATUS, # acknowledged

36

30 => DEFAULT_STATUS, # acknowledged

37

40 => DEFAULT_STATUS, # confirmed

37

40 => DEFAULT_STATUS, # confirmed

38

50 => assigned_status, # assigned

38

50 => assigned_status, # assigned

39

80 => resolved_status, # resolved

39

80 => resolved_status, # resolved

40

90 => closed_status # closed

40

90 => closed_status # closed

41

}

41

}

42

43

priorities = IssuePriority.all

43

priorities = IssuePriority.all

44

DEFAULT_PRIORITY = priorities[2]

44

DEFAULT_PRIORITY = priorities[2]

45

PRIORITY_MAPPING = {10 => priorities[1], # none

45

PRIORITY_MAPPING = {10 => priorities[1], # none

46

20 => priorities[1], # low

46

20 => priorities[1], # low

47

30 => priorities[2], # normal

47

30 => priorities[2], # normal

48

40 => priorities[3], # high

48

40 => priorities[3], # high

49

50 => priorities[4], # urgent

49

50 => priorities[4], # urgent

50

60 => priorities[5] # immediate

50

60 => priorities[5] # immediate

51

}

51

}

52

53

TRACKER_BUG = Tracker.find_by_position(1)

53

TRACKER_BUG = Tracker.find_by_position(1)

54

TRACKER_FEATURE = Tracker.find_by_position(2)

54

TRACKER_FEATURE = Tracker.find_by_position(2)

55

56

roles = Role.find(:all, :conditions => {:builtin => 0}, :order => 'position ASC')

56

roles = Role.find(:all, :conditions => {:builtin => 0}, :order => 'position ASC')

57

manager_role = roles[0]

57

manager_role = roles[0]

58

developer_role = roles[1]

58

developer_role = roles[1]

59

DEFAULT_ROLE = roles.last

59

DEFAULT_ROLE = roles.last

60

ROLE_MAPPING = {10 => DEFAULT_ROLE, # viewer

60

ROLE_MAPPING = {10 => DEFAULT_ROLE, # viewer

61

25 => DEFAULT_ROLE, # reporter

61

25 => DEFAULT_ROLE, # reporter

62

40 => DEFAULT_ROLE, # updater

62

40 => DEFAULT_ROLE, # updater

63

55 => developer_role, # developer

63

55 => developer_role, # developer

64

70 => manager_role, # manager

64

70 => manager_role, # manager

65

90 => manager_role # administrator

65

90 => manager_role # administrator

66

}

66

}

67

68

CUSTOM_FIELD_TYPE_MAPPING = {0 => 'string', # String

68

CUSTOM_FIELD_TYPE_MAPPING = {0 => 'string', # String

69

1 => 'int', # Numeric

69

1 => 'int', # Numeric

70

2 => 'int', # Float

70

2 => 'int', # Float

71

3 => 'list', # Enumeration

71

3 => 'list', # Enumeration

72

4 => 'string', # Email

72

4 => 'string', # Email

73

5 => 'bool', # Checkbox

73

5 => 'bool', # Checkbox

74

6 => 'list', # List

74

6 => 'list', # List

75

7 => 'list', # Multiselection list

75

7 => 'list', # Multiselection list

76

8 => 'date', # Date

76

8 => 'date', # Date

77

}

77

}

78

79

RELATION_TYPE_MAPPING = {1 => IssueRelation::TYPE_RELATES, # related to

79

RELATION_TYPE_MAPPING = {1 => IssueRelation::TYPE_RELATES, # related to

80

2 => IssueRelation::TYPE_RELATES, # parent of

80

2 => IssueRelation::TYPE_RELATES, # parent of

81

3 => IssueRelation::TYPE_RELATES, # child of

81

3 => IssueRelation::TYPE_RELATES, # child of

82

0 => IssueRelation::TYPE_DUPLICATES, # duplicate of

82

0 => IssueRelation::TYPE_DUPLICATES, # duplicate of

83

4 => IssueRelation::TYPE_DUPLICATES # has duplicate

83

4 => IssueRelation::TYPE_DUPLICATES # has duplicate

84

}

84

}

85

86

class MantisUser < ActiveRecord::Base

86

class MantisUser < ActiveRecord::Base

87

self.table_name = :mantis_user_table

87

self.table_name = :mantis_user_table

88

89

def firstname

89

def firstname

90

@firstname = realname.blank? ? username : realname.split.first[0..29]

90

@firstname = realname.blank? ? username : realname.split.first[0..29]

91

@firstname

91

@firstname

92

end

92

end

93

94

def lastname

94

def lastname

95

@lastname = realname.blank? ? '-' : realname.split[1..-1].join(' ')[0..29]

95

@lastname = realname.blank? ? '-' : realname.split[1..-1].join(' ')[0..29]

96

@lastname = '-' if @lastname.blank?

96

@lastname = '-' if @lastname.blank?

97

@lastname

97

@lastname

98

end

98

end

99

100

def email

100

def email

101

if read_attribute(:email).match(/^([^@\s]+)@((?:[-a-z0-9]+\.)+[a-z]{2,})$/i) &&

101

if read_attribute(:email).match(/^([^@\s]+)@((?:[-a-z0-9]+\.)+[a-z]{2,})$/i) &&

102

!User.find_by_mail(read_attribute(:email))

102

!User.find_by_mail(read_attribute(:email))

103

@email = read_attribute(:email)

103

@email = read_attribute(:email)

104

else

104

else

105

@email = "#{username}@foo.bar"

105

@email = "#{username}@foo.bar"

106

end

106

end

107

end

107

end

108

109

def username

109

def username

110

read_attribute(:username)[0..29].gsub(/[^a-zA-Z0-9_\-@\.]/, '-')

110

read_attribute(:username)[0..29].gsub(/[^a-zA-Z0-9_\-@\.]/, '-')

111

end

111

end

112

end

112

end

113

114

class MantisProject < ActiveRecord::Base

114

class MantisProject < ActiveRecord::Base

115

self.table_name = :mantis_project_table

115

self.table_name = :mantis_project_table

116

has_many :versions, :class_name => "MantisVersion", :foreign_key => :project_id

116

has_many :versions, :class_name => "MantisVersion", :foreign_key => :project_id

117

has_many :categories, :class_name => "MantisCategory", :foreign_key => :project_id

117

has_many :categories, :class_name => "MantisCategory", :foreign_key => :project_id

118

has_many :news, :class_name => "MantisNews", :foreign_key => :project_id

118

has_many :news, :class_name => "MantisNews", :foreign_key => :project_id

119

has_many :members, :class_name => "MantisProjectUser", :foreign_key => :project_id

119

has_many :members, :class_name => "MantisProjectUser", :foreign_key => :project_id

120

121

def identifier

121

def identifier

122

read_attribute(:name).gsub(/[^a-z0-9\-]+/, '-').slice(0, Project::IDENTIFIER_MAX_LENGTH)

122

read_attribute(:name).gsub(/[^a-z0-9\-]+/, '-').slice(0, Project::IDENTIFIER_MAX_LENGTH)

123

end

123

end

124

end

124

end

125

126

class MantisVersion < ActiveRecord::Base

126

class MantisVersion < ActiveRecord::Base

127

self.table_name = :mantis_project_version_table

127

self.table_name = :mantis_project_version_table

128

129

def version

129

def version

130

read_attribute(:version)[0..29]

130

read_attribute(:version)[0..29]

131

end

131

end

132

133

def description

133

def description

134

read_attribute(:description)[0..254]

134

read_attribute(:description)[0..254]

135

end

135

end

136

end

136

end

137

138

class MantisCategory < ActiveRecord::Base

138

class MantisCategory < ActiveRecord::Base

139

self.table_name = :mantis_project_category_table

139

self.table_name = :mantis_project_category_table

140

end

140

end

141

142

class MantisProjectUser < ActiveRecord::Base

142

class MantisProjectUser < ActiveRecord::Base

143

self.table_name = :mantis_project_user_list_table

143

self.table_name = :mantis_project_user_list_table

144

end

144

end

145

146

class MantisBug < ActiveRecord::Base

146

class MantisBug < ActiveRecord::Base

147

self.table_name = :mantis_bug_table

147

self.table_name = :mantis_bug_table

148

belongs_to :bug_text, :class_name => "MantisBugText", :foreign_key => :bug_text_id

148

belongs_to :bug_text, :class_name => "MantisBugText", :foreign_key => :bug_text_id

149

has_many :bug_notes, :class_name => "MantisBugNote", :foreign_key => :bug_id

149

has_many :bug_notes, :class_name => "MantisBugNote", :foreign_key => :bug_id

150

has_many :bug_files, :class_name => "MantisBugFile", :foreign_key => :bug_id

150

has_many :bug_files, :class_name => "MantisBugFile", :foreign_key => :bug_id

151

has_many :bug_monitors, :class_name => "MantisBugMonitor", :foreign_key => :bug_id

151

has_many :bug_monitors, :class_name => "MantisBugMonitor", :foreign_key => :bug_id

152

end

152

end

153

154

class MantisBugText < ActiveRecord::Base

154

class MantisBugText < ActiveRecord::Base

155

self.table_name = :mantis_bug_text_table

155

self.table_name = :mantis_bug_text_table

156

157

# Adds Mantis steps_to_reproduce and additional_information fields

157

# Adds Mantis steps_to_reproduce and additional_information fields

158

# to description if any

158

# to description if any

159

def full_description

159

def full_description

160

full_description = description

160

full_description = description

161

full_description += "\n\n*Steps to reproduce:*\n\n#{steps_to_reproduce}" unless steps_to_reproduce.blank?

161

full_description += "\n\n*Steps to reproduce:*\n\n#{steps_to_reproduce}" unless steps_to_reproduce.blank?

162

full_description += "\n\n*Additional information:*\n\n#{additional_information}" unless additional_information.blank?

162

full_description += "\n\n*Additional information:*\n\n#{additional_information}" unless additional_information.blank?

163

full_description

163

full_description

164

end

164

end

165

end

165

end

166

167

class MantisBugNote < ActiveRecord::Base

167

class MantisBugNote < ActiveRecord::Base

168

self.table_name = :mantis_bugnote_table

168

self.table_name = :mantis_bugnote_table

169

belongs_to :bug, :class_name => "MantisBug", :foreign_key => :bug_id

169

belongs_to :bug, :class_name => "MantisBug", :foreign_key => :bug_id

170

belongs_to :bug_note_text, :class_name => "MantisBugNoteText", :foreign_key => :bugnote_text_id

170

belongs_to :bug_note_text, :class_name => "MantisBugNoteText", :foreign_key => :bugnote_text_id

171

end

171

end

172

173

class MantisBugNoteText < ActiveRecord::Base

173

class MantisBugNoteText < ActiveRecord::Base

174

self.table_name = :mantis_bugnote_text_table

174

self.table_name = :mantis_bugnote_text_table

175

end

175

end

176

177

class MantisBugFile < ActiveRecord::Base

177

class MantisBugFile < ActiveRecord::Base

178

self.table_name = :mantis_bug_file_table

178

self.table_name = :mantis_bug_file_table

179

180

def size

180

def size

181

filesize

181

filesize

182

end

182

end

183

184

def original_filename

184

def original_filename

185

MantisMigrate.encode(filename)

185

MantisMigrate.encode(filename)

186

end

186

end

187

188

def content_type

188

def content_type

189

file_type

189

file_type

190

end

190

end

191

192

def read(*args)

192

def read(*args)

193

if @read_finished

193

if @read_finished

194

nil

194

nil

195

else

195

else

196

@read_finished = true

196

@read_finished = true

197

content

197

content

198

end

198

end

199

end

199

end

200

end

200

end

201

202

class MantisBugRelationship < ActiveRecord::Base

202

class MantisBugRelationship < ActiveRecord::Base

203

self.table_name = :mantis_bug_relationship_table

203

self.table_name = :mantis_bug_relationship_table

204

end

204

end

205

206

class MantisBugMonitor < ActiveRecord::Base

206

class MantisBugMonitor < ActiveRecord::Base

207

self.table_name = :mantis_bug_monitor_table

207

self.table_name = :mantis_bug_monitor_table

208

end

208

end

209

210

class MantisNews < ActiveRecord::Base

210

class MantisNews < ActiveRecord::Base

211

self.table_name = :mantis_news_table

211

self.table_name = :mantis_news_table

212

end

212

end

213

214

class MantisCustomField < ActiveRecord::Base

214

class MantisCustomField < ActiveRecord::Base

215

self.table_name = :mantis_custom_field_table

215

self.table_name = :mantis_custom_field_table

216

set_inheritance_column :none

216

set_inheritance_column :none

217

has_many :values, :class_name => "MantisCustomFieldString", :foreign_key => :field_id

217

has_many :values, :class_name => "MantisCustomFieldString", :foreign_key => :field_id

218

has_many :projects, :class_name => "MantisCustomFieldProject", :foreign_key => :field_id

218

has_many :projects, :class_name => "MantisCustomFieldProject", :foreign_key => :field_id

219

220

def format

220

def format

221

read_attribute :type

221

read_attribute :type

222

end

222

end

223

224

def name

224

def name

225

read_attribute(:name)[0..29]

225

read_attribute(:name)[0..29]

226

end

226

end

227

end

227

end

228

229

class MantisCustomFieldProject < ActiveRecord::Base

229

class MantisCustomFieldProject < ActiveRecord::Base

230

self.table_name = :mantis_custom_field_project_table

230

self.table_name = :mantis_custom_field_project_table

231

end

231

end

232

233

class MantisCustomFieldString < ActiveRecord::Base

233

class MantisCustomFieldString < ActiveRecord::Base

234

self.table_name = :mantis_custom_field_string_table

234

self.table_name = :mantis_custom_field_string_table

235

end

235

end

236

237

def self.migrate

237

def self.migrate

238

239

# Users

239

# Users

240

print "Migrating users"

240

print "Migrating users"

241

User.delete_all "login <> 'admin'"

241

User.delete_all "login <> 'admin'"

242

users_map = {}

242

users_map = {}

243

users_migrated = 0

243

users_migrated = 0

244

MantisUser.find(:all).each do |user|

244

MantisUser.find(:all).each do |user|

245

u = User.new :firstname => encode(user.firstname),

245

u = User.new :firstname => encode(user.firstname),

246

:lastname => encode(user.lastname),

246

:lastname => encode(user.lastname),

247

:mail => user.email,

247

:mail => user.email,

248

:last_login_on => user.last_visit

248

:last_login_on => user.last_visit

249

u.login = user.username

249

u.login = user.username

250

u.password = 'mantis'

250

u.password = 'mantis'

251

u.status = User::STATUS_LOCKED if user.enabled != 1

251

u.status = User::STATUS_LOCKED if user.enabled != 1

252

u.admin = true if user.access_level == 90

252

u.admin = true if user.access_level == 90

253

next unless u.save!

253

next unless u.save!

254

users_migrated += 1

254

users_migrated += 1

255

users_map[user.id] = u.id

255

users_map[user.id] = u.id

256

print '.'

256

print '.'

257

end

257

end

258

puts

258

puts

259

260

# Projects

260

# Projects

261

print "Migrating projects"

261

print "Migrating projects"

262

Project.destroy_all

262

Project.destroy_all

263

projects_map = {}

263

projects_map = {}

264

versions_map = {}

264

versions_map = {}

265

categories_map = {}

265

categories_map = {}

266

MantisProject.find(:all).each do |project|

266

MantisProject.find(:all).each do |project|

267

p = Project.new :name => encode(project.name),

267

p = Project.new :name => encode(project.name),

268

:description => encode(project.description)

268

:description => encode(project.description)

269

p.identifier = project.identifier

269

p.identifier = project.identifier

270

next unless p.save

270

next unless p.save

271

projects_map[project.id] = p.id

271

projects_map[project.id] = p.id

272

p.enabled_module_names = ['issue_tracking', 'news', 'wiki']

272

p.enabled_module_names = ['issue_tracking', 'news', 'wiki']

273

p.trackers << TRACKER_BUG unless p.trackers.include?(TRACKER_BUG)

273

p.trackers << TRACKER_BUG unless p.trackers.include?(TRACKER_BUG)

274

p.trackers << TRACKER_FEATURE unless p.trackers.include?(TRACKER_FEATURE)

274

p.trackers << TRACKER_FEATURE unless p.trackers.include?(TRACKER_FEATURE)

275

print '.'

275

print '.'

276

277

# Project members

277

# Project members

278

project.members.each do |member|

278

project.members.each do |member|

279

m = Member.new :user => User.find_by_id(users_map[member.user_id]),

279

m = Member.new :user => User.find_by_id(users_map[member.user_id]),

280

:roles => [ROLE_MAPPING[member.access_level] || DEFAULT_ROLE]

280

:roles => [ROLE_MAPPING[member.access_level] || DEFAULT_ROLE]

281

m.project = p

281

m.project = p

282

m.save

282

m.save

283

end

283

end

284

285

# Project versions

285

# Project versions

286

project.versions.each do |version|

286

project.versions.each do |version|

287

v = Version.new :name => encode(version.version),

287

v = Version.new :name => encode(version.version),

288

:description => encode(version.description),

288

:description => encode(version.description),

289

:effective_date => (version.date_order ? version.date_order.to_date : nil)

289

:effective_date => (version.date_order ? version.date_order.to_date : nil)

290

v.project = p

290

v.project = p

291

v.save

291

v.save

292

versions_map[version.id] = v.id

292

versions_map[version.id] = v.id

293

end

293

end

294

295

# Project categories

295

# Project categories

296

project.categories.each do |category|

296

project.categories.each do |category|

297

g = IssueCategory.new :name => category.category[0,30]

297

g = IssueCategory.new :name => category.category[0,30]

298

g.project = p

298

g.project = p

299

g.save

299

g.save

300

categories_map[category.category] = g.id

300

categories_map[category.category] = g.id

301

end

301

end

302

end

302

end

303

puts

303

puts

304

305

# Bugs

305

# Bugs

306

print "Migrating bugs"

306

print "Migrating bugs"

307

Issue.destroy_all

307

Issue.destroy_all

308

issues_map = {}

308

issues_map = {}

309

keep_bug_ids = (Issue.count == 0)

309

keep_bug_ids = (Issue.count == 0)

310

MantisBug.find_each(:batch_size => 200) do |bug|

310

MantisBug.find_each(:batch_size => 200) do |bug|

311

next unless projects_map[bug.project_id] && users_map[bug.reporter_id]

311

next unless projects_map[bug.project_id] && users_map[bug.reporter_id]

312

i = Issue.new :project_id => projects_map[bug.project_id],

312

i = Issue.new :project_id => projects_map[bug.project_id],

313

:subject => encode(bug.summary),

313

:subject => encode(bug.summary),

314

:description => encode(bug.bug_text.full_description),

314

:description => encode(bug.bug_text.full_description),

315

:priority => PRIORITY_MAPPING[bug.priority] || DEFAULT_PRIORITY,

315

:priority => PRIORITY_MAPPING[bug.priority] || DEFAULT_PRIORITY,

316

:created_on => bug.date_submitted,

316

:created_on => bug.date_submitted,

317

:updated_on => bug.last_updated

317

:updated_on => bug.last_updated

318

i.author = User.find_by_id(users_map[bug.reporter_id])

318

i.author = User.find_by_id(users_map[bug.reporter_id])

319

i.category = IssueCategory.find_by_project_id_and_name(i.project_id, bug.category[0,30]) unless bug.category.blank?

319

i.category = IssueCategory.find_by_project_id_and_name(i.project_id, bug.category[0,30]) unless bug.category.blank?

320

i.fixed_version = Version.find_by_project_id_and_name(i.project_id, bug.fixed_in_version) unless bug.fixed_in_version.blank?

320

i.fixed_version = Version.find_by_project_id_and_name(i.project_id, bug.fixed_in_version) unless bug.fixed_in_version.blank?

321

i.status = STATUS_MAPPING[bug.status] || DEFAULT_STATUS

321

i.status = STATUS_MAPPING[bug.status] || DEFAULT_STATUS

322

i.tracker = (bug.severity == 10 ? TRACKER_FEATURE : TRACKER_BUG)

322

i.tracker = (bug.severity == 10 ? TRACKER_FEATURE : TRACKER_BUG)

323

i.id = bug.id if keep_bug_ids

323

i.id = bug.id if keep_bug_ids

324

next unless i.save

324

next unless i.save

325

issues_map[bug.id] = i.id

325

issues_map[bug.id] = i.id

326

print '.'

326

print '.'

327

STDOUT.flush

327

STDOUT.flush

328

329

# Assignee

329

# Assignee

330

# Redmine checks that the assignee is a project member

330

# Redmine checks that the assignee is a project member

331

if (bug.handler_id && users_map[bug.handler_id])

331

if (bug.handler_id && users_map[bug.handler_id])

332

i.assigned_to = User.find_by_id(users_map[bug.handler_id])

332

i.assigned_to = User.find_by_id(users_map[bug.handler_id])

333

i.save(:validate => false)

333

i.save(:validate => false)

334

end

334

end

335

336

# Bug notes

336

# Bug notes

337

bug.bug_notes.each do |note|

337

bug.bug_notes.each do |note|

338

next unless users_map[note.reporter_id]

338

next unless users_map[note.reporter_id]

339

n = Journal.new :notes => encode(note.bug_note_text.note),

339

n = Journal.new :notes => encode(note.bug_note_text.note),

340

:created_on => note.date_submitted

340

:created_on => note.date_submitted

341

n.user = User.find_by_id(users_map[note.reporter_id])

341

n.user = User.find_by_id(users_map[note.reporter_id])

342

n.journalized = i

342

n.journalized = i

343

n.save

343

n.save

344

end

344

end

345

346

# Bug files

346

# Bug files

347

bug.bug_files.each do |file|

347

bug.bug_files.each do |file|

348

a = Attachment.new :created_on => file.date_added

348

a = Attachment.new :created_on => file.date_added

349

a.file = file

349

a.file = file

350

a.author = User.find :first

350

a.author = User.find :first

351

a.container = i

351

a.container = i

352

a.save

352

a.save

353

end

353

end

354

355

# Bug monitors

355

# Bug monitors

356

bug.bug_monitors.each do |monitor|

356

bug.bug_monitors.each do |monitor|

357

next unless users_map[monitor.user_id]

357

next unless users_map[monitor.user_id]

358

i.add_watcher(User.find_by_id(users_map[monitor.user_id]))

358

i.add_watcher(User.find_by_id(users_map[monitor.user_id]))

359

end

359

end

360

end

360

end

361

362

# update issue id sequence if needed (postgresql)

362

# update issue id sequence if needed (postgresql)

363

Issue.connection.reset_pk_sequence!(Issue.table_name) if Issue.connection.respond_to?('reset_pk_sequence!')

363

Issue.connection.reset_pk_sequence!(Issue.table_name) if Issue.connection.respond_to?('reset_pk_sequence!')

364

puts

364

puts

365

366

# Bug relationships

366

# Bug relationships

367

print "Migrating bug relations"

367

print "Migrating bug relations"

368

MantisBugRelationship.find(:all).each do |relation|

368

MantisBugRelationship.find(:all).each do |relation|

369

next unless issues_map[relation.source_bug_id] && issues_map[relation.destination_bug_id]

369

next unless issues_map[relation.source_bug_id] && issues_map[relation.destination_bug_id]

370

r = IssueRelation.new :relation_type => RELATION_TYPE_MAPPING[relation.relationship_type]

370

r = IssueRelation.new :relation_type => RELATION_TYPE_MAPPING[relation.relationship_type]

371

r.issue_from = Issue.find_by_id(issues_map[relation.source_bug_id])

371

r.issue_from = Issue.find_by_id(issues_map[relation.source_bug_id])

372

r.issue_to = Issue.find_by_id(issues_map[relation.destination_bug_id])

372

r.issue_to = Issue.find_by_id(issues_map[relation.destination_bug_id])

373

pp r unless r.save

373

pp r unless r.save

374

print '.'

374

print '.'

375

STDOUT.flush

375

STDOUT.flush

376

end

376

end

377

puts

377

puts

378

379

# News

379

# News

380

print "Migrating news"

380

print "Migrating news"

381

News.destroy_all

381

News.destroy_all

382

MantisNews.find(:all, :conditions => 'project_id > 0').each do |news|

382

MantisNews.find(:all, :conditions => 'project_id > 0').each do |news|

383

next unless projects_map[news.project_id]

383

next unless projects_map[news.project_id]

384

n = News.new :project_id => projects_map[news.project_id],

384

n = News.new :project_id => projects_map[news.project_id],

385

:title => encode(news.headline[0..59]),

385

:title => encode(news.headline[0..59]),

386

:description => encode(news.body),

386

:description => encode(news.body),

387

:created_on => news.date_posted

387

:created_on => news.date_posted

388

n.author = User.find_by_id(users_map[news.poster_id])

388

n.author = User.find_by_id(users_map[news.poster_id])

389

n.save

389

n.save

390

print '.'

390

print '.'

391

STDOUT.flush

391

STDOUT.flush

392

end

392

end

393

puts

393

puts

394

395

# Custom fields

395

# Custom fields

396

print "Migrating custom fields"

396

print "Migrating custom fields"

397

IssueCustomField.destroy_all

397

IssueCustomField.destroy_all

398

MantisCustomField.find(:all).each do |field|

398

MantisCustomField.find(:all).each do |field|

399

f = IssueCustomField.new :name => field.name[0..29],

399

f = IssueCustomField.new :name => field.name[0..29],

400

:field_format => CUSTOM_FIELD_TYPE_MAPPING[field.format],

400

:field_format => CUSTOM_FIELD_TYPE_MAPPING[field.format],

401

:min_length => field.length_min,

401

:min_length => field.length_min,

402

:max_length => field.length_max,

402

:max_length => field.length_max,

403

:regexp => field.valid_regexp,

403

:regexp => field.valid_regexp,

404

:possible_values => field.possible_values.split('|'),

404

:possible_values => field.possible_values.split('|'),

405

:is_required => field.require_report?

405

:is_required => field.require_report?

406

next unless f.save

406

next unless f.save

407

print '.'

407

print '.'

408

STDOUT.flush

408

STDOUT.flush

409

# Trackers association

409

# Trackers association

410

f.trackers = Tracker.find :all

410

f.trackers = Tracker.find :all

411

412

# Projects association

412

# Projects association

413

field.projects.each do |project|

413

field.projects.each do |project|

414

f.projects << Project.find_by_id(projects_map[project.project_id]) if projects_map[project.project_id]

414

f.projects << Project.find_by_id(projects_map[project.project_id]) if projects_map[project.project_id]

415

end

415

end

416

417

# Values

417

# Values

418

field.values.each do |value|

418

field.values.each do |value|

419

v = CustomValue.new :custom_field_id => f.id,

419

v = CustomValue.new :custom_field_id => f.id,

420

:value => value.value

420

:value => value.value

421

v.customized = Issue.find_by_id(issues_map[value.bug_id]) if issues_map[value.bug_id]

421

v.customized = Issue.find_by_id(issues_map[value.bug_id]) if issues_map[value.bug_id]

422

v.save

422

v.save

423

end unless f.new_record?

423

end unless f.new_record?

424

end

424

end

425

puts

425

puts

426

427

puts

427

puts

428

puts "Users: #{users_migrated}/#{MantisUser.count}"

428

puts "Users: #{users_migrated}/#{MantisUser.count}"

429

puts "Projects: #{Project.count}/#{MantisProject.count}"

429

puts "Projects: #{Project.count}/#{MantisProject.count}"

430

puts "Memberships: #{Member.count}/#{MantisProjectUser.count}"

430

puts "Memberships: #{Member.count}/#{MantisProjectUser.count}"

431

puts "Versions: #{Version.count}/#{MantisVersion.count}"

431

puts "Versions: #{Version.count}/#{MantisVersion.count}"

432

puts "Categories: #{IssueCategory.count}/#{MantisCategory.count}"

432

puts "Categories: #{IssueCategory.count}/#{MantisCategory.count}"

433

puts "Bugs: #{Issue.count}/#{MantisBug.count}"

433

puts "Bugs: #{Issue.count}/#{MantisBug.count}"

434

puts "Bug notes: #{Journal.count}/#{MantisBugNote.count}"

434

puts "Bug notes: #{Journal.count}/#{MantisBugNote.count}"

435

puts "Bug files: #{Attachment.count}/#{MantisBugFile.count}"

435

puts "Bug files: #{Attachment.count}/#{MantisBugFile.count}"

436

puts "Bug relations: #{IssueRelation.count}/#{MantisBugRelationship.count}"

436

puts "Bug relations: #{IssueRelation.count}/#{MantisBugRelationship.count}"

437

puts "Bug monitors: #{Watcher.count}/#{MantisBugMonitor.count}"

437

puts "Bug monitors: #{Watcher.count}/#{MantisBugMonitor.count}"

438

puts "News: #{News.count}/#{MantisNews.count}"

438

puts "News: #{News.count}/#{MantisNews.count}"

439

puts "Custom fields: #{IssueCustomField.count}/#{MantisCustomField.count}"

439

puts "Custom fields: #{IssueCustomField.count}/#{MantisCustomField.count}"

440

end

440

end

441

442

def self.encoding(charset)

442

def self.encoding(charset)

443

@ic = Iconv.new('UTF-8', charset)

443

@ic = Iconv.new('UTF-8', charset)

444

rescue Iconv::InvalidEncoding

444

rescue Iconv::InvalidEncoding

445

return false

445

return false

446

end

446

end

447

448

def self.establish_connection(params)

448

def self.establish_connection(params)

449

constants.each do |const|

449

constants.each do |const|

450

klass = const_get(const)

450

klass = const_get(const)

451

next unless klass.respond_to? 'establish_connection'

451

next unless klass.respond_to? 'establish_connection'

452

klass.establish_connection params

452

klass.establish_connection params

453

end

453

end

454

end

454

end

455

456

def self.encode(text)

456

def self.encode(text)

457

@ic.iconv text

457

@ic.iconv text

458

rescue

458

rescue

459

text

459

text

460

end

460

end

461

end

461

end

462

463

puts

463

puts

464

if Redmine::DefaultData::Loader.no_data?

464

if Redmine::DefaultData::Loader.no_data?

465

puts "Redmine configuration need to be loaded before importing data."

465

puts "Redmine configuration need to be loaded before importing data."

466

puts "Please, run this first:"

466

puts "Please, run this first:"

467

puts

467

puts

468

puts " rake redmine:load_default_data RAILS_ENV=\"#{ENV['RAILS_ENV']}\""

468

puts " rake redmine:load_default_data RAILS_ENV=\"#{ENV['RAILS_ENV']}\""

469

exit

469

exit

470

end

470

end

471

472

puts "WARNING: Your Redmine data will be deleted during this process."

472

puts "WARNING: Your Redmine data will be deleted during this process."

473

print "Are you sure you want to continue ? [y/N] "

473

print "Are you sure you want to continue ? [y/N] "

474

STDOUT.flush

474

STDOUT.flush

475

break unless STDIN.gets.match(/^y$/i)

475

break unless STDIN.gets.match(/^y$/i)

476

477

# Default Mantis database settings

477

# Default Mantis database settings

478

db_params = {:adapter => 'mysql2',

478

db_params = {:adapter => 'mysql2',

479

:database => 'bugtracker',

479

:database => 'bugtracker',

480

:host => 'localhost',

480

:host => 'localhost',

481

:username => 'root',

481

:username => 'root',

482

:password => '' }

482

:password => '' }

483

484

puts

484

puts

485

puts "Please enter settings for your Mantis database"

485

puts "Please enter settings for your Mantis database"

486

[:adapter, :host, :database, :username, :password].each do |param|

486

[:adapter, :host, :database, :username, :password].each do |param|

487

print "#{param} [#{db_params[param]}]: "

487

print "#{param} [#{db_params[param]}]: "

488

value = STDIN.gets.chomp!

488

value = STDIN.gets.chomp!

489

db_params[param] = value unless value.blank?

489

db_params[param] = value unless value.blank?

490

end

490

end

491

492

while true

492

while true

493

print "encoding [UTF-8]: "

493

print "encoding [UTF-8]: "

494

STDOUT.flush

494

STDOUT.flush

495

encoding = STDIN.gets.chomp!

495

encoding = STDIN.gets.chomp!

496

encoding = 'UTF-8' if encoding.blank?

496

encoding = 'UTF-8' if encoding.blank?

497

break if MantisMigrate.encoding encoding

497

break if MantisMigrate.encoding encoding

498

puts "Invalid encoding!"

498

puts "Invalid encoding!"

499

end

499

end

500

puts

500

puts

501

502

# Make sure bugs can refer bugs in other projects

502

# Make sure bugs can refer bugs in other projects

503

Setting.cross_project_issue_relations = 1 if Setting.respond_to? 'cross_project_issue_relations'

503

Setting.cross_project_issue_relations = 1 if Setting.respond_to? 'cross_project_issue_relations'

504

505

# Turn off email notifications

505

# Turn off email notifications

506

Setting.notified_events = []

506

Setting.notified_events = []

507

508

MantisMigrate.establish_connection db_params

508

MantisMigrate.establish_connection db_params

509

MantisMigrate.migrate

509

MantisMigrate.migrate

510

end

510

end

511

end

511

end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

             # Redmine - project management software
             # Copyright (C) 2006-2012  Jean-Philippe Lang
             #
             # This program is free software; you can redistribute it and/or
             # modify it under the terms of the GNU General Public License
             # as published by the Free Software Foundation; either version 2
             # of the License, or (at your option) any later version.
             #
             # This program is distributed in the hope that it will be useful,
             # but WITHOUT ANY WARRANTY; without even the implied warranty of
             # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
             # GNU General Public License for more details.
             #
             # You should have received a copy of the GNU General Public License
             # along with this program; if not, write to the Free Software
             # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
             desc 'Mantis migration script'
             require 'active_record'
             require 'iconv'
             require 'pp'
             namespace :redmine do
             task :migrate_from_mantis => :environment do
               module MantisMigrate
                   DEFAULT_STATUS = IssueStatus.default
                   assigned_status = IssueStatus.find_by_position(2)
                   resolved_status = IssueStatus.find_by_position(3)
                   feedback_status = IssueStatus.find_by_position(4)
                   closed_status = IssueStatus.find :first, :conditions => { :is_closed => true }
                   STATUS_MAPPING = {10 => DEFAULT_STATUS,  # new
 => feedback_status, # feedback
 => DEFAULT_STATUS,  # acknowledged
 => DEFAULT_STATUS,  # confirmed
 => assigned_status, # assigned
 => resolved_status, # resolved
 => closed_status    # closed
                                     }
                   priorities = IssuePriority.all
                   DEFAULT_PRIORITY = priorities[2]
                   PRIORITY_MAPPING = {10 => priorities[1], # none
 => priorities[1], # low
 => priorities[2], # normal
 => priorities[3], # high
 => priorities[4], # urgent
 => priorities[5]  # immediate
                                       }
                   TRACKER_BUG = Tracker.find_by_position(1)
                   TRACKER_FEATURE = Tracker.find_by_position(2)
                   roles = Role.find(:all, :conditions => {:builtin => 0}, :order => 'position ASC')
                   manager_role = roles[0]
                   developer_role = roles[1]
                   DEFAULT_ROLE = roles.last
                   ROLE_MAPPING = {10 => DEFAULT_ROLE,   # viewer
 => DEFAULT_ROLE,   # reporter
 => DEFAULT_ROLE,   # updater
 => developer_role, # developer
 => manager_role,   # manager
 => manager_role    # administrator
                                   }
                   CUSTOM_FIELD_TYPE_MAPPING = {0 => 'string', # String
 => 'int',    # Numeric
 => 'int',    # Float
 => 'list',   # Enumeration
 => 'string', # Email
 => 'bool',   # Checkbox
 => 'list',   # List
 => 'list',   # Multiselection list
 => 'date',   # Date
                                                }
                   RELATION_TYPE_MAPPING = {1 => IssueRelation::TYPE_RELATES,    # related to
 => IssueRelation::TYPE_RELATES,    # parent of
 => IssueRelation::TYPE_RELATES,    # child of
 => IssueRelation::TYPE_DUPLICATES, # duplicate of
 => IssueRelation::TYPE_DUPLICATES  # has duplicate
                                            }
                 class MantisUser < ActiveRecord::Base
                   self.table_name = :mantis_user_table
                   def firstname
                     @firstname = realname.blank? ? username : realname.split.first[0..29]
                     @firstname
                   end
                   def lastname
                     @lastname = realname.blank? ? '-' : realname.split[1..-1].join(' ')[0..29]
                     @lastname = '-' if @lastname.blank?
                     @lastname
                   end
                   def email
                     if read_attribute(:email).match(/^([^@\s]+)@((?:[-a-z0-9]+\.)+[a-z]{2,})$/i) &&
                          !User.find_by_mail(read_attribute(:email))
                       @email = read_attribute(:email)
                     else
                       @email = "#{username}@foo.bar"
                     end
                   end
                   def username
                     read_attribute(:username)[0..29].gsub(/[^a-zA-Z0-9_\-@\.]/, '-')
                   end
                 end
                 class MantisProject < ActiveRecord::Base
                   self.table_name = :mantis_project_table
                   has_many :versions, :class_name => "MantisVersion", :foreign_key => :project_id
                   has_many :categories, :class_name => "MantisCategory", :foreign_key => :project_id
                   has_many :news, :class_name => "MantisNews", :foreign_key => :project_id
                   has_many :members, :class_name => "MantisProjectUser", :foreign_key => :project_id
                   def identifier
                     read_attribute(:name).gsub(/[^a-z0-9\-]+/, '-').slice(0, Project::IDENTIFIER_MAX_LENGTH)
                   end
                 end
                 class MantisVersion < ActiveRecord::Base
                   self.table_name = :mantis_project_version_table
                   def version
                     read_attribute(:version)[0..29]
                   end
                   def description
                     read_attribute(:description)[0..254]
                   end
                 end
                 class MantisCategory < ActiveRecord::Base
                   self.table_name = :mantis_project_category_table
                 end
                 class MantisProjectUser < ActiveRecord::Base
                   self.table_name = :mantis_project_user_list_table
                 end
                 class MantisBug < ActiveRecord::Base
                   self.table_name = :mantis_bug_table
                   belongs_to :bug_text, :class_name => "MantisBugText", :foreign_key => :bug_text_id
                   has_many :bug_notes, :class_name => "MantisBugNote", :foreign_key => :bug_id
                   has_many :bug_files, :class_name => "MantisBugFile", :foreign_key => :bug_id
                   has_many :bug_monitors, :class_name => "MantisBugMonitor", :foreign_key => :bug_id
                 end
                 class MantisBugText < ActiveRecord::Base
                   self.table_name = :mantis_bug_text_table
                   # Adds Mantis steps_to_reproduce and additional_information fields
                   # to description if any
                   def full_description
                     full_description = description
                     full_description += "\n\n*Steps to reproduce:*\n\n#{steps_to_reproduce}" unless steps_to_reproduce.blank?
                     full_description += "\n\n*Additional information:*\n\n#{additional_information}" unless additional_information.blank?
                     full_description
                   end
                 end
                 class MantisBugNote < ActiveRecord::Base
                   self.table_name = :mantis_bugnote_table
                   belongs_to :bug, :class_name => "MantisBug", :foreign_key => :bug_id
                   belongs_to :bug_note_text, :class_name => "MantisBugNoteText", :foreign_key => :bugnote_text_id
                 end
                 class MantisBugNoteText < ActiveRecord::Base
                   self.table_name = :mantis_bugnote_text_table
                 end
                 class MantisBugFile < ActiveRecord::Base
                   self.table_name = :mantis_bug_file_table
                   def size
                     filesize
                   end
                   def original_filename
                     MantisMigrate.encode(filename)
                   end
                   def content_type
                     file_type
                   end
                   def read(*args)
-                  	if @read_finished
+                      if @read_finished
-                  		nil
+                          nil
-                  	else
+                      else
-                  		@read_finished = true
+                          @read_finished = true
-                  		content
+                          content
-                  	end
+                      end
                   end
                 end
                 class MantisBugRelationship < ActiveRecord::Base
                   self.table_name = :mantis_bug_relationship_table
                 end
                 class MantisBugMonitor < ActiveRecord::Base
                   self.table_name = :mantis_bug_monitor_table
                 end
                 class MantisNews < ActiveRecord::Base
                   self.table_name = :mantis_news_table
                 end
                 class MantisCustomField < ActiveRecord::Base
                   self.table_name = :mantis_custom_field_table
                   set_inheritance_column :none
                   has_many :values, :class_name => "MantisCustomFieldString", :foreign_key => :field_id
                   has_many :projects, :class_name => "MantisCustomFieldProject", :foreign_key => :field_id
                   def format
                     read_attribute :type
                   end
                   def name
                     read_attribute(:name)[0..29]
                   end
                 end
                 class MantisCustomFieldProject < ActiveRecord::Base
                   self.table_name = :mantis_custom_field_project_table
                 end
                 class MantisCustomFieldString < ActiveRecord::Base
                   self.table_name = :mantis_custom_field_string_table
                 end
                 def self.migrate
                   # Users
                   print "Migrating users"
                   User.delete_all "login <> 'admin'"
                   users_map = {}
                   users_migrated = 0
                   MantisUser.find(:all).each do |user|
-                	u = User.new :firstname => encode(user.firstname),
+                    u = User.new :firstname => encode(user.firstname),
-                				 :lastname => encode(user.lastname),
+                                 :lastname => encode(user.lastname),
-                				 :mail => user.email,
+                                 :mail => user.email,
-                				 :last_login_on => user.last_visit
+                                 :last_login_on => user.last_visit
-                	u.login = user.username
+                    u.login = user.username
-                	u.password = 'mantis'
+                    u.password = 'mantis'
-                	u.status = User::STATUS_LOCKED if user.enabled != 1
+                    u.status = User::STATUS_LOCKED if user.enabled != 1
-                	u.admin = true if user.access_level == 90
+                    u.admin = true if user.access_level == 90
-                	next unless u.save!
+                    next unless u.save!
-                	users_migrated += 1
+                    users_migrated += 1
-                	users_map[user.id] = u.id
+                    users_map[user.id] = u.id
-                	print '.'
+                    print '.'
                   end
                   puts
                   # Projects
                   print "Migrating projects"
                   Project.destroy_all
                   projects_map = {}
                   versions_map = {}
                   categories_map = {}
                   MantisProject.find(:all).each do |project|
-                	p = Project.new :name => encode(project.name),
+                    p = Project.new :name => encode(project.name),
                                     :description => encode(project.description)
-                	p.identifier = project.identifier
+                    p.identifier = project.identifier
-                	next unless p.save
+                    next unless p.save
-                	projects_map[project.id] = p.id
+                    projects_map[project.id] = p.id
-                	p.enabled_module_names = ['issue_tracking', 'news', 'wiki']
+                    p.enabled_module_names = ['issue_tracking', 'news', 'wiki']
                     p.trackers << TRACKER_BUG unless p.trackers.include?(TRACKER_BUG)
                     p.trackers << TRACKER_FEATURE unless p.trackers.include?(TRACKER_FEATURE)
-                	print '.'
+                    print '.'
-                	# Project members
+                    # Project members
-                	project.members.each do |member|
+                    project.members.each do |member|
                       m = Member.new :user => User.find_by_id(users_map[member.user_id]),
-                	                   :roles => [ROLE_MAPPING[member.access_level] || DEFAULT_ROLE]
+                                       :roles => [ROLE_MAPPING[member.access_level] || DEFAULT_ROLE]
-                	  m.project = p
+                      m.project = p
-                	  m.save
+                      m.save
-                	end
+                    end
-                	# Project versions
+                    # Project versions
-                	project.versions.each do |version|
+                    project.versions.each do |version|
                       v = Version.new :name => encode(version.version),
                                       :description => encode(version.description),
                                       :effective_date => (version.date_order ? version.date_order.to_date : nil)
                       v.project = p
                       v.save
                       versions_map[version.id] = v.id
-                	end
+                    end
-                	# Project categories
+                    # Project categories
-                	project.categories.each do |category|
+                    project.categories.each do |category|
                       g = IssueCategory.new :name => category.category[0,30]
                       g.project = p
                       g.save
                       categories_map[category.category] = g.id
-                	end
+                    end
                   end
                   puts
                   # Bugs
                   print "Migrating bugs"
                   Issue.destroy_all
                   issues_map = {}
                   keep_bug_ids = (Issue.count == 0)
                   MantisBug.find_each(:batch_size => 200) do |bug|
                     next unless projects_map[bug.project_id] && users_map[bug.reporter_id]
-                	i = Issue.new :project_id => projects_map[bug.project_id],
+                    i = Issue.new :project_id => projects_map[bug.project_id],
                                   :subject => encode(bug.summary),
                                   :description => encode(bug.bug_text.full_description),
                                   :priority => PRIORITY_MAPPING[bug.priority] || DEFAULT_PRIORITY,
                                   :created_on => bug.date_submitted,
                                   :updated_on => bug.last_updated
-                	i.author = User.find_by_id(users_map[bug.reporter_id])
+                    i.author = User.find_by_id(users_map[bug.reporter_id])
-                	i.category = IssueCategory.find_by_project_id_and_name(i.project_id, bug.category[0,30]) unless bug.category.blank?
+                    i.category = IssueCategory.find_by_project_id_and_name(i.project_id, bug.category[0,30]) unless bug.category.blank?
-                	i.fixed_version = Version.find_by_project_id_and_name(i.project_id, bug.fixed_in_version) unless bug.fixed_in_version.blank?
+                    i.fixed_version = Version.find_by_project_id_and_name(i.project_id, bug.fixed_in_version) unless bug.fixed_in_version.blank?
-                	i.status = STATUS_MAPPING[bug.status] || DEFAULT_STATUS
+                    i.status = STATUS_MAPPING[bug.status] || DEFAULT_STATUS
-                	i.tracker = (bug.severity == 10 ? TRACKER_FEATURE : TRACKER_BUG)
+                    i.tracker = (bug.severity == 10 ? TRACKER_FEATURE : TRACKER_BUG)
-                	i.id = bug.id if keep_bug_ids
+                    i.id = bug.id if keep_bug_ids
-                	next unless i.save
+                    next unless i.save
-                	issues_map[bug.id] = i.id
+                    issues_map[bug.id] = i.id
-                	print '.'
+                    print '.'
-                  STDOUT.flush
+                    STDOUT.flush
                     # Assignee
                     # Redmine checks that the assignee is a project member
                     if (bug.handler_id && users_map[bug.handler_id])
                       i.assigned_to = User.find_by_id(users_map[bug.handler_id])
                       i.save(:validate => false)
                     end
-                	# Bug notes
+                    # Bug notes
-                	bug.bug_notes.each do |note|
+                    bug.bug_notes.each do |note|
-                	  next unless users_map[note.reporter_id]
+                      next unless users_map[note.reporter_id]
                       n = Journal.new :notes => encode(note.bug_note_text.note),
                                       :created_on => note.date_submitted
                       n.user = User.find_by_id(users_map[note.reporter_id])
                       n.journalized = i
                       n.save
-                	end
+                    end
                     # Bug files
                     bug.bug_files.each do |file|
                       a = Attachment.new :created_on => file.date_added
                       a.file = file
                       a.author = User.find :first
                       a.container = i
                       a.save
                     end
                     # Bug monitors
                     bug.bug_monitors.each do |monitor|
                       next unless users_map[monitor.user_id]
                       i.add_watcher(User.find_by_id(users_map[monitor.user_id]))
                     end
                   end
                   # update issue id sequence if needed (postgresql)
                   Issue.connection.reset_pk_sequence!(Issue.table_name) if Issue.connection.respond_to?('reset_pk_sequence!')
                   puts
                   # Bug relationships
                   print "Migrating bug relations"
                   MantisBugRelationship.find(:all).each do |relation|
                     next unless issues_map[relation.source_bug_id] && issues_map[relation.destination_bug_id]
                     r = IssueRelation.new :relation_type => RELATION_TYPE_MAPPING[relation.relationship_type]
                     r.issue_from = Issue.find_by_id(issues_map[relation.source_bug_id])
                     r.issue_to = Issue.find_by_id(issues_map[relation.destination_bug_id])
                     pp r unless r.save
                     print '.'
                     STDOUT.flush
                   end
                   puts
                   # News
                   print "Migrating news"
                   News.destroy_all
                   MantisNews.find(:all, :conditions => 'project_id > 0').each do |news|
                     next unless projects_map[news.project_id]
                     n = News.new :project_id => projects_map[news.project_id],
                                  :title => encode(news.headline[0..59]),
                                  :description => encode(news.body),
                                  :created_on => news.date_posted
                     n.author = User.find_by_id(users_map[news.poster_id])
                     n.save
                     print '.'
                     STDOUT.flush
                   end
                   puts
                   # Custom fields
                   print "Migrating custom fields"
                   IssueCustomField.destroy_all
                   MantisCustomField.find(:all).each do |field|
                     f = IssueCustomField.new :name => field.name[0..29],
                                              :field_format => CUSTOM_FIELD_TYPE_MAPPING[field.format],
                                              :min_length => field.length_min,
                                              :max_length => field.length_max,
                                              :regexp => field.valid_regexp,
                                              :possible_values => field.possible_values.split('|'),
                                              :is_required => field.require_report?
                     next unless f.save
                     print '.'
                     STDOUT.flush
                     # Trackers association
                     f.trackers = Tracker.find :all
                     # Projects association
                     field.projects.each do |project|
                       f.projects << Project.find_by_id(projects_map[project.project_id]) if projects_map[project.project_id]
                     end
                     # Values
                     field.values.each do |value|
                       v = CustomValue.new :custom_field_id => f.id,
                                           :value => value.value
                       v.customized = Issue.find_by_id(issues_map[value.bug_id]) if issues_map[value.bug_id]
                       v.save
                     end unless f.new_record?
                   end
                   puts
                   puts
                   puts "Users:           #{users_migrated}/#{MantisUser.count}"
                   puts "Projects:        #{Project.count}/#{MantisProject.count}"
                   puts "Memberships:     #{Member.count}/#{MantisProjectUser.count}"
                   puts "Versions:        #{Version.count}/#{MantisVersion.count}"
                   puts "Categories:      #{IssueCategory.count}/#{MantisCategory.count}"
                   puts "Bugs:            #{Issue.count}/#{MantisBug.count}"
                   puts "Bug notes:       #{Journal.count}/#{MantisBugNote.count}"
                   puts "Bug files:       #{Attachment.count}/#{MantisBugFile.count}"
                   puts "Bug relations:   #{IssueRelation.count}/#{MantisBugRelationship.count}"
                   puts "Bug monitors:    #{Watcher.count}/#{MantisBugMonitor.count}"
                   puts "News:            #{News.count}/#{MantisNews.count}"
                   puts "Custom fields:   #{IssueCustomField.count}/#{MantisCustomField.count}"
                 end
                 def self.encoding(charset)
                   @ic = Iconv.new('UTF-8', charset)
                 rescue Iconv::InvalidEncoding
                   return false
                 end
                 def self.establish_connection(params)
                   constants.each do |const|
                     klass = const_get(const)
                     next unless klass.respond_to? 'establish_connection'
                     klass.establish_connection params
                   end
                 end
                 def self.encode(text)
                   @ic.iconv text
                 rescue
                   text
                 end
               end
               puts
               if Redmine::DefaultData::Loader.no_data?
                 puts "Redmine configuration need to be loaded before importing data."
                 puts "Please, run this first:"
                 puts
                 puts "  rake redmine:load_default_data RAILS_ENV=\"#{ENV['RAILS_ENV']}\""
                 exit
               end
               puts "WARNING: Your Redmine data will be deleted during this process."
               print "Are you sure you want to continue ? [y/N] "
               STDOUT.flush
               break unless STDIN.gets.match(/^y$/i)
               # Default Mantis database settings
               db_params = {:adapter => 'mysql2',
                            :database => 'bugtracker',
                            :host => 'localhost',
                            :username => 'root',
                            :password => '' }
               puts
               puts "Please enter settings for your Mantis database"
               [:adapter, :host, :database, :username, :password].each do |param|
                 print "#{param} [#{db_params[param]}]: "
                 value = STDIN.gets.chomp!
                 db_params[param] = value unless value.blank?
               end
               while true
                 print "encoding [UTF-8]: "
                 STDOUT.flush
                 encoding = STDIN.gets.chomp!
                 encoding = 'UTF-8' if encoding.blank?
                 break if MantisMigrate.encoding encoding
                 puts "Invalid encoding!"
               end
               puts
               # Make sure bugs can refer bugs in other projects
               Setting.cross_project_issue_relations = 1 if Setting.respond_to? 'cross_project_issue_relations'
               # Turn off email notifications
               Setting.notified_events = []
               MantisMigrate.establish_connection db_params
               MantisMigrate.migrate
             end
             end