Importing Attachments To Table (En Masse)

[abbaddon223]

Hi all,

I'm hoping someone can help me please?

I'm building a CRM system to manage candidates / clients for a recruitment company.

One issue they have just hit me with is that they have c10,000 CV's (PDF and Word format) that they need to import.

Importing the text for candidates (names, addresses etc) is bread and butter. Each one as they go in with me given a URN automatically.

The problem I have is:

1) I don't know how to import attachements in bulk
2) If it is possible, how to I assign them to the correct URN?

Thanks in advance for any help - I am in a serious jam !!

 

[gemma-the-husky]

surely you do not need (or want) to import the cv etc.

just store the link to the cv file as a string in your candidate table.


----
in order to import existing files you would need some standard naming convention so eg

smith_john.doc, gets added to the record for john smith.

without some standard, you would have to process each one manually.