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