X-Cart:Import-Export Troubleshooting - Revision history

Dohtur: /* CSV import times out before completion. Large numbers of duplicate images are populating the /images/D folder. 'Drop' detailed images does nothing. */

2017-04-14T14:06:34Z

‎CSV import times out before completion. Large numbers of duplicate images are populating the /images/D folder. 'Drop' detailed images does nothing.

Dohtur: /* CSV import times out before completion. Large numbers of duplicate images are populating the /images/D folder. 'Drop' detailed images does nothing. */

2017-04-14T14:01:22Z

‎CSV import times out before completion. Large numbers of duplicate images are populating the /images/D folder. 'Drop' detailed images does nothing.

Dohtur at 13:58, 14 April 2017

2017-04-14T13:58:11Z

Seyfin: /* "I cannot import a CSV file generated on Mac" */

2013-12-16T12:49:38Z

‎"I cannot import a CSV file generated on Mac"

Dohtur at 10:15, 6 August 2013

2013-08-06T10:15:20Z

Seyfin: /* "I cannot import a CSV file generated on Mac" */

2012-08-01T06:03:23Z

‎"I cannot import a CSV file generated on Mac"

Ivka: /* "I cannot import a CSV file generated on Mac" */

2010-11-17T08:43:30Z

‎"I cannot import a CSV file generated on Mac"

Ivka at 08:34, 17 November 2010

2010-11-17T08:34:04Z

Ivka: /* Problem 4 */

2010-11-17T08:30:52Z

‎Problem 4

Ivka: /* Problem 4 */

2010-11-17T08:30:25Z

‎Problem 4

@@ Line 93: / Line 93: @@
 The problem may be related to using the FastCGI Apache Module.
-If using this module, you have to increase the values of the following settings  in the apache/FastCGI configs:
+If using this module, you have to increase the values of the following settings in the apache/FastCGI configs:
 :* [https://httpd.apache.org/mod_fcgid/mod/mod_fcgid.html#fcgidiotimeout FcgidIOTimeout] - The default value of 40 sec is too low for the import procedure;
 :* [https://httpd.apache.org/mod_fcgid/mod/mod_fcgid.html#fcgididletimeout FcgidIdleTimeout] - The default value of 300 sec is too low for the import procedure.

← Older revision		Revision as of 14:01, 14 April 2017
Line 87:		Line 87:
	* Execute the following PHP command from the command line:<br />php -r 'print_r(setlocale(LC_CTYPE, '0'));'		* Execute the following PHP command from the command line:<br />php -r 'print_r(setlocale(LC_CTYPE, '0'));'

		+	<div id="FastCGI"> </div>
	== CSV import times out before completion. Large numbers of duplicate images are populating the /images/D folder. 'Drop' detailed images does nothing.==		== CSV import times out before completion. Large numbers of duplicate images are populating the /images/D folder. 'Drop' detailed images does nothing.==

@@ Line 87: / Line 87: @@
 * Execute the following PHP command from the command line:<br />php -r 'print_r(setlocale(LC_CTYPE, '0'));'
-[[Category:X-Cart user manual]]
+== CSV import times out before completion. Large numbers of duplicate images are populating the /images/D folder. 'Drop' detailed images does nothing.==
-[[Category:X-Cart user manual]]
 [[Category:X-Cart user manual]]

@@ Line 57: / Line 57: @@
 If your CSV file was created with Macintosh, it may contain Macintosh EOL characters (\r). These characters are causing the problem.
-To fix the problem please ask your hosting provider to set the <u>'auto_detect_line_endings'</u> directive to 'true' in 'php.ini' on your server.
+To fix the problem please ask your hosting provider to set the <u>'auto_detect_line_endings'</u> directive to 'On' in 'php.ini' on your server.
 When this directive is turned on, PHP will examine the data read by fgets() and file() to see if it is using Unix, MS-Dos or Macintosh line-ending conventions.

@@ Line 66: / Line 66: @@
 If this does not help, please contact our support team for help.
 [[Category:X-Cart user manual]]
 [[Category:X-Cart user manual]]
 [[Category:X-Cart user manual]]

@@ Line 53: / Line 53: @@
 =="I cannot import a CSV file generated on Mac"==
-Please contact our support team for help.
+If your CSV file was created with Macintosh, it may contain Macintosh EOL characters (\r). These characters are causing the problem.
 [[Category:X-Cart user manual]]

@@ Line 1: / Line 1: @@
-== Problem 1 ==
+== "I cannot import a CSV file I have just exported" ==
 You cannot import a CSV file that you have just exported from your own store. The error message reads:
@@ Line 15: / Line 15: @@
 You are probably trying to re-import a file that was exported with the option '<u>Do you wish to export images?</u>' enabled. On export, your image files were saved to a temporary directory <u>/var/tmp/export_YYYYMMDD_HHMMSS</u> corresponding to the name of the main export file, while the image filenames were written to the export CSV file without filepaths. As you were not going to import images, you probably failed to specify a '<u>Directory where images are located</u>', which caused the error. To import the CSV file into the store without importing images, remove the column containing image filenames from the CSV file altogether (or create a new export CSV file, this time setting the option '<u>Do you wish to export images?</u>' to 'No').
-== Problem 2 ==
+== "I cannot import a CSV file I have edited in an external editor. The error says "A heading is missing"" ==
 You edited your CSV file in an external spreadsheet editor, and now you cannot import it. X-Cart generates an error like this:
@@ Line 29: / Line 29: @@
 Normally, X-Cart interprets two delimiter symbols following one after another as an empty field; however, the combination must not be used in heading rows like in the example above, as column headings may not be empty. To solve the problem, remove any delimiters leading X-Cart to believe there is an empty column heading.
-== Problem 3 ==
+== "I cannot import a CSV file I have edited in an external editor. The error says "Wrong data type"" ==
 You edited your CSV file in an external spreadsheet editor, and now you cannot import it. X-Cart generates an error like this:
@@ Line 40: / Line 40: @@
-== Errors during CSV import ==
+== "I get errors during CSV import" ==
 Attempting to import a CSV file, you get one or more errors of the following type:

← Older revision		Revision as of 08:30, 17 November 2010
Line 40:		Line 40:


−	== ~~Problem 4~~ ==	+	== Errors during CSV import ==

	Attempting to import a CSV file, you get one or more errors of the following type:		Attempting to import a CSV file, you get one or more errors of the following type:

← Older revision		Revision as of 08:30, 17 November 2010
Line 50:		Line 50:

	[[Image:Troubleshooting.png\|center\|581px]]		[[Image:Troubleshooting.png\|center\|581px]]
		+
		+	=="I cannot import a CSV file generated on Mac"==
		+
		+	Please contact our support team for help.

	[[Category:X-Cart user manual]]		[[Category:X-Cart user manual]]