7,649
edits
Changes
Jump to navigation
Jump to search
Created page with "VCDB23 is the 2023 iteration of my venture capital database. The last previous build was VCBD20, and this follows the same basic design. == Processing Steps == # Cop..."
[[VCDB23]] is the 2023 iteration of my venture capital database. The last previous build was [[VCBD20]], and this follows the same basic design.
== Processing Steps ==
# Copy over the rpt, ssh, and pl files, and bulk edit the ssh files, now in E:\projects\vcdb23\SDC.
## Change 12/31/2020 (and one 07/20/2020) to 12/31/2022 and vcdb20 to vcdb23
# Run the ssh files against SDC Platinum. Note that SDC Platinum's service will be withdrawn on 31 December 2023.
# Run the [[SDC Normalizer]] script (one of the pl files) on each output
## There are special steps for USFirms1980, USFund1980, USFundExecs1980, USPortCo1980, and RoundOnOneLine (which needs multistep processing)
## PortCo_Long_Description requires bespoke processing
# Create a new database on mother (createdb vcdb23) and setup a directory for the input files: E:\projects\vcdb23
# Copy over and edit Load.sql. Run it section-by-section.
== Processing Steps ==
# Copy over the rpt, ssh, and pl files, and bulk edit the ssh files, now in E:\projects\vcdb23\SDC.
## Change 12/31/2020 (and one 07/20/2020) to 12/31/2022 and vcdb20 to vcdb23
# Run the ssh files against SDC Platinum. Note that SDC Platinum's service will be withdrawn on 31 December 2023.
# Run the [[SDC Normalizer]] script (one of the pl files) on each output
## There are special steps for USFirms1980, USFund1980, USFundExecs1980, USPortCo1980, and RoundOnOneLine (which needs multistep processing)
## PortCo_Long_Description requires bespoke processing
# Create a new database on mother (createdb vcdb23) and setup a directory for the input files: E:\projects\vcdb23
# Copy over and edit Load.sql. Run it section-by-section.
