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: [email protected] 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 <[email protected]> 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: [email protected] 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 <[email protected]> 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 < > [email protected]> 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: *[email protected]***** >> >> W: *www.computacenter.com* **** >> >> ** ** >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> [email protected]] *On Behalf Of *John Sundberg >> *Sent:* 13 April 2012 15:25 >> *To:* [email protected] >> *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* *[email protected] **** >> >> 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 [email protected] > 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 [email protected] www.kineticdata.com I community.kineticdata.com _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
