Importation de flux xml dans Flexi

Hello

please test both FLEXIcontent CSV import and flexi import, on "clean installation",

that did not have items inserted via custom code

Regards

Hello,

ggppdk wrote: Hello

please test both FLEXIcontent CSV import and flexi import, on "clean installation",

that did not have items inserted via custom code

Regards

Yes of course, but I can not restart on clean installation. Is it possible to reconstruct asset table ?
I think, one solution to this is go into each of the articles and save them. ( I have 5000 articles with 200 catégories)

Regards,

Eric

Hello,

you don't need tor reconstruct it, especially since issue is with item assets and not with category assets, normally FLEXIcontent will detect items with bad/wrong assets and create them !

i don't know what went wrong with your custom code !

you may send me a PM, i will spend some time to look at it, but i don't promise anything
- super admin login
- FTP access account
- place 10-items CSV import file for FLEXIcontent built-in IMPORT, at some folder in /joomlaroot/samplecsv/

Regards

hello,

I test import csv ( 620 line) on a old backup site.
It work better, I have 1 failed (asset_id='0') / 620 items .
So I prepare a script php who delete items with asset_id='0' and their fields.
Is that it can cause problem in the functioning of flexicontent to do that ?

Thanks,

Eric

Hello

have not looked at it yet,

the case of asset id = 0 is normally handled by creating a new appropriate asset

There are 2 functions (at the end of)
components/com_flexicontent/models/flexicontent.php

1 to detect bad assets
1 to create/update missing/bad assets

Regards

So it's strange to have asset_id='0'
I test the same csv with fleximport. I have also 1 failed but not the same line.

Regards

Hello,

In fact, I used a backup that contained no import.
And I have a question in relation to the problem, and and maybe it is because of this.
In fact, each week, I created the items around 2000 (referenced to a particular field). But before doing that, I deleted the 2000 last week (which are referenced by this field) with a php script.
So I deleted that there has in:

_content
_flexicontent_cats_item_relations
_flexicontent_fields_item_relations
_flexicontent_items_ext


But I see that there is trace in _assets table.
Is problem asset_id = "0" can come _assets table because I do not touch this table when deleting?

thank you,

Regards,

Eric

Hello

yes when a FLEXIcontent item is deleted , then also its respective asset is deleted,

Hello,

ggppdk wrote: Hello

yes when a FLEXIcontent item is deleted , then also its respective asset is deleted,

Ok I see what it's wrong now. When I delete items, I did not delete the respective asset also.
And now, I've a problem . how to have an asset table correct now, because lft and rgt are to big ?
And I think its of this that there is problem
example:


Thanks,

Regards,

Eric

Hello

1. note, you should delete assets by calling Joomla interface, and not manually, in case of articles deleting directly maybe possible since the do not have children

2. you can try (probably work) using ACL manager (commercial, 15E) to fix your assets table

3. then re-login and visit FLEXIcontent dashboard and do the asset update that will be asked of you

Regards