EE compatibility updates:

  • Publisher is EE5 compatible, but it does not currently support the Fluid field.

ExpressionEngine.com licenses:

  • If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: Export data

Status Client Wait
Add-on / Version Publisher 2.10.2
Severity
EE Version 5.3.2

Cameron Ross

Oct 05, 2020

Hi

I am trying to export translated data but it seems to be missing random content for no reason

is all entry translated data stored in exp_publisher_data and exp_publisher_titles?

This is my query

SELECT t.id,t.lang_id,t.title,t.entry_id,t.url_title, t.status,
( SELEct GROUP_CONCAT(cat_id) cid FROM exp_category_posts where entry_id = t.entry_id)  as cid,
d.field_id_1 as ct_body,
d.field_id_7 as short_description,
d.field_id_30 as ref,
d.field_id_48 as achive,
d.field_id_9 as image,
d.field_id_8 as thumb,
d.field_id_21 as ct_type,
d.field_id_44 as ct_search_url,
d.field_id_51 as external_url,
d.field_id_53 as reference,
s.title as meta_title,
s.keywords as meta_keywords,
s.description as meta_description ,
t.entry_date


FROM exp_publisher_titles t
left join exp_publisher_data d on t.id = d.id
where t.channel_id = ‘15’ and t.lang_id = 20

I ran a search for some of the missing content in php my admin but it could not find it even though i can see this data in EE when editing the entry

Strange

#1

BoldMinded (Brian)

Oct 05, 2020

Yes, if you’re using Publisher 2.10, which is old and no longer supported, all the data is in the tables you mentioned, unless you need Grid, Matrix, Relationship, Playa, or Assets data, or any other content type that is saved in their own tables.

#2

Cameron Ross

Oct 05, 2020

Thanks Brian

I think my query join is incorrect.

FROM exp_publisher_titles t
left join exp_publisher_data d on t.id = d.id

Do you know what the correct join is?

#3

BoldMinded (Brian)

Oct 05, 2020

Your best bet is probably to enable the query profiler and look at the queries Publisher is doing, and modify from there.

Login to reply

For add-on support, please use the Support section. General inquries and pre-sale questions can be sent to support@boldminded.com.