Hi all!
I am working on an alternative way to batch upload materials from ProQuest to Digital Commons. As some of you may know, they have a new feature "Batch Upload File Manager" that allows you to upload pdf's and then it generates an excel sheet with pdf urls (see attached example). The downside of this is that you then have to add all the corresponding metadata (title, author name, etc.)

I have a way to download the corresponding xml files and combined them all, but I don't have an easy way to transform the xml file to the formal of the excel file.

Does anyone know of an online converter or free software that can help me create this? Or alternatively, have a good macro guide? I know that all of this is possible, I am just way out of my league when it comes to skillset. Our IT Director left last year and I've been scrambling ever since!

I attached two file examples (the xml + the excel spreadsheet that I need it to align with)

Best,
Mackenzie



<root> 
<?xml version="1.0" encoding="UTF-8"?>
<DISS_submission publishing_option="1" embargo_code="0" third_party_search="Y">
  <DISS_authorship>
    <DISS_author type="primary">
      <DISS_name>
        <DISS_surname>Boulware</DISS_surname>
        <DISS_fname>Myisha</DISS_fname>
        <DISS_middle/>
        <DISS_suffix/>
      </DISS_name>
      <DISS_contact type="future">
        <DISS_contact_effdt>11/05/2021</DISS_contact_effdt>
        <DISS_address>
          <DISS_addrline>3861 Slate Rd</DISS_addrline>
          <DISS_city>AURORA</DISS_city>
          <DISS_st>IL</DISS_st>
          <DISS_pcode>60504</DISS_pcode>
          <DISS_country>US</DISS_country>
        </DISS_address>
        <DISS_email>[log in to unmask]</DISS_email>
      </DISS_contact>
      <DISS_citizenship/>
    </DISS_author>
  </DISS_authorship>
  <DISS_description page_count="120" type="doctoral" external_id="http://dissertations.umi.com/waldenu:27105" apply_for_copyright="yes">
    <DISS_title>Reluctance to Seek Mental Health Treatment Among African Americans Living in Generational Poverty</DISS_title>
    <DISS_dates>
      <DISS_comp_date>2021</DISS_comp_date>
      <DISS_accept_date>01/01/2021</DISS_accept_date>
    </DISS_dates>
    <DISS_degree>Ph.D.</DISS_degree>
    <DISS_institution>
      <DISS_inst_code>0543</DISS_inst_code>
      <DISS_inst_name>Walden University</DISS_inst_name>
      <DISS_inst_contact>Psychology</DISS_inst_contact>
      <DISS_processing_code>D</DISS_processing_code>
    </DISS_institution>
    <DISS_advisor>
      <DISS_name>
        <DISS_surname>Street</DISS_surname>
        <DISS_fname>Sandra</DISS_fname>
        <DISS_middle/>
      </DISS_name>
    </DISS_advisor>
    <DISS_cmte_member>
      <DISS_name>
        <DISS_surname>Barnes-Young</DISS_surname>
        <DISS_fname>Leslie</DISS_fname>
        <DISS_middle/>
        <DISS_suffix/>
      </DISS_name>
    </DISS_cmte_member>
    <DISS_categorization>
      <DISS_category>
        <DISS_cat_code>0384</DISS_cat_code>
        <DISS_cat_desc>Behavioral psychology</DISS_cat_desc>
      </DISS_category>
      <DISS_category>
        <DISS_cat_code>0602</DISS_cat_code>
        <DISS_cat_desc>Behavioral sciences</DISS_cat_desc>
      </DISS_category>
      <DISS_category>
        <DISS_cat_code>0620</DISS_cat_code>
        <DISS_cat_desc>Developmental psychology</DISS_cat_desc>
      </DISS_category>
      <DISS_keyword>African Americans, Chicago, generational poverty, mental health, mental health treatment, mental illness</DISS_keyword>
      <DISS_language>en</DISS_language>
    </DISS_categorization>
  </DISS_description>
  <DISS_content>
    <DISS_abstract>
      <DISS_para>African Americans are 20% more likely to experience mental health issues but are the least likely group to seek professional mental health treatment. In addition, African Americans are more likely to experience severe mental health conditions than other races due to a greater risk of homelessness and being exposed to violence. This research study used a phenomenological qualitative methodology to explore the attitudes and lived experiences of 10 African Americans living in generational poverty in inner-city Chicago. The participants provide detailed accounts of their lived experiences with generational poverty, mental health, and the attitudes their family lineage had shared with them regarding professional mental health treatment. This research study is based on social stratification and racial segregation theories which focus on the poverty cycle in poor neighborhoods. Thematic analysis was used to analyze the qualitative data. Using the common sense model to guide analysis, four core themes emerged: coping mechanisms, upbringing, attitude, and religion. Two subthemes were also identified: family involvement and mistrust. All of the participants expressed various levels of reluctance towards mental health treatment based on personal experiences, cultural influence, and coping mechanisms utilized by family members. Reduction in mental health care disparities can restore African Americans’ trust in clinicians and encourage African Americans to seek professional mental health treatment when needed. African Americans living in generational poverty may benefit from the results of this study by alleviating the symptoms associated with poor mental health such as psychological distress, severe depressive episodes, poverty, and violence.</DISS_para>
    </DISS_abstract>
    <DISS_binary type="PDF">Boulware_waldenu_0543D_27105.pdf</DISS_binary>
  </DISS_content>
  <DISS_restriction/>
  <DISS_repository>
    <DISS_version>2018-07-13 15:43:13</DISS_version>
    <DISS_agreement_decision_date>2021-11-05 10:16:22</DISS_agreement_decision_date>
    <DISS_acceptance>1</DISS_acceptance>
    <DISS_delayed_release/>
    <DISS_access_option>Open access</DISS_access_option>
  </DISS_repository>
  <DISS_creative_commons_license>
    <DISS_abbreviation/>
  </DISS_creative_commons_license>
</DISS_submission>
<?xml version="1.0" encoding="UTF-8"?>
<DISS_submission publishing_option="0" embargo_code="0" third_party_search="Y">
  <DISS_authorship>
    <DISS_author type="primary">
      <DISS_name>
        <DISS_surname>Le</DISS_surname>
        <DISS_fname>Michael</DISS_fname>
        <DISS_middle>H.</DISS_middle>
        <DISS_suffix/>
      </DISS_name>
      <DISS_contact type="current">
        <DISS_contact_effdt>05/18/2017</DISS_contact_effdt>
        <DISS_address>
          <DISS_addrline/>
          <DISS_city/>
          <DISS_st/>
          <DISS_pcode/>
          <DISS_country>US</DISS_country>
        </DISS_address>
        <DISS_email>[log in to unmask]</DISS_email>
      </DISS_contact>
      <DISS_contact type="future">
        <DISS_contact_effdt>12/24/2021</DISS_contact_effdt>
        <DISS_address>
          <DISS_addrline>8717 Franklin Ave.</DISS_addrline>
          <DISS_city>Clive</DISS_city>
          <DISS_st>IA</DISS_st>
          <DISS_pcode>50325</DISS_pcode>
          <DISS_country>US</DISS_country>
        </DISS_address>
        <DISS_email>[log in to unmask]</DISS_email>
      </DISS_contact>
      <DISS_citizenship/>
    </DISS_author>
  </DISS_authorship>
  <DISS_description page_count="156" type="doctoral" external_id="http://dissertations.umi.com/waldenu:18969" apply_for_copyright="no">
    <DISS_title>Health Care Leader Strategies for Cultural Diversity in the Workplace</DISS_title>
    <DISS_dates>
      <DISS_comp_date>2021</DISS_comp_date>
      <DISS_accept_date>01/01/2021</DISS_accept_date>
    </DISS_dates>
    <DISS_degree>D.B.A.</DISS_degree>
    <DISS_institution>
      <DISS_inst_code>0543</DISS_inst_code>
      <DISS_inst_name>Walden University</DISS_inst_name>
      <DISS_inst_contact>Business Administration</DISS_inst_contact>
      <DISS_processing_code>D</DISS_processing_code>
    </DISS_institution>
    <DISS_advisor>
      <DISS_name>
        <DISS_surname>Simon</DISS_surname>
        <DISS_fname>Marilyn </DISS_fname>
        <DISS_middle>K</DISS_middle>
      </DISS_name>
    </DISS_advisor>
    <DISS_cmte_member>
      <DISS_name>
        <DISS_surname>Simon</DISS_surname>
        <DISS_fname>Marilyn</DISS_fname>
        <DISS_middle>K</DISS_middle>
        <DISS_suffix/>
      </DISS_name>
    </DISS_cmte_member>
    <DISS_cmte_member>
      <DISS_name>
        <DISS_surname>Brown</DISS_surname>
        <DISS_fname>Annie </DISS_fname>
        <DISS_middle>H</DISS_middle>
        <DISS_suffix/>
      </DISS_name>
    </DISS_cmte_member>
    <DISS_cmte_member>
      <DISS_name>
        <DISS_surname>Blando</DISS_surname>
        <DISS_fname>Judy</DISS_fname>
        <DISS_middle>L</DISS_middle>
        <DISS_suffix/>
      </DISS_name>
    </DISS_cmte_member>
    <DISS_categorization>
      <DISS_category>
        <DISS_cat_code>0310</DISS_cat_code>
        <DISS_cat_desc>Business administration</DISS_cat_desc>
      </DISS_category>
      <DISS_keyword>Cultural Diversity </DISS_keyword>
      <DISS_language>en</DISS_language>
    </DISS_categorization>
  </DISS_description>
  <DISS_content>
    <DISS_abstract>
      <DISS_para>Health care leaders who lack strategies to manage workers from diverse ethnic and cultural backgrounds face high employee turnover. High employee turnover can jeopardize the health of patients and the financial stability of their organization. Grounded in the cognitive diversity theory, the purpose of this qualitative multiple case study was to explore strategies eight health care leaders in Iowa use to manage diverse employees. Data sources were semistructured interviews, researcher notes, and a review of the diversity policies of each facility. Five themes identified through thematic analysis included leaders using recruitment strategies to promote diversity, leaders encouraging and using communication/feedback, leaders conducting diversity training to encourage diversity, leaders providing suitable working conditions to promote diversity, and leaders encouraging and engaging in teamwork and collaboration. A key recommendation for health care leaders is to conduct diversity training that encourages teamwork and collaboration amongst employees with diverse cultures and backgrounds. The implications for positive social change include the potential for health care leaders to build a more inclusive culture that can lead to lower turnover in staff and improve the quality of healthcare for patients.   </DISS_para>
    </DISS_abstract>
    <DISS_binary type="PDF">Le_waldenu_0543D_18969.pdf</DISS_binary>
  </DISS_content>
  <DISS_restriction/>
  <DISS_repository>
    <DISS_version>2018-07-13 15:43:13</DISS_version>
    <DISS_agreement_decision_date>2021-12-24 10:12:43</DISS_agreement_decision_date>
    <DISS_acceptance>1</DISS_acceptance>
    <DISS_delayed_release/>
    <DISS_access_option>Open access</DISS_access_option>
  </DISS_repository>
  <DISS_creative_commons_license>
    <DISS_abbreviation/>
  </DISS_creative_commons_license>
</DISS_submission>
<?xml version="1.0" encoding="UTF-8"?>
<DISS_submission publishing_option="0" embargo_code="0" third_party_search="Y">
  <DISS_authorship>
    <DISS_author type="primary">
      <DISS_name>
        <DISS_surname>White</DISS_surname>
        <DISS_fname>John</DISS_fname>
        <DISS_middle>Todd</DISS_middle>
        <DISS_suffix/>
      </DISS_name>
      <DISS_contact type="future">
        <DISS_contact_effdt>10/21/2021</DISS_contact_effdt>
        <DISS_address>
          <DISS_addrline>1069 North 4150 West</DISS_addrline>
          <DISS_city>West Point</DISS_city>
          <DISS_st>UT</DISS_st>
          <DISS_pcode>84015</DISS_pcode>
          <DISS_country>US</DISS_country>
        </DISS_address>
        <DISS_email>[log in to unmask]</DISS_email>
      </DISS_contact>
      <DISS_citizenship/>
    </DISS_author>
  </DISS_authorship>
  <DISS_description page_count="147" type="doctoral" external_id="http://dissertations.umi.com/waldenu:27028" apply_for_copyright="no">
    <DISS_title>The Efficacy of Interpersonal Skills on Sales Production Among Pharmaceutical Salespeople</DISS_title>
    <DISS_dates>
      <DISS_comp_date>2021</DISS_comp_date>
      <DISS_accept_date>01/01/2021</DISS_accept_date>
    </DISS_dates>
    <DISS_degree>Psy.D.</DISS_degree>
    <DISS_institution>
      <DISS_inst_code>0543</DISS_inst_code>
      <DISS_inst_name>Walden University</DISS_inst_name>
      <DISS_inst_contact>Psychology</DISS_inst_contact>
      <DISS_processing_code>D</DISS_processing_code>
    </DISS_institution>
    <DISS_advisor>
      <DISS_name>
        <DISS_surname>Orr-Sprague</DISS_surname>
        <DISS_fname>Stacy</DISS_fname>
        <DISS_middle/>
      </DISS_name>
    </DISS_advisor>
    <DISS_cmte_member>
      <DISS_name>
        <DISS_surname>Sukal</DISS_surname>
        <DISS_fname>Marlon</DISS_fname>
        <DISS_middle/>
        <DISS_suffix/>
      </DISS_name>
    </DISS_cmte_member>
    <DISS_cmte_member>
      <DISS_name>
        <DISS_surname>Schmidt</DISS_surname>
        <DISS_fname>John</DISS_fname>
        <DISS_middle/>
        <DISS_suffix/>
      </DISS_name>
    </DISS_cmte_member>
    <DISS_categorization>
      <DISS_category>
        <DISS_cat_code>0703</DISS_cat_code>
        <DISS_cat_desc>Organizational behavior</DISS_cat_desc>
      </DISS_category>
      <DISS_category>
        <DISS_cat_code>0635</DISS_cat_code>
        <DISS_cat_desc>Organization theory</DISS_cat_desc>
      </DISS_category>
      <DISS_keyword>Interpersonal Skills, Large Group Meetings, People Skills, Pharmaceutical Sales, Sales, Tenure</DISS_keyword>
      <DISS_language>en</DISS_language>
    </DISS_categorization>
  </DISS_description>
  <DISS_content>
    <DISS_abstract>
      <DISS_para>The pharmaceutical industry relies heavily on sales to stimulate growth, support research and development, and remain solvent. A review of the literature revealed there is limited insight on the impact of interpersonal skills on sales performance. This study addressed the role of interpersonal skills in a pharmaceutical salesperson’s performance in terms of total sales income, which includes salary, bonuses, and commissions. Gardner’s (1983) multiple intelligences theory, specifically interpersonal skills, served as the study’s framework. The Conversational Skills Rating Scale (CSRS) was used to assess interpersonal skill level. Additionally, the relationship between salesperson tenure and the number of sales meetings attended were also used to predict total sales income. A sample of 107 pharmaceutical salespeople served as participants, completing the CSRS and a questionnaire capturing the other two predictors as well as their income sources. Interpersonal skills predicted increased sales income with an R2 of .10, a beta value of .23, and an improved t value of 2.45. Tenure also predicted increased sales income with a positive correlation of .25, a t value of 2.91 and a beta of .30. There was no significant increase from the number of large group meetings held with a beta of -270.16. Through the findings of this study positive social change will be promoted by increasing the understanding of the role of interpersonal skills in a pharmaceutical salesperson’s performance thereby improving the sales experience for both consumers and salespeople alike. Additionally, companies can use these findings to provide more targeted employee training and potentially identify more suitable job candidates, which could lead to greater organizational sales performance and an even better customer experience.</DISS_para>
    </DISS_abstract>
    <DISS_binary type="PDF">White_waldenu_0543D_27028.pdf</DISS_binary>
  </DISS_content>
  <DISS_restriction/>
  <DISS_repository>
    <DISS_version>2018-07-13 15:43:13</DISS_version>
    <DISS_agreement_decision_date>2021-10-21 11:33:57</DISS_agreement_decision_date>
    <DISS_acceptance>1</DISS_acceptance>
    <DISS_delayed_release/>
    <DISS_access_option>Open access</DISS_access_option>
  </DISS_repository>
  <DISS_creative_commons_license>
    <DISS_abbreviation/>
  </DISS_creative_commons_license>
</DISS_submission>
</root>