7,649
edits
Changes
Jump to navigation
Jump to search
==Loading the data==
First, create a dbase:
createdb vcdb4
Then load the data, running Load.sql
The following were nuances of this process:
*Replace all double quotes with nothing in PortCo, Fund
*Renormalize firm by fixing the header -- the Capital Under Mgmt field was too close to the next field -- and remove two bad area codes (lines 931 and 11298).
no edit summary
The build should be done as quickly but cleanly as possible, as it is needed right away but also will likely need to be updated in January of 2020 to reflect 2019's year end.
==SDC Platinum Requests==
Not that USMAPrivate100pc2013 and USIPO1980 have some non-numerics in their value fields, and we are generally going to have take care of some type issues.
==Loading the data==
First, create a dbase:
createdb vcdb4
Then load the data, running Load.sql
The following were nuances of this process:
*Replace all double quotes with nothing in PortCo, Fund
*Renormalize firm by fixing the header -- the Capital Under Mgmt field was too close to the next field -- and remove two bad area codes (lines 931 and 11298).
*Be careful not to replace single quotes in company names as it will destroy the keys (or do it everywhere!).
