Running CiviCRM latest on Joomla latest, Dutch translation, locally on Windows 8.1 and xampp, online with hosting; Joomla and CiviCRM installed and working. Now I would like to backup the complete installation.
I exported all of my 2000 contacts to a CSV file. I am trying to import the 2000 contacts from the same file, on localhost as well as online. The first step is successful, CiviCRM adds the first row as labels, the second row with data. The second step, creating the mapping the labels fails for all. After the mapping I get an error on all contacts, so no contact is imported at all. If I choose to import only the obligatory * labels, names, mail, CiviCRM imports only those. So I end up with only the contacts and have to do the rest manually (no email, no bulk, etc.)
- Is the order of the importing columns in the CSV important? So, first column = name, second colum= mail etc?
- Is the translation in Dutch causing problems mapping?
- I tried to edit the CSV with open office and saving in utf8, the same problem; does the file change after editing in such a way that importing is a problem?
- is it possible to backup by exporting the database to SQL file and if needed restoring by uploading the same SQL again with PHPMyAdmin?