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>[email protected]</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>[email protected]</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>[email protected]</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>[email protected]</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>
batch_upload.xls
Description: batch_upload.xls
