[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 5377 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 90 days
Recommended Popular Threads Controvertial Threads
डीभी परेन भने खुसि हुनु होस् ! अमेरिकामाधेरै का श्रीमती अर्कैसँग पोइला गएका छन् !
शीर्षक जे पनि हुन सक्छ।
What are your first memories of when Nepal Television Began?
Sajha Poll: नेपालका सबैभन्दा आकर्षक महिला को हुन्?
NRN card pros and cons?
Basnet or Basnyat ??
निगुरो थाहा छ ??
Nas and The Bokas: Coming to a Night Club near you
TPS Re-registration
अमेरिकामा छोरा हराएको सूचना
Breathe in. Breathe out.
Drawback for applying NRN card
nrn citizenship
Democrats are so sure Trump will win
My facebook archive (for sale)
Top 10 Anti-vaxxers Who Got Owned by COVID
Doctors dying suddenly or unexpectedly since the rollout of COVID-19 vaccines
ढ्याउ गर्दा दसैँको खसी गनाउच
Sajha has turned into MAGATs nest
Send Parcels from USA to Nepal & Worldwide.
Nas and The Bokas: Coming to a Night Club near you
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