Re: Is there a way to Copy/Replicate tasks in XPlanner. How about an import?

Shankar,

Sorry for responding so late.
There is no way to copy tasks. Direct SQL will have to take care of
incrementing the identifier table.

Good luck

Jacques

On 8/28/06, gyanapalam-email-/[email protected] <gyanapalam-email-/[email protected]> wrote:
>
> Hi There,
> I have a certain known tasks that are common to certain developer/acceptor
> groups. Is there a way to copy tasks in XPlanner.
> I know, I can do it by doing a SQL data import to task table. Will the IDs
> and timestamp generated will maintain integrity?
>
> It is a planned or unplanned feature. I don't see this common feature
> available.
> Is there a way to import tasks like user stories?
>
> Regards,
>
> (Shankar .P)
>
>
>
> *xplanner-devel-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org* wrote:
>
> Send Xplanner-devel mailing list submissions to
> [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/xplanner-devel
> or, via email, send a message with subject or body 'help' to
> xplanner-devel-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>
> You can reach the person managing the list at
> xplanner-devel-owner-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Xplanner-devel digest..."
>
>
> Today's Topics:
>
> 1. Re: XPlanner 0.7b7 throws SQLException during setup. Patch
> Scripts wont install (Jacques Morel)
> 2. Re: XPlanner 0.7b7 throws SQLException during setup. Patch
> Scripts wont install (gyanapalam-email-/[email protected])
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 25 Aug 2006 03:37:34 -0500
> From: "Jacques Morel"
> Subject: Re: [Xplanner-devel] XPlanner 0.7b7 throws SQLException
> during setup. Patch Scripts wont install
> To: gyanapalam-email-/[email protected], [email protected]
> Message-ID:
> <2ae5715c0608250137p7e2003d1ra07fc4ff1397bc48-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org>
> Content-Type: text/plain; charset="iso-8859-1"
>
> A little bit more information would be critical here to diagnose the
> problem.
> Are you a developer yourself? Put yourself in my shoes and then ask
> yourself
> what information would you needed in order to troubleshoot your problem?
> THEN write the email to request support. That will save everybody some
> time!
>
> Also a little bit of courtesy would be nice... A thank sometimes makes a
> world of difference when you do not pay for support.
>
> So now back to business:
> What database are your running?
> What version are you upgrading from or is it a brand new install?
> What package are you trying to install?
> Have you followed the steps in the README.txt in respect to setting
> xplanner-customer.properties properly? Could you dump it here?
>
> Jacques
>
> On 8/24/06, gyanapalam-email-/[email protected] wrote:
> >
> > [ 16796] ERROR - on.jdbc.SqlScriptMigrationTask -
> > patch0004_0-6-2_to_0-7b1_A.sql: Error running SQL "SELECT @id:=next FROM
> > identifier" java.sql.SQLException:
> > Unknown column 'next' in 'field list' at
> > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
> > at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
> > at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
> > at com.mysql.jdbc.Statement.execute(Statement.java:529)
> > at com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask.migrate
> (
> > SqlScriptMigrationTask.java:124)
> > at com.tacitknowledge.util.migration.MigrationProcess.doMigrations(
> > MigrationProcess.java:162)
> > at
> >
> com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(
> > JdbcMigrationLauncher.java:288)
> > at
> >
> com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(
> > JdbcMigrationLauncher.java:108)
> >
> >
> >
> > Shankar S. Pattabiraman,
> > Sr.Software Engineer
> > Applied Biosystems,Silicon Valley
> > Address:
> > 3770 Flora Vista Ave,#903
> > Santa Clara, USA.
> > *Res*: 408-985-7131,
> > *Mobie*: 408-623-7230
> >
> >
> -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services,
> security?
> > Get stuff done quickly with pre-integrated technology to make your job
> > easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> >
> > _______________________________________________
> > Xplanner-devel mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/xplanner-devel
> >
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://sourceforge.net/mailarchive/forum.php?forum=xplanner-devel/attachments/20060825/2c698392/attachment.html
>
> ------------------------------
>
> Message: 2
> Date: Fri, 25 Aug 2006 07:08:17 -0700 (PDT)
> From:
> Subject: Re: [Xplanner-devel] XPlanner 0.7b7 throws SQLException
> during setup. Patch Scripts wont install
> To: Jacques Morel ,
> [email protected]
> Message-ID: <20060825140817.58210.qmail-Mz9BxYqd2bKvuULXzWHTWIglqE1Y4D90QQ4Iyu8u01E@public.gmane.org>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi,
> My issue is resolved after dropping and recreating xplanner database and
> some tweaks(anyway it was my first xplanner DB setup. I was trying various
> combinations after looking at the log. Atlast the database reinitialization
> worked. I had posted the detailed message but the mailing list bounces back
> saying the message content is larger than 60 KB. )
> Message body is too big: 131571 bytes with a limit of 60 KB
>
> I guess xplanner patch upgrade scripts have some problem applying patch to
> a partially setup database(due to tomcat deploy errors)
>
> Answers to your questions:
> What database are your running? MySql 5.x(Oracle didn't work has issues
> with 10g Driver for Oracle 9i DB)
> What version are you upgrading from or is it a brand new
> install?None,Brand New. The DB Scripts in XPlanner is written to setup the
> old schema and upgrade[I find it from Tomcat log].
> What package are you trying to install? I was just letting the deployer
> setup the packages
> Have you followed the steps in the README.txt in respect to setting
> xplanner-customer.properties properly? Yes. Could you dump it here?
> *********************** XPLANNER INFO ************************ Build:
> Version: 0.7b7 Build Date: 05/24/2006 Build Revision: 1149 Build Package:
> War Database: Dialect:
> com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect Driver:
> com.mysql.jdbc.Driver Driver Version: mysql-connector-java-3.1.12 ( $Date:
> 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ ) Database
> Vendor: MySQL Database Version: 5.0.24-community-nt Database Name:
> xplanner Database Url: jdbc:mysql://localhost/xplanner Database User Name:
> xplanner Database User Password: ****** Database Patch Level: 3 App Server:
> Application Server: Apache Tomcat/5.5.12 Servlet Version: 2.4 System:
> System Date: Aug 23, 2006 System Time: 3:11:54 PM Current directory:
> C:\apache-tomcat-5.5.12\bin Java Version: 1.5.0_04 Java Vendor: Sun
> Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM
> Implementation Version: 1.5.0_04-b05 Java Runtime: Java(TM) 2 Runtime
> Environment, Standard Edition Java VM:
> Java HotSpot(TM) Client VM User Name: spattabi User Timezone:
> America/Chicago Operating System: Windows XP 5.1 OS Architecture: x86 [
> 12784] INFO - work.web.context.ContextLoader - Using context class [
> org.springframework.web.context.support.XmlWebApplicationContext] for root
> WebApplicationContext [ 12800] INFO - work.web.context.ContextLoader -
> Root WebApplicationContext: initialization completed in 12550 ms [ 14112]
> INFO - til.migration.MigrationProcess - Running migration task
> "patch0004_0-6-2_to_0-7b1_A.sql [
> com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask]"... [
> 15160] ERROR - on.jdbc.SqlScriptMigrationTask -
> patch0004_0-6-2_to_0-7b1_A.sql: Error running SQL "/* Purge unattached notes
> */ CREATE temporary table tempnote AS select n.id, n.attachment_id from
> note n left join project p on n.attachedTo_id = p.id left join iteration i
> on n.attachedTo_id = i.id left join story s on n.attachedTo_id = s.id left
> join task t on n.attachedTo_id = t.id where p.id is
> null and i.id is null and s.id is null and t.id is null"
> java.sql.SQLException: Unknown database 'xplanner' at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571
>
> -Shankar .P
> Jacques Morel wrote:
> A little bit more information would be critical here to diagnose the
> problem.
> Are you a developer yourself? Put yourself in my shoes and then ask
> yourself what information would you needed in order to troubleshoot your
> problem?
> THEN write the email to request support. That will save everybody some
> time!
>
> Also a little bit of courtesy would be nice... A thank sometimes makes a
> world of difference when you do not pay for support.
>
> So now back to business:
> What database are your running?
> What version are you upgrading from or is it a brand new install?
> What package are you trying to install?
> Have you followed the steps in the README.txt in respect to setting
> xplanner-customer.properties properly? Could you dump it here?
>
> Jacques
>
> On 8/24/06, gyanapalam-email-/[email protected] wrote: [ 16796] ERROR -
> on.jdbc.SqlScriptMigrationTask - patch0004_0-6-2_to_0-7b1_A.sql: Error
> running SQL "SELECT @id:=next FROM identifier" java.sql.SQLException:
> Unknown column 'next' in 'field list' at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at
> com.mysql.jdbc.Connection.execSQL(Connection.java :2988) at
> com.mysql.jdbc.Connection.execSQL(Connection.java:2917) at
> com.mysql.jdbc.Statement.execute(Statement.java:529) at
> com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask.migrate(
> SqlScriptMigrationTask.java:124)
> at com.tacitknowledge.util.migration.MigrationProcess.doMigrations(
> MigrationProcess.java:162) at
> com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(
> JdbcMigrationLauncher.java:288) at
> com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(
> JdbcMigrationLauncher.java:108)
>
>
> Shankar S. Pattabiraman,
> Sr.Software Engineer
> Applied Biosystems,Silicon Valley
> Address:
> 3770 Flora Vista Ave,#903
> Santa Clara, USA.
> Res: 408-985-7131,
> Mobie: 408-623-7230
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>
> _______________________________________________
> Xplanner-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/xplanner-devel
>
>
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://sourceforge.net/mailarchive/forum.php?forum=xplanner-devel/attachments/20060825/a200e746/attachment.html
>
> ------------------------------
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>
> ------------------------------
>
> _______________________________________________
> Xplanner-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/xplanner-devel
>
>
> End of Xplanner-devel Digest, Vol 3, Issue 9
> ********************************************
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>
> _______________________________________________
> Xplanner-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/xplanner-devel
>
>
>

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
Xplanner-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xplanner-devel