And I have just confirmed that this is indeed the case (unless I lost my
mind).
This must be causing great confusing to anybody trying to piece together
examples from multiple places in DIH wiki and getting completely confused.
The example I had just now was:
1) I had this in XpathEntityProcessor example:
<field column="date" xpath="/add/doc/field[@name='date']"
dateTimeFormat="dd MMM yyyy"/>
2) I copy this to JDBC example:
<field column="date" name="DATE" dateTimeFormat="dd MMM yyyy"/>
The import fails due to date format not matching the field. But I have
DateFormatTransformer and it just worked for the other example.
3) Here is the correct line _for JDBC_:
<field name="date" column="DATE" dateTimeFormat="dd MMM yyyy"/>
Notice how the _name_ is what should match to the schema.xml. But of course
in the example 2 above, it worked against the DB, but then
DateFormatTransformer was looking for "DATE" rather than "date" field.
And this is an obvious setup, imagine if this was more subtle..... I bet
some people just give up on DIH handler because of this.
I'll fill in an issue, but I am surprised nobody got caught by this before.
Plus, wiki needs to be seriously updated.
Regards,
Alex. (wearing my ex-Tech Support hat)
Personal blog: http://blog.outerthoughts.com/
LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
- Time is the quality of nature that keeps events from happening all at
once. Lately, it doesn't seem to be working. (Anonymous - via GTD book)
On Mon, Jan 21, 2013 at 10:24 AM, Alexandre Rafalovitch
<arafa...@gmail.com>wrote:
> Hello,
>
> When I look at XPathEntityProcessor, it seems that "column" refers to a
> field registered in schema.xml and "xpath" to the source content.
>
> When I look at JdbcDataSource, it seems that "column" refers to the source
> content (in the database) and "name " to a field registered in schema.xml
>
> When I look at Transformers, which one assumes can apply to both, they use
> "column" and "sourceColName" to refer to names that may or may not be
> registered in schema.xml (the critical architecture diagram image seem to
> be missing).
>
> Given that this is all within one Wiki page and the examples
> cross-reference each other a bit, this is awfully confusing.
>
> Does anybody have a straight insight into this?
>
> Thank you,
> Alex.
>
