Support Forum

If you want to show a shortcode in forum post - use [ instead of [ as you write it so you can see the shortcode 😉

We use and recommend UK2 for hosting - get a month free

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register sp_MemberList Members

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Importing CSV
14th February 2020
11:14 am
Avatar
New Member
Members
Forum Posts: 2
Member Since:
14th February 2020
sp_UserOfflineSmall Offline

Hi, I have installed church admin and have been updating the records I previously imported when I have realised that the database I imported is incomplete. If I go back and import as CSV will it overwrite changes I have made? I can see you have the option to overwrite but does that delete the old entries or just add to them. Also if I have completed fields within the app that aren't on my CSV, if I choose to overwrite will it blank out those fields in the app? Thanks

14th February 2020
11:35 am
Avatar
Admin
Forum Posts: 808
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

Hi Lis, welcome aboard!

If you "overwrite", then all the people and households are deleted before the CSV is processed. That will be an issue if you have set up small groups, rotas (schedule if you are from the US!) etc - because they store the id of the person rather than the name, which may change.
If you don't overwrite, the import will check each person and import them if not in the directory already - thereby not breaking rotas and small group leadership and so on.

If you are finding the plugin useful, please subscribe to the app - it's free for your congregation to use and only £9.99pm for a church subscription

15th February 2020
9:44 am
Avatar
New Member
Members
Forum Posts: 2
Member Since:
14th February 2020
sp_UserOfflineSmall Offline

Hi Andy,
Thanks for the above, however I have just imported the new CSV file and have two issues. Firstly it has duplicated entries, so now I have several entries for the same person & household and secondly it hasn't imported the addresses to the new files and has overwritten the addresses already input with the first address on the new CSV file. I am hoping that doing a rollback will take me back to my previous information but would like advice on what may have gone wrong?
Thanks

Forum Timezone: Europe/London

Most Users Ever Online: 93

Currently Online:
8 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Rich Cox: 87

David Z.: 83

Pastor Andres: 83

rrfranks: 53

Allen: 51

Gavin: 36

seanmcint: 29

Jon: 29

Janeen: 23

365sussex: 21

Member Stats:

Guest Posters: 44

Members: 394

Moderators: 0

Admins: 1

Forum Stats:

Groups: 5

Forums: 14

Topics: 529

Posts: 1967

Administrators: andymoyle: 808