Question

Photo of Jeremy Turgeon

0

Database Migration

5

We're almost ready to roll out Rock but need to get our existing data imported.  I've tried using Excavator and the Rock Data Import projects on Github but none of them seem to work for me.  Has anyone found a way to import from Arena or even just a CSV file into Rock?

Thanks!

CMS
  • Photo of Jeremy Turgeon

    1

    Excavator is now mostly working and am testing our data before making the leap.  I hope to have a step by step walkthrough compiled soon with my experiences and pitfalls.

  • Photo of Trey Hendon III

    0

    I haven't started yet, but plan to use something like Map Force (http://www.altova.com/mapforce.html).  Hope that helps!

  • Photo of Chris Funk

    0

    Hi Jeremy, are you getting an error with the Rock Data Import tool? If so what error(s) are you seeing?  

    • Jeremy Turgeon

      Jeremy Turgeon

      The project seems beyond my technical abilities. Extracting the files and running SECC Rock Data Import.exe returns: Unexpected status code returned. 0 - . Invalid URI could not be determined.

      • Chris Funk

        Chris Funk

        The RockUrl should be the web path to your instance of Rock (i.e. http://rock.yourdomain.org) the /api will be automatically appended. Let me take a look to see if I can reproduce this, it will be sometime tomorrow before I can dig into it though.

        • Jeremy Turgeon

          Jeremy Turgeon

          Is there a specific place the files should be extracted to? I've tried running the exe from the desktop and overriding the default bin folder with the extracted content. Originally I hadn't included the http:// so after adding that I get "Could not load file or assembly 'org.secc.Rock.DataImport.Extensions.Arena, Version=0.1.0.0, Culture=neutral, PublicKeyToken=null'.

        • Photo of Michael Garrison

          0

          I used Excavator and it worked perfectly. I also know the developers are very responsive to questions and posts in their github section- did you try asking them for help or let them know what wasn't working?

        • Photo of Chris Funk

          0

          Jeremy,

          I was able to dig into the "Could not load assembly..." error.  it turns out that because I deployed the application as a .zip file, Windows will block certain dll files.  The workaround is to go into the "Plugins" folder, right click the dll file and go to properties and then click unblock. I will try to resolve in a future release.

          Also, you shouldn't have to move the org.secc.Rock.DataImport.Extensions.Arena file from the Plugins folder, the app will search that directory for .dlls that contains ImportComponents (data sources) and Export Maps.