Formify - Export: How can I update the cache per record in bulk, or not read from the cache?

Permalink
There was an instance of needing to write a script that updates the FormifyAnswers table with different values. (formatting reasons)

The problem enters when we run the export on the form. I concluded it uses the cache column of the FormifyRecords table. To my knowledge, I'm looking for help doing one of the following:
1. A way for the form export to not read the cache column
2. A way to bulk rescan/update the cache per record with the correct values we updated in the FormifyAnswers table.

I know option 2 would work because in the admin I can "rescan" a single record in the dashboard and it updates the answers as expected and then shows up correctly in the export. There's just a lot of records to go thru and I wasn't seeing a bulk rescan option.

Thank you for any ideas!

2 Attachments

Fjorge
View Replies:
hutman replied on at Permalink Reply
hutman
What version of Formify are you using? I have a few installs with the latest version and the schema doesn't look like this.
Fjorge replied on at Permalink Reply
Fjorge
o you know what, I got this confused with another concrete5 site we work on that is more up to date - This one is significantly older than I was thinking it was:

# concrete5 Version
Core Version - 5.7.5.1
Version Installed - 5.7.5.1
Database Version - 20150713000000

# concrete5 Packages
Blend Formify (1.0.3), Formify (1.0.3).

Soooo I suppose this puts me in the wrong forum area. Quick question - do i need to delete this one and make it under the old 5.7 forum or is there an easier way to re-categorize it?
hutman replied on at Permalink Reply
hutman
This is still technically the correct forum area, just important information as the schema has changed pretty significantly since the version you are using. This problem might actually be fixed in the newer version, but I am not sure what it's minimum core requirement is.