import feature: which value to use for category?

Quote

nican

Total posts: 392
24 Oct 2015 13:27

Hello,

when testing the import feature I always receive an error saying that the category has not been selected

in the database table I see this value for the category associated to a record

{"4":"Scienza e Tecnologia"}

do I have to use the same value in the csv file? - "category-id":"category name"

Currently I have just: Scienza e Tecnologia

eg:

id,title,text,created_by,created,author,category,hits
3,Alan Watts,"Lo Zen non confonde la spiritualità con il pensare",1395,28-02-2013 12:38,Alan Watts,Scienza e Tecnologia,198

Thank you

Last Modified: 28 Oct 2015

Quote

klox7

Total posts: 914
25 Oct 2015 16:44

For me it works with category name, so your Scienza e Tecnologia should be fine.

Quote

nican

Total posts: 392
26 Oct 2015 08:50

Thanks, some times the syetm shows the category selection field during import, some others it son't. But even when it does and I select the correct category to asscoiate, it just doesn't import it.

Quote

Sergey

Total posts: 13,748
26 Oct 2015 08:53

Try to encode your file UTF-8 without BOM.

Quote

nican

Total posts: 392
26 Oct 2015 12:04

Sergey Try to encode your file UTF-8 without BOM.

Here is the .csv. file encoded in UTF-8

quotes import first 3 -utf8

Still not importing the category, I tried to change the category name in the file and also select a different category where to import. Still not importing.

Quote

Sergey

Total posts: 13,748
27 Oct 2015 12:37

I have successfuly imported it into selected category, your given CSV. Try create local Joomla and test there. now i suspect your server somehow.

Quote

nican