[VIEWED 6724
TIMES]
|
SAVE! for ease of future access.
|
|
|
Ghiraunla
Please log in to subscribe to Ghiraunla's postings.
Posted on 09-16-16 11:06
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
There is a table with a number of rows say 100 rows and just 3 columns, SerialNumber (Primarykey), and First Name and Resume. However, the column resume is empty. The resumes of all 100 persons are in a folder. How: 1) Can I load the corresponding resumes to the resume column? 2) How to retrieve the data like Names and files like Resume from the database? Guhar!
|
|
|
|
Sajha keto
Please log in to subscribe to Sajha keto's postings.
Posted on 09-17-16 2:00
AM [Snapshot: 42]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
1. You can but you have to convert it to binary. So it's better to store in file system and store the pointers to DB if the content of file is static . 2.you can retrieve names and pointer from database and using the pointer, get the file from file system
|
|
|
Ghiraunla
Please log in to subscribe to Ghiraunla's postings.
Posted on 09-17-16 2:28
AM [Snapshot: 57]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Hi Sajha Keto, store in file system and store the pointers to DB , how can they be automated if there are 1000 rows and 1000 corresponding documents? Appreciate if you elaborate it.
|
|
|
fuckeetow
Please log in to subscribe to fuckeetow's postings.
Posted on 09-17-16 7:41
AM [Snapshot: 156]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Create a folder somewhere and store all the resume files in there. Of course the file name should be unique. Now, just store the name of the files in the resume column. Now first read the entries from database and the files from the folder.
|
|
|
Ghiraunla
Please log in to subscribe to Ghiraunla's postings.
Posted on 09-17-16 8:17
AM [Snapshot: 176]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
fuckeetow, how to make sure right resume file goes to the right row?
|
|
|
fuckeetow
Please log in to subscribe to fuckeetow's postings.
Posted on 09-17-16 11:15
AM [Snapshot: 252]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
The file name should be associated with the first name.
|
|
|
Ghiraunla
Please log in to subscribe to Ghiraunla's postings.
Posted on 09-17-16 12:58
PM [Snapshot: 303]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
which tool or sample skript?
|
|
|
SumOne1
Please log in to subscribe to SumOne1's postings.
Posted on 09-17-16 1:18
PM [Snapshot: 319]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
IT Mitrahru, I found Ghiraunla's posting helpful for me too. Can anyone post the sample solution with Screenshots?
|
|
|
sajhamitra
Please log in to subscribe to sajhamitra's postings.
Posted on 09-17-16 1:39
PM [Snapshot: 331]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Here are the scenarios and solutions 1.) resume file name is same as first name in DB Get the list of doc or docx files using the system command Insert into #temp xp_cmdshell e.g xp_cmdshell 'dir /b *.docx'. Your temp table will have list of file name. Hit the update statement by joining #temp table and your main table. This solution will only points to files in the directory. It does not load the file itself into the table 2.) resume file name is not same as name of the person in DB In this case you have only one option and bit tricky. Your code have to open the content using office API and do a fuzzy lookup to get the name which is in first name column.
|
|
|
fuckeetow
Please log in to subscribe to fuckeetow's postings.
Posted on 09-17-16 3:22
PM [Snapshot: 252]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Do you need to open the files to find out who's resume that is. If yes, it will little more complicated.
|
|
|
Ghiraunla
Please log in to subscribe to Ghiraunla's postings.
Posted on 09-17-16 7:13
PM [Snapshot: 406]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
yes, that is what I need, open name, and other information along with the file, can be downloaded.
|
|
|