Manual Import to FLEXIContent v2.0

How I can know the structure of the database tables flexicontent?
I need to upload a package of 20,000 items but do not know which tables should I change?
I don't know how as connected or related the keys or the fields of each table

a tips for this use flexi import by netassopro you can export import all content in flexicontent with type field etc ...
extensions.netassopro.com/5-exte ... fleximport
regards

Moderator note: split from another thread

If you are just importing article text, you can use any Joomla import tool.

I did test this with Joomla 1.5/FLEXIcontent 1.5 using the Bulk Import component.
After import FLEXIcontent notified me to bind these new items.
And it was done.

Have not tested any other import tools on J2.5/FLEXIcontent 2.0.

Note that there is now a CSV import in upcoming FLEXIcontent 1.5.6.
This feature has not yet been ported to the FLEXIcontent 2.0 branch.
That is currently planned for the FLEXIcontent 2.1 version.

I too would like to know exactly what is needed to manually import data.
What tables, what fields, etc.
We should have this documented for the future.

.

Thanks Ken, yes the basic CSV import feature is not ported to the J2.5 version yet.

Also as Ken said you can use ANY joomla import tool, and then FLEXIcontent will notify about the new items and ask you to bind them to ANY of you content types

NOTE that recently i have include most of the code for CSV import to the J2.5 FC version, to finish, i think it is needed only just a little more work ...

Format is a comma separated CSV file that looks like:

title,text,field15,field16,field17,field18,field19
title of item 1,description of item 1,field15 value,field16 value,field17 value,field18 value,field19 value
title of item 2,description of item 2,field15 value,field16 value,field17 value,field18 value,field19 value
...

Of course the all field values can included new-lines characters and comma characters as long as the are quoted and escaped properly (remember it is a CSV file)

Regards

I'm trying to load the items of database via phpMyAdmin, in the table flexicontent_fields_item_relations, but does not work.
What is the base table where the data are? and Which tables are replicated?

Example of data:

INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`16`, `22`, `1`, `1`);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`17`, `22`, `1`, `AGO`);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`19`, `22`, `1`, `a:3:{s:4:"link";s:22:" www.faceconomia-uan.ao/";s:5:"title";s:9:"Faculdade de Economia Universidade Agostinho Neto;s:4:hits";s:0:"";}`);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`21`, `22`, `1`, ``);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`42`, `22`, `1`, ``);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`45`, `22`, `1`, `1`);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`46`, `22`, `1`, ``);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`47`, `22`, `1`, ``);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`16`, `23`, `1`, `1`);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`17`, `23`, `1`, `AGO`);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`19`, `23`, `1`, `a:3:{s:4:"link";s:22:" www.iseuan.ed.ao/";s:5:"title";s:9:"Instituto Superior de Enfermagem;s:4:hits";s:0:"";}`);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`21`, `23`, `1`, ``);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`42`, `23`, `1`, ``);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`45`, `23`, `1`, `2`);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`46`, `23`, `1`, ``);
INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES(`47`, `23`, `1`, ``);


Error
consulta SQL:

INSERT INTO `jos_flexicontent_fields_item_relations` ( `field_id` , `item_id` , `valueorder` , `value` )
VALUES (

`16` , `22` , `1` , `1`
);

MySQL ha dicho:

#1054 - Unknown column '16' in 'field list'

.
The usual Joomla article data is stored in the usual tables.
That is where the usual article text data should be imported.

This is one of the advantages of FLEXIcontent.
The normal Joomla content data and tables are used.

FLEXIcontent connects the extended data (the other fields you have created) to the usual Joomla data.
This connection is done via the item_relations table.
There is no data in that table.

If you are importing simple article text any Joomla import extension or manual technique will still work.
Then open the FLEXIcontent Items interface and it will ask you to bind those new articles data to the FLEXIcontent extended data.

This binding process will populate the items_relations table for you.

Are you trying to import anything other than the article text and other normal Joomla data such as creation date, etc.?

.