How to increase max title length when import via csv

More
11 years 4 months ago #37714 by lordphoenix
Hi,

I have a problem that I need to import many items that have long title (more than 255) via CSV import.

I have changed structure of title, alias and title-alias column of #_contents table from varchar(255) to text but it still not work.

Please help me, I have no idea about this. :cry:

Regards,

Please Log in or Create an account to join the conversation.

More
11 years 4 months ago #37718 by micker
hello
actualy the best way is use fleximport by netassopro a 3th party component
go to extension part of flexicontent site
regards

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

More
11 years 4 months ago #37730 by ggppdk
Hello,
we have done a lot of work in CSV import view, of course, despite powerful particular scenarios not be possible.

about your question

- the only limitation should be at the DB table, because inside code i don't see or (remember) any place to put this limit,

but without taking time to test this i cannot say the limitation maybe by some function of joomla.

a question: when looking at the DB table , then you see the text being truncated? or you see it truncated when item EDIT form loads ?


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
11 years 4 months ago #37747 by lordphoenix
Hi

micker,
Thank you for your suggestion, but I prefer to save my money because I think the extention is too expensive for me and I have already make software to convert my data to csv.

ggppdk,
Thank you for your support,
About your question, when I import some long title items the browser(chrome) is loading for a while, then they show 'connection error page' but when I delete the long title items it's work!!.

In debug mode, It's show correct long title.

FYI, I have attach 'example.csv' that contain a confusing long title item. (title is Thai lang with UTF-8 encoding)

Regards
Attachments:

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.329 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline