User Import / Export

scipio-user-manager-import-export

 

The Import/Export screen (“User » Import/Export”) is a quick and easy way to create and export user-accounts. The tool relies on CSV files (comma-seperated files).

 


Example CSV File

"partyId","preferredCurrencyUomId","groupName","firstName","middleName","lastName","companyPartyId","companyName","roleTypeId","contactMechPurposeTypeId","contactMechTypeId","emailAddress","telCountryCode","telAreaCode","telContactNumber","address1","address2","city","stateProvinceGeoId","postalCode","countryGeoId",
"admin","","","THE","","ADMINISTRATOR","Company","Your Company Name Here","CUSTOMER","ORDER_EMAIL","EMAIL_ADDRESS","ofbiztest@example.com","","","","","","","","","",
"admin","","","THE","","ADMINISTRATOR","Company","Your Company Name Here","CUSTOMER","PRIMARY_EMAIL","EMAIL_ADDRESS","ofbiztest@example.com","","","","","","","","","",
"admin","","","THE","","ADMINISTRATOR","Company","Your Company Name Here","CUSTOMER","BILLING_LOCATION","POSTAL_ADDRESS","","","","","123 The Lane","Some District","Some Town","GB-BDFD","124 c525","GBR",
"admin","","","THE","","ADMINISTRATOR","Company","Your Company Name Here","CUSTOMER","SHIPPING_LOCATION","POSTAL_ADDRESS","","","","","123 The Lane","Some District","Some Town","GB-BDFD","124 c525","GBR",
"admin","","","THE","","ADMINISTRATOR","Company","Your Company Name Here","CUSTOMER","PHONE_SHIPPING","TELECOM_NUMBER","","23","233","234234234","","","","","","",
"admin","","","THE","","ADMINISTRATOR","Company","Your Company Name Here","CUSTOMER","PHONE_BILLING","TELECOM_NUMBER","","12","233","324234234234","","","","","","",
"admin","","","THE","","ADMINISTRATOR","Company","Your Company Name Here","CUSTOMER","PHONE_SHIPPING","TELECOM_NUMBER","","1","444","4566788666","","","","","","",