Douglas "BearlyDoug" Hazard

I saw it mentioned on the WP 5.9 blog page. Look for the section titled “The Navigation block”.

That said, after re-reading this, it appears this is specific to within the editor interface itself. Wouldn’t mind another set of eyes on this to confirm that I swung and missed here (ha!)

Thanks. ??

It would seem that this should be a core feature of your plugin, especially since some calendars (Non-WordPress) have this capability (Outlook and Google both have this capability). I would definitely expect this for the pro upgrade (and not the free version), of course. ??

Thanks!

Can’t believe it was that simple, @jules-colle. Thank you!

Marking this solved. ??

Okay, I’ve tried changing

header("Content-Encoding: UTF-8"); 
header("Content-Type: text/csv; charset=UTF-8");

to cp1252, CP1252, windows-1252 and Windows-1252 with no luck.

I’ll have to defer to you how best to implement my suggested change in a more efficient manner, @arshidkv12. ??

UPDATE! I have a workaround! Two file edits, and this will allow CSV files to be directly opened within Microsoft Excel without having to use the special instructions above.

FILE: inc/admin-subpage.php (lines 462-464)
SEARCH FOR:

        echo "&emsp;<a href='".esc_html($_SERVER['REQUEST_URI'])."&csv=true&nonce=".$nonce."' style='float:right; margin:0;' class='button'>";
        _e( 'Export CSV', 'contact-form-cfdb7' );
        echo '</a>';

ADD BEFORE:

/***
 * @BearlyDoug (on www.remarpro.com) Edit: Export as Excel CSV file...
 */
	echo "<a href='".esc_html($_SERVER['REQUEST_URI'])."&csv=true&excel=true&nonce=".$nonce."' style='float:right; margin: 0 0 0 7px;' class='button'>";
	_e( 'Export as Excel CSV', 'contact-form-cfdb7' );
	echo '</a>';

FILE: inc/export-csv.php (lines 122-123)
SEARCH FOR:

                    foreach ($resultTmp as $key => $value):
                        $matches = array();

ADD AFTER:

			/***
			 * @BearlyDoug (on www.remarpro.com) Edit: Export as Excel CSV file...
			 */
			if(isset($_REQUEST['excel']) && $_REQUEST['excel'] == "true") {
				$newValue = mb_convert_encoding($value, "cp1252", "UTF-8");
				$value = $newValue;
			}

There’s probably a more efficient way to handle this… possibly by simply changing the charset to cp1252 (AKA Windows-1252). I’ll test that functionality now, and will report back in a new reply.

Hope this helps!

• This reply was modified 3 years, 3 months ago by Douglas "BearlyDoug" Hazard.
• This reply was modified 3 years, 3 months ago by Douglas "BearlyDoug" Hazard.
• This reply was modified 3 years, 3 months ago by Douglas "BearlyDoug" Hazard.

Some additional information. The file is being exported as a CSV in UTF-8 format:

root@lb17 17:41:41 
 > /data/www # file -i cfdb7-2021-08-11.csv 
cfdb7-2021-08-11.csv: text/plain; charset=utf-8

HOWEVER, if you open directly after downloading it, it opens it up in a non UTF-8 format. My coworker was kind enough to provide a workaround for this:

Instructions are:
1.	Open new excel file
2.	From the Data Tab -> Click “From Text/CSV”
3.	Point to the file downloaded
4.	On the Next Page -> file origin to 65001-Unicode (UTF-8)
5.	Click load

You might need to do some additional digging into this to see if you can force Excel to automatically open in UTF-8 format.

FYI, my excel version is “Microsoft? Excel? for Microsoft 365 MSO (16.0.14228.20216) 64-bit”

I cannot do that, because that would violate our privacy policy.

I did, however, quote a part of one of the lines, directly from the database, and from the CSV above.

Upload what? I didn’t provide any fixes. I’m asking that this be fixed. ??

@ameeker, just got confirmation that this issue has been addressed.

Thanks again for your quick response and even quicker fix!

Thank you, Angie for the quick turnaround. I’ve loaded the update and am waiting to hear back from the web team to see if they have any more issues.

I appreciate your help and assistance. ??

Good afternoon!

When I created the child theme and switched over to it, it appears that none of the settings within that theme (header logo, header background, section backgrounds, etc) are carried through to the child theme.

Since I can’t attach files to this post, you can download the child theme I created at https://thefan.net/sppp.zip. Just let me know when you have this file, so I can remove it from my personal site.

There doesn’t be a way to automatically export the settings from the Faith theme to import them into a child theme. There are some themes that detect when a child theme is being used and will supply the data from the parent theme set up for the child theme.

Thanks for any advice you can provide. ??

Please accept my apologies in forgetting to post an update.

Turns out the feed that was linked was rendered inoperable, because of a brand new website design by the USCCB folks, without them telling anyone else. I was a bit busy trying to re-sync the feeds back to our sites.

This affected 30+ of our sites, and our own intranet. Considering the popularity of that feed within the Catholic Religion, I have to imagine thousands of other sites are also affected.

This is NOT an issue related to the (incredibly FANTASTIC) CyberSEO Lite plugin. ??

You need to switch back to the original plugin (deactivate the RW one and delete, download and activate the original one). If you’re still having issues, please post on those forums.

I just checked… apparently, anadnet’s plugin got yanked for security issues.

I no longer work for Richweb, so I am unable to provide any support for this plugin (which has been deactivated for over a year).

(I don’t have access to the files any longer, and time is a luxury for me, unfortunately. I’m the last person that wants to say “No, I can’t do that”, however, I have to be that guy, sadly.)

Thanks!

• This reply was modified 4 years, 6 months ago by Douglas "BearlyDoug" Hazard.

Question for you, @adamkayce… why did you not put in support request for this before posting your review? I bet if you had, they would’ve addressed that issue immediately.

I need to note that this ended up being a very uniquely solved situation. Out of respect for the time that the BWPS teamies took, I will not post the changes I needed to do, anywhere.

That said, the fact that the BWPS team *did* go above and beyond for my situation is amazing. If you were on the fence about purchasing their pro edition, I definitely encourage you to do so, if only to support the BWPS team, financially. You will not be disappointed with the support staff, for sure.

This plugin does exactly what it needs to do, and I am appreciative that it exists.

Thank you, BWPS Teamies, for everything!

• This reply was modified 4 years, 6 months ago by Douglas "BearlyDoug" Hazard.