InfoPath Dev

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)"

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!

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: [email protected]

_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;}

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