I have 40k PDF's in windows shared drive. Each pdf should be attached to parent account. The name of each pdf is an external ID in salesforce. e.g AA123.pdf corresponds to AccountRecordId '0015C00000OaTWhQAN' AA456 corresponds to AccountRecordId '0015C00000OaRWhAVN'
My question is when i prepare my csv to be uploaded via Dataloader, how can i get the path of each pdf without having to type the path ?
e.g path of AA123.pdf is S:\IT\Database\Attachments\Extracts\AA123.pdf
Is there any utility program or do i have to write a script that will go through each pdf in the folder, extract the absolute path and create a csv. ?