Moving a data base

Hi @webadjointr88,

1)
I believe your new meeting site is already being imported on the Québec website, am I correct? I find the meeting “Compréhension (SUSPENDUE)” to have the right data:
https://aaregion88.org/meetings/comprehension/?tsml-time=upcoming
https://aa-quebec.org/aaqc_wp/meetings/comprehension/?tsml-time=upcoming

2)
You need to find out the correct links to provide to Meeting Guide and others:
– In your WordPress Backend,
– Go to “Meetings / Import & Settings”
– On the right side find “Authorized Apps”
– Below that is a list of Links
– The Links hopefully have descriptive names:
– There should be a Link meant for the Québec website, which is importing your data already, I believe?
– Or is there one meant for the Meeting Guide?

3)
If Quebec is importing your meetings, you can probably just wait, until their data is updated in the Meeting Guide app. That may take a while…
Do you find other Québec regions’ meetings are up-to-date in the Meeting Guide app?

4)
If the Meeting Guide app is importing region 88 meetings directly, you need to get in touch with them and change that link.
This might break: But for now you also can redirect your old feed Url to your new one by placing these redirects at the top of an .htaccess file in the root directory of your old site. They should work in /, /region88, or /region88/WP:

Redirect temp /region88/WP/wp-admin/admin-ajax.php https://aaregion88.org/wp-admin/admin-ajax.php
Redirect temp /WP/wp-admin/admin-ajax.php https://aaregion88.org/wp-admin/admin-ajax.php
Redirect temp /wp-admin/admin-ajax.php https://aaregion88.org/wp-admin/admin-ajax.php

• This reply was modified 4 years, 12 months ago by wokat.

Thank you,
About: 1)
I believe your new meeting site is already being imported on the Québec website, am I correct? I find the meeting “Compréhension (SUSPENDUE)” to have the right data:
https://aaregion88.org/meetings/comprehension/?tsml-time=upcoming
https://aa-quebec.org/aaqc_wp/meetings/comprehension/?tsml-time=upcoming
—-
Web site https://aa-quebec.org is the provincial web site where four Area (87, 88, 89 and 90) work together and have an unified meetings list. All meetings in the province of Québec are listed at: https://aa-quebec.org/aaqc_wp/meetings/. Each Area has it own web site and meeting list. When an Area update the meeting information, the aa-quebec webmaster is informed and he retrieve the Area database he needs. Exemple, if Area 88 update some meetings (from https://aa-quebec.org/region88/meeting/), normaly our database (https://aa-quebec.org/region88/WP/wp-admin/admin-ajax.php?action=meetings&key=…..) have the update.
We also have a new web site (https://aaregion88.org) and when we make manuel meeting update, the database is not changed. We wish in the future move our database to the new web site and still have Meeting Guide applycation working OK.
My needs are to understand how Meeting Guide is working and which link I use to inform correctly Meeting Guide team.
I have some picture but unable to send it ([email protected]) . If I download the CSV file (You can also download your meetings in CSV format.) from old web site and use it to feed the new site, we have a lot of error (day and time are changed for appointment) Any idea?

Hi @webadjointr88,

So I need to make sure we’re using the right lexicon:

Meeting Guide refers to the Meeting Guide App maintained and provided by GSO. So if you’re talking about wanting to know how the App works, you’ll need to contact GSO.

Twelve Step Meeting List (TSML) is the plugin (and this page is the user support page for that plugin). Please confirm you’re using the plugin for all of your sites.

Meeting changes in a TSML database that is connected to Meeting Guide might take up to 12 hours to update in the App.

I’m willing to help you make sure functions with your TSML plugin are working. Once that is confirmed, you’ll need to work with GSO if you feel your meeting information in the App is not being updated.

So please tell us specifically what may not be working with the TSML plugin on one of your websites, and we’ll try to help with that. That is step 1. Step 2 will be to work the Meeting Guide App connection.

Make sense?

Thank you for your help,
I am new as a webmaster and I have to live with what somebody else has done before. Both web site (aa-quebec and aaregion88) use WordPress and the 12 Step Meeting List
By Code4Recovery plugin. My goal is to have only one data base for Area 88. I have some problem with CSV file. I am working on this because it will be easier to update meeting information with a *.xlxs file. I am using Microsoft Office 365 ProPlus, and Excel version is 1908. For now, I have to update manually each meeting in both site. If I understand, our data update is automatic if in Meetings app, under Import & Setting, at the right side, under Autorized Apps I have Meeting Guide? I will try Exemple spreadsheet and try to make a workable CSV file. I will come back here if I need some more help.
MERCI

Search the help forums here for a description of a problem that can be introduced by Excel. I think it has to do with smart quotes. You’ll need to get them converted to regular double quotes if my memory holds. Then you should be able to make your changes and import data.

I suggest then using the Plugin’s Meetings interface to manage changes after that. Some people use csv’s (export/import repeatedly) without troubles, but often people do have troubles and it is too easy to lose version control.

Good luck, and let me know how you’re fairing!

Use a simple text editor to prepare your .csv file. Such as TextEdit (Mac) or Notepad (Windows). These programs enable you to create a non formatted piece of text that is just less risky than Excel.

The term comma separated is often misunderstood. The comma’s are the separators between each values. But, more importantly so, you start the document with a comma separated list of the field names. Then a hard return.
Then the first set of values, each value between quotes.

Fieldname1,fieldname2,fieldname3
“firstcontent1″,”firstcontent2″,”firstcontent3”
“secondcontent1″,”secondcontent2″,”secondcontent3”

If translated into how you see Excel:
Each line is a row, each field/content is a column
However, as well as any .csv file displays in Excel (good for double checking to spot errors) it is not a good program to prepare the import.

Instead put it in a texteditor. When saving, do not use the default .txt as format, but change it to .csv when you save and import from there.

Good luck!