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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
