SitePoint Sponsor

User Tag List

Results 1 to 7 of 7

Thread: Data Import

  1. #1
    SitePoint Zealot
    Join Date
    Jan 2006
    Location
    Washington DC and Skopelos, Greece
    Posts
    71
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Data Import

    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.
    The only way I can repay your help, is to help others.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,329
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Zealot
    Join Date
    Jan 2006
    Location
    Washington DC and Skopelos, Greece
    Posts
    71
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

    Code:
    								
    P. S. 	I discovered, invented				I was discovered, invented			
    	ανακάλυψα		ανακαλύψαμε		ανακαλύφθηκα		ανακαλυφθήκαμε	
    	ανακάλυψες		ανακαλύψατε		ανακαλύφθηκες		ανακαλυφθήκατε	
    	ανακάλυψε		ανακάλυψαν		ανακαλύφθηκε		ανακαλύφθηκαν	
    								
    F. C. 	I will be discovering, inventing			I will be being discovered, invented				
    	θα ανακαλύπτω					θα ανακαλύπτομαι		
    	θα ανακαλύπτεις   	etc.			θα ανακαλύπτεσαι	etc.		
    								
    F. S. 	I will discover, invent				I will be discovered, invented			
    	θα ανακαλύψω		θα ανακαλύψουμε	θα ανακαλυφθώ		θα ανακαλυφθούμε		
    	θα ανακαλύψεις    	θα ανακαλύψετε	θα ανακαλυφθείς	θα ανακαλυφθείτε				
    	θα ανακαλύψει      	θα ανακαλύψουν	θα ανακαλυφθεί		θα ανακαλυφθούν 			
    								
    Pr. P.	I have discovered, invented			I have been discovered, invented				
    	έχω ανακαλύψει				έχω ανακαλυφθεί 			
    	έχεις ανακαλύψει 	etc.			έχεις ανακαλυφθεί	etc.		
    								
    P. P. 	I had discovered, invented			I had been discovered, invented				
    	είχα ανακαλύψει				είχα ανακαλυφθεί 			
    	είχες ανακαλύψει  	etc.			είχες ανακαλυφθεί  	etc. 		
    								
    F. P.	Ι will have discovered, invented		I will have been discovered, invented					
    	θα έχω ανακαλύψει 	etc.			θα έχω ανακαλυφθεί 	etc.		
    				   	Subjunctive 	(with να, για να, όταν, etc.)		
    P. 	να ανακαλύπτω 	that I may discover    	να ανακαλύπτομαι      that I may be discovered					
    P. S. 	να ανακαλύψω 		that I might discover	να ανακαλυφθώ          that I might be discovered				
    P. P. 	να έχω ανακαλύψει 	that I may have 		να έχω ανακαλυφθεί 	that I may have been 			
    				    	Imperative			
    P. 	ανακάλυπτε (sing.) 	be discovering		-				
    	ανακαλύπτετε (pl.)	be discovering		-				
    P. S. 	ανακάλυψε (sing.) 	discover		ανακαλύψου (sing.) 	be discovered			
    	ανακαλύψετε (pl.) 	discover		ανακαλυφτείτε (pl.) 	be discovered			
    				    	Infinitive			
    	να ανακαλύψει 		to discover		να ανακαλυφθεί 	to be discovered		
    				    	 Participle			
    	ανακαλύπτοντας 	discovering		ανακαλυφθ-είς, -είσα, -έν      discovered
    The only way I can repay your help, is to help others.

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,329
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    yeah, you would have to seriously massage that before it is import-worthy

    1. no blank cells

    2. everything in a column must come from the same domain, i.e. be the "same type" of data
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Zealot
    Join Date
    Jan 2006
    Location
    Washington DC and Skopelos, Greece
    Posts
    71
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What do you mean by same type of data? strings? text?

    Thanks
    The only way I can repay your help, is to help others.

  6. #6
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,329
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  7. #7
    SitePoint Zealot
    Join Date
    Jan 2006
    Location
    Washington DC and Skopelos, Greece
    Posts
    71
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Got it.. Thank you Sir.

    If you think of automated ways to handle this, let me know
    The only way I can repay your help, is to help others.


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •