Login Register
MrGeneration

MrGeneration / Zammad CSV-Import for Users and Organizations

Last active 2 weeks ago

Like 0

Sample CSV files to highlight the CSV import function - as shown in the youtube video https://www.youtube.com/watch?v=OeelYx106WU

csv import users organizations

MrGeneration revised this gist 2 weeks ago · bf8dfae

No changes

MrGeneration revised this gist 2 weeks ago · 317a9b7

1 file changed, 1 insertion, 1 deletion

organizations.csv
@@ -1,3 +1,3 @@
1 1 name,members
2 2 Zammad GmbH,nicole.braun@zammad.org~~~some-employee@example.com
3 - Another Company",alias@example.com
3 + Another Company,alias@example.com

MrGeneration revised this gist 2 weeks ago · 3034192

1 file changed, 3 insertions, 3 deletions

users.csv
@@ -1,4 +1,4 @@
1 1 login,firstname,lastname,email,web,phone,fax,mobile,department,street,zip,city,country,address,vip,verified,active,note,last_login,out_of_office,out_of_office_start_at,out_of_office_end_at,roles,two_factor_preferences,out_of_office_replacement,organizations,chat_agent_created_by,chat_agent_updated_by,overview_sortings,organization
2 - 4,mherrguth@example.com,Marcel,Herrguth,mherrguth@example.com,"","","","",,"","","","",,false,false,true,"",,false,,,Customer,"",,"",,,"",
3 - 3,some-employee@example.com,Marcel,Herrguth,some-employee@example.com,"",+492214710231,"","","","","","","","",false,false,true,"",2024-11-26T17:01:15Z,false,,,Admin~~~Agent~~~Customer,"",,"",,,"",Zammad GmbH
4 - 2,nicole.braun@zammad.org,Nicole,Braun,nicole.braun@zammad.org,"","","","","","","","","","",false,false,true,"",,false,,,Customer,"",,"",,,"",Zammad Foundation
2 + mherrguth@example.com,Marcel,Herrguth,mherrguth@example.com,"","","","",,"","","","",,false,false,true,"",,false,,,Customer,"",,"",,,"",
3 + some-employee@example.com,Marcel,Herrguth,some-employee@example.com,"",+492214710231,"","","","","","","","",false,false,true,"",2024-11-26T17:01:15Z,false,,,Admin~~~Agent~~~Customer,"",,"",,,"",Zammad GmbH
4 + nicole.braun@zammad.org,Nicole,Braun,nicole.braun@zammad.org,"","","","","","","","","","",false,false,true,"",,false,,,Customer,"",,"",,,"",Zammad Foundation

MrGeneration revised this gist 3 weeks ago · 969af59

2 files changed, 7 insertions

organizations.csv (file created)
@@ -0,0 +1,3 @@
1 + name,members
2 + Zammad GmbH,nicole.braun@zammad.org~~~some-employee@example.com
3 + Another Company",alias@example.com
users.csv (file created)
@@ -0,0 +1,4 @@
1 + login,firstname,lastname,email,web,phone,fax,mobile,department,street,zip,city,country,address,vip,verified,active,note,last_login,out_of_office,out_of_office_start_at,out_of_office_end_at,roles,two_factor_preferences,out_of_office_replacement,organizations,chat_agent_created_by,chat_agent_updated_by,overview_sortings,organization
2 + 4,mherrguth@example.com,Marcel,Herrguth,mherrguth@example.com,"","","","",,"","","","",,false,false,true,"",,false,,,Customer,"",,"",,,"",
3 + 3,some-employee@example.com,Marcel,Herrguth,some-employee@example.com,"",+492214710231,"","","","","","","","",false,false,true,"",2024-11-26T17:01:15Z,false,,,Admin~~~Agent~~~Customer,"",,"",,,"",Zammad GmbH
4 + 2,nicole.braun@zammad.org,Nicole,Braun,nicole.braun@zammad.org,"","","","","","","","","","",false,false,true,"",,false,,,Customer,"",,"",,,"",Zammad Foundation