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?
Ftp Directory Listing in Advanced ETL Processor (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: Ftp Directory Listing in Advanced ETL Processor
#653
DarkOdin (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Ftp Directory Listing in Advanced ETL Processor 9 Months, 1 Week ago Karma: 0  
A couple things I have noticed that might enhance the user experience.

1. When creating _object_s, the cursor defaults to the “Cancel” button. So if I create a new package or _object_, give it a de_script_ion, and then hit enter….it closes the box. Typically, I would expect the default to be “create” and not “cancel”.

2. When setting up the FTP _object_ inside of a package, it would be nice to have a side scroll bar (if needed) as well. After connecting to the FTP, if you have extracts whose file names exceed 35 characters, the end of the extract scrolls off the side. It makes it difficult to select the correct extract if you have extracts with the exact same name with the only difference in that they have the date appended to the end of the extract name.

3. When creating an email _object_ inside a package, the tab order (inside the advanced tab) seems a bit off. It appears the tab order is

To
Attach Check Box
Subject
Attachments 1
Attachments 2
Message Toolbar
Message Body

It seems more intuitive for the tab order to follow

To
Subject
Message Toolbar
Message Body
Attach Check Box
Attachments 1
Attachments 2.

I realize all of these are more aesthetic in nature but thought I would pass them along anyhow.

Finally, I am not sure if this is something currently possible with your tool or not. I looked through the PDF and did not see anything related to this. One Task that I need to perform is generating a list of the names of all extracts on an FTP server and then emailing this list to specific individuals. This is done prior to any validation or transformation. Basically, I would set up a mask for specific groups of extracts so each different group listing could be emailed on. Is there a way in your tool to only capture the physical extract information (File name, size, creation date etc) in a format that could be attached to an email?

Thanks,
Caleb
 
Report to moderator   Logged Logged  
 
Last Edit: 2009/06/01 01:55 By DarkOdin.
  The administrator has disabled public write access.
#655
admin (Admin)
Admin
Posts: 147
graph
User Online Now Click here to see the profile of this user
Re:Ftp Directory Listing in Advanced ETL Processor 9 Months, 1 Week ago Karma: 0  
That was very useful feed back which will benefit all users of our ETL software

OK everything is added to the latest version

Support for FTP Directory Listing
ODBC Connection String Builder was introduced
Improved support for N_onstop_ ODBC/MX 2.0 ver 3.51.20.126 ODBC Driver
Various Cosmetic Changes and Bug Fixes
Additional Option to select OLE DB Provider for Oracle was introduced

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

Testimonials

Our prior imports were done using VB. Our VB expert retired. No one in my group knows VB. So Visual Importer was the answer to the lack of VB skills problem my group experienced.
Ron Bradshaw,
IT Reporting Manager,
ConAgra Foods / Lamb Weston
 

Free Newsletter

Please provide your Name and Email address so that we can tell you about latest releases, new features and free offers.






b.150.100.16777215.0..Screenshots.AdvancedETL.aetl8.jpg
DB Software Laboratory - Intel Software PartnerDB Software Laboratory - My SQL Ready Partner
DB Software Laboratory Embacadero Technology Partner