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 <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> > <indexName>I899_179_1</indexName> > <uniqueIndex>true</uniqueIndex> > <fieldIDList> > <fieldID>179</fieldID> > </fieldIDList> > </formIndex> > <formIndex> > <indexName>I899_240000005_1</indexName> > <uniqueIndex>true</uniqueIndex> > <fieldIDList> > <fieldID>240000005</fieldID> > </fieldIDList> > </formIndex> > <formIndex> > <indexName>I899_720000000_1</indexName> > <uniqueIndex>false</uniqueIndex> > <fieldIDList> > <fieldID>720000000</fieldID> > </fieldIDList> > </formIndex> > <formIndex> > <indexName>I899_240000003_1</indexName> > <uniqueIndex>false</uniqueIndex> > <fieldIDList> > <fieldID>240000003</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 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* >> > * >> > * >> > 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"_ > -- *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"
