exporting MEMO along with other data

Bill Randall wrandall at fptech.com
Tue Aug 15 11:16:35 PDT 2017


I was not consistent in my explanation.

It should ""{memofield


On 8/15/2017 2:14 PM, Bill Randall wrote:
> I do not have 5.0.05 to test with but I am pretty sure we have been doing this internally since early 5.0
> It does work this way in 5.7 and higher.
> Note the syntax for handling memo fields is a little different than regular fields.
> When assigning it, precede it with {""
>
>     invfile(42)=""{invy(367)
>
> Bill
>
> On 8/15/2017 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170815/707c30f2/attachment.html>


More information about the Filepro-list mailing list