search

DNNCommunity / DNN.Events

DNN Events manages display of upcoming events as a list in chronological order or in calendar format with additional information. This Github repo is used for source management and releases.
MIT License
27 stars 40 forks source link

Import/Export #96

Closed jncraig closed 4 years ago

jncraig commented 6 years ago

Is your feature request related to a problem?

On multiple occasions, I've needed/wanted to mode a copy of an Events module to a new portal or to a new installation of DNN.

Describe the solution you'd like

I would like for the Events module to support Import/Export of all data (iPortable) so that the module and its contents can be moved to a new portal/site/installation.

EPTamminga commented 6 years ago

I am familiar with the need/wish for standard import/export, but it is a complex task. The Events data structure is not a simple straightforward one. It involves data & settings on host, portal, users and user groups level and individual data in module instance level, combined with data for eg. PayPal payments. I would prefer to split the import/export into a definition only implementation and a definition + data implementation. More work, but a better solution. Both options require a serious amount of think & development work.

PeterCasper commented 5 years ago

Ernst, I am trying to migrate 4 sites on an old Server 2012R2 host running 9.01.01 to a new Azure host running 9.02.02. Both servers have Events 7.0.3 installed. I am most disappointed in DNN with the site export / import feature, not just the Events module but with multiple modules & features. Even basic site configuration info such as site time zone, language, copyright, site logo & Favicon were not successfully transferred. Users, roles & basic page information was transferred but the damage is so great that I must give serious consideration to adopting another product.

Is evoq built on the same basic systems?

Peter

EPTamminga commented 5 years ago

@PeterCasper Import/Export is not a generic function of DNN, but a feature that has to build in into each and every module individually. Some modules do have that feature, some don't. Events falls in that last category. The request for Import/Export for Events is around for a long time but never made it in a version (it is a lot of coding to get it implemented). If we do upgrades/move between servers ourselves, we normally do a complete file & database copy (backup/restore) from old to new, which gets the job done most of the time. Evoq might have better options for Evoq modules, but the (Open Source and other) modules you use from DNNPlatform stay the same.

valadas commented 5 years ago

@PeterCasper, I also suggest you log the Dnn Import/Export issues at: https://github.com/DnnSoftware/Dnn.Platform but just the ones that are not module specific like the site logo & Favicon you mention.

hcpctthree commented 5 years ago

I am familiar with the need/wish for standard import/export, but it is a complex task. The Events data structure is not a simple straightforward one. It involves data & settings on host, portal, users and user groups level and individual data in module instance level, combined with data for eg. PayPal payments. I would prefer to split the import/export into a definition only implementation and a definition + data implementation. More work, but a better solution. Both options require a serious amount of think & development work.

Is it possible to use a database query to copy all the events from one portal to another portal?

In essence is there a manual process?

EPTamminga commented 5 years ago

If you have enough experience in SQL, I assume that this is possible. The table structure is available as document. Please remember that there are portal and module settings as well that should be copied.

hcpctthree commented 5 years ago

Do you have a working example of the query that I can take a look at?

On Wed, Jan 16, 2019 at 11:43 AM Ernst Peter Tamminga < notifications@github.com> wrote:

If you have enough experience in SQL, I assume that this is possible. The table structure is available as document. Please remember that there are portal and module settings as well that should be copied.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/DNNCommunity/DNN.Events/issues/96#issuecomment-454872055, or mute the thread https://github.com/notifications/unsubscribe-auth/AslfpSo3UsOrqCkLkQ0gIFg0peVWtDEkks5vD2SlgaJpZM4VIUcH .

EPTamminga commented 5 years ago

Sorry, I do not have one query. The copy of Events content from one site to another will certainly take several queries, both for export as well as import. If the solution would consist of a single query, I would probably have added that to the module long time ago.

stale[bot] commented 4 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] commented 4 years ago

This issue has been closed automatically due to inactivity (as mentioned 21 days ago). Feel free to re-open the issue if you believe it is still relevant.

wbhyde commented 2 years ago

If you have enough experience in SQL, I assume that this is possible. The table structure is available as document. Please remember that there are portal and module settings as well that should be copied.

Where is the table structure document?