Bulk Change "No Search Record" to "Search Record"

Post Reply
Guest

Bulk Change "No Search Record" to "Search Record"

Post by Guest » Mon Jul 02, 2018 5:46 pm

When I look at the Detail tab of a person's record, some are marked as "No Search Record" and some are "Search Record".

Is there a way of changing all of the current settings from "No Search Record" to "Search Record" other than manually?

Previously it could be done by using "File/Prepare for/Heredis Mac" and opening the resulting file with an SQL Management software tool.

This feature doesn't seem available under Heredis 2017.

Does anybody have any ideas please?

Alternatively, is there a way of identifying all "No Search Records" to change them manually (this would be a terrible shortcoming with the software if this is the only way of doing this).

Thanks

User avatar
mike
Posts: 249
Joined: Mon Jan 29, 2018 9:14 am

Re: Bulk Change "No Search Record" to "Search Record"

Post by mike » Tue Jul 03, 2018 5:17 am

andrewp wrote:
Mon Jul 02, 2018 5:46 pm
This feature doesn't seem available under Heredis 2017.
No need for it any longer, the file IS in SQL format ...
Sincerely.
Mike

AuroraR8 : Intel Core i9-9900K 3,60 GHz - RAM 16 Go - SSD 1 To + RAID1 2 DD 1 To - Inverter 510 W
W10 Pro - Firefox - McAfee LiveSafe
Heredis EN + FR

Guest

Re: Bulk Change "No Search Record" to "Search Record"

Post by Guest » Wed Jul 04, 2018 3:03 pm

Thanks for the quick response.

I've opened the file but can't find the field to update as everything seems to be in French. Are you able to let me know which db table and which field within that table I need to update please?

Thanks v much.

Guest

Re: Bulk Change "No Search Record" to "Search Record"

Post by Guest » Wed Jul 04, 2018 3:31 pm

Found it! :D

In case anybody else wants to do this, the field was in a db table called EVENEMENTS and the field is RECHERCHERACT and it was changed from 0 to 1.

Hope this helps.

User avatar
mike
Posts: 249
Joined: Mon Jan 29, 2018 9:14 am

Re: Bulk Change "No Search Record" to "Search Record"

Post by mike » Wed Jul 04, 2018 3:37 pm

andrewp wrote:
Mon Jul 02, 2018 5:46 pm
Previously it could be done ...
No major change since then … and still in french …
Sincerely.
Mike

AuroraR8 : Intel Core i9-9900K 3,60 GHz - RAM 16 Go - SSD 1 To + RAID1 2 DD 1 To - Inverter 510 W
W10 Pro - Firefox - McAfee LiveSafe
Heredis EN + FR

Guest

Re: Bulk Change "No Search Record" to "Search Record"

Post by Guest » Wed Jul 04, 2018 5:34 pm

Not too sure how the last comment helps but at least it’s fixed now.

Thanks for your help.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests