export then email doesn't send whole file

[Jeff Harrison]

>________________________________
> From: Jean-Pierre A. Radley <appl at jpr.com>
>To: FilePro Mailing List <filepro-list at lists.celestial.com> 
>Sent: Thursday, June 13, 2013 2:13 PM
>Subject: Re: export then email doesn't send whole file
> 
>
>scooter6 at gmail.com propounded (on Wed, Jun 12, 2013 at 12:02:53PM -0400):
>| 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
>| 
>
>What version of mutt are you using, and what mutt command?
>
>-- 
>JP

Is it possible that the automatic close of the file does not occur until after the @done processing?  It sounds like that is the case.  Try executing a "close cli" as the first thing after @done

Good luck.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHIMport.