Hi all - new user here. We are migrating over from a competitor and have a robust metadata file that I have been planning on using to supplement our smart import. I'm running into a problem where the file name (that I'm labelling as Record Name) is not matching the Record Name used by IC. The issue is that when we import our files, the Record Name in IC adds the file extension (.pdf for example) when our metadata spreadsheet only has the actual file name without the extension (minus the .pdf at the end). This was the main way we were planning on tying the two data sets together to be able to do the metadata import to get the rest of our data uploaded. Any help would be appreciated.
Thanks,
Josh