Brand new Installation - Old Server Died - OLD Forum of Users and Developers of Epesi BIM

Brand new Installation - Old Server Died

thinlinx

We lost everything on our Epesi when our 15 x 1TB Raid 6 drive server had 4 of the 15 drives fails for some reason...I had backed up the Postgresql Database to the Raid 6 server as well which could not be recovered :(

Only good thing was we had exported a CSV list of Companies and Contacts a few months before the failure

We had bought all the premium modules that were available in 2013

I have just installed a VirtualBox VM to make sure we don't have this issue again as we will just backup the VM from time to time. I have installed the latest Epesi and licenced it online, but how do I get my Premium Modules back again, I think we spent around US$1000 on all of them

Thanks

John

ajb

Please send us via email your company data info from the email used for registration, date of the registration(more or less accurate) and a list of bought (only paid) modules and we'll send you back your license key.
Also please send currently used license key - we'll delete currently used and you'll have to edit your license key to the old one. Then you'll be able to download all modules.

Regards,
Adam

thinlinx

Thanks for the reply, what email address do I send the request to?

I managed to recover the old /var/www directory containing Epesi but have lost the RAID Database and backup, is the old Licence Key somewhere in the /var/www directory, if so I can probably just trash the latest install, then re install and use the old Licence key when prompted for a Licence. Will this work?

Thanks again

Regards,

John

ajb

No - license key is stored only in the database. I've replied to your email.

thinlinx

Adam,

Thanks for the email

I copied the old licence key you sent me into my latest EPESI installation and then I could install all the modules including the ones we had bought last year 🙂

I then tried to import the .csv that we had created when we exported the Company and Contacts last year, I tried importing the company_export .csv file first, and waited and waited but nothing happened, was still processing after a few hours. I had assumed that a file exported by EPESI could be just imported but maybe not...

The exported Company file contains the record names pasted below in the first row. The first row Record ID starts at 441, the next row Record ID is 22 then 94, do I need to remove the Record ID Column to import the file? I am having trouble finding documentation on the import process from a Epesi exported .csv file

"Record ID","Company Name","Short Name",Phone,Fax,Email,"Web address",Group,Permission,"Address

Regard,

John

thinlinx

Sorry, we encountered an error while displaying this content. If you're a user, please try again later. If you're an administrator, take a look in your Flarum log files for more information.

ajb

Hi,

please use code tags to quote outputs 🙂

Here's why:
f_company_name should be the ID of a company. But exported data has a string in there. CSV export/import is not the ideal way to restore data. In fact it's used to export/import data from the other systems like excel etc. The best way to make a backup is to export sql table.

Do you use the most recent version of the import module? It's been released recently and probably we should improve this module to search for companies with a such name.
You could try to replace all company names with its ids from the current installation. Excel/Openoffice should be able to link it and replace the name with ID, but I'm not sure about that.

I'll talk with the person who's responsible for the import module.

Regards,
Adam

thinlinx

Hi Adam,

Thanks for all your help 😃

I have now become quite proficient with the Import module which is fantastic!

I have managed to import all the tradeshow .csv information that we collected over the last few years

Great work!

Regards,

John

ajb

Great to read that 🙂 Do you have any tips, what could be done better in the import module?

thinlinx

Hi Adam,

The biggest issue I had was understanding how to use the import module, once I worked that out it was all smooth sailing

Maybe you could consider making a screencast for the import Module which would have been very useful to me

We have just found Camtasia which is a good choice for creating Screencasts

http://www.techsmith.com/camtasia.html

Thanks

John

ajb

Thanks. We're going to write manuals and we've got some screencast for Premium modules already. Definitely there will be some detailed instructions.

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge