FilePro Mass Update

[Fairlight]

Understand that filePro has system-maintained fields (@cd, @ud, and others)
which will not be accurate if you export, alter, and re-import.

That can be a largely downside, depending upon your needs.

m->


On Thu, Aug 01, 2019 at 03:44:28PM +0000, Seijyaku via Filepro-list thus spoke:
> Yes, rcabe, dcabe, and dmoedef available.
> 
> What I have currently is an old application with several custom integrations and hundreds of databases, one of which holds over 100,000 address records, most of which have missing or incorrect country data.
> 
> I have written a small application that uses the map and key files to export the data to a CSV and it would be a minor task to re-write it so that it would be capable of writing data as well.  There are several obvious concerns when updating raw datastores outside of the host application: indexes, file locks, record locks, data clobbering, and updating related data in other databases (I'm assuming FilePro does this as there appears to be duplicated data between some databases).
> 
> I can run my process after hours which will mitigate the risk of lock issues and data clobbering, but don't know what other data might need to be updated that would be missed by using this approach ? I'm assuming not much as country seems to have been an after-though.
> 
> The alternative appears to be writing some kind of import process within FilePro that will either process each record of the CSV file or each record in FilePro, look up the correlating record in the other dataset, and update the FilePro record with the relevant CSV data.
> My stopping point with this solution is that I am not familiar with FilePro and would need specific instructions or a tutorial on how to implement it.
> 
> Given my skill set and the options at hand, I feel that the least risky option is to re-write my existing script to allow updates.  The country field seemed to be more of an afterthought and likely isn't tied to anything else.
> 
> 
> Sent with ProtonMail Secure Email.
> 
> ??????? Original Message ???????
> On Wednesday, July 31, 2019 1:10 PM, Nancy Palmquist via Filepro-list <filepro-list at lists.celestial.com> wrote:
> 
> > 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
> >
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list

-- 
Audio panton, cogito singularis.