exporting MEMO along with other data

[Mike Fedkiw]

I was pretty excited after reading this hoping it might be that simple.

But after changing the invfile(42)=invy(367) to invfile(42)=""{invy(367) 
the result was no different. I still wind up with a blank column in the 
export file, ugh.


Mike



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
>>
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> 
> 	Virus-free. www.avast.com 
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> 
>
>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170815/253fcae6/attachment.html>