<div dir="ltr"><div>That's exactly what it was....it needed the 'close cli' statement.......ugh...I always forget that ha</div><div>thanks guys</div><div> </div><div>Scott</div></div><div class="gmail_extra"><br>
<br><div class="gmail_quote">On Thu, Jun 13, 2013 at 3:28 PM, Jeff Harrison <span dir="ltr"><<a href="mailto:jeffaharrison@yahoo.com" target="_blank">jeffaharrison@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
>________________________________<br>
> From: Jean-Pierre A. Radley <<a href="mailto:appl@jpr.com">appl@jpr.com</a>><br>
>To: FilePro Mailing List <<a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>><br>
>Sent: Thursday, June 13, 2013 2:13 PM<br>
>Subject: Re: export then email doesn't send whole file<br>
<div><div class="h5">><br>
><br>
><a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> propounded (on Wed, Jun 12, 2013 at 12:02:53PM -0400):<br>
>| I have an export where our marketing people can set select whatever<br>
>| criteria they want<br>
>| It then asks them for the name of the file to output to csv....and their<br>
>| name to email it<br>
>|<br>
>| it runs /fp/rreport client -f exportCLI -u -x<br>
>|<br>
>| and runs the following process:<br>
>|<br>
>| top:aa=""<br>
>| :input aa(20,*) "What do you want to name the file? (i.e. flclients.csv<br>
>| )"<br>
>| :ba=""<br>
>| :input ba(5,*) "Who are you? (i.e. Kalan, Jim)":<br>
>| :aa="" or ba=""<br>
>| :goto top:<br>
>| ::ab(44,*)="/appl/fpmerge/cliexport/"{aa:<br>
>| ::export ascii cli=(ab) r=\n f=, o=" c=":<br>
>| ::cli(1)=1;cli(2)=2;cli(3)=3;cli(4)=4;cli(5)=5;cli(6)=6;cli(7)=7;cli(8)=8:<br>
>| ::cli(9)=17-"1";cli(10)=67;cli(11)=75;cli(12)=77;:<br>
>| ::ac(4,.0)=@td-67:<br>
>| ::cli(13)=ac:<br>
>| ::x(10,.0,g)=x+"1":<br>
>| ::end:<br>
>| @done::beep;msgbox "A total of"<x<"Records were selected...Press Enter":<br>
>| ::system "/appl/fpmerge/cliexport/send_file.scr"<aa<ba:<br>
>|<br>
>| So as you can see, using the parameters the user enters, it calls the<br>
>| send_file script which basically is just using mutt to send the file..<br>
>| The problem is, once the csv files arrives in the users Inbox, it rarely<br>
>| has all the records in it (every now and then it does, but typically gets<br>
>| cut off somewhere)<br>
>| However, if I go look in the directory where the file gets created, all of<br>
>| the records are there<br>
>| If I send the file from the command line using mutt just like my script<br>
>| does, then the file will arrive fully intact with all the records?<br>
>|<br>
>| I even put a sleep command (sleep 10) in the beginning of my script - just<br>
>| in case the file hadn't been written out completely, but that didn't change<br>
>| anything....<br>
>|<br>
>| What would cause this behaviour? It's as if the email trigger gets called<br>
>| prior to the entire file being 'written to disk' or something?<br>
>|<br>
>| Any insight would be appreciated<br>
>|<br>
><br>
>What version of mutt are you using, and what mutt command?<br>
><br>
>--<br>
>JP<br>
<br>
</div></div>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<br>
<br>
Good luck.<br>
<br>
Jeff Harrison<br>
<a href="mailto:jeffaharrison@yahoo.com">jeffaharrison@yahoo.com</a><br>
<br>
Author of JHExport and JHIMport.<br>
<div class="HOEnZb"><div class="h5"><br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br></div>