Developer forum

Forum » CMS - Standard features » Users update
Giuseppina Giunta
Reply

I have to update Users using Data Integration module.

I'm trying to upload my .csv file but I have this error:

 

12-09-2014 11:35:25    Batch failed.    
12-09-2014 11:35:25    Finished job - sett1.    
12-09-2014 11:35:25    Job Failed with the following message:
The CSV appears to be corrupt near record '0' field '5 at position '1673'. Current raw data : 'AccessUserID;AccessUserUserName;
AccessUserPassword;AccessUserName;AccessUserDepartment;AccessUserEmail;AccessUserPhone;AccessUserFax;AccessUserGroups;
AccessUserType;AccessUserValidFrom;AccessUserValidTo;AccessUserPages;AccessUserAreas;AccessUserSettings;AccessUserModules;
AccessUserInformation;AccessUserMyFolder;AccessUserAddress;AccessUserAddress2;AccessUserZip;AccessUserCity;AccessUserCountry;
AccessUserJobTitle;AccessUserCompany;AccessUserPhonePriv;AccessUserMobile;AccessUserCustomerNumber;AccessUserRedirectOnLogin;
AccessUserCurrencyCharacter;AccessUserRead;AccessUserAdsiMap;AccessUserPasswordDate;AccessUserLastName;AccessUserMiddleName;
AccessUserActive;AccessUserImage;AccessUserBusiness;AccessUserInitials;AccessUserComment;AccessUserLevel;AccessUserInheritAddress;
AccessUserWeb;AccessUserSort;AccessUserStatus;AccessUserStatusBegin;AccessUserStatusEnd;AccessUserStatusComment;AccessUserEditorConfigurationID;
AccessUserHideStat;AccessUserCartID;AccessUserAllowBackend;AccessUserApprovalKey;AccessUserIsConvertedByWizard;AccessUserExternalID;
AccessUserSortXML;AccessUserShopID;AccessUserGeoLocationLat;AccessUserGeoLocationLng;AccessUserGeoLocationIsCustom;
AccessUserGeoLocationImage;AccessUserGeoLocationHash;AccessUserIsAccount;AccessUserAccountPermissions;
AccessUserNewsletterAllowed;AccessUser_Informations;AccessUser_Web;AccessUserCreatedOn;
AccessUserUpdatedOn;AccessUserCreatedBy;AccessUserUpdatedBy;AccessUserEmailPermissionGivenOn;
AccessUserEmailPermissionUpdatedOn;AccessUserState;AccessUserVatRegNumber;AccessUser_City_Code;
AccessUser_Other;AccessUser_PostalBox    
12-09-2014 11:35:25    Importing data to table: AccessUser    
12-09-2014 11:35:22    Starting job - sett1.    
12-09-2014 11:35:20    Starting batch

 

What is the problem?

Thank you.

Giuseppina


Replies

 
Merethe Nielsen
Reply

Hi,

Have you checked that the .csv follows the correct structure?

You can check the structure with a samle .csv file that you can download here (links above the first image):
http://developer.dynamicweb.com/documentation/for-developers/data-integration/providers/user-provider.aspx

Kind regards,
Merethe

 

You must be logged in to post in the forum