export then email doesn't send whole file
Scott Nelson
scott at logicdatasystems.com
Wed Jun 12 09:11:49 PDT 2013
Close the file:
::close ab
On 6/12/2013 11:02 AM, scooter6 at gmail.com wrote:
> 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
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
More information about the Filepro-list
mailing list