Mike,
As you suggested using web forum from now on
Thanks for your efforts to date. I do have a work around as I mentioned in a previous email so this takes the pressure off some; I am just running an SQL script that does a bulk Copy and it works fine. The only issue is it requires the data to reside on the PostgreSQL server, so I need an open share on the server and I move it to the server share using one of your file operations.
I need to look at that rejected record you received in your test; that data should have been clean and looking through it the Invoice Number looks fine here on the copy of the same file I have. I have already imported that file on the live system with no errors, not sure what that is all about unless the file was damaged in getting it to you.
I will test this from my side via the VPN and maybe with a local PostgreSQL server using Vista as the client and see if it works. I know it works fine for MS SQL I did my initial testing here with one of my MS SQL servers and it was great. The client will be purchasing the program so I do need to get the import Wizard working with their PostgreSQL
server and their client in the near future. They have lots of little jobs that could be automated with your tool.
I have one unrelated question; with your FTP application should I be able to move files on the remote FTP server by using the rename function. I have noticed many FTP clients seem to do a move by just doing a rename. Should this work with your FTP module and most FTP servers? Or how would you recommend I do a move? My first attempt
failed doing the rename. I have done the same operations with my login credentials using FileZilla FTP Client and it all worked, so I do have the correct access rights. I would like to move the successfully downloaded files to an archive on the remote FTP server as a backup.
Jim
