47 Posts
sebg
8 years ago
16
Topic

Good evening,


I import a site in a file with books (in French). I use com_importer
Here's my file structure

catid,title,autheur,nom_auteur,prenom_auteur,editeur,date_de_publication,introtext,image,numerique

I have problems to import introtext : in each books, it is the introtext of the first element that is import.

Could you help me ?


Get a Book for SEBLOD
4229 Posts
Kadministrator
8 years ago
0
Level 1

Are other fields imported correctly? Import can break if cvs file is not encoded correctly as utf-8 and/or server does not support utf fully, then import can break on fields that contain non-ascii characters.

47 Posts
sebg
8 years ago
0
Level 1

Hello Klas,

Thanks for answer.
Yes, other fiels are perfectly imported. I tried on two different servers (web and local) and I have same mistakes. The file is utf-8 without BOM....

47 Posts
sebg
8 years ago
0
Level 1

Hello,

I did several import tests but still the same result. I do not understand.
Can we import items into introtext? Are there any limits?

An example of import test file is here, all items are imported correctly except introtext which is always one of the first line for each element.

Could you help me ?

4229 Posts
Kadministrator
8 years ago
0
Level 1

Hi,

I can confirm the problem with your test file. Please report this together with test fiele on the seblo more github tracker:

https://github.com/Octopoos/SEBLOD_more/issues

47 Posts
sebg
8 years ago
0
Level 1

Hi,

I did it !
do you know whether the problem will be fixed quickly? 

Thanks

8 years ago
3
Level 1

In your csv file there are commata in the values for a field like in title. Use for seperator a semicolon ( ; ) or a ( | ).

19 Posts
web2e
8 years ago
2
Level 2

I have the same problem when try to import a csv file.

My csv file it is verry simple (is a test):

"catid";"title";"alias";"introtext";"state"
10;"Title 1";"title-1";"This is the first article";1
10;"Title 2";"title-2";"This is the second article";1

but when I import this file in the introtext I have always in the value of first row "This is the first article".

My test environmet is based on: Joomla 3.6.4, Sblod 3.10.0b, com_cck_importer_1.8.1

Can you help me to understand which is the problem ?

Thank you





4229 Posts
Kadministrator
19 Posts
web2e
8 years ago
0
Level 4

ok, I'll wait for the next version

Thank you for your replay

38 Posts
CDCG
7 years ago
2
Level 1

Has this issue been resolved?  The current import tool still doesn't support.  Fulltext has the same problem.  If the importer hasn't been updated, is there a work around to this?  Thanks in advance.

4229 Posts
Kadministrator
7 years ago
1
Level 2

Judging by the status at the issue there was no progress since it was reported.

38 Posts
CDCG
7 years ago
0
Level 3

Do you know, is there any intent to fix?  And do you have a suggested work around?  Thanks in advance.

103 Posts
shubhaanshu
7 years ago
3
Level 1

Hi, this problem still persists and we are feeling very helpless to import data :(

I need to import 7436 articles in my new project, this is a wordpress to joomla migration, tried everything but unfortunately could not import the data.

Please update if anyone has the solution...

4229 Posts
Kadministrator
7 years ago
2
Level 2

Why do you insist on importing into introtext? You can create a new field and import into that one to avoid this problem.

103 Posts
shubhaanshu
7 years ago
1
Level 3

Thank you for your reply Klas! I tried creating a new field then imported some records, but it still created problem (multiple entries in a single introtext field)

4229 Posts
Kadministrator
7 years ago
0
Level 4

Did you create new field with new storage or did you use introtext column as storage? There is a problem with introtext as storage as seblod uses this database column for other purposes.

Get a Book for SEBLOD