158
edits
Changes
Jump to navigation
Jump to search
#[[Retrieving US VC Data From SDC]]
no edit summary
#[[Retrieving US VC Data From SDC]]
#[[VC Database Rebuild]]
==Location==
===VCFund Pull Problem===
When pulling the VCFund1980-Present, I encountered two problems. One, is that SDC is not able to sort through the funds that are US only with the built in filters. Two, there are multiple rpt files that specify different variables for the fund pull. I pulled from both to be safe, but in the [[VC Database Rebuild]] page there is a section on the fund pull where Ed specifies which rpt file he used to pull data from SDC. Regardless I have both saved in the ExtractedData folder. After speaking with Ed, he told me to use the VCFund1980-present.rpt file to extract the data. Had various problems extracting data including freezing of SDC program or getting error Out of Memory. Check the [[SDC Platinum (Wiki)]] page to fix these issues.
==Loading Tables==
Begin with loading the scripts that I have written and placed in the vcdb3 file. Copy and paste the code from the text files into PuTTY. When loading the roundbase folder, I ran into the problem of one entry Cardtronic Technology having an word in the description that looked like this: "smart'. I just manually removed the quotations and was good to go.
