Table Transformer - concatenate data from multiple rows based on criteria

[Joel Tabares]

Hi,

SQL functions in Table Transformer is limited that i'm having trouble concatenating/merging data from multiple rows.

Table

Project  | Remarks

P1   |  The quick brown

P1   |  Fox jumps

P2   |  Over the

P2   |  Lazy dog

I need it to produce the output below:

Project | Remarks

P1   | The quick brown Fox jumps

P2   | Over the Lazy dog

[Ping Xiao]

Hello,

Do you have any updates?

I tried to do XML backup on the environment which is has 18GB data) but failed with the following error.

2014-07-05 22:02:27,985 WARN [Timer-0] [mchange.v2.async.ThreadPoolAsynchronousRunner] run com.mchange.v2.async.Th

readPoolAsynchronousRunner$DeadlockDetector@157b448 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!

Our current confluence is 3.4.9. We'd like to upgrade to 5.5.2. Based on Confluence recommendation, we are going to go through v3.5.17 and v5.0.1 and then v5.5.2. We have built a confluence v3.5.17 without data. How do we load the data from v.3.4.9 to v3.5.17? The v3.4.9 is using DB2. We will use Postgres for newer version. Do you have an upgrade/migration document for our situation?

thanks.

[Ping Xiao]

Do you have size limit for exporting from a large database for Confluence version 3.4.9?

What's the best way if we want to upgrade and migrate from a large database (18GB data)? Currently we are using version 3.4.9 and want to move to latest version 5.5.2. Our plan is to keep current version 3.4.9 and build a brand new 5.5.2 system and migrate data from 3.4.9.

thanks.

[Bruna Griebeler]

Hi,

Seems that the problem is related to the versions. If the XML file was generated on a v3.4.9, it should be imported on v3.4.9 as well. Just then you can upgrade it to a newer version.

The size also is bigger that the recommended for the XML to be well imported (2GB is the max).

So if the problem persists importing the XML using the same version, try exporting/importing spaces froma confluence to another.

Kind Regards