{"id":9248,"date":"2016-12-17T14:28:54","date_gmt":"2016-12-17T14:28:54","guid":{"rendered":"https:\/\/www.process.st\/templates\/adding-new-state-and-cities\/"},"modified":"2024-02-28T20:50:13","modified_gmt":"2024-02-28T20:50:13","slug":"adding-new-state-and-cities","status":"publish","type":"post","link":"https:\/\/www.process.st\/templates\/adding-new-state-and-cities\/","title":{"rendered":"Adding New State and Cities"},"content":{"rendered":"<section id=\"update-city-template\">\n<h2> Update City Template <\/h2>\n<div class=\"text-content\">\n<p>Bulk create new city pages in each category on the website using the above template.<\/p>\n<h5>1. Use the Replace function to quickly find and replace all filler information.<\/h5>\n<ul>\n<li>City name placeholders exist in the template as &quot;city1&quot; and &quot;City1&quot;<\/li>\n<li>The state name exists as &quot;State&quot; and &quot;state&quot;\n<ul>\n<li><u><em><strong>NOTE<\/strong><\/em><\/u> the capitalization of the two instances of each city and of the state name. Maintain the capitalization for visual formatting by marking 'Match Case' in Excel's replace function.<\/li>\n<\/ul>\n<\/li>\n<\/ul><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/qLzxpAtlXogDBe_9IltC3A.jpg\" alt=\"Update City Template\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/qLzxpAtlXogDBe_9IltC3A.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<h5>2. Delete or create additional city rows as needed.<\/h5>\n<p>Maintain all field data aside from the E and I columns and replace text as needed.<\/p>\n<\/p><\/div>\n<div class=\"text-content\">\n<h5>3. Save all changes in CSV format<\/h5>\n<p>Once you've completed all changes to the template, save the new spreadsheet in CSV format for upload to the website.<\/p>\n<\/p><\/div>\n<\/section>\n<section id=\"upload-new-pages-csv\">\n<h2> Upload New Pages CSV <\/h2>\n<div class=\"text-content\">\n<h5>Login and Go to WP CSV &gt; Import<\/h5>\n<p><a href=\"https:\/\/infosource.vet\/wp-admin\/admin.php?page=wpcsv-import\" rel=\"nofollow\">https:\/\/infosource.vet\/wp-admin\/admin.php?page=wpcsv-import<\/a><\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/mZfqeMtr6IRwrD6kk3lGYQ.png\" alt=\"Upload New Pages CSV\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/mZfqeMtr6IRwrD6kk3lGYQ.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Choose the new <strong>CSV<\/strong> you just saved and click the upload button to begin creating the new city pages.<\/p>\n<\/p><\/div>\n<\/section>\n<section id=\"create-a-new-state-row\">\n<h2> Create a New State Row <\/h2>\n<div class=\"text-content\">\n<h5>1. Open the Main Business Directory Page to Edit<\/h5>\n<p><a href=\"https:\/\/infosource.vet\/wp-admin\/post.php?post=263&amp;action=edit\" rel=\"nofollow\">https:\/\/infosource.vet\/wp-admin\/post.php?post=263&amp;action=edit<\/a><\/p>\n<h5>2. Add a Blank State&nbsp;Row<\/h5>\n<p>See below&nbsp;image to quickly insert a new state template block.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/m6yR7wgqcBilRXpfIztBjA.png\" alt=\"Create a New State Row\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/m6yR7wgqcBilRXpfIztBjA.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<h5>3. Edit the Template&nbsp;State&nbsp;Row<\/h5>\n<p>See below&nbsp;image for points to edit.<\/p>\n<ol>\n<li>Change the Row ID (stateNameHere) to the appropriate state name to be used as an anchor tag.\n<ul>\n<li>Remember this ID. You'll need it in the next step.<\/li>\n<\/ul>\n<\/li>\n<li>Modify the Custom Heading block to reflect the new state name (e.g. Michigan)<\/li>\n<li>Edit the Raw JS block, replacing all instances of STATENAME with the corresponding state.<\/li>\n<li>Replace all instances of &quot;state&quot; in the image and text links.\n<ul>\n<li>Do this for each column in the row. This creates links to the newly uploaded pages. Do so by editing each text block in &quot;Text&quot; mode, not &quot;Visual&quot;<\/li>\n<\/ul>\n<\/li>\n<\/ol><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/qH_j3VKlZ_wctA0lZkZPeQ.png\" alt=\"Create a New State Row\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/qH_j3VKlZ_wctA0lZkZPeQ.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<h5>4. Update Page<\/h5>\n<\/p><\/div>\n<\/section>\n<section id=\"update-the-business-directory-map\">\n<h2> Update the Business Directory Map <\/h2>\n<div class=\"text-content\">\n<h5>1. Go to the Business Directory Map - Edit<\/h5>\n<p><a href=\"https:\/\/infosource.vet\/wp-admin\/post.php?post=737&amp;action=edit\" rel=\"nofollow\">https:\/\/infosource.vet\/wp-admin\/post.php?post=737&amp;action=edit<\/a><\/p>\n<p>Click to edit the <em>US Business Map - States<\/em> map<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/vaEJGKmx4j4un2B2AY5LZQ.png\" alt=\"Update the Business Directory Map\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/vaEJGKmx4j4un2B2AY5LZQ.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<h5>2. Edit the Javascript Section - Make a State&nbsp;Link<\/h5>\n<p>In the Javascript editor, scroll to find the ID of your newly created state. It will be formatted as US-XX, where &quot;XX&quot; is the state abbreviated&nbsp;code.<\/p>\n<p>For reference, codes can be found here:&nbsp;<a href=\"http:\/\/www.infoplease.com\/ipa\/A0110468.html\" rel=\"nofollow\">http:\/\/www.infoplease.com\/ipa\/A0110468.html<\/a><\/p>\n<ol>\n<li>Change &quot;myURL&quot; from a blank hash (#) to the Row ID you created in Step 3: it must include the # (e.g. #michigan) for the anchor link to function.<\/li>\n<li>Add color:&quot;#7A9BCE&quot; to the state<\/li>\n<li>Save changes<\/li>\n<\/ol>\n<p>(See image below for example) Be sure that all formatting is the same as other completed states, including comma and quotation placement.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/saJOGHvWxyMwxCakEolMLw.png\" alt=\"Update the Business Directory Map\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/saJOGHvWxyMwxCakEolMLw.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<\/section>\n<section id=\"confirm-changes\">\n<h2> Confirm Changes <\/h2>\n<div class=\"text-content\">\n<p>Navigate to the live version of the <a href=\"https:\/\/infosource.vet\/businesses-support-veterans\/\" target=\"_blank\" rel=\"nofollow noopener\">Business Directory<\/a> and confirm your updates are error free.<\/p>\n<p>Click on the now highlighted state icon in the map, verify links function properly and confirm the links in state category pages are also functioning.<\/p>\n<\/p><\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>Update City Template Bulk create new city pages in each category on the website using the above template. 1. Use the Replace function to quickly find and replace all filler information. City name placeholders exist in the template as &quot;city1&quot; and &quot;City1&quot; The state name exists as &quot;State&quot; and &quot;state&quot; NOTE the capitalization of the [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":9249,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"ep_exclude_from_search":false,"cover_icon_emoji":"","cover_icon_url":"","tasks_count":"5","template_description":"","template_id":"p9SQ6t7qA4njLrODFpRKNg","task_0":"Update City Template","task_slug_0":"update-city-template","task_1":"Upload New Pages CSV","task_slug_1":"upload-new-pages-csv","task_2":"Create a New State Row","task_slug_2":"create-a-new-state-row","task_3":"Update the Business Directory Map","task_slug_3":"update-the-business-directory-map","task_4":"Confirm Changes","task_slug_4":"confirm-changes","task_5":"","task_slug_5":"","task_6":"","task_slug_6":"","task_7":"","task_slug_7":"","task_8":"","task_slug_8":"","task_9":"","task_slug_9":"","task_10":"","task_slug_10":"","task_11":"","task_slug_11":"","task_12":"","task_slug_12":"","task_13":"","task_slug_13":"","task_14":"","task_slug_14":"","task_15":"","task_slug_15":"","task_16":"","task_slug_16":"","task_17":"","task_slug_17":"","task_18":"","task_slug_18":"","task_19":"","task_slug_19":"","task_20":"","task_slug_20":"","task_21":"","task_slug_21":"","task_22":"","task_slug_22":"","task_23":"","task_slug_23":"","task_24":"","task_slug_24":"","task_25":"","task_slug_25":"","task_26":"","task_slug_26":"","task_27":"","task_slug_27":"","task_28":"","task_slug_28":"","task_29":"","task_slug_29":"","task_30":"","task_slug_30":"","task_31":"","task_slug_31":"","task_32":"","task_slug_32":"","task_33":"","task_slug_33":"","task_34":"","task_slug_34":"","task_35":"","task_slug_35":"","task_36":"","task_slug_36":"","task_37":"","task_slug_37":"","task_38":"","task_slug_38":"","task_39":"","task_slug_39":"","task_40":"","task_slug_40":"","task_41":"","task_slug_41":"","task_42":"","task_slug_42":"","task_43":"","task_slug_43":"","task_44":"","task_slug_44":"","task_45":"","task_slug_45":"","task_46":"","task_slug_46":"","task_47":"","task_slug_47":"","task_48":"","task_slug_48":"","task_49":"","task_slug_49":"","task_50":"","task_slug_50":"","task_51":"","task_slug_51":"","task_52":"","task_slug_52":"","task_53":"","task_slug_53":"","task_54":"","task_slug_54":"","task_55":"","task_slug_55":"","task_56":"","task_slug_56":"","task_57":"","task_slug_57":"","task_58":"","task_slug_58":"","task_59":"","task_slug_59":"","task_60":"","task_slug_60":"","task_61":"","task_slug_61":"","task_62":"","task_slug_62":"","task_63":"","task_slug_63":"","task_64":"","task_slug_64":"","task_65":"","task_slug_65":"","task_66":"","task_slug_66":"","task_67":"","task_slug_67":"","task_68":"","task_slug_68":"","task_69":"","task_slug_69":"","task_70":"","task_slug_70":"","task_71":"","task_slug_71":"","task_72":"","task_slug_72":"","task_73":"","task_slug_73":"","task_74":"","task_slug_74":"","task_75":"","task_slug_75":"","task_76":"","task_slug_76":"","task_77":"","task_slug_77":"","task_78":"","task_slug_78":"","task_79":"","task_slug_79":"","task_80":"","task_slug_80":"","task_81":"","task_slug_81":"","task_82":"","task_slug_82":"","task_83":"","task_slug_83":"","task_84":"","task_slug_84":"","task_85":"","task_slug_85":"","task_86":"","task_slug_86":"","task_87":"","task_slug_87":"","task_88":"","task_slug_88":"","task_89":"","task_slug_89":"","task_90":"","task_slug_90":"","task_91":"","task_slug_91":"","task_92":"","task_slug_92":"","task_93":"","task_slug_93":"","task_94":"","task_slug_94":"","task_95":"","task_slug_95":"","task_96":"","task_slug_96":"","task_97":"","task_slug_97":"","task_98":"","task_slug_98":"","task_99":"","task_slug_99":"","footnotes":""},"categories":[7,1],"tags":[],"class_list":["post-9248","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-miscellaneous","category-uncategorized"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/9248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/comments?post=9248"}],"version-history":[{"count":0,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/9248\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media\/9249"}],"wp:attachment":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media?parent=9248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/categories?post=9248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/tags?post=9248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}