Skip to main content

2 posts tagged with "Data Migration"

View All Tags

Shorten Long File Pathnames for Sharepoint Compatibility

· One min read
Calum Miller
Director

Apace Hop Diagram

When a client needed 10,000 file pathnames shortened for compatibility with Microsoft Sharepoint, there was only one tool to use...Apache Hop! With Hop we were able to read in all the original long pathnames and perform consistent name shortening by subfolder. Our task was to ensure they were all under 256 characters. Incredible to think Sharepoint still has this limitation! Then we were able to recreate the new folder structure and copy over all the shortened file pathnames. Simple!

CareerBuilder™ Migration and Fuzzy Matching

· 4 min read
Blair Murray
Lead Software Engineer

Moving candidate records out of a legacy recruitment platform is rarely as simple as exporting a spreadsheet and importing it somewhere else. Names change, email addresses go out of date, and documents are often stored separately from the candidate record they belong to.

We recently helped a client move data from CareerBuilder™ into a new platform using Apache Hop. The job was to match the exported candidates to the client's payroll list, prepare the data for import, and make sure each person's CVs and supporting documents ended up in the right place.