VCDB23 - Revision history

Ed at 23:37, 29 December 2023

2023-12-29T23:37:39Z

Ed at 15:25, 10 January 2023

2023-01-10T15:25:23Z

Ed at 02:36, 5 January 2023

2023-01-05T02:36:20Z

Ed: 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..."

2023-01-04T23:09:07Z

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..."

New page

[[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.

← Older revision		Revision as of 23:37, 29 December 2023
Line 1:		Line 1:
−	[[VCDB23]] is the 2023 iteration of my venture capital database. The last previous build was [[VCDB20]], and this follows the same basic design.	+	[[VCDB23]] is the 2023 iteration of my venture capital database. The last previous build was [[VCDB20]], and this follows the same basic design. This build was partial - not all location data was included. It was superseded by [[VCDB24]].

	== Processing Steps ==		== Processing Steps ==

@@ Line 1: / Line 1: @@
-[[VCDB23]] is the 2023 iteration of my venture capital database. The last previous build was [[VCBD20]], and this follows the same basic design.
+[[VCDB23]] is the 2023 iteration of my venture capital database. The last previous build was [[VCDB20]], and this follows the same basic design.
 == Processing Steps ==
@@ Line 11: / Line 11: @@
 ## The private and public M&A file sets have to be separately combined into 2 files after they've been normalized. Then replace \tnp\t and \tnm\t with \t\t in each.
 ## For RoundOnOneLine, remove the footer, run NormalizeFixedWidth.pl first, then RoundOnOneLine.pl, and then fix the header.
-## PortCoLongDescription must be pre-processed from the command line and then post-processed in excel (see VCDB20H1 and Vcdb4#Long_Description).
+## PortCoLongDescription must be pre-processed from the command line and then post-processed in excel (see VCDB20H1 and Vcdb4#Long_Description). However, I didn't load it for this run.
 # 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.

@@ Line 7: / Line 7: @@
 # 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)
+## Fix the header row in USFirms1980.txt before normalizing (the Capital Under Management column name is too long)
-## PortCo_Long_Description requires bespoke processing
+## Remove double quotes from USFund1980-normal.txt, USFundExecs1980-normal.txt, USPortCo1980-normal.txt, USFirmBranchOffices1980.txt
 # 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.