Importing Users with CBJUICE

1 year 10 months ago #284817 by Intellitech
Hi.
I hope you will be able to help.

I am preparing the CSV file to import my users. I have exported the current CSV with the headers to be used.

Could I please check if all the exported header columns have to be used for the import (ie, using the headers as the template to prepare the CSV to be imported)?
Or could those selected header columns be used?

Thanks and appreciate it.
1 year 10 months ago #284820 by jciconsult
If you exported from community builder using cbjuice, then the headers could be used. If they are from another program probably not.
My suggestion is to do a save using cbjuice from your site to see the available headers and their format
1 year 10 months ago #284821 by wolverton
As Paul says, best way is to do an export to get the headers. Then in your spreadsheet software you can delete any fields ( columns ) that aren't necessary. For 'add mode' you only need the key field ( either email or username ) plus one additional CB profile variable
1 year 10 months ago #284823 by Intellitech

wolverton wrote: As Paul says, best way is to do an export to get the headers. Then in your spreadsheet software you can delete any fields ( columns ) that aren't necessary. For 'add mode' you only need the key field ( either email or username ) plus one additional CB profile variable


So does this mean that I could only use those headers of those fields I am importing?
What happen about those Confirmed/Approved status?
Do I need to give the row records the values, so that the users are considered Registered and already imported into system?

I have a list of to be imported users, with many column (fields). So I need to know if using the exported headers, and reorganising the data to the headers should be what I should be doing leading to the import.
1 year 9 months ago #286630 by Intellitech

wolverton wrote: As Paul says, best way is to do an export to get the headers. Then in your spreadsheet software you can delete any fields ( columns ) that aren't necessary. For 'add mode' you only need the key field ( either email or username ) plus one additional CB profile variable


Sorry, I might have missed this. Just to clarify and confirm that, if I were to do an 'edit mode' import, the spreadsheet should contain the key field ( either email or username ) AND any other columns/fields that I wish to update/import??

Just need to be sure that edit imports can exclude fields which I do not wish to update, and will not be overwritten with empty values.
Moderators: beatnantjciconsultwolvertonkrileon
Time to create page: 0.169 seconds
Facebook Twitter Google LinkedIn