{"id":2390,"date":"2019-03-04T11:58:42","date_gmt":"2019-03-04T16:58:42","guid":{"rendered":"https:\/\/www.collectionsmax.com\/index.php\/docs\/collections-max-update-utility\/update-utility-top-menu"},"modified":"2019-03-04T15:41:14","modified_gmt":"2019-03-04T20:41:14","slug":"update-utility-top-menu","status":"publish","type":"docs","link":"https:\/\/www.collectionsmax.com\/index.php\/docs\/collections-max-update-utility\/update-utility-top-menu","title":{"rendered":"Update Utility &#8211; Top Menu"},"content":{"rendered":"<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-2391 size-full\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/updateutilitytopmenu.jpg\" alt=\"\" width=\"1016\" height=\"782\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/updateutilitytopmenu.jpg 1016w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/updateutilitytopmenu-300x231.jpg 300w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/updateutilitytopmenu-768x591.jpg 768w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/updateutilitytopmenu-600x462.jpg 600w\" sizes=\"(max-width: 1016px) 100vw, 1016px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>After you have loaded your csv file the top menu will populate.\u00a0 Here are the functions for them.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-2394\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/dividegrid.jpg\" alt=\"\" width=\"167\" height=\"204\" \/><\/p>\n<p>The Divide Grid menu will show you the columns that correspond with the tab pages to make it easier for navigating.\u00a0 When you select an option on this menu (like Page 1 for example) you will only see the column names for Page1&#8230;etc.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-2396\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/format2-300x115.jpg\" alt=\"\" width=\"300\" height=\"115\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/format2-300x115.jpg 300w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/format2.jpg 301w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>The format menu allows you to split names from full names.\u00a0 So if you only have the full name the first, middle and last names can be populated by these functions.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-2398\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/savegrid.jpg\" alt=\"\" width=\"181\" height=\"47\" \/><\/p>\n<p>The save grid to excel function will allow you to save the current datagrid into an excel spreadsheet for manual editing.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-2399 size-full\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/columnssocialsecuritynumbers.jpg\" alt=\"\" width=\"735\" height=\"64\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/columnssocialsecuritynumbers.jpg 735w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/columnssocialsecuritynumbers-300x26.jpg 300w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/columnssocialsecuritynumbers-600x52.jpg 600w\" sizes=\"(max-width: 735px) 100vw, 735px\" \/><\/p>\n<p>The run social security number test will format social security numbers and indicate any isues with them.<\/p>\n<p>The mark all invalid social security numbers as &#8216;000-00-0000&#8217; function will change the social security numbers to 000-00-0000 (our default value) if the numbers are missing characters or if the numbers are invalid.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-2401 size-full\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/columnsdates.jpg\" alt=\"\" width=\"557\" height=\"69\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/columnsdates.jpg 557w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/columnsdates-300x37.jpg 300w\" sizes=\"(max-width: 557px) 100vw, 557px\" \/><\/p>\n<p>The check for invalid dates function will highlight any invalid dates in your file.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-2402 size-full\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/functions.jpg\" alt=\"\" width=\"485\" height=\"157\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/functions.jpg 485w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/functions-300x97.jpg 300w\" sizes=\"(max-width: 485px) 100vw, 485px\" \/><\/p>\n<p>The calculate accrued interest functions will allow you to calculate accrued interest as long as certain fields are present.<\/p>\n<p>For instance&#8230;..calculate accrued interest from chargeoff date (using current balance) will at least require the chargeoff date and the current balance being loaded in the same file.<\/p>\n<p>Remove apostrophes will remove any apostrohes encountered in the file that could prevent the system from updating.<\/p>\n<p>Get accrued interest by subtracting currentbalance from principal will get the accrued interest as long as the current balance and principal are loaded in the same file.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-2405 size-full\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2019\/03\/open.jpg\" alt=\"\" width=\"191\" height=\"48\" \/><\/p>\n<p>The open CSV Data file function is the same as the Open CSV Data File button.\u00a0 It allows you to load your data file that was exported from the update mapping utility.<\/p>\n","protected":false},"featured_media":0,"parent":1659,"menu_order":15,"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\/2390"}],"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=2390"}],"version-history":[{"count":0,"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/2390\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/1659"}],"next":[{"title":"Documents and Skip Info Utility","link":"https:\/\/www.collectionsmax.com\/index.php\/docs\/collections-max-update-utility\/documents-and-skip-info-utility","href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/2446"}],"prev":[{"title":"Update Utility - Overview","link":"https:\/\/www.collectionsmax.com\/index.php\/docs\/collections-max-update-utility\/update-utility-overview","href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/2338"}],"wp:attachment":[{"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/media?parent=2390"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/doc_tag?post=2390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}