Default DB Table fields

Posted in: Newspaper
Post count: 11

Our system uses a service that pulls in data from Adobe IN Design and posts it to our website. Our pubs are actually printed so this is the way for us to go. However when we are running into some issues.

Can you tell me what the default post form fields correlate to in the DB Table? I need to know so we can map them properly. The headline, body, all that stuff. If I could get that it would make mapping the data a whole lot easier.

You have a few extra ones like Source, Via and some other options that we would love to use from our interface, but I need some sort of map to show me how to flow the data properly so these fields get utilized.

Thank you.

Post count: 22421

Hello
Our theme uses the default database of wordpress. It does not change anything in the db structure. There are only 2 tables for posts. wp_posts and wp_postmeta
Thank you!

Post count: 11

Thank you.

Okay so are there added values in one of these tables to elicit the behavior for the articles?

We need to be able to add from an interface the various values the posts are taking. For example, I want to be able to send the Via and Via URL from this interface. How does that happen what value is added and where? Also to be able to choose between video and standard post types. All the extras are the things I need to figure out so we can get this thing working properly and then start using it for our other publications.

Gerald

Post count: 22421

Hello Gerald,

Unfortunately if you cannot manage to find the necessary fields, you will have to hire a developer as this falls beyond what the theme support can provide. We do not have a customization department so we cannot offer any such services. Sorry.

Post count: 11

Okay I think you are misunderstanding. I don’t want anything customized from you at all. I want to know what the fields you added via your template populate in the postmeta.

ie. you have added subheadline… what is that in the postmeta? you have a via field… what is that in the post meta? You added a source field… what is that in the postmeta? Does this make more sense to you now. I want this from you so I can map the XML feed from IN-Design.

Please and Thank You.

Post count: 22421

Hi,

All of the post settings including thesource and via are kept in wp_postmeta->td_post_theme_settings meta key
It is an empty array at first and is populated once the settings are applied to the post.

Thanks

Post count: 11

okay perfect. I did some digging and filled out all the arrays so that if I have one it can be applied in the table. I will share it here incase someone else uses this in a real newspaper setting. You should also consider adding this to your documentation. An actual newspaper uses InDesign to create newspapers. Then they flow that to the massive printers via an XML data feed and creates the printable pages via generated .pdf’s and also uses that XML feed to post the data where it is supposed to go in the websites. So when I send an article to print, I know where and how to map my fields i.e. sub-headline, cutline and so forth. Otherwise I’m stuck trying to figure this out by filling in a bunch of extra shit which really sucks, because you never know if you missed one or if something changes when it’s in a new template or whatever. So that is my plea to you, to make this actually useful in a real newspaper setting where your dealing with system integrations and writers submitting via the software’s article submission system, tell us what all the options are. What they lead to so its just simple and ready to go. Unless you already have something for that.

Here is what I was able to dig up, Will you see if there are others that I missed please.
———————————————————-
pulled via phpMyAdmin:

td_post_theme_settings

a:7:{
s:14:”td_primary_cat”;
s:3:”294″;
s:11:”td_subtitle”;
s:20:”This is the subtitle”;
s:18:”td_quote_on_blocks”;
s:24:”quote on blocks are here”;
s:9:”td_source”;
s:23:”this is the source name”;
s:13:”td_source_url”;
s:22:”this is the source URL”;
s:6:”td_via”;
s:20:”This is the Via Name”;
s:10:”td_via_url”;
s:19:”This is the via URL”;
}

———————————————————-

Post count: 22421

Hello,

Our theme is built for a newspaper type website, not a real newspaper where you pull information and print it. If you own a real newspaper then why use wordpress in the first place? WordPress is not a powerfull software you will need in a real newspaper. For that you will need an IT team that will handle everything you need, not a wordpress site and a printer. Our theme was built with a set amount of features and capabilities. If you require anything other than what we can provide you can either hire a developer to make the proper implementation you need or request a refund and we will provide it so you can choose another theme for your project.

Thank you!

Post count: 11

I literally have no idea what your talking about at this point. I never said it was bad. I never said I wanted a refund or that it didn’t work, so get off of the defense. As a matter of fact, I think NewsPaper is great and wonderfully well put together and exceeds our every expectation. I wanted to know what you named the table, rows and fields that YOU (TagDiv Team) added so I could pass it to the company that pushes the data-feed from the Printer to the website. Currently our system is set to push the XML feed to TownNews, the largest provider of Newspaper websites in the world. Their fields don’t match yours… I bet your shocked.

I wanted to know where to map my data for the fields YOU have built in here. E.G. YOU added a “via” field (AMONG OTHERS) on the admin-end of the post section. Okay so now, when I want to populate that field with data from the XML-feed. I would add the “Via Name” result to which table and field?

Instead of answering “via name” goes into “td_via” inside of “td_post_theme_settings”, I got you telling me that is custom work or I need to hire an IT team and that you’d give me a refund all while insinuating I and my company are stupid for using WordPress for this and then telling me how a real newspapers works. None of which was even remotely accurate, helpful or requested. Especially since thousands of newspapers are using WordPress and they are pushing hard at all the major press conventions with new papers converting daily. I do however know for a fact I never asked if you could be smarmy and condescending.

Post count: 22421

OK.
Let’s try this another way.

From your example:
td_primary_cat – https://forum.tagdiv.com/primary-category/
td_subtitle – https://www.screencast.com/t/zyLWDsV8
td_quote_on_blocks – https://www.screencast.com/t/jjUw9cZEM
td_source/td_source_url – https://www.screencast.com/t/xwfrsf8FL2
td_via/td_via_url – https://www.screencast.com/t/GFL29inOlP

Are there any other fields you are interested?

Thank you!

Viewing 10 posts - 1 through 10 (of 10 total)
The forum ‘Newspaper’ is closed to new topics and replies.