Reply To: Give Connections Import CSV the option to edit existing data

09/16/2015 at 3:48 pm #346992
Steven Zahm
Keymaster

@ Dwight

re: can give me 1 or 2 examples of the types of tags you think might be causing a problem

HTML in the bio/notes is fine… the tags I’m talking about can be found on line 50 of the CSV in the last name column. Here’s an example

Yost</lastname><firstname>Richard</firstname><middlename>A.</middlename><title>Gibson Professor</title><building>CLB</building><room>210A</room><phone>352-392-0557</phone><email>ryost@chem.ufl.edu</email><areas>faculty</areas><areas>analytical</areas><areas>bioanalytical</areas><areas>research</areas><division>Analytical</division><photo>yost</photo><fax>352-392-4651</fax><webpage>https://yost.chem.ufl.edu/</webpage><education>B.S., University of Arizona, 1974<br/>Ph.D., Michigan State, 1979</education><keywords>Analytical mass spectrometry</keywords><paragraph>Research in our group centers around three aspects of analytical mass spectrometry and related techniques: instrumentation, fundamentals, and applications. Instrumentation development includes projects in tandem mass spectrometry (MS/MS) and ion mobility, including the development of the first laser microprobe MS/MS system able to image trace levels of drugs and biomolecules in tissue specimens. Fundamental studies in our group employ both experiment and computer modeling/simulation to explore such issues as ion motion and ion-molecule interactions in high-field ion mobility. Applications of the techniques developed in our group include a wide range of studies in clinical, pharmacological, biotechnological, environmental, and forensic analysis.</paragraph></entry><!-- BEGIN EMERITUS FACULTY LISTING --><entry><lastname>Brey

All of this is in the last name field of that row. Others like this are scatter randomly throughout the file.

re: Are you saying to delete the category name, save, then edit the blank category and re-enter the name, or just delete/retype/save as one operation?

Do this as a single operation, only save once. Not sure if I ever tested saving an empty category name, not sure what would happen… just tested… I throw a user error telling them they need a name :) I must have been smarter that day.