Question

Photo of Nathan Parikh

0

Is there a developer able to help us import to Rock?

5

Hello,

I've posted before asking for guidance on how to import people from our existing solution to Rock. The responses were very helpful but I'm just not experience enough with Microsoft Access (our old database format) or Microsoft SQL server to actually make the import happen.

Also, figuring out how to prepare/edit the Access database fields to match the new fields in the SQL database so that Rock will actually be able to recognize and use our data is difficult for me to understand.

If there a developer here or somewhere else that can assist us with this transition?

Thanks!

  • Photo of Jay Greentree

    0

    There is a nice import tool that was created by some of the devs with the help of NewSpring Church. It is available on github: https://github.com/NewSpring/Excavator/blob/master/Excavator.zip

    When you download the file before extracting it you will need to right click then go to Properties and click on the unblock button and then ok. now you can safly extract the files. If you don't do it in this order it will crash.

  • Photo of Trey Hendon III

    0

    Hey Nathan,

    I work with Kingdom First Solutions and we offer data migration services.  We'd be happy to chat, my email is treyh at kingdomfirstsolutions dot com.

    Thanks,

    Trey

  • Photo of Stan Mungwe

    0

    Hi Nathan,

     

    we are a young group in Cameroon using Rock to help churches and to train young people in IT, we can help you if you still need help. For now we are passionate we are free. My skype is stanley.coupa

  • Photo of Hock_Hin Lee

    0

    I used Microsoft Excel to get the data from the Microsoft Access database.  From Excel, then export the cleansed data to CSV format which Excavator will happily use.  These steps I can help you with.

    A lot of time and effort was spent in (a) data cleansing the old data (b) Separating the name (all in one field) to First Name, Last Name, etc, (c) Separating the address (all in one field) to the different fields (d) grouping individual persons into families.  This is because our old data did not keep names and addresses as per Rock, and this Name/Address data was formatted in different ways.

  • Photo of Jeremy Hoff

    0

    A new tool, available as of v14, can help with importing people data. Find it here: https://community.rockrms.com/documentation/bookcontent/9#csvimport

    I hope that helps,