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