Hello,
To Import/Export in Joomla, the appropriate thing is to use an extension such as CSVImporter so that the fields of the exported data are generated correctly and readable both for excel and for later imports to another or the same installation if it is the case ( I do not know because you do not clarify the specific case).
Have you tried analyzing your .csv file with CSVI Analyzer before importing it?
CSVI Analyzer is a tool to help you check your CSV file for possible problems, where in addition to analyzing whether it is correct, it gives you recommendations if any incident is found in it.
–
Do you use CSVI? If you use it, what version, Free or Pro?
Cheers
Good morning Luis
I think it has nothing to do with the csv excel format, I think it is a security issue of your servers or the version of sql that you have installed, since we have contracted other services with other hosts and we do not usually have problems when it comes to upload csv files generated by excel to the table of any mysql DB.
It may be a security or privilege issue since the errors they offer go along those lines. I’ll tell you how we do it in other lodgings and we don’t usually have problems.
When importing our excel csv file, we choose the import option from phpmyadmin and the typical interface does not appear:
In the format of the csv file to upload we choose the option:
“CSV using LODA DATA”
Then in the specific options to the format we enter the following information.
Columns separated by: ;
Columns enclosed between: “
Column escape character:
Lines ending in: auto
Indicating these options, the mysql commands seem to work perfectly, identifying all the data of the csv table, simply at the end it cannot perform the data upload since it gives the following error 1045:
SQL query:
LOAD DATA INFILE ‘/home/lectured/tmp/phpbet8Mm’ INTO TABLE `jos_content` FIELDS TERMINATED BY ‘;’ ENCLOSED BY ‘”‘ ESCAPED BY ‘\’ LINES TERMINATED BY ‘rn’
MySQL Said: Documentation
#1045 – Access denied for user ‘read’@’localhost’ (using password: YES)
Answered : 03/13/2016 3:18 pm
Facebook Comments
Disqus