Ghiraunla
Replies to this thread:

More by Ghiraunla
What people are reading
Subscribers
Subscribers
[Total Subscribers 1]

fi_nepali
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 SQL Server, Java and IT gurus, Guhar
[VIEWED 6724 TIMES]
SAVE! for ease of future access.
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!







 
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
 
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.
 
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.
 
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?
 
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.
 
Posted on 09-17-16 12:58 PM     [Snapshot: 303]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

which tool or sample skript?
 
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?
 
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.
 
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.
 
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.
 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 7 days
Recommended Popular Threads Controvertial Threads
TPS Re-registration case still pending ..
To Sajha admin
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters