ajtruckle / meeting-schedule-assistant-support

Get support for Meeting Schedule Assistant.
https://www.publictalksoftware.co.uk/meeting-schedule-assistant/
5 stars 0 forks source link

Import / Export Congregation Database Information #5

Closed ajtruckle closed 4 months ago

ajtruckle commented 1 year ago

Is your feature request related to a problem? Please describe. There is no way to export the Congregation Database.

Describe the solution you'd like Is it possible to add Export / Import and not only Import?

Describe alternatives you've considered I am aware that the congregation database is stored in a specific XML file.

Additional context It's good to share the data of the speakers & congregation. Since it took lot of time to add them (if not imported from the PTS application). This feature was originally requested by @fstouma.

ajtruckle commented 1 year ago

@fstouma It is a good idea 💡 and one worthy of consideration. In Public Talks it has the concept of Synchronization. To quote the help topic:

This feature has been implemented to make it easier for Talk Coordinators to transfer their latest details between each other. This is how the feature would work (in theory):

  • Export your congregation data into a INI file
  • Email your INI file to the talk coordinator
  • He synchronizes your INI file into his database
  • He now has your update to date details

Likewise, a coordinator could email you his latest INI file and you would synchronize it into your database.

Things are somewhat easier in Meeting Schedule Assistant because we don’t have the headache of a Microsoft Access Database. But we can discuss …

cengizu commented 5 months ago

That's an important feature. It should be there.

If the database is already in XML, MSA could simply offer user the import/export db option.

** in case a db already exists, will this feature overwrite or append to existing db. Can be prompted to user.

Users then can attach this XML file to emails or copy on USB sticks.

ajtruckle commented 5 months ago

@cengizu

** in case a db already exists, will this feature overwrite or append to existing db. Can be prompted to user. PTS has two modes for import / export of congregation data:

  1. Bulk import / export.
    • Exports all congregation data.
    • Imports (or appends) congregation data.
  2. Specific import / export.
    • Exports the selected congregation.
    • Imports and merges the selected congregation.
ajtruckle commented 5 months ago

@cengizu Regarding the exportation of the congregation database:

  1. A popup window will display a list of congregations.
  2. The user can select one or more congregations for export.
  3. After clicking OK, the user will be prompted to provide a filename for the exported XML database.
  4. The selected congregations will then be saved to the specified XML data file.

Note:

cengizu commented 5 months ago

Looks good to me. Let's see it in action

ajtruckle commented 5 months ago

@cengizu Alright, I'll put something together.

ajtruckle commented 4 months ago

@cengizu @Fahdeya

I have been working on the Export functionality. There is now a Export menu item:

image

I'll send you a beta to try.

ajtruckle commented 4 months ago

@cengizu @Fahdeya

I have been working on the Import functionality. See:

image

New betas on their way to you.

cengizu commented 4 months ago

@ajtruckle

I tried the last beta and import / export works fine. There is no problem when importing, I have imported the same file several times in a row and the congregation names are numbered. image

I also corrupted the XML file I exported and tried it that way. MSA detects the faulty XML file and shows the log records. image

The process is successful, good job.

ajtruckle commented 4 months ago

@cengizu Updated help topics for review 👀: