SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DatabaseImport

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
DatabaseImport
Author Message
Shawn Martin



Joined: 15 Nov 2004
Posts: 15

Post DatabaseImport Reply with quote

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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7970

Post Re: DatabaseImport Reply with quote

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 View user's profile Send private message
Shawn Martin



Joined: 15 Nov 2004
Posts: 15

Post Re: DatabaseImport Reply with quote

: 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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7970

Post Re: DatabaseImport Reply with quote

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 View user's profile Send private message
Shawn Martin



Joined: 15 Nov 2004
Posts: 15

Post Re: DatabaseImport Reply with quote

: 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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7970

Post Re: DatabaseImport Reply with quote

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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.