 |
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: 7970
|
|
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: 7970
|
|
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: 7970
|
|
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
|
|
|