File Saving to UNIX

A

Adrian

Member²
I know this topic has been discussed before, but I am having trouble saving files directory to my UNIX directory. I have set up a NFS link and all the files come through with a ^M appearing at the end of each line. I understand this is a result of the different control character that windows/unix uses to interpret a carriage return.

I was wondering if some save function to UNIX File system would be implemented at a later version of PL/SQL developer?

I tried installing the ftp plugin, but I cannot navigate into sub-directories. The ftp windows simply refreshes and puts me back in the root directory.

Thanks,

Adrian
 
Adrian,

I had the same problem and implemented a "Save in UNIX format" plug-in a few years ago (on v4 I think) but have since moved jobs several times since then, and lost the source code & dll. However, it's very do-able so maybe one of the other plug-in writers here could help you out - I no longer have access to a Delphi dev platform. Or even Marco could stick it on the Enhancement request list.

D.
 
Hey, Marco, do you know if plug-ins are possible with the FreePascal compiler?

And, do you know if Direct Oracle Access can be used with FreePascal?
 
If FreePascal can create a DLL then it should be doable. Direct Oracle Access requires Delphi though.
 
Originally posted by Adrian:
I know this topic has been discussed before, but I am having trouble saving files directory to my UNIX directory. I have set up a NFS link and all the files come through with a ^M appearing at the end of each line. I understand this is a result of the different control character that windows/unix uses to interpret a carriage return.

I was wondering if some save function to UNIX File system would be implemented at a later version of PL/SQL developer?

I tried installing the ftp plugin, but I cannot navigate into sub-directories. The ftp windows simply refreshes and puts me back in the root directory.

Thanks,

Adrian
Click to expand...
Problem related to ^M is how you tranfer the file.
Make sure that mode you are using is character NOTbinary
 
Originally posted by Adrian:
I know this topic has been discussed before, but I am having trouble saving files directory to my UNIX directory. I have set up a NFS link and all the files come through with a ^M appearing at the end of each line. I understand this is a result of the different control character that windows/unix uses to interpret a carriage return.

I was wondering if some save function to UNIX File system would be implemented at a later version of PL/SQL developer?

I tried installing the ftp plugin, but I cannot navigate into sub-directories. The ftp windows simply refreshes and puts me back in the root directory.

Thanks,

Adrian
Click to expand...
Hi Adrian, The pluggin "ftp" to be used in pl/sql developer, transfer file in format ascii (text), check the manual: "All transfers by the FTP Plug-In are done in ASCII mode so cr/lf are converted to the native format of your server.". So, if you are using another program to transfer this files, make sure set mode in ascii before of transfer files.

Bye.
 
I can't use the ftp plugin - it doesn't work on my PC (I cannot navigate into sub-directories).

I have an NFS link set up to save directly to the UNIX box. I also use Gvim (which saves perfectly to my UNIX directory as it understands the host is UNIX not WINDOWS).

What I need is a plugin or addition to PL/SQL editor that can understand I am saving DIRECTLY to UNIX and change the return control character from WINDOWS to UNIX so that the ^M does not appear at the end of each line.
 
Adrian,

You could, of course, just run the resulting saved file through

tr -d \\r

on the UNIX system. This will result in the ^M characters at the end of each line being deleted.

D.
 
Thanks D - I have something like this that I use, but I am a lazy developer and want everything automated...

Doesn't look like there is going to be anything in PL/SQL Developer to cater for this, I am suprised that more people don't need this feature.
 
Agreed! I have worked on many sites where a Samba link was used to connect directly to UNIX directories and the code was saved there.

Moreover, TOAD has an option to "Save source files in UNIX format", so seems sensible to include it. Anyone volunteering to re-write a plug-in yet ?

D.
 
i dont know whats going on but the ftp plugin that you download from the addins page has worked like a charm for me. i have had no issues saving to unix boxes, be they solaris or linux. in fact, its worked so well that i have a "save unix" shortcut assigned, shift-ctrl-s.
 
The ftp plugin works fine in the sense that I can save files to our UNIX development box, but I cannot navigate to sub-directories. This makes the time-saving aspect of not having to open a separate ftp session useless, As I can save to my home directory and then I have to copy the file to the necessay sub-directory. Whenever I try to navigate into a sub-directory using the ftp plugin the screen simply refreshes and I am back in my home directory. :mad:
 
I will send you a debug version of the FTP dll shortly so that we can determine what exactly goes wrong when you try to go to a subdirectory.
 
OK. The new version of the ftp plugin seems to solve the problem in so far as I can now navigate to the sub-directories within the unix box and save the files. however, I still seem to have the issue that it is saving in a Windows format (the ^M is appearing still at the end of each line).

Am I missing a setting on this one or is it a problem? :confused:
 
This would indicate a binary transfer. An ascii FTP transfer would implicitly convert LF and CR/LF pairs according to the platform.

Can you send me the ftplog.txt file that is generated in the PL/SQL Developer directory?
 
I get the same thing - ^M's with this version, so there's more than one person that it happens to. I'm looking forward to the fix, because I really like the ftp plug-in when it works.

Have a good day,

Mike
 
You must log in or register to reply here.

Similar threads

Z
  • Discussion Discussion
PLSD revert code to an earlier version?
Replies
1
Views
277
Marco Kalter
Marco Kalter
Claus Pedersen
  • Discussion Discussion
PLD crashes when used from remote desktop and maybe cloud/non-cloud database
Replies
1
Views
560
Marco Kalter
Marco Kalter
Claus Pedersen
  • Discussion Discussion
File browser Properties window is shown in all white using dark theme
Replies
3
Views
424
Claus Pedersen
Claus Pedersen
T
  • Discussion Discussion
Opening workset containing a link to an absent file
Replies
2
Views
999
Tim Scott
T
Z
  • Discussion Discussion
Open window type by file type
Replies
5
Views
5K
Marco Kalter
Marco Kalter
Back
Top