Project

General

Profile

RE: email format that works for redmine:email:receive_imap ยป devlopmentlog.txt

Kameron Hott, 2012-08-06 17:13

 
1
Received mail:
2
 Received: from MAILHUB2.domain.org (10.100.90.79) by MAILHUB4.domain.org
3
 (10.100.212.37) with Microsoft SMTP Server (TLS) id 14.2.247.3; Fri, 3 Aug
4
 2012 16:33:11 -0700
5
Received: from CMSWEB1 (10.100.112.108) by mailhub.domain.org (10.100.90.80)
6
 with Microsoft SMTP Server id 14.2.247.3; Fri, 3 Aug 2012 16:33:10 -0700
7
From: <access.domain.org@domain.org>
8
To: <RISHelpDesk@domain.org>
9
Date: Fri, 3 Aug 2012 16:33:10 -0700
10
Subject: Form: Contact Redmine ISHelpDesk
11
Content-Type: text/html; charset="us-ascii"
12
Content-Transfer-Encoding: quoted-printable
13
Message-ID: <8aa9a029-7b0a-46d7-b36f-825155da7a60@MAILHUB2.domain.org>
14
Return-Path: access.domain.org@domain.org
15
X-MS-Exchange-Organization-AuthSource: MAILHUB2.domain.org
16
X-MS-Exchange-Organization-AuthAs: Anonymous
17
MIME-Version: 1.0
18

    
19
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
20
><span style=3D"font-size:12pt"><b>priority:</b> Low<br> <b>Assignee:</b> k=
21
hott3<br> <b>Contact Name:</b> Bill<br> <b>Contact Email:</b> mylogin@yrmc.o=
22
rg<br> <b>Location:</b> WC<br> <b>Department:</b> Information Systems (IS,L=
23
N)<br> <b>Device Name:</b> pisv27<br> <b>Phone Number:</b> 5692<br> <b>Cern=
24
er Solution / Module:</b> Not applicable<br><br> <b>Description:</b> test<b=
25
r> <b>Username of person who had issue?</b>test<br> <b>Application Coach co=
26
ntacted?</b><br> <b>Name of AC/SME?</b><br> <b>Software?</b>Not applicable<=
27
br> <b>Has function worked before?</b><br> <b>Is issue device specific?</b>=
28
<br> <b>Patient Name?</b><br> <b>FIN?</b><br> <b>MRN?</b><br></span>
29

    
30
  ^[[4;36;1mSetting Columns (0.5ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `settings`^[[0m
31
  ^[[4;35;1mSetting Load (0.2ms)^[[0m   ^[[0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'mail_from') LIMIT 1^[[0m
32
  ^[[4;36;1mUser Columns (0.4ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `users`^[[0m
33
  ^[[4;35;1mUser Load (0.4ms)^[[0m   ^[[0mSELECT * FROM `users` WHERE (LOWER(mail) = 'access.domain.org@domain.org') AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) LIMIT 1^[[0m
34
  ^[[4;36;1mAnonymousUser Columns (3.9ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `users`^[[0m
35
  ^[[4;35;1mAnonymousUser Load (0.2ms)^[[0m   ^[[0mSELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1^[[0m
36
  ^[[4;36;1mProject Columns (0.4ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `projects`^[[0m
37
  ^[[4;35;1mProject Load (0.2ms)^[[0m   ^[[0mSELECT * FROM `projects` WHERE (`projects`.`identifier` = 'emailsupport') LIMIT 1^[[0m
38
  ^[[4;36;1mIssue Columns (0.5ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `issues`^[[0m
39
  ^[[4;35;1mProject Load (0.1ms)^[[0m   ^[[0mSELECT * FROM `projects` WHERE (`projects`.`id` = 0) ^[[0m
40
  ^[[4;36;1mIssueStatus Columns (0.3ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `issue_statuses`^[[0m
41
  ^[[4;35;1mIssueStatus Load (0.1ms)^[[0m   ^[[0mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 0) ^[[0m
42
  ^[[4;36;1mIssueStatus Load (0.1ms)^[[0m   ^[[0;1mSELECT * FROM `issue_statuses` WHERE (is_default=1) LIMIT 1^[[0m
43
  ^[[4;35;1mIssuePriority Columns (0.3ms)^[[0m   ^[[0mSHOW FIELDS FROM `enumerations`^[[0m
44
  ^[[4;36;1mIssuePriority Load (0.1ms)^[[0m   ^[[0;1mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 0) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC^[[0m
45
  ^[[4;35;1mIssuePriority Load (0.1ms)^[[0m   ^[[0mSELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position AS$
46
  ^[[4;36;1mWatcher Columns (0.4ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `watchers`^[[0m
47
  ^[[4;35;1mSQL (0.1ms)^[[0m   ^[[0mBEGIN^[[0m
48
  ^[[4;36;1mSQL (0.1ms)^[[0m   ^[[0;1mCOMMIT^[[0m
49
MailHandler: plain_text_body priority: Low Assignee: mylogin Contact Name: Bill Contact Email: mylogin@domain.org Location: WC Department: Information Systems (IS,LN) Device Name: pisv27 Phone Number: 5692 Ce$
50

    
51
  ^[[4;35;1mSetting Load (0.2ms)^[[0m   ^[[0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'default_language') LIMIT 1^[[0m
52
  ^[[4;36;1mProject Load (0.3ms)^[[0m   ^[[0;1mSELECT * FROM `projects` WHERE (`projects`.`id` = 126) ^[[0m
53
  ^[[4;35;1mprojects_trackers Columns (0.3ms)^[[0m   ^[[0mSHOW FIELDS FROM `projects_trackers`^[[0m
54
  ^[[4;36;1mTracker Load (0.2ms)^[[0m   ^[[0;1mSELECT * FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`projects_trackers`.project_id = 126 ) AND ($
55
  ^[[4;35;1mTracker Columns (0.3ms)^[[0m   ^[[0mSHOW FIELDS FROM `trackers`^[[0m
56
  ^[[4;36;1mIssueStatus Load (0.1ms)^[[0m   ^[[0;1mSELECT * FROM `issue_statuses` WHERE (LOWER(issue_statuses.name) = LOWER('New')) LIMIT 1^[[0m
57
  ^[[4;35;1mIssueStatus Load (0.1ms)^[[0m   ^[[0mSELECT * FROM `issue_statuses` WHERE (is_default=1) LIMIT 1^[[0m
58
  ^[[4;36;1mRole Load (0.2ms)^[[0m   ^[[0;1mSELECT * FROM `roles` WHERE (`roles`.`builtin` = 2) LIMIT 1^[[0m
59
  ^[[4;35;1mTracker Load (0.1ms)^[[0m   ^[[0mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 0) ^[[0m
60
  ^[[4;36;1mEnabledModule Load (0.2ms)^[[0m   ^[[0;1mSELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 126) ^[[0m
61
  ^[[4;35;1mEnabledModule Columns (0.3ms)^[[0m   ^[[0mSHOW FIELDS FROM `enabled_modules`^[[0m
62
  ^[[4;36;1mRole Columns (0.3ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `roles`^[[0m
63
  ^[[4;35;1mIssueStatus Load (0.1ms)^[[0m   ^[[0mSELECT * FROM `issue_statuses` WHERE (is_default=1) LIMIT 1^[[0m
64
  ^[[4;36;1mTracker Load (0.1ms)^[[0m   ^[[0;1mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 3) ^[[0m
65
  ^[[4;35;1mWorkflow Load (0.2ms)^[[0m   ^[[0mSELECT * FROM `workflows` WHERE (`workflows`.old_status_id = 1 AND (role_id IN (2) AND tracker_id = 3 AND ((author = 0 AND assignee = 0) OR author = 1))) ^[[0m
66
  ^[[4;36;1mIssueCustomField Columns (0.4ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `custom_fields`^[[0m
67
  ^[[4;35;1mIssueCustomField Load (0.3ms)^[[0m   ^[[0mSELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position^[[0m
68
  ^[[4;36;1mcustom_fields_projects Columns (0.3ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `custom_fields_projects`^[[0m
69
  ^[[4;35;1mIssueCustomField Load (0.2ms)^[[0m   ^[[0mSELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fiel$
70
  ^[[4;36;1mIssueCustomField Load (0.2ms)^[[0m   ^[[0;1mSELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id W$
71
  ^[[4;35;1mCustomValue Columns (0.3ms)^[[0m   ^[[0mSHOW FIELDS FROM `custom_values`^[[0m
72
  ^[[4;36;1mIssueStatus Load (0.1ms)^[[0m   ^[[0;1mSELECT * FROM `issue_statuses` WHERE (is_default=1) LIMIT 1^[[0m
73
  ^[[4;35;1mWorkflow Load (0.2ms)^[[0m   ^[[0mSELECT * FROM `workflows` WHERE (`workflows`.old_status_id = 1 AND (role_id IN (2) AND tracker_id = 3 AND ((author = 0 AND assignee = 0) OR author = 1))) ^[[0m
74
  ^[[4;36;1mSetting Load (0.2ms)^[[0m   ^[[0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'mail_handler_body_delimiters') LIMIT 1^[[0m
75
  ^[[4;35;1mSQL (0.1ms)^[[0m   ^[[0mBEGIN^[[0m
76
  ^[[4;36;1mSetting Load (0.2ms)^[[0m   ^[[0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_done_ratio') LIMIT 1^[[0m
77
  ^[[4;35;1mTracker Load (0.1ms)^[[0m   ^[[0mSELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 3) AND (`project$
78
  ^[[4;36;1mSQL (0.1ms)^[[0m   ^[[0;1mROLLBACK^[[0m
79
Validation failed: Contact Name can't be blank, Location can't be blank, Department can't be blank, Assignee can't be blank
80

    
    (1-1/1)