Seon Enterprise partner migration - Revision history

Admin: /* Generic CSV */

2018-05-11T11:15:43Z

‎Generic CSV

2017-08-08T13:48:52Z

2016-02-16T08:40:44Z

2015-04-28T11:48:43Z

‎Daxware CSV

2015-04-28T11:48:30Z

‎Generic CSV

2015-04-28T11:39:18Z

‎Generic CSV

2015-04-28T11:25:35Z

‎Generic CSV

2015-04-28T11:25:13Z

‎Generic CSV

2014-08-19T15:25:19Z

2013-12-13T11:54:36Z

‎Generic CSV

@@ Line 76: / Line 76: @@
 The header of the CSV file must be:
   Companyname;Companylocation;Lastname;Firstname;Phonenumber;Mobilenumber;Faxnumber;eMail;Department;Password;Userrole;AddressCode;Username
 == DDX ==

← Older revision		Revision as of 13:48, 8 August 2017
Line 89:		Line 89:

	Depending on the speed of your system(s), the migration should not take longer than 10 minutes.		Depending on the speed of your system(s), the migration should not take longer than 10 minutes.
		+
		+
		+	[[Category:Seon Enterprise]]

@@ Line 11: / Line 11: @@
 #Import "departments and recipients" CSV
 The second step is based on the first step, so it would make no sense to switch the order of import.
 == EurexC ==

@@ Line 35: / Line 35: @@
 The CSV for companies and locations (in one file) must contain exactly this following header line as the first line to be contained in the CSV file:
-  Companyname;Street;Housenumber;PostalCode;City;Country;Phonenumber;Fax;SSID;SFID;Net;Address;Password;Characterset;Fileformat;Recordsize;
+  Companyname;Street;Housenumber;PostalCode;City;Country;Phonenumber;Fax;SSID;SFID;Net;Address;Password;Characterset;Fileformat;Recordsize
 The second file for departments and recipients must contain exactly this following header line as the first line to be contained in the CSV file:
-  Companyname;Companylocation;Lastname;Firstname;Phonenumber;Mobilenumber;Faxnumber;eMail;Department;Password;Userrole;
+  Companyname;Companylocation;Lastname;Firstname;Phonenumber;Mobilenumber;Faxnumber;eMail;Department;Password;Userrole
 The references between the two files are the names of the company (1. "Companyname" = 2. "Companyname" ) and the location name 1. "City" = 2. "Companylocation").

@@ Line 56: / Line 56: @@
 *username
 The header of the CSV file must be:
-  Companyname;Companylocation;Lastname;Firstname;Phonenumber;Mobilenumber;Faxnumber;eMail;Department;Password;Userrole;AddressCode;Username;
+  Companyname;Companylocation;Lastname;Firstname;Phonenumber;Mobilenumber;Faxnumber;eMail;Department;Password;Userrole;AddressCode;Username
 == DDX ==

@@ Line 52: / Line 52: @@
 === Generic CSV ===
-In addition to the above documented Daxware CSV format, you can upload a CSV formatted file for departments and recipients  with two more attributes:
+In addition to the above documented Daxware CSV format, you can upload a CSV formatted file for departments and recipients  with two more attributes (starting with Seon release 2015-04-29):
 *address code
 *username

@@ Line 29: / Line 29: @@
 The partner databae schema must exist in the same database which Seon is working on. If the underlying tables exist, but the button is disabled, please contact us in order to verify your (possibly inconsistent) data.
-== Generic CSV ==
+== CSV ==
 Via the Daxware import possibility, you can generate CSV files with a given format in order to import your partner data. The format of the files must follow a fix syntax.
@@ Line 39: / Line 41: @@
 The references between the two files are the names of the company (1. "Companyname" = 2. "Companyname" ) and the location name 1. "City" = 2. "Companylocation").
 The field names indicate the value of the entity. Some words about special values:
@@ Line 49: / Line 50: @@
 **Entries with the same department, same company, same first name and same last name are updated; all others are inserted
 **all departments of a given location with the same department name are being updated; all others are inserted
 == DDX ==

← Older revision		Revision as of 15:25, 19 August 2014
Line 38:		Line 38:
	Companyname;Companylocation;Lastname;Firstname;Phonenumber;Mobilenumber;Faxnumber;eMail;Department;Password;Userrole;		Companyname;Companylocation;Lastname;Firstname;Phonenumber;Mobilenumber;Faxnumber;eMail;Department;Password;Userrole;

−	The references between the two files are the names of the company (1. "Companyname" = 2. "Companyname" )and the location name 1. "City" = 2. "Companylocation").	+	The references between the two files are the names of the company (1. "Companyname" = 2. "Companyname" ) and the location name 1. "City" = 2. "Companylocation").