0001148: entities might block your generic import

ID	Project	Category	View Status	Date Submitted	Last Update

0001148	OXID eShop (all versions)	2. ----- eShop backend (admin) -----	public	2009-07-30 14:15	2009-08-18 08:55

Reporter	marco_steinhaeuser	Assigned To
Priority	normal	Severity	major	Reproducibility	always
Status	resolved	Resolution	fixed
Product Version	4.1.3 revision 19918
Fixed in Version	4.1.5 revision 21618

Summary	0001148: entities might block your generic import
Description	If you have entities in your CSV import file, the import may become mixed up a funny way as the seperators are semicolons: OXID;oxtitle;oxlongdescr 17889;steinhäuser;this is marco's last name -> "17889" goes to OXID -> "steinh&auml" goes to oxtitle -> "user" goes to oxlongdescr
Additional Information	Here http://www.oxid-esales.com/forum/showthread.php?t=1935 somebody offers a possible solution.
Tags	No tags attached.

Theme
Browser	All
PHP Version	5.2.6
Database Version	5.0.33

philipp_grashoff 2009-08-05 17:20 reporter ~0001364	AFAIK you should enclose all import data in quotes (not sure whether its double or single quotes in import). This should solve the problem: OXID;oxtitle;oxlongdescr '17889';'steinhäuser';'this is marco's last name' changing the separator isnt really a fix as the separator can always appear in the data, no matter which separator u use.

rimvydas_paskevicius 2009-08-13 17:03 reporter ~0001402 Last edited: 2009-08-13 17:04	Now when you start importing, in first step you can select cvs fields delimiter and string encloser symbol. These symbols are stored in DB.