export then email doesn't send whole file
scooter6 at gmail.com
scooter6 at gmail.com
Wed Jun 12 09:02:53 PDT 2013
I have an export where our marketing people can set select whatever
criteria they want
It then asks them for the name of the file to output to csv....and their
name to email it
it runs /fp/rreport client -f exportCLI -u -x
and runs the following process:
top:aa=""
:input aa(20,*) "What do you want to name the file? (i.e. flclients.csv
)"
:ba=""
:input ba(5,*) "Who are you? (i.e. Kalan, Jim)":
:aa="" or ba=""
:goto top:
::ab(44,*)="/appl/fpmerge/cliexport/"{aa:
::export ascii cli=(ab) r=\n f=, o=" c=":
::cli(1)=1;cli(2)=2;cli(3)=3;cli(4)=4;cli(5)=5;cli(6)=6;cli(7)=7;cli(8)=8:
::cli(9)=17-"1";cli(10)=67;cli(11)=75;cli(12)=77;:
::ac(4,.0)=@td-67:
::cli(13)=ac:
::x(10,.0,g)=x+"1":
::end:
@done::beep;msgbox "A total of"<x<"Records were selected...Press Enter":
::system "/appl/fpmerge/cliexport/send_file.scr"<aa<ba:
So as you can see, using the parameters the user enters, it calls the
send_file script which basically is just using mutt to send the file..
The problem is, once the csv files arrives in the users Inbox, it rarely
has all the records in it (every now and then it does, but typically gets
cut off somewhere)
However, if I go look in the directory where the file gets created, all of
the records are there
If I send the file from the command line using mutt just like my script
does, then the file will arrive fully intact with all the records?
I even put a sleep command (sleep 10) in the beginning of my script - just
in case the file hadn't been written out completely, but that didn't change
anything....
What would cause this behaviour? It's as if the email trigger gets called
prior to the entire file being 'written to disk' or something?
Any insight would be appreciated
Scott
PDM
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20130612/f9b9d3a3/attachment.html
More information about the Filepro-list
mailing list