158
edits
Changes
Jump to navigation
Jump to search
no edit summary
==Loading Tables==
When I describe errors I encountered, I will not describe them using line numbers. This is because as soon as any data is added, the line numbers will become useless. Instead I recommend that you copy the normalized file you are working with into an excel file and using the filter feature. This way you can find the line number in your specific file that is causing errors and fix it in the file itself. The line numbers that PuTTY errors display are often wrong, so I relied on excel to discover the error fastest. If my instructions are not enough for you to find the error, my advice would be to find key words in the line that PuTTY is telling you is causing errors and filter through excel.
\COPY fundbase FROM 'VCFund1980-2018q2-NoFoot-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--29397
There is a Ukranian fund that has stray quotation marks in its name. It is called something along the lines of "VAT "ZNVKIF "Skhidno-Evropeis'lyi investytsiynyi Fond". If this does not help, you can filter in excel using Kiev as the keyword in the city column and find the line where you are getting errors. Then manually remove the commas in the actual text file. After that, the table should load correctly.
DROP TABLE firmbase;
CREATE TABLE firmbase(
firmname varchar(255),
foundingdate date, --mm-dd-yyyy
datefirstinv date, --mm-dd-yyyy
datelastinv date, --mm-dd-yyyy
addr1 varchar(100),
addr2 varchar(100),
location varchar(100),
city varchar(100),
zip varchar(10),
areacode integer,
county varchar(100),
state varchar(2),
nationcode varchar(10),
nation varchar(100),
worldregion varchar(100),
numportcos integer,
numrounds integer,
investedk money,
capitalundermgmt money,
invstatus varchar(100),
msacode varchar(10),
rolepref varchar(100),
geogpref varchar(100),
indpref varchar(100),
stagepref varchar(100),
type varchar(100)
);
\COPY firmbase FROM 'USVCFirms1980-2018q2-NoFoot-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--15899
The normalization for this file was wrong when I tried to load the data. To fix this go to the file where you have removed the footer and find the column header titled Firm Capital under Mgmt{0Mil}. Delete the {0mil} and renormalize the file. Then everything should be ok. A good way to check this is to copy and paste the normalized file into an excel sheet and see whether the entries line up with their column header correctly.
The second error I found was with the Kerala Ventures firm. Here the address has the word l"opera in it. This quotation will cause errors so find the line number using excel and remove it manually.
The third error is in an area code where 1-8 is written. This hyphen causes errors. Interestingly, the line number given by PuTTY was correct, and I found it in my text file and deleted it manually.
These were the only errors I encountered while loading this table.
