  | 
			
				SoftTree Technologies 
				Technical Support Forums
			 | 
		 
		  | 
	 
	 
	
	
	
		
	
	
	
		| Author | 
		Message | 
	 
	
		
			Shawn Martin 
			 
			
  
			
			
				Joined: 15 Nov 2004 Posts: 15
  | 
			 
			  
		 | 
		
			
				  DatabaseImport | 
				     | 
			 
			
				I am getting error message #8 - Error importing file,  not a tab-separated file. The problem is the file is tab-  separated and was created with FileReplaceEx to create the  tabs. What else could be the problem? 
   | 
			 
		  | 
	 
	
		| Wed Jan 12, 2005 7:49 pm | 
		          | 
	 
	
		  | 
	 
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				  Re: DatabaseImport | 
				     | 
			 
			
				Does it have .TXT extension?  : I am getting error message #8 - Error importing file,  : not a tab-separated file. The problem is the file is tab-  : separated and was created with FileReplaceEx to create the  : tabs. What else could be the problem?   
   | 
			 
		  | 
	 
	
		| Wed Jan 12, 2005 8:12 pm | 
		          | 
	 
	
		  | 
	 
	
		
			Shawn Martin 
			 
			
  
			
			
				Joined: 15 Nov 2004 Posts: 15
  | 
			 
			  
		 | 
		
			
				  Re: DatabaseImport | 
				     | 
			 
			
				: Does it have .TXT extension?  No, it doesn't. I was trying to use Filerename, but getting  another error. Does filerename support wildcards? 
   | 
			 
		  | 
	 
	
		| Wed Jan 12, 2005 10:40 pm | 
		          | 
	 
	
		  | 
	 
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				  Re: DatabaseImport | 
				     | 
			 
			
				No, it currently doesn't support wildcards. To load multiple files using wildcards use DirEx with a LoopWhile and DatabaseImport in it. Please note that files must have .TXT extensions, this is how they are recognized as tab-separated files. DatabaseImport currently supports .TXT and .DBF files. Future versions of DatabaseImport will support CSV, XLS and some other file types. File extension is and will be used as a standard way to determine file type.  : No, it doesn't. I was trying to use Filerename, but getting  : another error. Does filerename support wildcards?   
   | 
			 
		  | 
	 
	
		| Wed Jan 12, 2005 11:09 pm | 
		          | 
	 
	
		  | 
	 
	
		
			Shawn Martin 
			 
			
  
			
			
				Joined: 15 Nov 2004 Posts: 15
  | 
			 
			  
		 | 
		
			
				  Re: DatabaseImport | 
				     | 
			 
			
				: No, it doesn't. I was trying to use Filerename, but getting  : another error. Does filerename support wildcards?  I ConCat the filename so I didn't have to use wildcards, and  FileRename worked. Now I get an error message, "User cancelled the  import when I try to execute DatabaseImport. 
   | 
			 
		  | 
	 
	
		| Thu Jan 13, 2005 8:21 am | 
		          | 
	 
	
		  | 
	 
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				  Re: DatabaseImport | 
				     | 
			 
			
				In most cases this error is a result of failed data validation. For instance, if in a date-type column you have invalid date or spaces or "N/A" instead or a valid date value (or just nothing which is treated as NULL) it would lead to the described error. Other common causes are: text in a character-type column exceeds column size; problem with number conversion if you have hundreds or thousands separators. Numbers can have decimal separator only.  : I ConCat the filename so I didn't have to use wildcards, and  : FileRename worked. Now I get an error message, "User cancelled the  : import when I try to execute DatabaseImport.   
   | 
			 
		  | 
	 
	
		| Thu Jan 13, 2005 11:09 am | 
		          | 
	 
	
		  | 
	 
	
		 | 
	 
 
  
	 
	    
	   | 
	
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
  | 
   
 
		 | 
	 
	  |