<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#330099" bgcolor="#FFFFFF">
<tt>I would ask if you have a development version of filePro or just
a runtime version.<br>
<br>
If you are able to export the data, you might have those tools.<br>
<br>
The process-only reports are intended for times when you need to
modify data based on logic/selection criteria.<br>
<br>
I am not clear if, once updated, the filepro data file will still
be used under filepro or it is going into some other database.<br>
<br>
If you intend to update the file from outside filepro, it can
cause issues for a native filepro database. The 20 bytes at the
beginning of a record hold binary data. Also indexes might be
affected. They can however, be removed and rebuilt after changes
are applied if that is a consideration.<br>
<br>
See if your Linux version has these files in the fp folder.
dcabe/rcabe dmoedef<br>
<br>
The first writes the processing tables and dmoedef will start the
output format.<br>
<br>
This is where you would make a process -only output and indicate
in the processing what or how the data should change.<br>
<br>
For example, all the records selected might get a price increase
by multiplying the price by 1.10.<br>
<br>
When you run an output, you will indicate the database name, the
process name, the order the records should be processed and then
select the records that should be included. The processing will
apply the logic given to each record selected.<br>
<br>
For example, If all items that start with A get a price increase
of 1.10 the existing price but all items that start with B get a
1.25 price increase, the processing will make that distinction.
Using simple IF:THEN: logic structure.<br>
<br>
IF: 10 eq "A" THEN: 5=5*"1.1"<br>
IF: 10 eq "B" THEN: 5=5*"1.25"<br>
<br>
Where field 10 is the item name and field 5 is the price.<br>
<br>
I hope this helps as you try to accomplish your task.<br>
<br>
Nancy<br>
</tt><br>
<div class="moz-cite-prefix">On 7/30/2019 11:42 AM, Seijyaku via
Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:5X31rYPcrLws4u9OF6XDqF0vLX_QQxB0-FuFVIEVwbHtexOeMogQq36dpmBF2-WVhWZElqA5f4_fMapiDHhMcmqc-icpk-Vth5s_XxuUItw=@protonmail.com">
<pre class="moz-quote-pre" wrap="">What is the easiest way to update several FilePro records programmatically?
I apologize in advance that I'm not familiar with FilePro, but have been asked to help clean up some of the data. I'm using FilePro 5.0.R14 on Linux, the data I'm working with is in a single folder, and I've been able to export it along with the record number. I'm hoping for a simple command-line interface that I can write a script to access, but am open to other suggestions.
I have spent the last week looking over the great depth of information in both YouTube videos and the online manual, but haven't been able to find anything that would work yet. A point in the right direction would be greatly appreciated.
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: <a class="moz-txt-link-freetext" href="http://www.vss3.com">http://www.vss3.com</a>
</pre>
</body>
</html>