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" > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.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"
