RE: Scarab XML import

"Chang, Jay" <[email protected]> Fri, 3 Sep 2010 14:31:10 -0600
Newsgroups gmane.comp.java.scarab.user
Message-ID <6276EFE82EC5D24ABE2159508D737EF60D5FEC1C@lmv08-mx01.corp.intrado.pri>
Hi Nathan and Mick,

Regarding (2) from my question: I tried /, \, //, and \\ for Windows attach=
ed file path and they all failed.  Since it works on Linux, I don't have to=
 use Windows for importing issues.

Regarding (3) from my question:  the dependency import seemed working for s=
ome issues but failing for others and it was not working for cross modules =
dependency at all.  There were too many issues to export, edit, and re-impo=
rt them to Scarab.  In addition, as Mick indicated update-same-db didn't fu=
nction as I thought it would.  Instead I imported those dependencies as com=
ments in the affected issues.  That satisfied our requirements.

Gentlemen, I appreciate all your helps.
Jay


-----Original Message-----
From: Kunkee,Nathan [mailto:[email protected]]=20
Sent: Wednesday, September 01, 2010 11:39 AM
To: [email protected]
Subject: RE: Scarab XML import

Hi Jay,

For (2), try both double backslashes \\ and using forward slashes instead /=
.
C:\\temp\\s940ftp.txt
C:/temp/s940ftp.txt
Java likes forward slashes while Windows uses backslashes, and I suspect on=
e of those will work.

For (3), I don't believe I imported any dependencies, but your idea sounds =
reasonable. I'd add all dependencies to the end of a single XML file (all i=
ssues + all dependencies) so that they load at once, leveraging the same ID=
 values throughout the file. Or, import all issues, export them all with Sc=
arab IDs, and then try an import of the dependencies using the Scarab ID va=
lues. NOTE: I have not tested or looked at code for these scenarios! Use at=
 your own risk, YMMV, etc.

Good luck!
Nathan

-----Original Message-----
From: Chang, Jay [mailto:[email protected]]=20
Sent: Monday, August 30, 2010 4:16 PM
To: [email protected]
Subject: RE: Scarab XML import

Hi Mick and Nathan,

Thanks for your helps.  I made some progress on importing issues.

(1) Importing COMMENT: With Nathan's suggestion, I added <id> elements for =
all <activity-set> and <activity> elements.  At first, they seemed worked r=
andomly for some but failed on others.  I then found that <description> ele=
ments must contain 250 characters or less in order to work properly; althou=
gh UI history tab shows <description> (Action) element can be much longer t=
han 250 characters.

(2) Importing ATTACHMENT: I used an admin account which has Domain__Admin a=
nd Domain__Edit permissions but it didn't work without changing ImportIssue=
s.java [from public ImportIssues(){this(false);} to public ImportIssues(){t=
his(true);}].  However, I'm still having problem on Windows XP platform.  I=
 get errors such as:=20
=09** Could not find file attachment "C:\temp\s940ftp.txt" **
While the OS file does exist.  Tested on Linux with "/tmp/s940ftp.txt" work=
ed fine.  Any idea why it is failing on Windows?

(2) Importing dependency: I have yet to test how it works.  Since all issue=
s must be exist in the DB before dependency records can be imported.  I am =
thinking to import all issues without dependency first, and then import jus=
t dependency with import-type "update-same-db" the second round.  Will this=
 work?  How did you accomplish this task in the past?

Thanks again,
Jay

PS. I'm using Scarab version 0.21



----------------------------------------------------------------------
CONFIDENTIALITY NOTICE This message and any included attachments are from C=
erner Corporation and are intended only for the addressee. The information =
contained in this message is confidential and may constitute inside or non-=
public information under international, federal, or state securities laws. =
Unauthorized forwarding, printing, copying, distribution, or use of such in=
formation is strictly prohibited and may be unlawful. If you are not the ad=
dressee, please promptly delete this message and notify the sender of the d=
elivery error by e-mail or you may call Cerner's corporate offices in Kansa=
s City, Missouri, U.S.A at (+1) (816)221-1024.

------------------------------------------------------
http://scarab.tigris.org/ds/viewMessage.do?dsForumId=3D456&dsMessageId=3D26=
54154

To unsubscribe from this discussion, e-mail: [[email protected]=
is.org].

------------------------------------------------------
http://scarab.tigris.org/ds/viewMessage.do?dsForumId=3D456&dsMessageId=3D26=
55252

To unsubscribe from this discussion, e-mail: [[email protected]=
is.org].