{"action":"created","comment":{"url":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/comments/42118669","id":42118669,"diff_hunk":"@@ -0,0 +1,200 @@\n+<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n+<job xmlns=\"http://eobjects.org/analyzerbeans/job/1.0\">\n+\t<job-metadata>\n+\t\t<job-description>Example job that cleanses the names, phone in the\n+\t\t\tdatabase\n+\t\t</job-description>\n+\t\t<metadata-properties>\n+\t\t\t<property name=\"CoordinatesY.PUBLIC.CUSTOMERS\">93</property>\n+\t\t\t<property name=\"CoordinatesX.PUBLIC.CUSTOMERS\">62</property>\n+\t\t\t<property name=\"DemoJob\">true</property>\n+\t\t</metadata-properties>\n+\t</job-metadata>\n+\t<source>\n+\t\t<data-context ref=\"orderdb\" />\n+\t\t<columns>\n+\t\t\t<column id=\"col_customernumber\" path=\"CUSTOMERS.CUSTOMERNUMBER\"\n+\t\t\t\ttype=\"INTEGER\" />\n+\t\t\t<column id=\"col_customername\" path=\"CUSTOMERS.CUSTOMERNAME\"\n+\t\t\t\ttype=\"VARCHAR\" />\n+\t\t\t<column id=\"col_contactlastname\" path=\"CUSTOMERS.CONTACTLASTNAME\"\n+\t\t\t\ttype=\"VARCHAR\" />\n+\t\t\t<column id=\"col_contactfirstname\" path=\"CUSTOMERS.CONTACTFIRSTNAME\"\n+\t\t\t\ttype=\"VARCHAR\" />\n+\t\t\t<column id=\"col_phone\" path=\"CUSTOMERS.PHONE\" type=\"VARCHAR\" />\n+\t\t\t<column id=\"col_addressline1\" path=\"CUSTOMERS.ADDRESSLINE1\"\n+\t\t\t\ttype=\"VARCHAR\" />\n+\t\t\t<column id=\"col_addressline2\" path=\"CUSTOMERS.ADDRESSLINE2\"\n+\t\t\t\ttype=\"VARCHAR\" />\n+\t\t\t<column id=\"col_city\" path=\"CUSTOMERS.CITY\" type=\"VARCHAR\" />\n+\t\t\t<column id=\"col_state\" path=\"CUSTOMERS.STATE\" type=\"VARCHAR\" />\n+\t\t\t<column id=\"col_postalcode\" path=\"CUSTOMERS.POSTALCODE\" type=\"VARCHAR\" />\n+\t\t\t<column id=\"col_country\" path=\"CUSTOMERS.COUNTRY\" type=\"VARCHAR\" />\n+\t\t\t<column id=\"col_salesrepemployeenumber\" path=\"CUSTOMERS.SALESREPEMPLOYEENUMBER\"\n+\t\t\t\ttype=\"INTEGER\" />\n+\t\t\t<column id=\"col_creditlimit\" path=\"CUSTOMERS.CREDITLIMIT\"\n+\t\t\t\ttype=\"NUMERIC\" />\n+\t\t\t<column id=\"col_jobtitle\" path=\"CUSTOMERS.JOBTITLE\" type=\"VARCHAR\" />\n+\t\t</columns>\n+\t</source>\n+\t<transformation>\n+\t\t<transformer>\n+\t\t\t<descriptor ref=\"Name Correction\" />\n+\t\t\t<metadata-properties>\n+\t\t\t\t<property name=\"CoordinatesY\">87</property>\n+\t\t\t\t<property name=\"CoordinatesX\">236</property>\n+\t\t\t</metadata-properties>\n+\t\t\t<properties>\n+\t\t\t\t<property name=\"Connection\" value=\"named:demo\" />","path":"desktop/ui/src/main/resources/datacleaner-home/jobs/OrderDB Name and Phone Cleansing.analysis.xml","position":48,"original_position":48,"commit_id":"0d3dcd1aa8cbc6e9df4a220d72efac77a1612060","original_commit_id":"0d3dcd1aa8cbc6e9df4a220d72efac77a1612060","user":{"login":"kaspersorensen","id":291450,"avatar_url":"https://avatars.githubusercontent.com/u/291450?v=3","gravatar_id":"","url":"https://api.github.com/users/kaspersorensen","html_url":"https://github.com/kaspersorensen","followers_url":"https://api.github.com/users/kaspersorensen/followers","following_url":"https://api.github.com/users/kaspersorensen/following{/other_user}","gists_url":"https://api.github.com/users/kaspersorensen/gists{/gist_id}","starred_url":"https://api.github.com/users/kaspersorensen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kaspersorensen/subscriptions","organizations_url":"https://api.github.com/users/kaspersorensen/orgs","repos_url":"https://api.github.com/users/kaspersorensen/repos","events_url":"https://api.github.com/users/kaspersorensen/events{/privacy}","received_events_url":"https://api.github.com/users/kaspersorensen/received_events","type":"User","site_admin":false},"body":"Check the common-datacleaner project. I think it's just \"demo\" but I cannot recall. It must be in the Converter class that handles ConnectionInformation conversion","created_at":"2015-10-15T12:43:07Z","updated_at":"2015-10-15T12:43:07Z","html_url":"https://github.com/datacleaner/DataCleaner/pull/807#discussion_r42118669","pull_request_url":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/807","_links":{"self":{"href":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/comments/42118669"},"html":{"href":"https://github.com/datacleaner/DataCleaner/pull/807#discussion_r42118669"},"pull_request":{"href":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/807"}}},"pull_request":{"url":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/807","id":47777752,"html_url":"https://github.com/datacleaner/DataCleaner/pull/807","diff_url":"https://github.com/datacleaner/DataCleaner/pull/807.diff","patch_url":"https://github.com/datacleaner/DataCleaner/pull/807.patch","issue_url":"https://api.github.com/repos/datacleaner/DataCleaner/issues/807","number":807,"state":"open","locked":false,"title":"Feature/387 cleansing job street","user":{"login":"ClaudiaPHI","id":6339923,"avatar_url":"https://avatars.githubusercontent.com/u/6339923?v=3","gravatar_id":"","url":"https://api.github.com/users/ClaudiaPHI","html_url":"https://github.com/ClaudiaPHI","followers_url":"https://api.github.com/users/ClaudiaPHI/followers","following_url":"https://api.github.com/users/ClaudiaPHI/following{/other_user}","gists_url":"https://api.github.com/users/ClaudiaPHI/gists{/gist_id}","starred_url":"https://api.github.com/users/ClaudiaPHI/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ClaudiaPHI/subscriptions","organizations_url":"https://api.github.com/users/ClaudiaPHI/orgs","repos_url":"https://api.github.com/users/ClaudiaPHI/repos","events_url":"https://api.github.com/users/ClaudiaPHI/events{/privacy}","received_events_url":"https://api.github.com/users/ClaudiaPHI/received_events","type":"User","site_admin":false},"body":"Fixes #387 \r\n\r\nI added 2 jobs.  \r\n\r\n-  \"Customer Age Filtering.analysis.xml\"  for Community users \r\n- \"OrderDB Name and Phone Cleansing.analysis.xml\" for Professional users","created_at":"2015-10-15T12:10:25Z","updated_at":"2015-10-15T12:43:07Z","closed_at":null,"merged_at":null,"merge_commit_sha":"2b2d347c1d32fba3b84c9facc878c218b6f4ba7e","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/807/commits","review_comments_url":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/807/comments","review_comment_url":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/comments{/number}","comments_url":"https://api.github.com/repos/datacleaner/DataCleaner/issues/807/comments","statuses_url":"https://api.github.com/repos/datacleaner/DataCleaner/statuses/0d3dcd1aa8cbc6e9df4a220d72efac77a1612060","head":{"label":"datacleaner:feature/387-cleansing-job-street","ref":"feature/387-cleansing-job-street","sha":"0d3dcd1aa8cbc6e9df4a220d72efac77a1612060","user":{"login":"datacleaner","id":1665195,"avatar_url":"https://avatars.githubusercontent.com/u/1665195?v=3","gravatar_id":"","url":"https://api.github.com/users/datacleaner","html_url":"https://github.com/datacleaner","followers_url":"https://api.github.com/users/datacleaner/followers","following_url":"https://api.github.com/users/datacleaner/following{/other_user}","gists_url":"https://api.github.com/users/datacleaner/gists{/gist_id}","starred_url":"https://api.github.com/users/datacleaner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/datacleaner/subscriptions","organizations_url":"https://api.github.com/users/datacleaner/orgs","repos_url":"https://api.github.com/users/datacleaner/repos","events_url":"https://api.github.com/users/datacleaner/events{/privacy}","received_events_url":"https://api.github.com/users/datacleaner/received_events","type":"Organization","site_admin":false},"repo":{"id":17034809,"name":"DataCleaner","full_name":"datacleaner/DataCleaner","owner":{"login":"datacleaner","id":1665195,"avatar_url":"https://avatars.githubusercontent.com/u/1665195?v=3","gravatar_id":"","url":"https://api.github.com/users/datacleaner","html_url":"https://github.com/datacleaner","followers_url":"https://api.github.com/users/datacleaner/followers","following_url":"https://api.github.com/users/datacleaner/following{/other_user}","gists_url":"https://api.github.com/users/datacleaner/gists{/gist_id}","starred_url":"https://api.github.com/users/datacleaner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/datacleaner/subscriptions","organizations_url":"https://api.github.com/users/datacleaner/orgs","repos_url":"https://api.github.com/users/datacleaner/repos","events_url":"https://api.github.com/users/datacleaner/events{/privacy}","received_events_url":"https://api.github.com/users/datacleaner/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/datacleaner/DataCleaner","description":"The premier open source Data Quality solution","fork":false,"url":"https://api.github.com/repos/datacleaner/DataCleaner","forks_url":"https://api.github.com/repos/datacleaner/DataCleaner/forks","keys_url":"https://api.github.com/repos/datacleaner/DataCleaner/keys{/key_id}","collaborators_url":"https://api.github.com/repos/datacleaner/DataCleaner/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/datacleaner/DataCleaner/teams","hooks_url":"https://api.github.com/repos/datacleaner/DataCleaner/hooks","issue_events_url":"https://api.github.com/repos/datacleaner/DataCleaner/issues/events{/number}","events_url":"https://api.github.com/repos/datacleaner/DataCleaner/events","assignees_url":"https://api.github.com/repos/datacleaner/DataCleaner/assignees{/user}","branches_url":"https://api.github.com/repos/datacleaner/DataCleaner/branches{/branch}","tags_url":"https://api.github.com/repos/datacleaner/DataCleaner/tags","blobs_url":"https://api.github.com/repos/datacleaner/DataCleaner/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/datacleaner/DataCleaner/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/datacleaner/DataCleaner/git/refs{/sha}","trees_url":"https://api.github.com/repos/datacleaner/DataCleaner/git/trees{/sha}","statuses_url":"https://api.github.com/repos/datacleaner/DataCleaner/statuses/{sha}","languages_url":"https://api.github.com/repos/datacleaner/DataCleaner/languages","stargazers_url":"https://api.github.com/repos/datacleaner/DataCleaner/stargazers","contributors_url":"https://api.github.com/repos/datacleaner/DataCleaner/contributors","subscribers_url":"https://api.github.com/repos/datacleaner/DataCleaner/subscribers","subscription_url":"https://api.github.com/repos/datacleaner/DataCleaner/subscription","commits_url":"https://api.github.com/repos/datacleaner/DataCleaner/commits{/sha}","git_commits_url":"https://api.github.com/repos/datacleaner/DataCleaner/git/commits{/sha}","comments_url":"https://api.github.com/repos/datacleaner/DataCleaner/comments{/number}","issue_comment_url":"https://api.github.com/repos/datacleaner/DataCleaner/issues/comments{/number}","contents_url":"https://api.github.com/repos/datacleaner/DataCleaner/contents/{+path}","compare_url":"https://api.github.com/repos/datacleaner/DataCleaner/compare/{base}...{head}","merges_url":"https://api.github.com/repos/datacleaner/DataCleaner/merges","archive_url":"https://api.github.com/repos/datacleaner/DataCleaner/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/datacleaner/DataCleaner/downloads","issues_url":"https://api.github.com/repos/datacleaner/DataCleaner/issues{/number}","pulls_url":"https://api.github.com/repos/datacleaner/DataCleaner/pulls{/number}","milestones_url":"https://api.github.com/repos/datacleaner/DataCleaner/milestones{/number}","notifications_url":"https://api.github.com/repos/datacleaner/DataCleaner/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/datacleaner/DataCleaner/labels{/name}","releases_url":"https://api.github.com/repos/datacleaner/DataCleaner/releases{/id}","created_at":"2014-02-20T20:37:25Z","updated_at":"2015-10-12T21:02:02Z","pushed_at":"2015-10-15T12:14:17Z","git_url":"git://github.com/datacleaner/DataCleaner.git","ssh_url":"git@github.com:datacleaner/DataCleaner.git","clone_url":"https://github.com/datacleaner/DataCleaner.git","svn_url":"https://github.com/datacleaner/DataCleaner","homepage":null,"size":178974,"stargazers_count":39,"watchers_count":39,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":25,"mirror_url":null,"open_issues_count":136,"forks":25,"open_issues":136,"watchers":39,"default_branch":"master"}},"base":{"label":"datacleaner:master","ref":"master","sha":"31b74e4ad47b445de93f3f662657531b4ddc4d88","user":{"login":"datacleaner","id":1665195,"avatar_url":"https://avatars.githubusercontent.com/u/1665195?v=3","gravatar_id":"","url":"https://api.github.com/users/datacleaner","html_url":"https://github.com/datacleaner","followers_url":"https://api.github.com/users/datacleaner/followers","following_url":"https://api.github.com/users/datacleaner/following{/other_user}","gists_url":"https://api.github.com/users/datacleaner/gists{/gist_id}","starred_url":"https://api.github.com/users/datacleaner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/datacleaner/subscriptions","organizations_url":"https://api.github.com/users/datacleaner/orgs","repos_url":"https://api.github.com/users/datacleaner/repos","events_url":"https://api.github.com/users/datacleaner/events{/privacy}","received_events_url":"https://api.github.com/users/datacleaner/received_events","type":"Organization","site_admin":false},"repo":{"id":17034809,"name":"DataCleaner","full_name":"datacleaner/DataCleaner","owner":{"login":"datacleaner","id":1665195,"avatar_url":"https://avatars.githubusercontent.com/u/1665195?v=3","gravatar_id":"","url":"https://api.github.com/users/datacleaner","html_url":"https://github.com/datacleaner","followers_url":"https://api.github.com/users/datacleaner/followers","following_url":"https://api.github.com/users/datacleaner/following{/other_user}","gists_url":"https://api.github.com/users/datacleaner/gists{/gist_id}","starred_url":"https://api.github.com/users/datacleaner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/datacleaner/subscriptions","organizations_url":"https://api.github.com/users/datacleaner/orgs","repos_url":"https://api.github.com/users/datacleaner/repos","events_url":"https://api.github.com/users/datacleaner/events{/privacy}","received_events_url":"https://api.github.com/users/datacleaner/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/datacleaner/DataCleaner","description":"The premier open source Data Quality solution","fork":false,"url":"https://api.github.com/repos/datacleaner/DataCleaner","forks_url":"https://api.github.com/repos/datacleaner/DataCleaner/forks","keys_url":"https://api.github.com/repos/datacleaner/DataCleaner/keys{/key_id}","collaborators_url":"https://api.github.com/repos/datacleaner/DataCleaner/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/datacleaner/DataCleaner/teams","hooks_url":"https://api.github.com/repos/datacleaner/DataCleaner/hooks","issue_events_url":"https://api.github.com/repos/datacleaner/DataCleaner/issues/events{/number}","events_url":"https://api.github.com/repos/datacleaner/DataCleaner/events","assignees_url":"https://api.github.com/repos/datacleaner/DataCleaner/assignees{/user}","branches_url":"https://api.github.com/repos/datacleaner/DataCleaner/branches{/branch}","tags_url":"https://api.github.com/repos/datacleaner/DataCleaner/tags","blobs_url":"https://api.github.com/repos/datacleaner/DataCleaner/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/datacleaner/DataCleaner/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/datacleaner/DataCleaner/git/refs{/sha}","trees_url":"https://api.github.com/repos/datacleaner/DataCleaner/git/trees{/sha}","statuses_url":"https://api.github.com/repos/datacleaner/DataCleaner/statuses/{sha}","languages_url":"https://api.github.com/repos/datacleaner/DataCleaner/languages","stargazers_url":"https://api.github.com/repos/datacleaner/DataCleaner/stargazers","contributors_url":"https://api.github.com/repos/datacleaner/DataCleaner/contributors","subscribers_url":"https://api.github.com/repos/datacleaner/DataCleaner/subscribers","subscription_url":"https://api.github.com/repos/datacleaner/DataCleaner/subscription","commits_url":"https://api.github.com/repos/datacleaner/DataCleaner/commits{/sha}","git_commits_url":"https://api.github.com/repos/datacleaner/DataCleaner/git/commits{/sha}","comments_url":"https://api.github.com/repos/datacleaner/DataCleaner/comments{/number}","issue_comment_url":"https://api.github.com/repos/datacleaner/DataCleaner/issues/comments{/number}","contents_url":"https://api.github.com/repos/datacleaner/DataCleaner/contents/{+path}","compare_url":"https://api.github.com/repos/datacleaner/DataCleaner/compare/{base}...{head}","merges_url":"https://api.github.com/repos/datacleaner/DataCleaner/merges","archive_url":"https://api.github.com/repos/datacleaner/DataCleaner/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/datacleaner/DataCleaner/downloads","issues_url":"https://api.github.com/repos/datacleaner/DataCleaner/issues{/number}","pulls_url":"https://api.github.com/repos/datacleaner/DataCleaner/pulls{/number}","milestones_url":"https://api.github.com/repos/datacleaner/DataCleaner/milestones{/number}","notifications_url":"https://api.github.com/repos/datacleaner/DataCleaner/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/datacleaner/DataCleaner/labels{/name}","releases_url":"https://api.github.com/repos/datacleaner/DataCleaner/releases{/id}","created_at":"2014-02-20T20:37:25Z","updated_at":"2015-10-12T21:02:02Z","pushed_at":"2015-10-15T12:14:17Z","git_url":"git://github.com/datacleaner/DataCleaner.git","ssh_url":"git@github.com:datacleaner/DataCleaner.git","clone_url":"https://github.com/datacleaner/DataCleaner.git","svn_url":"https://github.com/datacleaner/DataCleaner","homepage":null,"size":178974,"stargazers_count":39,"watchers_count":39,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":25,"mirror_url":null,"open_issues_count":136,"forks":25,"open_issues":136,"watchers":39,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/807"},"html":{"href":"https://github.com/datacleaner/DataCleaner/pull/807"},"issue":{"href":"https://api.github.com/repos/datacleaner/DataCleaner/issues/807"},"comments":{"href":"https://api.github.com/repos/datacleaner/DataCleaner/issues/807/comments"},"review_comments":{"href":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/807/comments"},"review_comment":{"href":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/datacleaner/DataCleaner/pulls/807/commits"},"statuses":{"href":"https://api.github.com/repos/datacleaner/DataCleaner/statuses/0d3dcd1aa8cbc6e9df4a220d72efac77a1612060"}}}}