Browser Forms

Re: Advice about a Resume field

g21cincy — Tue, 02 Apr 2013 17:45:30 GMT

The solution that worked best for this was making the Resume variable a 'text' Data Type. The text isn't completely formatted correctly when displayed but it's broked up enough to be read. Below is an example of how the text isn't formatted the same way it was pasted and submitted.

December 2001 – October 2003 MXLS of Kansas, LC

At
home Medical Transcriptionist

Re: Advice about a Resume field

g21cincy — Wed, 27 Feb 2013 19:29:07 GMT

Patrick,

Sorry for taking so long to get back to you. Here is an example of one the submissions with some editing for privacy of the person who submitted it copied straight out of the Resume field in SQL. Thanks for your help.

Normal
0

false
false
false

EN-US
X-NONE
X-NONE

L Wood

2
H Ct ● A, OH 42 ● (513) 111-1111 ● Email: thw@yahoo.com

_Website: _www.linkedin.com/__

Professional summary

A results-driven professional,

education

D University Graduation: February 2002

Bachelor
of Tech Management / Concentration: Sales and Marketing GPA: 4.00

N College Graduation: February 2003

Associate
of App Business / Concentration: Business Administration Management
GPA: 4.00

skill inventory

Software: Microsoft
Word, Outlook

Database: Excel,
Access, CampusVue

Experience: Customer
Service, General Accounting, Data Entry, Internet Explorer

Transferable
Skills:
Multi-Tasking, People Person

employment Experience

N
College
Ohio March 2003 – April 2004

Student Services Representative

Assisted students with
all academic and financial issues and completed necessary paperwork on
behalf of the students

K
Dept Store Cincinnati,
Ohio November 2008 – February 2009

Point of Sales/Department Store Associate

Provided courteous and prompt service on the sales
floor and at the cash

M Dept Store Cincinnati,
Ohio November 2006 – November 2007

Retail Sales Associate

Provided courteous and prompt service by assisting
in locating merchandise for customers and by checking them out at the cash
registerPersuaded the customers to buy merchandise

Career Development Campus Ohio April 2008 - May
2008

Receptionist

§ Greeted and directed customers to correct area of the campus

Routed
incoming calls via a multi-line switchboard, provided information to
callers and took and relayed messages to staff and faculty

§ Sorted
through mail and put them in the right mail boxes, and put postage on mailings
to go out the next day

§
Developed and copied documents for teachers; used
fax machine for teachers or other documents

§
Sorted
through office supplies cabinet and then developed a list of supplies that
needed to be ordered

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:Table Normal;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:;
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:Calibri,sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}

Re: Advice about a Resume field

Patrick Halstead — Fri, 25 Jan 2013 22:26:06 GMT

Hi g21cincy and thanks for all of the posts!

So, I'm guessing the 3rd party .net form doesn't submit XML. You should verify that it submits rich text for the resume. It could be submitting non xhtml compliant rich text which means you may need to add a plugin for viewing it. The out-of-box InfoPath rich text control does require a certain format. If you're lucky, it's the right format but it's missing a few things, like an attribute, that make InfoPath think it's not rich text.

Can you paste an example of the text in a reply so we can see?

Thanks!

Advice about a Resume field

g21cincy — Fri, 25 Jan 2013 19:36:22 GMT

Hello I was hoping someone out there could help me out with a dilemma I'm having. I’ve built an InfoPath 2007 browser-enabled form for my company’s HR department to be able to view data that is being submitted to our database from a .Net form that a 3^rd party company created for us. I have no problem querying the data regarding Personal Information, Education, Skills and Work History as I have each piece of data populate to its text box on each view using a search page to filter candidates.

The issue I’m having is what to do about the Resume page. I’ve tried both Rich Text Box and Text Box controls to display the data but the problem I keep running into for both is that the data runs all together instead of having line breaks where carriage returns should be. Any help with this would be greatly appreciated. Thanks!

The data type for the Resume field in SQL is "nvarchar(MAX)"