Data Import

ddelmonte · January 14, 2011, 1:44pm

Hi all, I have a series of Word pages, that make up a book of verbs.

The client would like these made into a dictionary database.

Each page has similarities but they are not identical.

Each page has one verb and all of its conjugations.

I can get the pages into html and Excel.

I have a database structure. The question is how to import the data.

At worst, I can copy and paste

I would appreciate any ideas on how to better accomplish this task.

r937 · January 14, 2011, 1:52pm

without seeing any details, there is very little anyone can to do help you

excel files import very easily, although the mechanism varies by database system

however, this presupposes that you have created the excel file with the express purpose of importing into a database table, which means no blank columns, everything must fit into specific table columns logically

ddelmonte · January 14, 2011, 3:05pm

Hi Rudy, I am posting a few lines of the spreadsheet below. I guess I could massage the spreadsheet as per your advice… It’s a toss up between dealing with a 300 page spreadsheet and copy and pasting directly into sql tables, unless there is a more sophisticated method…

Thanks for helping.

								
P. S. 	I discovered, invented				I was discovered, invented			
	&#945;&#957;&#945;&#954;&#940;&#955;&#965;&#968;&#945;		&#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#945;&#956;&#949;		&#945;&#957;&#945;&#954;&#945;&#955;&#973;&#966;&#952;&#951;&#954;&#945;		&#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#942;&#954;&#945;&#956;&#949;	
	&#945;&#957;&#945;&#954;&#940;&#955;&#965;&#968;&#949;&#962;		&#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#945;&#964;&#949;		&#945;&#957;&#945;&#954;&#945;&#955;&#973;&#966;&#952;&#951;&#954;&#949;&#962;		&#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#942;&#954;&#945;&#964;&#949;	
	&#945;&#957;&#945;&#954;&#940;&#955;&#965;&#968;&#949;		&#945;&#957;&#945;&#954;&#940;&#955;&#965;&#968;&#945;&#957;		&#945;&#957;&#945;&#954;&#945;&#955;&#973;&#966;&#952;&#951;&#954;&#949;		&#945;&#957;&#945;&#954;&#945;&#955;&#973;&#966;&#952;&#951;&#954;&#945;&#957;	
								
F. C. 	I will be discovering, inventing			I will be being discovered, invented				
	&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#960;&#964;&#969;					&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#960;&#964;&#959;&#956;&#945;&#953;		
	&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#960;&#964;&#949;&#953;&#962;   	etc.			&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#960;&#964;&#949;&#963;&#945;&#953;	etc.		
								
F. S. 	I will discover, invent				I will be discovered, invented			
	&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#969;		&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#959;&#965;&#956;&#949;	&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#974;		&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#959;&#973;&#956;&#949;		
	&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#949;&#953;&#962;    	&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#949;&#964;&#949;	&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#949;&#943;&#962;	&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#949;&#943;&#964;&#949;				
	&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#949;&#953;      	&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#959;&#965;&#957;	&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#949;&#943;		&#952;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#959;&#973;&#957; 			
								
Pr. P.	I have discovered, invented			I have been discovered, invented				
	&#941;&#967;&#969; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#949;&#953;				&#941;&#967;&#969; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#949;&#943; 			
	&#941;&#967;&#949;&#953;&#962; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#949;&#953; 	etc.			&#941;&#967;&#949;&#953;&#962; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#949;&#943;	etc.		
								
P. P. 	I had discovered, invented			I had been discovered, invented				
	&#949;&#943;&#967;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#949;&#953;				&#949;&#943;&#967;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#949;&#943; 			
	&#949;&#943;&#967;&#949;&#962; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#949;&#953;  	etc.			&#949;&#943;&#967;&#949;&#962; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#949;&#943;  	etc. 		
								
F. P.	&#921; will have discovered, invented		I will have been discovered, invented					
	&#952;&#945; &#941;&#967;&#969; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#949;&#953; 	etc.			&#952;&#945; &#941;&#967;&#969; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#949;&#943; 	etc.		
				   	Subjunctive 	(with &#957;&#945;, &#947;&#953;&#945; &#957;&#945;, &#972;&#964;&#945;&#957;, etc.)		
P. 	&#957;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#960;&#964;&#969; 	that I may discover    	&#957;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#960;&#964;&#959;&#956;&#945;&#953;      that I may be discovered					
P. S. 	&#957;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#969; 		that I might discover	&#957;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#974;          that I might be discovered				
P. P. 	&#957;&#945; &#941;&#967;&#969; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#949;&#953; 	that I may have 		&#957;&#945; &#941;&#967;&#969; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#949;&#943; 	that I may have been 			
				    	Imperative			
P. 	&#945;&#957;&#945;&#954;&#940;&#955;&#965;&#960;&#964;&#949; (sing.) 	be discovering		-				
	&#945;&#957;&#945;&#954;&#945;&#955;&#973;&#960;&#964;&#949;&#964;&#949; (pl.)	be discovering		-				
P. S. 	&#945;&#957;&#945;&#954;&#940;&#955;&#965;&#968;&#949; (sing.) 	discover		&#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#959;&#965; (sing.) 	be discovered			
	&#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#949;&#964;&#949; (pl.) 	discover		&#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#964;&#949;&#943;&#964;&#949; (pl.) 	be discovered			
				    	Infinitive			
	&#957;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#973;&#968;&#949;&#953; 		to discover		&#957;&#945; &#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;&#949;&#943; 	to be discovered		
				    	 Participle			
	&#945;&#957;&#945;&#954;&#945;&#955;&#973;&#960;&#964;&#959;&#957;&#964;&#945;&#962; 	discovering		&#945;&#957;&#945;&#954;&#945;&#955;&#965;&#966;&#952;-&#949;&#943;&#962;, -&#949;&#943;&#963;&#945;, -&#941;&#957;      discovered

r937 · January 14, 2011, 3:13pm

yeah, you would have to seriously massage that before it is import-worthy

no blank cells
everything in a column must come from the same domain, i.e. be the “same type” of data

ddelmonte · January 14, 2011, 4:43pm

What do you mean by same type of data? strings? text?

Thanks

r937 · January 14, 2011, 4:47pm

you appear to have the english term and its various definitions in the same column

but those would be different columns in the table, no?

like, you could have an excel sheet with author on one row and the author’s books on subsequent rows, and you could have the author’s name “share” the same column as the book’s title – but they would be different columns in the table

thus you have to semantically “untangle” them (distinguish between data domains) before loading

ddelmonte · January 14, 2011, 4:53pm

Got it… Thank you Sir.

If you think of automated ways to handle this, let me know