Export content to a csv or xml file - Version 5.6.1

Permalink
Hello

I have an old C5 website in version 5.6.1
I need to export all the content of my pages to a csv file, or xml file or json file.

I don't find in the dashboard how to do this.
I've only found a "Export Database Tables" button but it isn't what I want to do.

Thank you for your help
Olivier

 
drbiskit replied on at Permalink Reply
drbiskit
Hi - Have you looked at the Migration add-ons at all? This will export your content in XML.

https://www.concrete5.org/community/forums/customizing_c5/5.6-to-5.7...

You can also then use it to import the same content into a 5.7+ site. There is a bit of a learning curve but it can be very useful.
wollastoni replied on at Permalink Reply
Thank you.

I've just downloaded this Migration Tool but when I try and install it, I have the error message that it works on version 5.6.4.0 or greater.

I am in 5.6.1
wollastoni replied on at Permalink Reply
and I see that the best update available on my old website is 5.6.3 ...
drbiskit replied on at Permalink Reply
drbiskit
You should be able to upgrade it to 5.6.4.0. Have you looked at these docs about how to run system upgrades?

https://legacy-documentation.concrete5.org/tutorials/manually-upgrad...

Obviously make sure you back up your files and your database first before running any upgrades - but, Concrete5.6 generally used to auto upgrade very smoothly without too many issues.
drbiskit replied on at Permalink Reply
drbiskit
Just in case you need it - here is the direct download link for v 5.6.4.0:
https://www.concrete5.org/download_file/-/view/108841/8497/...
wollastoni replied on at Permalink Reply
@drbiskit , thank you, once unzipped where exactly should I put that 5.6.4.0 file ?
In the www folder ?
In the concrete folder ?

Could you please explain me the full process to go from 5.6.3 to 5.6.4 as 5.6.4 is not proposed as "upgrade" in the C5 dashboard.

Thank you very much !
drbiskit replied on at Permalink Reply
drbiskit
There are a couple of ways to do it - outlined here:https://legacy-documentation.concrete5.org/tutorials/manually-upgrad... - But this is the quickest way:

1 - Make sure that you have backed up your database first, in case something goes wrong. This is usually best done through e.g. phpMyAdmin or equivalent, if you have access.

2 - Unzip the concrete5.6.4.0 zip file. Change the name of the 'concrete' directory to e.g. 'concrete-new', and upload it to the root of your site.

3 - Still on the live site, change the name of the existing 'concrete' directory to 'concrete-old'. This will temporarily stop the live site working.

4 - Then change the name of the directory you uploaded from 'concrete-new' to 'concrete'.

5 - Then go to this URL to run the upgrade script:
http://www.your-site.com/index.php/tools/required/upgrade...
(Change 'www.your-site.com' to your site domain name)

======

That should run the update the CMS successfully. If it is all okay, you can then delete 'concrete-old'.
wollastoni replied on at Permalink Reply
Unfortunately it doesn't work for me. I must do something wrong.

Once I renamed "concrete-new" in "concrete" and try to login to my website, I get a Fatal error message, and no page are able to open :

---
Warning: require(/home/collectoi/www/concrete/config/base_pre.php) [function.require]: failed to open stream: No such file or directory in /home/collectoi/www/concrete/dispatcher.php on line 19

Fatal error: require() [function.require]: Failed opening required '/home/collectoi/www/concrete/config/base_pre.php' (include_path='.:/usr/local/php5.3/lib/php') in /home/collectoi/www/concrete/dispatcher.php on line 19
---

There seems to be an error with the dispatcher file... ?
Any idea on how to fix this ?
wollastoni replied on at Permalink Reply
OK Now I achieved to do everything, but when I try and upgrade C5, it tells me "No other version available". I am stuck on 6.3.5
wollastoni replied on at Permalink Reply
You told me to upload only the "concrete" directory.

Are we sure we should not upload other files from the 5.6.4 archive ?
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
This is one of the reasons that I offer to do this as a paid service.
wollastoni replied on at Permalink Reply
It is ok, I used the Method 1 of drbiskit link and it worked fine !
Thanks a lot drbiskit !

Question to all : using that Method 1, can I go from 5.6.4 to the most recent C5 version, going version by version ???
drbiskit replied on at Permalink Reply
drbiskit
Great - Glad you got there in the end.

Just to confirm that the method I outlined above is a correct/official way to upgrade, and does usually work in most cases I've come up against.

Anyway - Well done for persevering, and I hope that the migration tool does what you need after all your effort.
drbiskit replied on at Permalink Reply
drbiskit
No you can't. 5.6 does not upgrade to 5.7 and beyond - But, you can use the migration Add-on to import your content into a brand new C.5 website.
tallacman replied on at Permalink Reply
tallacman
Depending on the size of your site you may want to consider just copying the information over to a new install./
wollastoni replied on at Permalink Reply
Unfortunately it is about 300 pages
digitmaster replied on at Permalink Reply
digitmaster
you can also do the following:
- run an online or installed link validity check and correct corrupted links if any. Recheck.
- use a web copying program like httptrack or similar and download a full copy of your website in working html, css, js. You have a static html copy.
- manuallly, be patient and copy and paste those contents in a fresh installed cms that might be also different from c5. I assume you prepared an empty template for your content.
- download anyway your current c5 folder structure and be sure that the files are there in the /file folder

another one: look at the corrupted links with the httptrack statistics, they should be zero or what you expect from the previous check.
good luck

Note: do not forget to copy also the content of hidden pages you might have.
Note 2: as last resort, but you really have to know what you are doing:https://www.concrete5.org/marketplace/addons/page-importer/...