I need to import a boatload of file attachments, but Import doesn't appear to allow it. So, I'm trying to come up with a way to upload the files and link them to their appropriate (previously imported) parent records. So far the only thing that looks like it might work is really cumbersome. It goes something like this:
Make sure the name of every file includes a parse-able ID that uniquely identifies the parent.
Use an SFTP Poll to locate and upload the files into individual Document objects.
Trigger an onCreate Rule that kicks an Event Action that parses the file name and relates the Document record to the parent data record.
It might work, but it’s ugly. Alternatives?