{"id":1007,"date":"2021-10-05T13:05:34","date_gmt":"2021-10-05T13:05:34","guid":{"rendered":"https:\/\/sls.gmu.edu\/web\/?p=1007"},"modified":"2021-10-05T13:05:34","modified_gmt":"2021-10-05T13:05:34","slug":"creating-a-spreadsheet-for-full-time-faculty","status":"publish","type":"post","link":"https:\/\/sls.gmu.edu\/web\/2021\/10\/05\/creating-a-spreadsheet-for-full-time-faculty\/","title":{"rendered":"Creating a Spreadsheet for Full-time Faculty"},"content":{"rendered":"<p>A request to pull the following information from the <a href=\"https:\/\/www.law.gmu.edu\/faculty\/directory\/fulltime\/\">full-time faculty directory<\/a>:<\/p>\n<ul>\n<li>Last Name<\/li>\n<li>First Name<\/li>\n<li>Title<\/li>\n<li>Degrees and Schools<\/li>\n<li>SSRN link<\/li>\n<li>Subjects taught<\/li>\n<li>Area(s) of Expertise<\/li>\n<li>CV (PDF link if they have one posted)<\/li>\n<li>Email<\/li>\n<li>Bio (link to profile page)<\/li>\n<\/ul>\n<p>Create a chunk (<code>ditto.faculty_list_2021_ABA<\/code>) using <code>tr<\/code> and <code>td<\/code> tags:<\/p>\n<p><code>&lt;tr&gt;<br \/>\n&lt;td&gt;[[+lname]]&lt;\/td&gt;<br \/>\n&lt;td&gt;[[+pref_name:default=`[[+fname]]`]]&lt;\/td&gt;<br \/>\n&lt;td&gt;[[+title_main]]&lt;\/td&gt;<br \/>\n&lt;td&gt;[[+degree6:isnot=``:then=`[[+degree6:ReplaceDegrees]]`]][[+alma_mater6:isnot=``:then=`, [[+alma_mater6]]; `]][[+degree5:isnot=``:then=`[[+degree5:ReplaceDegrees]]`]][[+alma_mater5:isnot=``:then=`, [[+alma_mater5]]; `]][[+degree4:isnot=``:then=`[[+degree4:ReplaceDegrees]]`]][[+alma_mater4:isnot=``:then=`, [[+alma_mater4]]; `]][[+degree3:isnot=``:then=`[[+degree3:ReplaceDegrees]]`]][[+alma_mater3:isnot=``:then=`, [[+alma_mater3]]; `]][[+degree2:isnot=``:then=`[[+degree2:ReplaceDegrees]]`]][[+alma_mater2:isnot=``:then=`, [[+alma_mater2]]; `]][[+degree1:ReplaceDegrees]][[+alma_mater1:isnot=``:then=`, [[+alma_mater1]]`]]&lt;\/td&gt;<br \/>\n&lt;td&gt;[[+ssrn:isnot=``:then=`https:\/\/ssrn.com\/author=[[+ssrn]]`]]&lt;\/td&gt;<br \/>\n&lt;td&gt;[[+faculty_subject_category:convert_ids_to_pagetitles_1]]&lt;\/td&gt;<br \/>\n&lt;td&gt;[[+expertise:convert_output_list_1]]&lt;\/td&gt;<br \/>\n&lt;td&gt;[[+cv_pdf:isnot=``:then=`https:\/\/www.law.gmu.edu\/[[+cv_pdf]]`]]&lt;\/td&gt;<br \/>\n&lt;td&gt;[[+email]]&lt;\/td&gt;<br \/>\n&lt;td&gt;https:\/\/www.law.gmu.edu\/faculty\/directory\/fulltime\/[[+alias]]&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<\/code><\/p>\n<p>The square brackets (<code>[[+lname]]<\/code>) correspond with the form field inside MODX. To see how the fields were created, take a look at the <code>2015_faculty_profile<\/code> chunk.<\/p>\n<p>After creating the <code>ditto.faculty_list_2021_ABA<\/code> chunk, put it inside the script below:<\/p>\n<p><code>&lt;table&gt;<br \/>\n[[getResources? &amp;showHidden=`1` &amp;includeTVs=`1` &amp;tvPrefix=`` &amp;limit=`0` &amp;sortbyTV=`lname` &amp;sortdirTV=`ASC` &amp;parents=`5842` &amp;depth=`1` &amp;tpl=`ditto.faculty_list_2021_ABA` &amp;sortBy=`lname` &amp;sortDir=`ASC` &amp;display=`all` &amp;filter=`hide_all,1,2`]]<br \/>\n&lt;\/table&gt;<\/code><\/p>\n<p>Past the script above on any page inside MODX to populate the table. The tag <code>&amp;parents=`5842`<\/code> refers to the ID number of the full-time faculty directory.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A request to pull the following information from the full-time faculty directory: Last Name First Name Title Degrees and Schools SSRN link Subjects taught Area(s) of Expertise CV (PDF link if they have one posted) Email Bio (link to profile page) Create a chunk (ditto.faculty_list_2021_ABA) using tr and td tags: &lt;tr&gt; &lt;td&gt;[[+lname]]&lt;\/td&gt; &lt;td&gt;[[+pref_name:default=`[[+fname]]`]]&lt;\/td&gt; &lt;td&gt;[[+title_main]]&lt;\/td&gt; &lt;td&gt;[[+degree6:isnot=&#8220;:then=`[[+degree6:ReplaceDegrees]]`]][[+alma_mater6:isnot=&#8220;:then=`, &hellip; <a href=\"https:\/\/sls.gmu.edu\/web\/2021\/10\/05\/creating-a-spreadsheet-for-full-time-faculty\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Creating a Spreadsheet for Full-time Faculty&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[4],"tags":[22],"class_list":["post-1007","post","type-post","status-publish","format-standard","hentry","category-cms","tag-modx"],"_links":{"self":[{"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/posts\/1007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/comments?post=1007"}],"version-history":[{"count":0,"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/posts\/1007\/revisions"}],"wp:attachment":[{"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/media?parent=1007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/categories?post=1007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/tags?post=1007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}