Data should be put into the proper format before it can be imported. Keep in mind, the process works just the same for all module data, but there are a few fields that do need special formatting. We'll cover them in this series as well.
See Also
Common Excel functions
The following functions are referenced in the video tutorials. You'll come here to copy and use them when you are preparing and formatting data in the bulk import sheets before importing data into SchoolStatus. Your project manager handling your data imports will use this file on Google drive for reference.
For merging folder ID with filenames:
=CONCATENATE("29990/",H2)
For formatting dates:
=TEXT(A1,"yyyy-mm-dd hh:mm:ss.0")
For merging phone extensions with phone numbers:
=(F2&"x"&G2)
Merging many fields into a single Bio field:
=(H2&"<p><b>Expertise</b><br>"&G2&"</p><p><b>Year Started</b><br>"&I2&"</p><p><b>Degrees</b><br>"&J2&"</p><p><b>Publications</b><br>"&K2&"</p><p><b>Presentations</b><br>"&L2&"</p><p><b>Professional Interests</b><br>"&M2&"</p><p><b>Awards</b><br>"&N2&"</p><p><b>Experience</b><br>"&O2&"</p>")
Merging Image fields for Galleries:
=CONCATENATE("/path-to-where-you-dumped-the-files-in-the-department-if-needed/", REFERENCE_TO_CELL_WITH_GALLERY_NAME, "/", REFERENCE_TO_CELL_WITH_IMAGE_FILE_NAME)
Comments
0 comments
Article is closed for comments.