Hi!
Like I said, I haven't tried this exact configuration, but my guess is
that the date function doesn't really work (maybe it's already looking
for something like metadata.approved). Anyways, here's what I use for
replicating approved articles in a 1.8. database:
<xsl:template match="mgd:midgard_article">
<xsl:if test="java:DateFunctions.timestampFromDate(mgd:approved)
>= java:DateFunctions.timestampFromDate(mgd:revised)">
<xsl:copy><xsl:apply-templates/></xsl:copy>
</xsl:if>
</xsl:template>
But I guess you already have something like this in place.
I just looked at the Exorcist source (I sincerely hoped I'd never have
to do that again :-) and in MidgardImporter.java line 147 I see the
following:
Timestamp created = getDate("metadata_created");
Timestamp revised = getDate("metadata_revised");
I know it's not the properties you're looking for (and maybe that's
already hacked by me and looks differently in the original source), but
maybe this gives you some clue. In MidgardExporter.java, there is
something similar in line 224:
builder.addContentElement("metadata_revised",
findRevised(guid));
What you could also try is to comment out the importer bean definition
in your staging2live.xml, this will redirect the XML output to the log
file, maybe this provides some hints as well.
Bye, and good luck!
Andreas
Mike Ross schrieb:
Does anyone have any ideas regarding this? everything i have tried has been
unsuccessful - even a duplicate of the staging database on live does not help
(trying to force it to update)
What i know so far:
Exorcist is successfully exporting all the approved topics and articles
correctly.
Exorcist does not import any of the approved topics and articles. (the problem)
Its not the config, sitegroups etc.
All styles, host info, pages, snippets etc transfer correctly and without any
issue.
At what point does exorcist check to see if an article is approved?
Looking at an example approved article in the database:
guid=f59b34e8c161b8a14fc3a886735e5810
repligard table
---------------
+----+---------------------+---------------------+---------+----------------------------------+--------+-----------+---------+---------------------+---------+---------------------+----------+--------+---------------------+--------+----------+---------------------+----------+------------------+---------------------+------------------+---------------------+-------------------+-------------------+---------------------+-----------------+---------------------+
| id | changed | updated | realm | guid
| action | sitegroup | creator | created | revisor |
revised | revision | locker | locked | author |
approver | approved | typename | metadata_creator | metadata_created
| metadata_revisor | metadata_revised | metadata_revision |
metadata_approver | metadata_approved | metadata_locker | metadata_locked
|
+----+---------------------+---------------------+---------+----------------------------------+--------+-----------+---------+---------------------+---------+---------------------+----------+--------+---------------------+--------+----------+---------------------+----------+------------------+---------------------+------------------+---------------------+-------------------+-------------------+---------------------+-----------------+---------------------+
| 74 | 2007-08-29 12:43:07 | 0000-00-00 00:00:00 | article |
f59b34e8c161b8a14fc3a886735e5810 | update | 1 | | 0000-00-00
00:00:00 | | 0000-00-00 00:00:00 | 0 | | 0000-00-00
00:00:00 | 2 | | 0000-00-00 00:00:00 | |
| 0000-00-00 00:00:00 | | 0000-00-00 00:00:00 |
0 | | 0000-00-00 00:00:00 | | 0000-00-00
00:00:00 |
+----+---------------------+---------------------+---------+----------------------------------+--------+-----------+---------+---------------------+---------+---------------------+----------+--------+---------------------+--------+----------+---------------------+----------+------------------+---------------------+------------------+---------------------+-------------------+-------------------+---------------------+-----------------+---------------------+
article table
-------------
+----+----+-------+--------+---------------------+------------+---------+------+------+-------+--------+--------+--------+---------------+---------+---------+----------+----------+---------------------+---------------------+-------+------+---------------------+--------+-----------+---------------+
| id | up | topic | author | created | calstart | caldays |
icon | view | print | extra1 | extra2 | extra3 | name | creator |
revisor | revision | approver | revised | approved |
score | type | locked | locker | sitegroup | metadata_size |
+----+----+-------+--------+---------------------+------------+---------+------+------+-------+--------+--------+--------+---------------+---------+---------+----------+----------+---------------------+---------------------+-------+------+---------------------+--------+-----------+---------------+
| 74 | 0 | 23 | 2 | 2007-08-29 12:43:07 | 1900-00-00 | 0 |
0 | 0 | 0 | | | | Consultations | 2 |
2 | 2 | 2 | 2007-08-29 12:43:07 | 2007-08-29 12:43:07 | 0 |
0 | 0000-00-00 00:00:00 | 0 | 1 | 0 |
+----+----+-------+--------+---------------------+------------+---------+------+------+-------+--------+--------+--------+---------------+---------+---------+----------+----------+---------------------+---------------------+-------+------+---------------------+--------+-----------+---------------+
article_i table
---------------
| id | sid | title | abstract | content | author |
created | url | lang | sitegroup |
+----+-----+---------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------------------+-----+------+-----------+
| 74 | 74 | Consultations | | <p></p>content here</p> | 0 |
2007-08-29 12:43:07 | | 0 | 1 |
+----+-----+---------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------------------+-----+------+-----------+
Mike.
_______________________________________________
user mailing list
[email protected]
http://lists.midgard-project.org/mailman/listinfo/user
_______________________________________________
user mailing list
[email protected]
http://lists.midgard-project.org/mailman/listinfo/user
