I am running a retrieve and report and then need to FTP that file. I have it working  when I am in single user on my Dev machine, however I need help understanding how to deal with the file on the server side when using @Insert()


The code below generates the file and in multi user it places the file on the server in C:\sesame but the @Insert() is looking for it on the client. so it does not get the data to send properly.

What is the proper method to deal with this?
My Mickey Mouse /  Rube Goldberg  thought was to create a batch file that copies or moves the file from the server to a shared drive and have @Insert() read it from there.

Thanks


Subroutine sendftptoMach()
var vFile as String
var vSource as String

vSource = @Insert("C:\sesame\OrderMonthDat.txt")

Ftp("www.placegoing.com", "username", "Password", "OrderMonthDat.txt" , Vsource)

     If @Error Then
     {
                 @Msgbox("The send failed", "", "friggin try something else")


     }


End subroutine


Var VStr as string
var vRun as Int

// Loads an already saved retrieve spec for use
vStr = @SpecCommand(SPEC_OPERATION_LOAD, SPEC_TYPE_RETRIEVE, "OrdersMonth")
// Runs the currently loaded retrieve spec
vStr = @SpecCommand(SPEC_OPERATION_RUN, SPEC_TYPE_RETRIEVE, "")

// Loads an already saved sort spec for use
//vStr = @SpecCommand(SPEC_OPERATION_LOAD, SPEC_TYPE_SORT, "RepStatRef")
// Runs the currently loaded sort spec
//vStr = @SpecCommand(SPEC_OPERATION_RUN, SPEC_TYPE_SORT, "")


     If @Mode() = 1
     {
           vRun = @LoadExportSpec("webexp1")
           If vRun = 1
           {
                 
           RunExportSpec("c:\Sesame\OrderMonthDat.txt",",","",0,1,0,1,0,1,0,0)

           // Clears the current retrieve spec
           vStr = @SpecCommand(SPEC_OPERATION_CLEAR, SPEC_TYPE_RETRIEVE, "")
           
           // Run subroutine to FTP data to a file on web server
           sendftptoMach ()
           
           }
     }

Probably fine.

I prefer the use of UNC paths instead. Hopefully, someday, MS will implement "drive mounting", where any filesystem can be mounted as a directory. But, until then, the UNC path is about as close as you can get.

BOBSCOTT wrote on Sep 24^th, 2012 at 5:04pm:


I got a good chuckle when I came across that line. I guess I just didn't expect something funny in a line of code, but that just got me laughing out loud. In my head I heard it in the voice of Napoleon Dynamite.

BOBSCOTT wrote on Sep 25^th, 2012 at 8:26pm:


Gotcha, and it makes perfect sense. I've just seen too many setups where an IT guy created a mapped drive on the server that pointed back to the server and wondered why it was slow and didn't want you to go down that path.

BOBSCOTT wrote on Sep 25^th, 2012 at 8:26pm:


Nah, the only time I laugh at you is when you tell me you're gonna send me Zappa music...

-Ray