Support » Plugin: 12 Step Meeting List » apostrophes

  • Resolved ldigioia

    (@ldigioia)


    Hello,
    I have found since earlier this year, over the past four or five plugin versions at least (about twenty uploads ago) that when I upload a CSV, any meeting with an apostrophe in the name will show a large, square character instead of the apostrophe.

    Example: “Wednesday Night Men’s” becomes “Wednesday Night Men[]s” (I can’t reproduce the actual character so I used brackets.)

    I then need to go into each meeting in WordPress and fix this. Am I missing anything? I just expected this to go away in a later version, but no. It creates a lot of extra work.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author tech2serve

    (@tech2serve)

    Hi–

    I’m not sure what is causing that but can add it to the list of things to look at.

    Why are you uploading CSVs? In general, that should be a one-time thing to create the database. Or possibly to restore a database.

    I maintain both the web and printed versions of our area meeting lists. The “master” is an Excel spreadsheet that eventually becomes a PDF for the printed list.

    In between printed editions (which occur about once per year) I continue to update it. When I accumulate enough changes to publish to the web, I do a CSV and upload it.

    In other words, the same spreadsheet drives both the print and the on-line lists.

    If the plugin offered “export to CSV,” I might consider going the other direction…

    Plugin Author tech2serve

    (@tech2serve)

    Look at the right-hand side of the Import & Settings page and you’ll see a Where’s My Info? panel. In the second paragraph, you can download your data as a csv file.

    I strongly encourage people to use the database as their master. The plugin is designed to manage these meeting lists.

    There is another plugin out there for creating PDFs from the database you might want to try. I can’t remember the name of it right now, but if you search the TIAA Forums you should be able to find it. If you’re stuck, I can try searching later.

    Please let me know if you need further help.

    Well, burn my britches! It’s there.

    OK, I will try to get used to the idea of the plugin becoming my master list. Luckily I have some time, since I just finished a print edition.

    I will cross that off the list that I am pushing to you over on TIAA-forum.org.

    Thanks!

    Plugin Author tech2serve

    (@tech2serve)

    @ldigioia,

    I tried to duplicate the apostrophe issue you reported, but didn’t have any luck.

    I opened a bug report at our source code repo. If you’re willing, please come over and let’s see if we can get it reproduced?

    Were you using PC or Mac? Excel?

    ldigioia

    (@ldigioia)

    Well, this is no longer an issue since I took your advice, and just changed my thinking to consider that the site is now the “master.”

    That just means I will no longer be regularly uploading CSV files, just exporting them. That solution also forces me to look at the use of many of the other “possible” fields that are in there. I will have a big headache next year when I need to make a cleaned-up spreadsheet for the next print version, but I can do it when the time comes.

    But for the record – the computer is Windows 10 1909 and Excel 2016. I have seen references to others with the same problem in the TIAA forum. Thank you for your help.

    Plugin Author tech2serve

    (@tech2serve)

    Thank you for getting back to me @ldigioia.

    Based on my research, the issue you were having with apostrophes was probably a result of the curly quotes Excel is using.

    If you run into the issue in the future with another project, or because you need to restore from a CSV file that has been modified in Excel, you may want to replace the curly quotes with straight quotes.

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.