[Show all top banners]

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 5376 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 200 days
Recommended Popular Threads Controvertial Threads
शीर्षक जे पनि हुन सक्छ।
NRN card pros and cons?
What are your first memories of when Nepal Television Began?
TPS Re-registration
Democrats are so sure Trump will win
Basnet or Basnyat ??
nrn citizenship
Sajha has turned into MAGATs nest
Nas and The Bokas: Coming to a Night Club near you
ChatSansar.com Naya Nepal Chat
डीभी परेन भने खुसि हुनु होस् ! अमेरिकामाधेरै का श्रीमती अर्कैसँग पोइला गएका छन् !
3 most corrupt politicians in the world
if you are in USA illegally and ask for asylum it is legal
Returning to Nepal with us citizenship. Property ownership
Top 10 Anti-vaxxers Who Got Owned by COVID
आज बाट तिहारको सेल सकियो
निगुरो थाहा छ ??
Do nepalese really need TPS?
सुवास नेम्वाङको निधन कोविद भ्याक्सीन को कारण हृदयघात
Travelling to Nepal - TPS AP- PASSPORT
Nas and The Bokas: Coming to a Night Club near you
Mr. Dipak Gyawali-ji Talk is Cheap. US sends $ 200 million to Nepal every year.
Harvard Nepali Students Association Blame Israel for hamas terrorist attacks
TPS Update : Jajarkot earthquake
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