I'm very new to Refine, and so pardon me if this is a really simple question.
I'm trying to do some manipulation of some Wordpress data to speed along a process I'd rather not have to do by hand. I have a bunch of custom posts that have associated metadata, which I've exported from WP as an XML file. From this, I'd like to format a CSV file that I can upload back into WordPress (by way of a plugin) in order to tell it to assign each post in to a custom category taxonomy based on some of the metadata (this wasn't done during original data entry, for reasons not worth going into here). It's also got to reupload all the metadata, since the plugin creates new posts, rather than editing the existing ones (I'll just dump the existing ones in the trash).
This'd be easy if it were not for the fact that each post is represented by more than one row of data. There's a master row for the post that contains most of it, and then beneath that, there's a row for each custom field in the metadata. What I'd like to do is create columns for each metadata key, and then bring the value of that key for each post up from the several rows beneath the master row and into a column in the master row.
Hopefully that's clear.
I'd be glad for any thoughts or assistance. It's not a ton of data, but it's more than I really want to do by hand.
You received this message because you are subscribed to the Google Groups "Open Refine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
You received this message because you are subscribed to a topic in the Google Groups "Open Refine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openrefine/t88PE-q1kVM/unsubscribe?hl=en-US.
To unsubscribe from this group and all its topics, send an email to openrefine+...@googlegroups.com.
I sure can. You're thinking the Key/Value Columnize function should, ostensibly, be doing what I'm trying to do? Just so I know what to put in the ticket.