FilePro Mass Update

Nancy Palmquist nancy.palmquist at vss3.com
Wed Jul 31 11:10:00 PDT 2019


I would ask if you have a development version of filePro or just a 
runtime version.

If you are able to export the data, you might have those tools.

The process-only reports are intended for times when you need to modify 
data based on logic/selection criteria.

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.

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.

See if your Linux version has these files in the fp folder. 
dcabe/rcabe   dmoedef

The first writes the processing tables and dmoedef will start the output 
format.

This is where you would make a process -only output and indicate in the 
processing what or how the data should change.

For example, all the records selected might get a price increase by 
multiplying the price by 1.10.

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.

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.

IF: 10 eq "A"  THEN: 5=5*"1.1"
IF: 10 eq "B"  THEN: 5=5*"1.25"

Where field 10 is the item name and field 5 is the price.

I hope this helps as you try to accomplish your task.

Nancy

On 7/30/2019 11:42 AM, Seijyaku via Filepro-list wrote:
> 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
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>

-- 
Nancy Palmquist         MOS & filePro Training Available
Virtual Software Systems    Web Based Training and Consulting
PHONE: (412) 835-9417           Web site:  http://www.vss3.com

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


More information about the Filepro-list mailing list