{"id":1777,"date":"2018-07-26T16:59:15","date_gmt":"2018-07-26T20:59:15","guid":{"rendered":"https:\/\/www.collectionsmax.com\/index.php\/docs\/collections-max-update-utility\/update-mapping-utility-basic"},"modified":"2019-03-11T16:08:26","modified_gmt":"2019-03-11T20:08:26","slug":"update-mapping-utility-basic","status":"publish","type":"docs","link":"https:\/\/www.collectionsmax.com\/index.php\/docs\/collections-max-update-utility\/update-mapping-utility-basic","title":{"rendered":"Update Mapping Utility &#8211; Basic"},"content":{"rendered":"<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1782\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/new1.png\" alt=\"\" width=\"1018\" height=\"791\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/new1.png 1018w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/new1-300x233.png 300w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/new1-768x597.png 768w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/new1-600x466.png 600w\" sizes=\"(max-width: 1018px) 100vw, 1018px\" \/><\/p>\n<p>The Update Mapping Utility is the first tool you use in the update process.\u00a0 This tool creates a csv file that gets loaded into the Update Utility in a format that Collections MAX can understand.\u00a0 It is similar to the Import Mapping Utility found in Collections MAX Administrator however you DO NOT NEED to map everything like in the Administrator.\u00a0 You only need to map the fields that you are updating &#8230;.. plus the account number.<\/p>\n<p>Updating debtor accounts requires a two step process.\u00a0 You need to make sure that the accounts are already in the Collections MAX database.\u00a0 Then the CSV file needs to at least have the debtor&#8217;s account number and any other information you need in it.\u00a0 Then you would load that csv file in the update mapping utility, select only the fields that you want to update plus the account number and export (save) a new file at the end to be used in the Update Utility.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1784\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-open.png\" alt=\"\" width=\"174\" height=\"39\" \/><\/p>\n<p>Clicking this button will allow you to select your csv file that has the information you want to update.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1785\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-refresh.png\" alt=\"\" width=\"133\" height=\"37\" \/><\/p>\n<p>Clicking this button will reset all the settings on the entire page.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1787\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-dropdown.png\" alt=\"\" width=\"127\" height=\"32\" \/><\/p>\n<p>The drop down boxes are used in the program to select the column that corresponds to the correct field name next to it. These boxes will populate with the column names AFTER the CSV file is loaded. DO NOT IMPORT is the default setting. It means that the column will not be imported to create the mapping file. To change the selected column setting you simply click on the drop down box next to the correct field and select the column name.<\/p>\n<p>It is IMPORTANT to only map the fields that you need to update (and the account number)\u00a0 INSTEAD of mapping ALL the fields like the Import Mapping Utility in Collections MAX Administrator.\u00a0 This is because the Update Utility will create a query for each field that needs updating.\u00a0 So for an example: updating 10 fields X 1000 accounts equals 10,000 update queries.\u00a0 If you chose to update all fields you would be looking at more than 100,000 queries which would take a very long time to complete.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1789\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-tabbed.png\" alt=\"\" width=\"530\" height=\"21\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-tabbed.png 530w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-tabbed-300x12.png 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/p>\n<p>The tabbed interface allows you to select different categories of fields that correspond to your csv file so you can map the proper fields.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1790\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-progressbar.png\" alt=\"\" width=\"799\" height=\"23\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-progressbar.png 799w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-progressbar-300x9.png 300w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-progressbar-768x22.png 768w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-progressbar-600x17.png 600w\" sizes=\"(max-width: 799px) 100vw, 799px\" \/><\/p>\n<p>The progress bar will populate during certain activities.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1791\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-datagrid.png\" alt=\"\" width=\"802\" height=\"175\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-datagrid.png 802w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-datagrid-300x65.png 300w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-datagrid-768x168.png 768w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/07\/New1-datagrid-600x131.png 600w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/p>\n<p>The data grid is where you see your csv file account information. The screen will populate once a csv file has been loaded.<\/p>\n","protected":false},"featured_media":0,"parent":1659,"menu_order":7,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/1777"}],"collection":[{"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/comments?post=1777"}],"version-history":[{"count":0,"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/1777\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/1659"}],"next":[{"title":"Update Mapping Utility - File Loaded","link":"https:\/\/www.collectionsmax.com\/index.php\/docs\/collections-max-update-utility\/update-mapping-utility-file-loaded","href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/1793"}],"prev":[{"title":"Top Menu","link":"https:\/\/www.collectionsmax.com\/index.php\/docs\/collections-max-update-utility\/top-menu","href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/1709"}],"wp:attachment":[{"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/media?parent=1777"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/doc_tag?post=1777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}