7,612
edits
Changes
Jump to navigation
Jump to search
→Updating data from vcdb4
==Updating data from vcdb4==
Using the Researcher RDP account:
#Go to: E:\mcnair\Projects\VentureXpert Database\vcdb3ScriptsForSDCExtract\ and copy all necessary files (for each of them, download the txt, the ssh and the rpt file) to E:\projects\vcdb4.
#Open SDC Platinum, input the initial, and create a project description.
#Open the ssh file in SDC Platinum and save it as a new file for updating (do not overwrite the old file).
#Go to the vcdb4 folder, open the txt file, scroll down to the bottom to delete the footer. Save the footer-less txt document as a new file.
#Move everything related to the updated session (ssh, rpt, txt, txt with no footer) to the updated file (all current updated files are in there).
Notes from Ed: I'm not sure about step 5!
List of files with status:
*USVCFirms1980-present2019 -- Done by Khai
*USVCFunds1980-present2019 -- Done by Khai
*USVCPortCos1980-present2019 -- Done by Khai
*USCompanyLongDescription1980-present -- Will require special processing
*VCFirmsLongDescription -- Will require special processing
*IPO1980-present
*MA1980-2018q2-updated
*USVCRound1980-present
