Re: Form export and import - renaming
Hi, The index names are not in the DEF-file. I do not think they are used at all when importing your XML-definitions. They have database names though, but they are created on the fly. It seems very strange that the names are included in the XML-definition file, it makes no sense. I bet that the names are not reused if you import your XML-definition. Best Regards - Misi, RRR AB, http://rrr.se Fundamentally what I am saying its that the xml file has what appears to be hard coded Index names… (Even without me touching it) -John On Fri, Apr 13, 2012 at 2:11 PM, Joe Martin D'Souza jdso...@shyle.netwrote: ** I am not sure I understood what you are trying to say.. Are you saying that when you mend the def file to create a clone, the indexes are invalid? Joe *From:* John Sundberg john.sundb...@kineticdata.com *Sent:* Friday, April 13, 2012 1:05 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Form export and import - renaming ** Bruce/Misi, I did some experimenting -- seems to work… Below is the formIndexList section of the exported XML -- it does show index names by number. My test ARS box is 7.01 -- so maybe this is different in 7.6.4 -- will check… (7.6.4 -- same thing -- uses index names as indexes) Seems like a bug to me… formIndexList formIndex indexNameI899_179_1/indexName uniqueIndextrue/uniqueIndex fieldIDList fieldID179/fieldID /fieldIDList /formIndex formIndex indexNameI899_24005_1/indexName uniqueIndextrue/uniqueIndex fieldIDList fieldID24005/fieldID /fieldIDList /formIndex formIndex indexNameI899_72000_1/indexName uniqueIndexfalse/uniqueIndex fieldIDList fieldID72000/fieldID /fieldIDList /formIndex formIndex indexNameI899_24003_1/indexName uniqueIndexfalse/uniqueIndex fieldIDList fieldID24003/fieldID /fieldIDList /formIndex /formIndexList -John On Fri, Apr 13, 2012 at 10:49 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, Are you sure you are seeing the SchemaId in the definition file? I have never seen that. There should be no problem renaming the form name and reimporting. I have done an almost identical thing where I used normal DEF-files as templates, where the database-name of the template-fields represented the datatypes of my input data. FieldName;DataType ... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. * I THINK DIFFERENTLY --- SOMETIMES THAT IS GOOD -- SOMETIMES NOT ** Yes - I could just go in and save as... However -- this is a small part of a larger project…. Autogenerate Remedy forms form Lotus Notes forms - :) 1) Auto create table 2) Auto migrate data 3) Auto delete Notes table 4) Party!!! My ***guess*** is that the index references are unused (not sure about that) -- but -- if I were to take this def to a new system -- which already had a T189/I189 -- I would imagine this definition would not overwrite those indexes… -- so it is probably safe…. I was wondering if anybody KNEW -- that this was a bad idea. Here is the fundamental problem -- when I export a def of a form -- I get 12500 lines… (IMHO - unusable) Yeah -- probably has 20 fields on it -- but the xml is so crazy it takes 12500 lines to describe… So -- WHAT IF I … created something like this: my_sample_file.txt table MySample Table field RequestID, 1 field Submitter, 2 … field My unique field, 0 # 0 is autoassigen field MY unique field2, 0 index [My unique field,My unique field2], unique etc…. Then -- when your run it -- it outputs a HORIFICALLYLARGE XML file -- that would import nicely. AND EVEN NICER …. you can get the reverse… a table - to a nice definition -- so you can EASILY FIND -- ??? (I know - many pieces behind the scenes) OK - an example: table MySample Table2 inherits_from MySample Table field My unique field3, 0 index [My unique field,My unique field3], unique -John On Fri, Apr 13, 2012 at 9:30 AM, Coleman, Gavin gavin.cole...@computacenter.com wrote: ** Can you not just select the form and then go to FileàSave As? Assuming you’re in Developer Studio. Similar functionality exists in the old Admin tool. ** ** Thanks, ** ** *Gavin Coleman* *Senior Analyst/Programmer * *Computacenter (UK) Ltd* Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 %2B44%20%280%29%201707%20631662 E: *gavin.cole...@computacenter.com
Form export and import - renaming
I was thinking of making a similar form to an existing form. I thought I would export it -- modify the name of the form in the export and then reimport. So -- I went poking through the xml definition of the file… The only gotcha I see is that the xml file describes the indexes by index name -- stuff like i189 …. (as in -- table 189 therefore index 189) So -- would this be a bad idea -- rename the form in the xml and then reimport? (My end goal is to have 2 similar forms) -John -- *John Sundberg* Kinetic Data, Inc. Your Business. Your Process. *WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award* * * 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Form export and import - renaming
Can you not just select the form and then go to File--Save As? Assuming you're in Developer Studio. Similar functionality exists in the old Admin tool. Thanks, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: gavin.cole...@computacenter.commailto:gavin.cole...@computacenter.com W: www.computacenter.comhttp://www.computacenter.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: 13 April 2012 15:25 To: arslist@ARSLIST.ORG Subject: Form export and import - renaming ** I was thinking of making a similar form to an existing form. I thought I would export it -- modify the name of the form in the export and then reimport. So -- I went poking through the xml definition of the file... The only gotcha I see is that the xml file describes the indexes by index name -- stuff like i189 (as in -- table 189 therefore index 189) So -- would this be a bad idea -- rename the form in the xml and then reimport? (My end goal is to have 2 similar forms) -John -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award 651-556-0930 I john.sundb...@kineticdata.commailto:john.sundb...@kineticdata.com www.kineticdata.comhttp://www.kineticdata.com/ I community.kineticdata.comhttp://community.kineticdata.com/ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Form export and import - renaming
I was going to say the same thing J Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Coleman, Gavin Sent: Friday, April 13, 2012 9:30 AM To: arslist@ARSLIST.ORG Subject: Re: Form export and import - renaming ** Can you not just select the form and then go to FileàSave As? Assuming you're in Developer Studio. Similar functionality exists in the old Admin tool. Thanks, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: gavin.cole...@computacenter.com mailto:gavin.cole...@computacenter.com W: www.computacenter.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: 13 April 2012 15:25 To: arslist@ARSLIST.ORG Subject: Form export and import - renaming ** I was thinking of making a similar form to an existing form. I thought I would export it -- modify the name of the form in the export and then reimport. So -- I went poking through the xml definition of the file... The only gotcha I see is that the xml file describes the indexes by index name -- stuff like i189 (as in -- table 189 therefore index 189) So -- would this be a bad idea -- rename the form in the xml and then reimport? (My end goal is to have 2 similar forms) -John -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com http://www.kineticdata.com/ I community.kineticdata.com http://community.kineticdata.com/ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ** _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ font face=monospacesize=-3brThe information transmitted is intended only for the person or entity to which it is addressed and brmay contain confidential and/or privileged material. If the reader of this message is not the intendedbrrecipient, you are hereby notified that your access is unauthorized, and any review, dissemination,brdistribution or copying of this message including any attachments is strictly prohibited. If you are notbrthe intended recipient, please contact the sender and delete the material from any computer.br ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Form export and import - renaming
* I THINK DIFFERENTLY --- SOMETIMES THAT IS GOOD -- SOMETIMES NOT ** Yes - I could just go in and save as... However -- this is a small part of a larger project…. Autogenerate Remedy forms form Lotus Notes forms - :) 1) Auto create table 2) Auto migrate data 3) Auto delete Notes table 4) Party!!! My ***guess*** is that the index references are unused (not sure about that) -- but -- if I were to take this def to a new system -- which already had a T189/I189 -- I would imagine this definition would not overwrite those indexes… -- so it is probably safe…. I was wondering if anybody KNEW -- that this was a bad idea. Here is the fundamental problem -- when I export a def of a form -- I get 12500 lines… (IMHO - unusable) Yeah -- probably has 20 fields on it -- but the xml is so crazy it takes 12500 lines to describe… So -- WHAT IF I … created something like this: my_sample_file.txt table MySample Table field RequestID, 1 field Submitter, 2 … field My unique field, 0 # 0 is autoassigen field MY unique field2, 0 index [My unique field,My unique field2], unique etc…. Then -- when your run it -- it outputs a HORIFICALLYLARGE XML file -- that would import nicely. AND EVEN NICER …. you can get the reverse… a table - to a nice definition -- so you can EASILY FIND -- ??? (I know - many pieces behind the scenes) OK - an example: table MySample Table2 inherits_from MySample Table field My unique field3, 0 index [My unique field,My unique field3], unique -John On Fri, Apr 13, 2012 at 9:30 AM, Coleman, Gavin gavin.cole...@computacenter.com wrote: ** Can you not just select the form and then go to FileàSave As? Assuming you’re in Developer Studio. Similar functionality exists in the old Admin tool. ** ** Thanks, ** ** *Gavin Coleman* *Senior Analyst/Programmer * *Computacenter (UK) Ltd* Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: *gavin.cole...@computacenter.com* W: *www.computacenter.com* ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg *Sent:* 13 April 2012 15:25 *To:* arslist@ARSLIST.ORG *Subject:* Form export and import - renaming ** ** ** ** ** I was thinking of making a similar form to an existing form. ** ** I thought I would export it -- modify the name of the form in the export and then reimport. ** ** ** ** So -- I went poking through the xml definition of the file… ** ** The only gotcha I see is that the xml file describes the indexes by index name -- stuff like i189 …. (as in -- table 189 therefore index 189)* *** ** ** ** ** So -- would this be a bad idea -- rename the form in the xml and then reimport? ** ** (My end goal is to have 2 similar forms) ** ** -John ** ** -- *John Sundberg* *Kinetic Data, Inc.* *Your Business. Your Process.* *WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award* ** ** 651-556-0930 I* *john.sundb...@kineticdata.com www.kineticdata.com I* *community.kineticdata.com ** ** ** ** _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ** _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- *John Sundberg* Kinetic Data, Inc. Your Business. Your Process. *WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award
Re: Form export and import - renaming
I clone remedy forms all the time...in fact a development practice I use is to create a demonstration ticketing form for each feature or enhancement that I am working on...so I have a base ticketing form and I export the form and workflow of the base to a def file...I'm more comfortable working with the def file than the XML...and make name changes and other mods...then reimport it. The base form I have does have indexes...and I have never had a problem. Bruce Sent from my iPad On Apr 13, 2012, at 11:12 AM, John Sundberg john.sundb...@kineticdata.com wrote: ** * I THINK DIFFERENTLY --- SOMETIMES THAT IS GOOD -- SOMETIMES NOT ** Yes - I could just go in and save as... However -- this is a small part of a larger project…. Autogenerate Remedy forms form Lotus Notes forms - :) 1) Auto create table 2) Auto migrate data 3) Auto delete Notes table 4) Party!!! My ***guess*** is that the index references are unused (not sure about that) -- but -- if I were to take this def to a new system -- which already had a T189/I189 -- I would imagine this definition would not overwrite those indexes… -- so it is probably safe…. I was wondering if anybody KNEW -- that this was a bad idea. Here is the fundamental problem -- when I export a def of a form -- I get 12500 lines… (IMHO - unusable) Yeah -- probably has 20 fields on it -- but the xml is so crazy it takes 12500 lines to describe… So -- WHAT IF I … created something like this: my_sample_file.txt table MySample Table field RequestID, 1 field Submitter, 2 … field My unique field, 0 # 0 is autoassigen field MY unique field2, 0 index [My unique field,My unique field2], unique etc…. Then -- when your run it -- it outputs a HORIFICALLYLARGE XML file -- that would import nicely. AND EVEN NICER …. you can get the reverse… a table - to a nice definition -- so you can EASILY FIND -- ??? (I know - many pieces behind the scenes) OK - an example: table MySample Table2 inherits_from MySample Table field My unique field3, 0 index [My unique field,My unique field3], unique -John On Fri, Apr 13, 2012 at 9:30 AM, Coleman, Gavin gavin.cole...@computacenter.com wrote: ** Can you not just select the form and then go to FileàSave As? Assuming you’re in Developer Studio. Similar functionality exists in the old Admin tool. Thanks, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: gavin.cole...@computacenter.com W: www.computacenter.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: 13 April 2012 15:25 To: arslist@ARSLIST.ORG Subject: Form export and import - renaming ** I was thinking of making a similar form to an existing form. I thought I would export it -- modify the name of the form in the export and then reimport. So -- I went poking through the xml definition of the file… The only gotcha I see is that the xml file describes the indexes by index name -- stuff like i189 …. (as in -- table 189 therefore index 189) So -- would this be a bad idea -- rename the form in the xml and then reimport? (My end goal is to have 2 similar forms) -John -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may
Re: Form export and import - renaming
Hi, Are you sure you are seeing the SchemaId in the definition file? I have never seen that. There should be no problem renaming the form name and reimporting. I have done an almost identical thing where I used normal DEF-files as templates, where the database-name of the template-fields represented the datatypes of my input data. FieldName;DataType ... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. * I THINK DIFFERENTLY --- SOMETIMES THAT IS GOOD -- SOMETIMES NOT ** Yes - I could just go in and save as... However -- this is a small part of a larger project…. Autogenerate Remedy forms form Lotus Notes forms - :) 1) Auto create table 2) Auto migrate data 3) Auto delete Notes table 4) Party!!! My ***guess*** is that the index references are unused (not sure about that) -- but -- if I were to take this def to a new system -- which already had a T189/I189 -- I would imagine this definition would not overwrite those indexes… -- so it is probably safe…. I was wondering if anybody KNEW -- that this was a bad idea. Here is the fundamental problem -- when I export a def of a form -- I get 12500 lines… (IMHO - unusable) Yeah -- probably has 20 fields on it -- but the xml is so crazy it takes 12500 lines to describe… So -- WHAT IF I … created something like this: my_sample_file.txt table MySample Table field RequestID, 1 field Submitter, 2 … field My unique field, 0 # 0 is autoassigen field MY unique field2, 0 index [My unique field,My unique field2], unique etc…. Then -- when your run it -- it outputs a HORIFICALLYLARGE XML file -- that would import nicely. AND EVEN NICER …. you can get the reverse… a table - to a nice definition -- so you can EASILY FIND -- ??? (I know - many pieces behind the scenes) OK - an example: table MySample Table2 inherits_from MySample Table field My unique field3, 0 index [My unique field,My unique field3], unique -John On Fri, Apr 13, 2012 at 9:30 AM, Coleman, Gavin gavin.cole...@computacenter.com wrote: ** Can you not just select the form and then go to FileàSave As? Assuming you’re in Developer Studio. Similar functionality exists in the old Admin tool. ** ** Thanks, ** ** *Gavin Coleman* *Senior Analyst/Programmer * *Computacenter (UK) Ltd* Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: *gavin.cole...@computacenter.com* W: *www.computacenter.com* ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg *Sent:* 13 April 2012 15:25 *To:* arslist@ARSLIST.ORG *Subject:* Form export and import - renaming ** ** ** ** ** I was thinking of making a similar form to an existing form. ** ** I thought I would export it -- modify the name of the form in the export and then reimport. ** ** ** ** So -- I went poking through the xml definition of the file… ** ** The only gotcha I see is that the xml file describes the indexes by index name -- stuff like i189 …. (as in -- table 189 therefore index 189)* *** ** ** ** ** So -- would this be a bad idea -- rename the form in the xml and then reimport? ** ** (My end goal is to have 2 similar forms) ** ** -John ** ** -- *John Sundberg* *Kinetic Data, Inc.* *Your Business. Your Process.* *WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award* ** ** 651-556-0930 I* *john.sundb...@kineticdata.com www.kineticdata.com I* *community.kineticdata.com ** ** ** ** _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield
Re: Form export and import - renaming
John: How about scripting the creation of the similar form? You could use Java, Perl, Python, or maybe even just a shell script using the driver program. Have the script do the File--Save As. Not quite a fully functional solution, but maybe the seed of one. --Phil From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: Friday, April 13, 2012 11:12 To: arslist@ARSLIST.ORG Subject: Re: Form export and import - renaming ** * I THINK DIFFERENTLY --- SOMETIMES THAT IS GOOD -- SOMETIMES NOT ** Yes - I could just go in and save as... However -- this is a small part of a larger project Autogenerate Remedy forms form Lotus Notes forms - :) 1) Auto create table 2) Auto migrate data 3) Auto delete Notes table 4) Party!!! My ***guess*** is that the index references are unused (not sure about that) -- but -- if I were to take this def to a new system -- which already had a T189/I189 -- I would imagine this definition would not overwrite those indexes... -- so it is probably safe I was wondering if anybody KNEW -- that this was a bad idea. Here is the fundamental problem -- when I export a def of a form -- I get 12500 lines... (IMHO - unusable) Yeah -- probably has 20 fields on it -- but the xml is so crazy it takes 12500 lines to describe... So -- WHAT IF I ... created something like this: my_sample_file.txt table MySample Table field RequestID, 1 field Submitter, 2 ... field My unique field, 0 # 0 is autoassigen field MY unique field2, 0 index [My unique field,My unique field2], unique etc Then -- when your run it -- it outputs a HORIFICALLYLARGE XML file -- that would import nicely. AND EVEN NICER you can get the reverse... a table - to a nice definition -- so you can EASILY FIND -- ??? (I know - many pieces behind the scenes) OK - an example: table MySample Table2 inherits_from MySample Table field My unique field3, 0 index [My unique field,My unique field3], unique -John On Fri, Apr 13, 2012 at 9:30 AM, Coleman, Gavin gavin.cole...@computacenter.commailto:gavin.cole...@computacenter.com wrote: ** Can you not just select the form and then go to File--Save As? Assuming you're in Developer Studio. Similar functionality exists in the old Admin tool. Thanks, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662tel:%2B44%20%280%29%201707%20631662 E: gavin.cole...@computacenter.commailto:gavin.cole...@computacenter.com W: www.computacenter.comhttp://www.computacenter.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: 13 April 2012 15:25 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Form export and import - renaming ** I was thinking of making a similar form to an existing form. I thought I would export it -- modify the name of the form in the export and then reimport. So -- I went poking through the xml definition of the file... The only gotcha I see is that the xml file describes the indexes by index name -- stuff like i189 (as in -- table 189 therefore index 189) So -- would this be a bad idea -- rename the form in the xml and then reimport? (My end goal is to have 2 similar forms) -John -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award 651-556-0930tel:651-556-0930 I john.sundb...@kineticdata.commailto:john.sundb...@kineticdata.com www.kineticdata.comhttp://www.kineticdata.com/ I community.kineticdata.comhttp://community.kineticdata.com/ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may
Re: Form export and import - renaming
I haven't seen schemaID's in definitions as well.. And ever since the dawn of xml formats of the definition files, personally, I have become a huge fan of them simply because of how easy it is to manipulate the contents of these definitions as they are human readable.. Go XML defs Yayyy!! Take an XML definition export, mend the form name, and check what you get out of it. You may even able to easily mend the form text headers if there are any directly on this xml.. Joe -Original Message- From: Misi Mladoniczky Sent: Friday, April 13, 2012 11:49 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Form export and import - renaming Hi, Are you sure you are seeing the SchemaId in the definition file? I have never seen that. There should be no problem renaming the form name and reimporting. I have done an almost identical thing where I used normal DEF-files as templates, where the database-name of the template-fields represented the datatypes of my input data. FieldName;DataType ... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. * I THINK DIFFERENTLY --- SOMETIMES THAT IS GOOD -- SOMETIMES NOT ** Yes - I could just go in and save as... However -- this is a small part of a larger project…. Autogenerate Remedy forms form Lotus Notes forms - :) 1) Auto create table 2) Auto migrate data 3) Auto delete Notes table 4) Party!!! My ***guess*** is that the index references are unused (not sure about that) -- but -- if I were to take this def to a new system -- which already had a T189/I189 -- I would imagine this definition would not overwrite those indexes… -- so it is probably safe…. I was wondering if anybody KNEW -- that this was a bad idea. Here is the fundamental problem -- when I export a def of a form -- I get 12500 lines… (IMHO - unusable) Yeah -- probably has 20 fields on it -- but the xml is so crazy it takes 12500 lines to describe… So -- WHAT IF I … created something like this: my_sample_file.txt table MySample Table field RequestID, 1 field Submitter, 2 … field My unique field, 0 # 0 is autoassigen field MY unique field2, 0 index [My unique field,My unique field2], unique etc…. Then -- when your run it -- it outputs a HORIFICALLYLARGE XML file -- that would import nicely. AND EVEN NICER …. you can get the reverse… a table - to a nice definition -- so you can EASILY FIND -- ??? (I know - many pieces behind the scenes) OK - an example: table MySample Table2 inherits_from MySample Table field My unique field3, 0 index [My unique field,My unique field3], unique -John On Fri, Apr 13, 2012 at 9:30 AM, Coleman, Gavin gavin.cole...@computacenter.com wrote: ** Can you not just select the form and then go to FileàSave As? Assuming you’re in Developer Studio. Similar functionality exists in the old Admin tool. ** ** Thanks, ** ** *Gavin Coleman* *Senior Analyst/Programmer * *Computacenter (UK) Ltd* Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: *gavin.cole...@computacenter.com* W: *www.computacenter.com* ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg *Sent:* 13 April 2012 15:25 *To:* arslist@ARSLIST.ORG *Subject:* Form export and import - renaming ** ** ** ** ** I was thinking of making a similar form to an existing form. ** ** I thought I would export it -- modify the name of the form in the export and then reimport. ** ** ** ** So -- I went poking through the xml definition of the file… ** ** The only gotcha I see is that the xml file describes the indexes by index name -- stuff like i189 …. (as in -- table 189 therefore index 189)* *** ** ** ** ** So -- would this be a bad idea -- rename the form in the xml and then reimport? ** ** (My end goal is to have 2 similar forms) ** ** -John ** ** -- *John Sundberg* *Kinetic Data, Inc.* *Your Business. Your Process.* *WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award* ** ** 651-556-0930 I* *john.sundb...@kineticdata.com www.kineticdata.com I* *community.kineticdata.com ** ** ** ** _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER
Re: Form export and import - renaming
Bruce/Misi, I did some experimenting -- seems to work… Below is the formIndexList section of the exported XML -- it does show index names by number. My test ARS box is 7.01 -- so maybe this is different in 7.6.4 -- will check… (7.6.4 -- same thing -- uses index names as indexes) Seems like a bug to me… formIndexList formIndex indexNameI899_179_1/indexName uniqueIndextrue/uniqueIndex fieldIDList fieldID179/fieldID /fieldIDList /formIndex formIndex indexNameI899_24005_1/indexName uniqueIndextrue/uniqueIndex fieldIDList fieldID24005/fieldID /fieldIDList /formIndex formIndex indexNameI899_72000_1/indexName uniqueIndexfalse/uniqueIndex fieldIDList fieldID72000/fieldID /fieldIDList /formIndex formIndex indexNameI899_24003_1/indexName uniqueIndexfalse/uniqueIndex fieldIDList fieldID24003/fieldID /fieldIDList /formIndex /formIndexList -John On Fri, Apr 13, 2012 at 10:49 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, Are you sure you are seeing the SchemaId in the definition file? I have never seen that. There should be no problem renaming the form name and reimporting. I have done an almost identical thing where I used normal DEF-files as templates, where the database-name of the template-fields represented the datatypes of my input data. FieldName;DataType ... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. * I THINK DIFFERENTLY --- SOMETIMES THAT IS GOOD -- SOMETIMES NOT ** Yes - I could just go in and save as... However -- this is a small part of a larger project…. Autogenerate Remedy forms form Lotus Notes forms - :) 1) Auto create table 2) Auto migrate data 3) Auto delete Notes table 4) Party!!! My ***guess*** is that the index references are unused (not sure about that) -- but -- if I were to take this def to a new system -- which already had a T189/I189 -- I would imagine this definition would not overwrite those indexes… -- so it is probably safe…. I was wondering if anybody KNEW -- that this was a bad idea. Here is the fundamental problem -- when I export a def of a form -- I get 12500 lines… (IMHO - unusable) Yeah -- probably has 20 fields on it -- but the xml is so crazy it takes 12500 lines to describe… So -- WHAT IF I … created something like this: my_sample_file.txt table MySample Table field RequestID, 1 field Submitter, 2 … field My unique field, 0 # 0 is autoassigen field MY unique field2, 0 index [My unique field,My unique field2], unique etc…. Then -- when your run it -- it outputs a HORIFICALLYLARGE XML file -- that would import nicely. AND EVEN NICER …. you can get the reverse… a table - to a nice definition -- so you can EASILY FIND -- ??? (I know - many pieces behind the scenes) OK - an example: table MySample Table2 inherits_from MySample Table field My unique field3, 0 index [My unique field,My unique field3], unique -John On Fri, Apr 13, 2012 at 9:30 AM, Coleman, Gavin gavin.cole...@computacenter.com wrote: ** Can you not just select the form and then go to FileàSave As? Assuming you’re in Developer Studio. Similar functionality exists in the old Admin tool. ** ** Thanks, ** ** *Gavin Coleman* *Senior Analyst/Programmer * *Computacenter (UK) Ltd* Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: *gavin.cole...@computacenter.com* W: *www.computacenter.com* ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg *Sent:* 13 April 2012 15:25 *To:* arslist@ARSLIST.ORG *Subject:* Form export and import - renaming ** ** ** ** ** I was thinking of making a similar form to an existing form. ** ** I thought I would export it -- modify the name of the form in the export and then reimport. ** ** ** ** So -- I went poking through the xml definition of the file… ** ** The only gotcha I see is that the xml file describes the indexes by index name -- stuff like i189 …. (as in -- table 189 therefore index 189)* *** ** ** ** ** So -- would this be a bad idea -- rename the form in the xml and then reimport? ** ** (My end goal is to have 2 similar forms) ** ** -John ** ** -- *John Sundberg* *Kinetic Data, Inc.* *Your Business. Your Process.* *WWRUG10 Best Customer Service
Re: Form export and import - renaming
I am not sure I understood what you are trying to say.. Are you saying that
when you mend the def file to create a clone, the indexes are invalid?
Joe
From: John Sundberg
Sent: Friday, April 13, 2012 1:05 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Form export and import - renaming
**
Bruce/Misi,
I did some experimenting -- seems to work…
Below is the formIndexList section of the exported XML -- it does show index
names by number.
My test ARS box is 7.01 -- so maybe this is different in 7.6.4 -- will check…
(7.6.4 -- same thing -- uses index names as indexes)
Seems like a bug to me…
formIndexList
formIndex
indexNameI899_179_1/indexName
uniqueIndextrue/uniqueIndex
fieldIDList
fieldID179/fieldID
/fieldIDList
/formIndex
formIndex
indexNameI899_24005_1/indexName
uniqueIndextrue/uniqueIndex
fieldIDList
fieldID24005/fieldID
/fieldIDList
/formIndex
formIndex
indexNameI899_72000_1/indexName
uniqueIndexfalse/uniqueIndex
fieldIDList
fieldID72000/fieldID
/fieldIDList
/formIndex
formIndex
indexNameI899_24003_1/indexName
uniqueIndexfalse/uniqueIndex
fieldIDList
fieldID24003/fieldID
/fieldIDList
/formIndex
/formIndexList
-John
On Fri, Apr 13, 2012 at 10:49 AM, Misi Mladoniczky m...@rrr.se wrote:
Hi,
Are you sure you are seeing the SchemaId in the definition file? I have
never seen that.
There should be no problem renaming the form name and reimporting.
I have done an almost identical thing where I used normal DEF-files as
templates, where the database-name of the template-fields represented the
datatypes of my input data.
FieldName;DataType
...
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
* I THINK DIFFERENTLY --- SOMETIMES THAT IS GOOD -- SOMETIMES NOT
**
Yes - I could just go in and save as...
However -- this is a small part of a larger project….
Autogenerate Remedy forms form Lotus Notes forms - :)
1) Auto create table
2) Auto migrate data
3) Auto delete Notes table
4) Party!!!
My ***guess*** is that the index references are unused (not sure about
that) -- but -- if I were to take this def to a new system -- which
already
had a T189/I189 -- I would imagine this definition would not overwrite
those indexes… -- so it is probably safe….
I was wondering if anybody KNEW -- that this was a bad idea.
Here is the fundamental problem -- when I export a def of a form -- I get
12500 lines…
(IMHO - unusable)
Yeah -- probably has 20 fields on it -- but the xml is so crazy it takes
12500 lines to describe…
So -- WHAT IF I …
created something like this:
my_sample_file.txt
table MySample Table
field RequestID, 1
field Submitter, 2
…
field My unique field, 0 # 0 is autoassigen
field MY unique field2, 0
index [My unique field,My unique field2], unique
etc….
Then -- when your run it -- it outputs a HORIFICALLYLARGE XML file --
that would import nicely.
AND EVEN NICER ….
you can get the reverse… a table - to a nice definition -- so you can
EASILY FIND -- ???
(I know - many pieces behind the scenes)
OK - an example:
table MySample Table2
inherits_from MySample Table
field My unique field3, 0
index [My unique field,My unique field3], unique
-John
On Fri, Apr 13, 2012 at 9:30 AM, Coleman, Gavin
gavin.cole...@computacenter.com wrote:
**
Can you not just select the form and then go to FileàSave As? Assuming
you’re in Developer Studio. Similar functionality exists in the old
Admin
tool.
** **
Thanks,
** **
*Gavin Coleman*
*Senior Analyst/Programmer *
*Computacenter (UK) Ltd*
Services Solutions
Hatfield Avenue
Hatfield, Hertfordshire, AL10 9TW, United Kingdom
T: +44 (0) 1707 631662
E: *gavin.cole...@computacenter.com*
W: *www.computacenter.com*
** **
*From:* Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg
*Sent:* 13 April 2012 15:25
*To:* arslist@ARSLIST.ORG
*Subject:* Form export and import - renaming
** **
**
** **
I was thinking of making a similar form to an existing form.
** **
I thought I would export it -- modify the name of the form in the export
and then reimport.
** **
** **
So -- I went poking through the xml definition of the file…
** **
The only
Re: Form export and import - renaming
Fundamentally what I am saying its that the xml file has what appears to be hard coded Index names… (Even without me touching it) -John On Fri, Apr 13, 2012 at 2:11 PM, Joe Martin D'Souza jdso...@shyle.netwrote: ** I am not sure I understood what you are trying to say.. Are you saying that when you mend the def file to create a clone, the indexes are invalid? Joe *From:* John Sundberg john.sundb...@kineticdata.com *Sent:* Friday, April 13, 2012 1:05 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Form export and import - renaming ** Bruce/Misi, I did some experimenting -- seems to work… Below is the formIndexList section of the exported XML -- it does show index names by number. My test ARS box is 7.01 -- so maybe this is different in 7.6.4 -- will check… (7.6.4 -- same thing -- uses index names as indexes) Seems like a bug to me… formIndexList formIndex indexNameI899_179_1/indexName uniqueIndextrue/uniqueIndex fieldIDList fieldID179/fieldID /fieldIDList /formIndex formIndex indexNameI899_24005_1/indexName uniqueIndextrue/uniqueIndex fieldIDList fieldID24005/fieldID /fieldIDList /formIndex formIndex indexNameI899_72000_1/indexName uniqueIndexfalse/uniqueIndex fieldIDList fieldID72000/fieldID /fieldIDList /formIndex formIndex indexNameI899_24003_1/indexName uniqueIndexfalse/uniqueIndex fieldIDList fieldID24003/fieldID /fieldIDList /formIndex /formIndexList -John On Fri, Apr 13, 2012 at 10:49 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, Are you sure you are seeing the SchemaId in the definition file? I have never seen that. There should be no problem renaming the form name and reimporting. I have done an almost identical thing where I used normal DEF-files as templates, where the database-name of the template-fields represented the datatypes of my input data. FieldName;DataType ... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. * I THINK DIFFERENTLY --- SOMETIMES THAT IS GOOD -- SOMETIMES NOT ** Yes - I could just go in and save as... However -- this is a small part of a larger project…. Autogenerate Remedy forms form Lotus Notes forms - :) 1) Auto create table 2) Auto migrate data 3) Auto delete Notes table 4) Party!!! My ***guess*** is that the index references are unused (not sure about that) -- but -- if I were to take this def to a new system -- which already had a T189/I189 -- I would imagine this definition would not overwrite those indexes… -- so it is probably safe…. I was wondering if anybody KNEW -- that this was a bad idea. Here is the fundamental problem -- when I export a def of a form -- I get 12500 lines… (IMHO - unusable) Yeah -- probably has 20 fields on it -- but the xml is so crazy it takes 12500 lines to describe… So -- WHAT IF I … created something like this: my_sample_file.txt table MySample Table field RequestID, 1 field Submitter, 2 … field My unique field, 0 # 0 is autoassigen field MY unique field2, 0 index [My unique field,My unique field2], unique etc…. Then -- when your run it -- it outputs a HORIFICALLYLARGE XML file -- that would import nicely. AND EVEN NICER …. you can get the reverse… a table - to a nice definition -- so you can EASILY FIND -- ??? (I know - many pieces behind the scenes) OK - an example: table MySample Table2 inherits_from MySample Table field My unique field3, 0 index [My unique field,My unique field3], unique -John On Fri, Apr 13, 2012 at 9:30 AM, Coleman, Gavin gavin.cole...@computacenter.com wrote: ** Can you not just select the form and then go to FileàSave As? Assuming you’re in Developer Studio. Similar functionality exists in the old Admin tool. ** ** Thanks, ** ** *Gavin Coleman* *Senior Analyst/Programmer * *Computacenter (UK) Ltd* Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 %2B44%20%280%29%201707%20631662 E: *gavin.cole...@computacenter.com* W: *www.computacenter.com* ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg *Sent:* 13 April 2012 15:25 *To:* arslist@ARSLIST.ORG *Subject:* Form export and import - renaming ** ** ** ** ** I was thinking of making a similar form to an existing form. ** ** I thought I would export
Re: Form export and import - renaming
I think that shouldn’t really mean a thing.. Internally in a database, where those indexes are stored, the index names are associated with tables with some internal database reference ID’s. So the index names being the same doesn’t mean they are the same indexes. Was your concern around that? Joe From: John Sundberg Sent: Friday, April 13, 2012 3:43 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Form export and import - renaming ** Fundamentally what I am saying its that the xml file has what appears to be hard coded Index names… (Even without me touching it) -John On Fri, Apr 13, 2012 at 2:11 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** I am not sure I understood what you are trying to say.. Are you saying that when you mend the def file to create a clone, the indexes are invalid? Joe From: John Sundberg Sent: Friday, April 13, 2012 1:05 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Form export and import - renaming ** Bruce/Misi, I did some experimenting -- seems to work… Below is the formIndexList section of the exported XML -- it does show index names by number. My test ARS box is 7.01 -- so maybe this is different in 7.6.4 -- will check… (7.6.4 -- same thing -- uses index names as indexes) Seems like a bug to me… formIndexList formIndex indexNameI899_179_1/indexName uniqueIndextrue/uniqueIndex fieldIDList fieldID179/fieldID /fieldIDList /formIndex formIndex indexNameI899_24005_1/indexName uniqueIndextrue/uniqueIndex fieldIDList fieldID24005/fieldID /fieldIDList /formIndex formIndex indexNameI899_72000_1/indexName uniqueIndexfalse/uniqueIndex fieldIDList fieldID72000/fieldID /fieldIDList /formIndex formIndex indexNameI899_24003_1/indexName uniqueIndexfalse/uniqueIndex fieldIDList fieldID24003/fieldID /fieldIDList /formIndex /formIndexList -John On Fri, Apr 13, 2012 at 10:49 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, Are you sure you are seeing the SchemaId in the definition file? I have never seen that. There should be no problem renaming the form name and reimporting. I have done an almost identical thing where I used normal DEF-files as templates, where the database-name of the template-fields represented the datatypes of my input data. FieldName;DataType ... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. * I THINK DIFFERENTLY --- SOMETIMES THAT IS GOOD -- SOMETIMES NOT ** Yes - I could just go in and save as... However -- this is a small part of a larger project…. Autogenerate Remedy forms form Lotus Notes forms - :) 1) Auto create table 2) Auto migrate data 3) Auto delete Notes table 4) Party!!! My ***guess*** is that the index references are unused (not sure about that) -- but -- if I were to take this def to a new system -- which already had a T189/I189 -- I would imagine this definition would not overwrite those indexes… -- so it is probably safe…. I was wondering if anybody KNEW -- that this was a bad idea. Here is the fundamental problem -- when I export a def of a form -- I get 12500 lines… (IMHO - unusable) Yeah -- probably has 20 fields on it -- but the xml is so crazy it takes 12500 lines to describe… So -- WHAT IF I … created something like this: my_sample_file.txt table MySample Table field RequestID, 1 field Submitter, 2 … field My unique field, 0 # 0 is autoassigen field MY unique field2, 0 index [My unique field,My unique field2], unique etc…. Then -- when your run it -- it outputs a HORIFICALLYLARGE XML file -- that would import nicely. AND EVEN NICER …. you can get the reverse… a table - to a nice definition -- so you can EASILY FIND -- ??? (I know - many pieces behind the scenes) OK - an example: table MySample Table2 inherits_from MySample Table field My unique field3, 0 index [My unique field,My unique field3], unique -John On Fri, Apr 13, 2012 at 9:30 AM, Coleman, Gavin gavin.cole...@computacenter.com wrote: ** Can you not just select the form and then go to FileàSave As? Assuming you’re in Developer Studio. Similar functionality exists
