exporting MEMO along with other data

Bruce Easton bruce at stn.com
Tue Aug 15 10:39:17 PDT 2017


Mike - the 'memo xx export...' command line should export the data from 
the memo field to the destination you specify in that command.  It is 
then up to you to read that resulting memo-exported file so that you can 
then output the data as desired in your 'invfile' export file.

In place of "invfile(42)=invy(367)", you may want to have a 'gosub 
getmem, where that subroutine would:

1.  export the memo field
2.  read the exported memo field file from step 1 (for instance, using 
readline loop)
3.  massage/select_from the data read in step 2 in order to:
4.  then assign to invfile(42) what you need there

On 8/15/17 12:48 PM, Mike Fedkiw via Filepro-list wrote:
> windows server 2008 r2,filepro 5.0.05dn9
>
> The line below is what I've been using to export the selected fields 
> information into a file. It's been working pretty good now, at least 
> until it gets to the field containing the memo which always winds up 
> to be a blank column.
>
> export multi invfile=c:\!Output\eBay\eBayInvy.slk
>
> In the help I see this...
>
> "MEMO xx EXPORT filename    Exports the MEMO field xx to the specified 
> filename"
>
> From that I have no clue how to get it to do what I'm needing as far 
> as the memo.
>
> I've got a ton of fields currently being exported into this file which 
> all work just fine like...
> invfile(1)=invy(1)
> invfile(2)=invy(14)
> invfile(3)=invy(68)
> invfile(4)=invy(112)
> etc...
> but when it gets to  "invfile(42)=invy(367)", I just get a blank 
> column in the export file. invy(367) is the field containing the 
> (16,memo) edit.
>
> Can someone please help me with this?
>
> P.S. I hope this isn't going to be a re-post because I thought I 
> posted this a couple days ago but never saw it come across.
>
> Mike
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: 
> <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170815/7fe803a7/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



More information about the Filepro-list mailing list