Close





Lost Password?
No account yet? Register
Increase font size Default font size Decrease font size Narrow screen resolution Wide screen resolution Auto adjust screen size default color red color blue color yellow color orange color
Support Forum
Welcome, Guest
Please Login or Register.    Lost Password?
Support Forum Forum Support
Re:How to load data from multiple files\ (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: Re:How to load data from multiple files\
#3
Michael10 (User)
Fresh Boarder
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
Birthdate: 2001-01-01
How to load data from multiple files 3 Years, 11 Months ago Karma: 0  
Hi.

I've been using Visual Importer for a while now and quite happy with the results.

I have to load multiple files into one table.

Names of files of are not sequntional like
inv01.txt
inv05.txt
inv10.txt
and so on

Is it possible to load these files in one go?
Thanks,
Michaer
[ Edited ]
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4
mike8888 (User)
Fresh Boarder
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
RE: How to load data from multiple files 3 Years, 11 Months ago Karma: 0  
Hi.

It is actually very simple.
What you need to do is to specifiy mask
c:\files\inv??.txt

Support Team
DB Software Laboratory
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#5
Michael10 (User)
Fresh Boarder
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
Birthdate: 2001-01-01
RE: How to load data from multiple files 3 Years, 11 Months ago Karma: 0  
Thanks,
That worked
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#553
alanimal (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Re:How to load data from multiple files 2 Months, 2 Weeks ago Karma: 0  
howdy doody,

I am trying to do this within Visual Importer Enterprise, but I cannot get this to work.

In the Template code, I have the follwing - but it doesnt work - can you tell me what the values should be to get the above to happen?

SourceFile=c:files
Directory=c:files
Filter=
FileUseMask=True
FileMask=c:filesinv??.txt

Thanks in advance
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#554
admin (Admin)
Admin
Posts: 31
graph
User Online Now Click here to see the profile of this user
Re:How to load data from multiple files 2 Months, 2 Weeks ago Karma: 0  
When you say it does not work are you getting any error messages?

I think backslashes are missing

SourceFile=c:files => SourceFile=c:\files\yourfilename.txt

Peter
 
Report to moderator   Logged Logged  
 
Last Edit: 2008/09/03 12:30 By admin.
  The administrator has disabled public write access.
#555
alanimal (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Re:How to load data from multiple files 2 Months, 2 Weeks ago Karma: 0  
agh sorry left out the slashes

should be:

SourceFile=c:files
Directory=c:files
Filter=
FileUseMask=True
FileMask=c:filesinv??.txt

the error I get is "Source File:C:files not found!"

cheers
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoard
 

Main Menu

Home
News
Links
Press Releases
FAQs
Contact Us
Awards
Search

Order Now


Latest News

What our customers say

 "We did a lot search and finally managed to find a solution Visual Importer Enteprise .

It was amazing how simple it was:

We created dedicated email account, designed package and with one hour we were able to start processing our data"

John Talker
 

Popular Downloads