Copy excel file from Linux server to Windows server

[weezerboy]

I have excel files on a Linux server that I need to copy to a windows server.

So I can read the excel file on the windows server and use the data to autofill PDF's.

Ideally, I would like to avoid the file transfer and just read from the excel on the Linux server.

But the Linux server only hasRailo, but no CF, so I can't use <cfspreadsheet to read the needed info.

Assuming all this is true, I need to copy the file from Linux server to Windows server.

How do I do that?

[WolfShade]

If the Linux server has FTP turned on and ready, you can use CFFTP to transfer the files to CF.

If you have Samba set up, you can just xfer the files via drag-n-drop.

V/r,

^ _ ^

UPDATE:  Actually, if you have Samba configured, you can set up a virtual drive on the Windows server and use CFDIRECTORY to get a list of the files, and then CFFILE to read the files on the Linux server.

[weezerboy]

Ideally, I'd like to just read from the excel file on the linux server and avoid the step of the file copy from linux to windows.

Is it possible to read from the excel file on a Linux , Railo server so that I can use it to create PDFS on my windows server?

[WolfShade]

Check my update.  You can "map" a Windows drive to the folder on the Linux server if you have Samba configured.  Then use CFDIRECTORY to list the folder contents and CFSPREADSHEET to create an Excel object from the file(s).  From there, it's up to you.

HTH,

^ _ ^

[weezerboy]

which server would samba be configured on? Windows or Linux

Also I need this to run as a scheduled task so I can drag and drop

[WolfShade]

Samba is a Linux utility for connecting to and seeing files on Windows servers.

Setting up a Scheduled Task shouldn't be a problem, if the Linux folder containing the files is mapped on the Windows server.

V/r,

^ _ ^

[weezerboy]

just to make sure the file I need to read from is currently on the Linux server