Changes

Jump to navigation Jump to search
1,039 bytes added ,  15:44, 11 July 2018
no edit summary
==Loading Tables==
Begin 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 loading into an excel file and using the scripts filter feature. This way you can find the line number in your specific file that I have written is causing errors and placed fix it in the vcdb3 fileitself. Copy and paste The line numbers that PuTTY errors display are often wrong, so I relied on excel to discover the code from the text files into PuTTYerror fastest. When loading the    DROP TABLE roundbase; CREATE TABLE roundbase folder( coname varchar(255), rounddate date, updateddate date, foundingdate date, datelastinv date, datefirstinv date, I ran into the problem of one entry Cardtronic Technology having an word in the investedk real, city varchar(100), description that looked like this: "smartvarchar(5000), msa varchar(100), msacode varchar(10), nationcode varchar(10), statecode varchar(10), addr1 varchar(100), addr2 varchar(100), indclass varchar(100), indsubgroup3 varchar(100), indminor varchar(100), url varchar(5000), zip varchar(10), stage1 varchar(100), stage3 varchar(100), rndamtdisck real, rndamtestk real, roundnum integer, numinvestors integer );  \COPY roundbase FROM 'USVC1980-2018q2-Good. txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV --151549 The only error I just manually removed the quotations and encountered here was good to gowith Cardtronic Technology Inc.Here there was a problem with a mixture of
158

edits

Navigation menu