Consuming Sharepoint data via Web service
Hello all, I can find lots on Sharepoint consuming Remedy Web services but not the other direction. Can anyone help me get this set up? I'm on 7.6, all Microsoft. Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Dev Studio Layout WinXP vs Win7
Hello All, When I transitioned to Windows 7 the font and layout of the fields on all my forms is messed up. Nothing is lined up and the fonts are too big. I am an a docked laptop with two monitors that only go up to 1280x1024 but this happens when i'm just on the laptop whish has a very nice size screen and goes much smaller in resolution. Any suggestions where this can be adjusted? Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Where does the 'Menu Name' attribute go?
It just seemed hit or miss when the attribute was displayed. I uninstalled all remedy apps and reinstalled all the latest versions and patches and everything seems better. On Thu, Apr 12, 2012 at 7:07 AM, Jon Slaven wrote: > Not quite sure what you're asking... do you want to know how to create a > menu on a field? (Attributes -> Selections) Or attach a menu from Menus to > a field? (Attributes -> Menu Name) > > > ___ > 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"
Where does the 'Menu Name' attribute go?
Hi All, I'm slowly coming up to speed with DS and can't seem to figure out where the Menu Name attribute goes on a random basis. Is it a problem with forms from older versions? I tried exporting and importing in the hopes the attribute would appear. No dice. Words or wisdom? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: ODBC not returning the expected values from Incident form
I've discovered a problem that seems to stem from the Office 2010 version of MS Query's interaction with the ODBC. A basic full table grab will not return att rows if certain fields ar included in the query. Remove those and att rows are returned. I tried adding a "where is not null" clause and get the same results 3k of 14k rows. The same query via user tool brings back all the rows as expected. Kinda messes up reporting. On Wed, Aug 3, 2011 at 9:47 AM, Elry wrote: > ARODBC Can return odd things if there is no "WHERE" clause. > > Even if the "WHERE" clause returns all entries. > > > On Aug 2, 8:42 am, Jonas Stumph stevnsvig wrote: > > Hi again, I'll try not to hit ctrl+enter again... sorry for the triple > > posts. > > > > I am still fiddling with this problem, concering ARODBC and the number > > of records to be returned. > > > > I and querying the incident form on a server with 12000 records, and > > getting very big variations in how many records are being returned. I > > started in excel, and moved to VBscript to > > 1) ascertain whether it was an excel or ARODBC error. > > and > > 2) to be able to correct and experiment faster than waiting for the GUIs > in the ODBC system in excel to refresh. > > > > I have tried several different variations of where clauses, as previously > suggested (eg. WHERE Incident_Number<> 'ThisOldString') but to no avail. > > > > BMC support is misunderstanding me, and thinks that I am trying on > different databases, wih different numbers of records, so I have tried to > clarfy my query to them. > > > > Does anyone else have any ideas of what else I can try? > > > > Best regards, Jonas Stevnsvig > > > > ** SELECT with approximately 60 records returned, of 12000 total > > SELECT > > * > > FROM > > HPD_Help_Desk > > ORDER BY > > Incident_Number DESC > > > > ** SELECT with approximately 1000 records returned, of 12000 > total > > SELECT > > Incident_Number, > > Product_Categorization_Tier_1, > > Product_Categorization_Tier_2, > > Product_Categorization_Tier_3, > > First_Name, > > Last_Name, > > Site, > > Status, > > Priority, > > Assignee, > > Assigned_Group, > > Assignee_Login_ID, > > Categorization_Tier_1, > > Categorization_Tier_2, > > Categorization_Tier_3, > > Corporate_ID, > > Reported_Source, > > Service_Type, > > Submit_Date, > > Submitter > > FROM > > HPD_Help_Desk > > ORDER BY > > Incident_Number DESC > > > > ** SELECT with approximately 9500 records returned, of 12000 > total > > SELECT > > Incident_Number, > > Product_Categorization_Tier_1, > > Product_Categorization_Tier_2, > > Product_Categorization_Tier_3, > > First_Name, > > Last_Name, > > Site, > > Status, > > Priority, > > Assignee, > > Assigned_Group, > > Assignee_Login_ID, > > Categorization_Tier_1, > > Categorization_Tier_2, > > Categorization_Tier_3, > > Corporate_ID, > > Reported_Source, > > Submit_Date, > > Submitter > > FROM > > HPD_Help_Desk > > ORDER BY > > Incident_Number DESC > > > > ** SELECT with 12000 records returned, of 12000 total > > SELECT > > Incident_Number, > > Product_Categorization_Tier_1, > > Product_Categorization_Tier_2, > > Product_Categorization_Tier_3, > > First_Name, > > Last_Name, > > Site, > > Status, > > Priority, > > Assignee, > > Assigned_Group, > > Assignee_Login_ID, > > Corporate_ID, > > Reported_Source, > > Submit_Date, > > Submitter > > FROM > > HPD_Help_Desk > > ORDER BY > > Incident_Number DESC > > > > > ___ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Conversion from Informix to SQLServer or Oracle?
Has anyone done a conversion from Informix to SQLServer? Since BMC will no longer support Informix after 7.6.3 I need to take the leap away from Informix. Any advice appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Problems Installing 7.5 on Solaris/Informix
Not according to BMC. v9.2 of the client is the only supported version. Like I said, I used v10 of the Informix client to install ARS v7.1 and had no problems. Forsome reason that exact client cannot connect(withing the 7.5 installer) to the db. I can use dbaccess just fine. I recieved an email that I've been escalated so I'll wait for contact and see where this goes. On Wed, Jun 16, 2010 at 10:27 AM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > ** > > As long as you are using the correct client the ARS 7.1 server should work > with the higher level Informix db. > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Steve McDonald > *Sent:* Wednesday, June 16, 2010 11:19 AM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Problems Installing 7.5 on Solaris/Informix > > > > ** > > Turns out I'm using an incompatible Informix client. I looked at the > compatibility matrix when I started the upgrade process and saw that for > Informix on solaris the minimum db version is 10. I have that db on my db > server and used the v10 client on my app server to upgrade to ARS v7.1 last > year so I figured I was good. > > > > Not so fast grasshopper! > > > > I'm being told by BMC that only v9.2 of the Informix client is compatible > and that is why it's failing. My DBA says 9.2 is no longer supported by > Informix and is about 5 years old. The reason I'm upgrading to 7.5 is > because for support reasons we are upgrading to Informix 11 and ARS v7.1 > isn't compatible with v11. This is such crap > > On Tue, Jun 15, 2010 at 3:11 PM, Donald Morton wrote: > > This may be something that your Informix DBA may be able answer better. > > I would get the exact SQL used to connect from the install's sql.log > (usually this is in a temp directory. /usr/tmp maybe?). Send the connect > line and the error message to a dba expert, and they'll likely be able to > tell you something. > > Are you running dbaccess as the same user that Remedy is starting up as? > > > > > > On Jun 14, 2010, at 4:00 PM, Joe D'Souza wrote: > > That's a great question.. Also along with the install log in the same > directory there is another log which has a little more verbose than the > install log. You may want to check all those logs that get generated on > that > directory.. > > Joe > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org]on Behalf Of Grooms, Frederick W > Sent: Monday, June 14, 2010 5:49 PM > To: arslist@ARSLIST.ORG > Subject: Re: Problems Installing 7.5 on Solaris/Informix > > > Is there an SQL log (probably in the same place as the install log)? > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Steve McDonald > Sent: Monday, June 14, 2010 4:45 PM > To: arslist@ARSLIST.ORG > Subject: Re: Problems Installing 7.5 on Solaris/Informix > > ** It's an upgrade and the system works fine. > On Mon, Jun 14, 2010 at 2:35 PM, Joe D'Souza wrote: > ** > Steve, > > Is this a fresh install? Or an upgrade? If its a fresh install, there > technically should be no config files available unless you copied one from > some other environment? In which case you will need to edit the > configuration information manually on that one to point to the dev instance > of the database. > > If it is an upgrade you are attempting, does the system currently stop or > start with no problems? > > Joe > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org]on Behalf Of Steve McDonald > Sent: Monday, June 14, 2010 5:24 PM > To: arslist@ARSLIST.ORG > Subject: Re: Problems Installing 7.5 on Solaris/Informix > ** > I probably wasn't clear enough. This is during the install process, right > after inouting the database info. It trys to connect and throws the "Could > not connect" message. I looked at the 7.1 install logs and the install > never asked for 'AR System Server DB Login ID" or the password. I'm sure > it > pulled the connection info from the onconfig file. That would be the > correct thing to do. > On Mon, Jun 14, 2010 at 11:40 AM, Joe D'Souza wrote: > ** > Steve, > > Put the AR Server in a startup debug mode and then try to restart.. This is > done by adding the flag -s (or -d I don't recall clearly) in the > armonitor.conf file. Check for details on setting that flag on the AR > Configuration Guide.. > > The server when in a debug mod
Re: Problems Installing 7.5 on Solaris/Informix
Turns out I'm using an incompatible Informix client. I looked at the compatibility matrix when I started the upgrade process and saw that for Informix on solaris the minimum db version is 10. I have that db on my db server and used the v10 client on my app server to upgrade to ARS v7.1 last year so I figured I was good. Not so fast grasshopper! I'm being told by BMC that only v9.2 of the Informix client is compatible and that is why it's failing. My DBA says 9.2 is no longer supported by Informix and is about 5 years old. The reason I'm upgrading to 7.5 is because for support reasons we are upgrading to Informix 11 and ARS v7.1 isn't compatible with v11. This is such crap On Tue, Jun 15, 2010 at 3:11 PM, Donald Morton wrote: > This may be something that your Informix DBA may be able answer better. > > I would get the exact SQL used to connect from the install's sql.log > (usually this is in a temp directory. /usr/tmp maybe?). Send the connect > line and the error message to a dba expert, and they'll likely be able to > tell you something. > > Are you running dbaccess as the same user that Remedy is starting up as? > > > > > On Jun 14, 2010, at 4:00 PM, Joe D'Souza wrote: > > That's a great question.. Also along with the install log in the same >> directory there is another log which has a little more verbose than the >> install log. You may want to check all those logs that get generated on >> that >> directory.. >> >> Joe >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:arsl...@arslist.org]on Behalf Of Grooms, Frederick W >> Sent: Monday, June 14, 2010 5:49 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: Problems Installing 7.5 on Solaris/Informix >> >> >> Is there an SQL log (probably in the same place as the install log)? >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:arsl...@arslist.org] On Behalf Of Steve McDonald >> Sent: Monday, June 14, 2010 4:45 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: Problems Installing 7.5 on Solaris/Informix >> >> ** It's an upgrade and the system works fine. >> On Mon, Jun 14, 2010 at 2:35 PM, Joe D'Souza wrote: >> ** >> Steve, >> >> Is this a fresh install? Or an upgrade? If its a fresh install, there >> technically should be no config files available unless you copied one from >> some other environment? In which case you will need to edit the >> configuration information manually on that one to point to the dev >> instance >> of the database. >> >> If it is an upgrade you are attempting, does the system currently stop or >> start with no problems? >> >> Joe >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:arsl...@arslist.org]on Behalf Of Steve McDonald >> Sent: Monday, June 14, 2010 5:24 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: Problems Installing 7.5 on Solaris/Informix >> ** >> I probably wasn't clear enough. This is during the install process, right >> after inouting the database info. It trys to connect and throws the >> "Could >> not connect" message. I looked at the 7.1 install logs and the install >> never asked for 'AR System Server DB Login ID" or the password. I'm sure >> it >> pulled the connection info from the onconfig file. That would be the >> correct thing to do. >> On Mon, Jun 14, 2010 at 11:40 AM, Joe D'Souza wrote: >> ** >> Steve, >> >> Put the AR Server in a startup debug mode and then try to restart.. This >> is >> done by adding the flag -s (or -d I don't recall clearly) in the >> armonitor.conf file. Check for details on setting that flag on the AR >> Configuration Guide.. >> >> The server when in a debug mode during startup, writes additional logs to >> a >> file that gets created in the server directory. That file may have more >> information on why the startup fails.. >> >> Cheers >> >> Joe >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:arsl...@arslist.org]on Behalf Of Steve McDonald >> Sent: Monday, June 14, 2010 2:30 PM >> To: arslist@ARSLIST.ORG >> Subject: Problems Installing 7.5 on Solaris/Informix >> ** >> I am trying to upgrade ARS on my dev server which connects to a remote >> database server. I'm getting "Cannot connect to the Informix server" >> error
Re: Problems Installing 7.5 on Solaris/Informix
It's an upgrade and the system works fine. On Mon, Jun 14, 2010 at 2:35 PM, Joe D'Souza wrote: > ** > Steve, > > Is this a fresh install? Or an upgrade? If its a fresh install, there > technically should be no config files available unless you copied one from > some other environment? In which case you will need to edit the > configuration information manually on that one to point to the dev instance > of the database. > > If it is an upgrade you are attempting, does the system currently stop or > start with no problems? > > Joe > > -Original Message- > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org]*on Behalf Of *Steve McDonald > *Sent:* Monday, June 14, 2010 5:24 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Problems Installing 7.5 on Solaris/Informix > > ** > I probably wasn't clear enough. This is during the install process, right > after inouting the database info. It trys to connect and throws the "Could > not connect" message. I looked at the 7.1 install logs and the install > never asked for 'AR System Server DB Login ID" or the password. I'm sure it > pulled the connection info from the onconfig file. That would be the > correct thing to do. > > On Mon, Jun 14, 2010 at 11:40 AM, Joe D'Souza wrote: > >> ** >> Steve, >> >> Put the AR Server in a startup debug mode and then try to restart.. This >> is done by adding the flag -s (or -d I don't recall clearly) in the >> armonitor.conf file. Check for details on setting that flag on the AR >> Configuration Guide.. >> >> The server when in a debug mode during startup, writes additional logs to >> a file that gets created in the server directory. That file may have more >> information on why the startup fails.. >> >> Cheers >> >> Joe >> >> -Original Message- >> *From:* Action Request System discussion list(ARSList) [mailto: >> arsl...@arslist.org]*on Behalf Of *Steve McDonald >> *Sent:* Monday, June 14, 2010 2:30 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Problems Installing 7.5 on Solaris/Informix >> >> ** >> I am trying to upgrade ARS on my dev server which connects to a remote >> database server. I'm getting "Cannot connect to the Informix server" >> error. Install log only says "SET PROPERTY >> VALIDATION_ERROR_RESULT],Detail=[INFORMIX_CONNECTION_ERROR]" and no >> details. Informix logs show nothing. >> >> I can use dbaccess from my app server to access the db on the remote db >> server. I can also telnet using the specific port the Informix client uses >> to communicate(telnet suncoast 1721). >> >> I threw everything over to BMC Support but the response time is killing >> me. I go on vacation Tursday morning and I'd really like to have the dev >> server conquered before I go. >> >> Thanks! >> >> Steve McDonald >> App server - Solaris 10 >> Database server - Informix 10 on Solaris 10 >> >> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Problems Installing 7.5 on Solaris/Informix
I probably wasn't clear enough. This is during the install process, right after inouting the database info. It trys to connect and throws the "Could not connect" message. I looked at the 7.1 install logs and the install never asked for 'AR System Server DB Login ID" or the password. I'm sure it pulled the connection info from the onconfig file. That would be the correct thing to do. On Mon, Jun 14, 2010 at 11:40 AM, Joe D'Souza wrote: > ** > Steve, > > Put the AR Server in a startup debug mode and then try to restart.. This is > done by adding the flag -s (or -d I don't recall clearly) in the > armonitor.conf file. Check for details on setting that flag on the AR > Configuration Guide.. > > The server when in a debug mode during startup, writes additional logs to a > file that gets created in the server directory. That file may have more > information on why the startup fails.. > > Cheers > > Joe > > -Original Message- > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org]*on Behalf Of *Steve McDonald > *Sent:* Monday, June 14, 2010 2:30 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Problems Installing 7.5 on Solaris/Informix > > ** > I am trying to upgrade ARS on my dev server which connects to a remote > database server. I'm getting "Cannot connect to the Informix server" > error. Install log only says "SET PROPERTY > VALIDATION_ERROR_RESULT],Detail=[INFORMIX_CONNECTION_ERROR]" and no > details. Informix logs show nothing. > > I can use dbaccess from my app server to access the db on the remote db > server. I can also telnet using the specific port the Informix client uses > to communicate(telnet suncoast 1721). > > I threw everything over to BMC Support but the response time is killing > me. I go on vacation Tursday morning and I'd really like to have the dev > server conquered before I go. > > Thanks! > > Steve McDonald > App server - Solaris 10 > Database server - Informix 10 on Solaris 10 > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Problems Installing 7.5 on Solaris/Informix
I am trying to upgrade ARS on my dev server which connects to a remote database server. I'm getting "Cannot connect to the Informix server" error. Install log only says "SET PROPERTY VALIDATION_ERROR_RESULT],Detail=[INFORMIX_CONNECTION_ERROR]" and no details. Informix logs show nothing. I can use dbaccess from my app server to access the db on the remote db server. I can also telnet using the specific port the Informix client uses to communicate(telnet suncoast 1721). I threw everything over to BMC Support but the response time is killing me. I go on vacation Tursday morning and I'd really like to have the dev server conquered before I go. Thanks! Steve McDonald App server - Solaris 10 Database server - Informix 10 on Solaris 10 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: ARS 7.5 and MidTier sharing the same hardware?
Thanks for the input. Since it's a resource issue and not a compatibility issue I think I'll do same box for dev/qa the seperate for production so that when v8 comes, I'll be ready as James suggested. On Wed, Jun 9, 2010 at 8:17 AM, jham36 wrote: > You might as well build another box now for the mid-tier. You will > need it for when the User Tool goes away. > > James > > On Jun 8, 7:43 pm, Axton wrote: > > The main issues have to do with contentions on resources, such as memory, > > cpu cycles, and storage. Depending on the hardware you have and the > current > > and projected utilization, you may not have any issues. > > > > Axton Grams > > > > These statements represent my opinion and nothing more. > > > > On Tue, Jun 8, 2010 at 3:46 PM, Steve McDonald < > s.mcdonald.arsl...@gmail.com > > > > > wrote: > > > ** > > > The install manual only recommends you don't. What are the > consequences if > > > I do? We don't heavily use the midtier so if I don't have to hassle > with > > > more equipment I'd rather not. I already have seperate application and > > > database hardware. > > > > > Thanks in advance for your insight. > > > > > Solaris 10 > > > Informix 10 > > > Upgrading from v7.1 to v7.5 > > > _attend WWRUG10www.wwrug.comARSlist: "Where the Answers Are"_ > > > > > ___ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
ARS 7.5 and MidTier sharing the same hardware?
The install manual only recommends you don't. What are the consequences if I do? We don't heavily use the midtier so if I don't have to hassle with more equipment I'd rather not. I already have seperate application and database hardware. Thanks in advance for your insight. Solaris 10 Informix 10 Upgrading from v7.1 to v7.5 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Upgrade to 7.5, is it possible without any errors?
The biggest time eater we found going from 6.3 to 7.1 was that the script altered three fields in every table that had the 8 core fields. The problem was it didn't do one alter for three fields, it did three alters, one for each field. Big tables took a long time. Fortunately we were doing a database upgrade at the same time and built the new database in a second instance and altered the schema script to create the tables with the longer core fields. Then we moved the data. Turned a 12 hour DB upgrade into 6. Do they test these install scripts in a life-like environment? On the up side, the 7.1 upgrade was the first time I didn't have to edit the install script. On Fri, Jan 8, 2010 at 10:09 AM, Jarl Grøneng wrote: > That is not an option, the database is appox 80Gb and it woud take > ages to move the records... But, it goes forward, in small steps. > > But found it very timeconsuming doing the install over and over again. > It takes several hours each time the database has to be rolledback... > > -- > Jarl > > > > 2010/1/8 LJ Longwing : > > I think the discussion is not 'upgrading' the serverbut instead, > build a > > new server at 7.5 and then import a def of this application...which I > think > > will work... > > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark > > Sent: Friday, January 08, 2010 9:41 AM > > To: arslist@ARSLIST.ORG > > Subject: Re: Upgrade to 7.5, is it possible without any errors? > > > > Jarl, > > > > This was discussed on the list before but I can't find the emails. I > believe > > there is a white paper out that states you have to upgrade those server > to > > 6.3 before you can go to 7.5. can't go straight from 2.1, 3.2, 4.51 to > 7.5 > > > > Fellow Listers, if I am wrong or you have the link to the white paper, > > please jump in. > > > > Thanks > > Mark > > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arsl...@arslist.org] On Behalf Of Jarl Grøneng > > Sent: Friday, January 08, 2010 10:20 AM > > To: arslist@ARSLIST.ORG > > Subject: Re: Upgrade to 7.5, is it possible without any errors? > > > > 7.01 is 7.0.1 > > > > But my issues when upgrading to 7.5 (patch 3) > > > > One of the server startet out as 2.1, the others as 3.2 and 4.51... > > > > -- > > Jarl > > > > > > 2010/1/8 Grooms, Frederick W : > >> For 7.01 Are you talking about 7.0.1 or 7.1.0? > >> > >> We did the upgrade from 6.3.0 (patch 20) to 7.1.0 (patch 3) with no > >> errors on Sun 5.10 with Oracle 10g. This was on servers that started > >> out as 5.1.2 > >> > >> Fred > >> > >> -Original Message- > >> From: Action Request System discussion list(ARSList) > >> [mailto:arsl...@arslist.org] On Behalf Of Jarl Grøneng > >> Sent: Friday, January 08, 2010 12:18 AM > >> To: arslist@ARSLIST.ORG > >> Subject: Upgrade to 7.5, is it possible without any errors? > >> > >> Hi, > >> > >> I've done a few upgrades from 6.3 and 7.01 to 7.5. And none of them > >> installes without any errors > >> > >> - bin/arsystem (Unix startup file) contains errors, upgrade failes > >> when the installer restart the server > >> - armonitor.conf/armonitor.cfg does not get created > >> - database upgrade in 3 tablss failes due to illegal operation > >> (Oracle) > >> - addinng unique index on form AR System User Cental File failes > >> - serveradmin form does not contain any information > >> - Approval/Assignment-engine failes to install if the server does not > >> run when starting the installation-program > >> - Upgrade fails if you do not have a admin user named Demo > >> - tnsnames.ora need to have an SID entry containing the ip-adress, > >> with domain name is failes. > >> > >> All the upgrades has been done against servers installed prior to > >> version 6.3. Upgrading servers which where original installed as 6.3 > >> or 7.01 does not fail. > >> > >> > >> Opening a ticket with support did not give any value to the issues. > >> After 5-6 weeks, we fixed most of the issues (need to do a lot manual > >> work during the installation), and the response from support was; "Can > >> I close the ticket now?" They was not not intressting in how the > >> issues was solved. This answer ended up in my worst satisfaction > >> survey ever! > >> > >> Looking forward to the CMDB upgrade > >> > >> Regards, > >> Jarl > >> > >> __ > >> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > >> Platinum > >> Sponsor:rmisoluti...@verizon.netARSlist: > >> "Where the Answers Are" > >> > > > > > > > ___ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > > Sponsor:rmisoluti...@verizon.net > > ARSlist: "Where the Answers Are" > > > > This e-mail is the property of NaviSite, Inc. It is intended only for the > > pers
Re: Voting option when sending mails
I'm not finding the "Other Actions > View in Browser " option. Has it moved in the later versoins of Outlook 2007? On Tue, Dec 19, 2006 at 11:23 AM, Heider, Stephen wrote: > ** > Sashi, > > Yes, it can be done. I use that here with html email forms. When the > user clicks a button it submits their entry to a web app, which in turn > updates Remedy. > > One thing to watch out for is the default button. If a user views the > email then presses Enter one of the buttons will be clicked. We did not > want that here, so I added two radio buttons for Approved and Rejected. No > default is selected so the user has to click one of the options, then click > the Submit button. > > Code was added to check when the user did not make a selection (pressed > Enter by mistake). When this occurs the Submit action is ignored. When the > user does make a selection the submit action is allowed to continue and post > their selection to a web page. > > Note: Outlook 2007 no longer allows html email forms to function. With OL > 2007 the user has to click Other Actions > View in Browser in order to > interact with an html form email. > > Stephen > > -- > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Sashi M > *Sent:* Tuesday, December 19, 2006 1:00 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Voting option when sending mails > > ** > Hi, > I need to have voting option (Buttons for Approved / Rejected) while > sending mails from Remedy. Is it possible to have? If yes, can you please > tell how it can be done? > > Thanks & Regards, > Sashi > > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com __20060125___This posting was > submitted with HTML in it___ > __20060125___This posting was submitted with HTML in > it___ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Send HTML To Email Engine
I've not been able to get radio buttons to work in gmail. Outlook worked until we started the upfrade to 2007, now I get parenthesis, like thisL ( ) Approved. Not much a user can do with that. On Wed, Sep 17, 2008 at 11:51 AM, Frank Caruso wrote: > ** > I have been able to to send a user an email from the Email Engine that > contains HTML. The HTML prompts the user to enter values into a few fields. > When the user received the email (tested in Outlook and gMail) the email > format looks good. User can type into fields and select from radio buttons. > However, when they click the reply button the input fields no longer > function. In Outlook the input fields act lie images and the radio buttons > act like they are disabled. > > Any thoughts? > > Thank you > > Frank > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Excell data query
Hi Kelly! Do you mean save a blank workbook as 2003 and then set up the data query? On Wed, Jul 8, 2009 at 3:40 PM, Kelly Deaver wrote: > ** I have seen that. Try saving as Excel 2003 from your 2007 application > > Kelly Deaver > kdea...@kellydeaver.com > (Yes, I work for BMC. This post reflects the opinions of the poster and not > the official opinion of BMC) > > > > Original Message > Subject: Excell data query > From: Steve McDonald > Date: Wed, July 08, 2009 5:29 pm > To: arslist@ARSLIST.ORG > > ** Has anyone had problems extracting data via Excel after upgrading to > Excel 2007? > > I have a user that the following error: > > Unable to obtain a list of tables from the data source. He said > spreadsheets created with Excel 2003 work ok but nothing new. > > We're on 7.1 patch 6 on Unix 10/Informix 10. > > > Thanks > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Excell data query
Has anyone had problems extracting data via Excel after upgrading to Excel 2007? I have a user that the following error: Unable to obtain a list of tables from the data source. He said spreadsheets created with Excel 2003 work ok but nothing new. We're on 7.1 patch 6 on Unix 10/Informix 10. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
ServerName reference in .xml def files
In cleaning an xml def file of server dependence I noticed some serverName references contain an astrisk(*) instead of the "@". Are they interchangeable? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Index disparity between Remedy and Informix
Hello All, On one of my email forms, Remedy says I have 2 indexes, Informix says I have none. Can someone tell me which admin table stores the Remedy listing on indexes? I'm familiar with DBAccess and need to drop them from the table. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Accellerating the 6.3 -> 7.x upgrade process
Hello All, Disclaimer: This upgrade involved an Informix upgrade as well. While testing the ARSystem upgrade process, what we thought would be around 4 hours turned into about 12. With tables containing nearly two million records and an audit trail table with over 9 million, the outage would have been unacceptable. What we found was the ARSystem database upgrade was increasing the length of three columns, c2, c4, and c5, in every table that had them to varchar(254). As part of our upgrade we were changing from v9.4 -> v10 of Informix. My DBA had already created scripts to migrate the data from the 9.4 instance to the 10.0 instance by first creating empty tables and then moving the data. By changing his scripts to pre-alter the three columns in the largest table BEFORE moving in the data, we saved 11 hours of upgrade time as the ARSystem alter effectively did nothing to the table. The problem with Remedy's upgrade script is that it performs 3 seperate alters for every table it changes instead of one alter to change all 3 at once. Having a talented DBA is a good thing! Hope this helps someone. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Anyone have Solaris10/Informix10/ARS 7.1 and can try something for me?
Here's what I found: - Take any form with an attachment pool and corresponding attachment fields - Must have a few attachments added to a record - Add the attachment field label to the results list - Query the form, qualified or unqualified. This crashes the arserverd process on my new dev, qa, and staged production servers. EVERY TIME. Remove the attachment label and everything works. I was told Monday by the resolution team, before I isolated it today, that I had database issues resulting from the DB upgrade from 9.4. I'm waiting to hear back if they can duplicate this now that I've narrowed it down. Heck, i'd be interested in knowing if this happened in ANY other environment. Thanks! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: How can I tell if tomcat is running?
Does it run all the time or is it started when needed? On Tue, Nov 18, 2008 at 4:55 PM, Alan Blake <[EMAIL PROTECTED]> wrote: > ** > > It should appear as a "java" process. > > > > *Alan Blake* > Knowlysis | Services Manager | Office: 801.224.0002 ext 105 > -- > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Steve McDonald > *Sent:* Tuesday, November 18, 2008 4:39 PM > *To:* arslist@ARSLIST.ORG > *Subject:* How can I tell if tomcat is running? > > > > ** > > I run the startup.sh script and get this: > > > > Using CATALINA_BASE: /remedy/apache-tomcat-5.5.25 > Using CATALINA_HOME: /remedy/apache-tomcat-5.5.25 > Using CATALINA_TMPDIR: /remedy/apache-tomcat-5.5.25/temp > Using JRE_HOME: /usr/java > > When I do a ps -ef I don't see any additional processes. > > > > Thanks! > > > > > > Steve > > Solaris 10 > > Informix 10 > > ARSystem 7.1 > > MidTier 7.1 > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: ARS for non Trouble Ticketing applications
I wrote an application(with help from the perl API) that was used to track calls to our licensees 4 times per month. the calls were a secret shopper kind of thing. On the first of the month an escalation fired that preloaded the survey form with over 12k blank survey forms. the callers pressed a "Next Call" button and the next randomzed survey was displayed. That was a fun one. The one that tracked manual credit card autorizations real-time to predict third-party prosessor communication problems was fun too. On Fri, Nov 14, 2008 at 9:21 AM, sam appecherla <[EMAIL PROTECTED]>wrote: > ** Hi List, > Just curious to know.. > > Apart from using Remedy for HelpDesk, Trouble Ticketing and the kinds, what > else can we do with this workflow engine for? Does anyone have a custom > built product/application built on ARS apart from Trouble Ticketing kinds > that you would like to share? > > Regards, > SriSamSri Appecherla > Mobile# +91 991 610 6008 > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
How can I tell if tomcat is running?
I run the startup.sh script and get this: Using CATALINA_BASE: /remedy/apache-tomcat-5.5.25 Using CATALINA_HOME: /remedy/apache-tomcat-5.5.25 Using CATALINA_TMPDIR: /remedy/apache-tomcat-5.5.25/temp Using JRE_HOME: /usr/java When I do a ps -ef I don't see any additional processes. Thanks! Steve Solaris 10 Informix 10 ARSystem 7.1 MidTier 7.1 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
umask in the web server startup sequence?
Good day All, In the midtier installation manual, for Apache servers, it states: *To minimize security exposure, include umask 077 in the web server start sequence. Using umask 077 makes sure that files created by the web server processes will be owned and only usable by the user who runs that web server.* ** I can find reference to umask in the .profile but I'm not sure how to use it in the startup. Any unix gurus care to chime in? Steve Arsystem 7.1 Solaris 10 Informix 10 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Best practice? Email engine with two Remedy servers on a single unix box
Can I do a single email engine to service two Remedy servers? Load isn't an issue as these are my DEV & QA servers. My Informix DBs for both are remote. Remedy v7.1 on Solaris 10 & Informix 10 Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: RPC Question
I understand the can only use for one concept but MUST I use portmapper at all? On Wed, Oct 22, 2008 at 10:49 AM, Frank Caruso <[EMAIL PROTECTED]>wrote: > Yes > One can use pmapper on only one and the other will need to be assigned a > specific TCP port. The server install talks about this. > > On Oct 22, 2008, at 1:30 PM, Steve McDonald <[EMAIL PROTECTED]> > wrote: > > ** >> >> Hello All! >> >> I need to intall 2 servers on a single machine. Do I NEED to set one of >> the severs to use portmapper? I installed the first and am having quirky >> problems. If I "rpcinfo -p" the server there are no RPC ports assined to >> Remedy. I have confirmed the /etc/rpc file has been updated to include the >> Remedy RPC ports. >> >> Exporting is a big problem. I can export a single form, but if I try to >> export all forms(75) it goes away forever. >> >> Of course Remedy support has not been much help. >> >> ARSystem v7.1 >> SunOS 5.10 >> Informix 10.00.FC7 >> >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ >> > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
RPC Question
Hello All! I need to intall 2 servers on a single machine. Do I NEED to set one of the severs to use portmapper? I installed the first and am having quirky problems. If I "rpcinfo -p" the server there are no RPC ports assined to Remedy. I have confirmed the /etc/rpc file has been updated to include the Remedy RPC ports. Exporting is a big problem. I can export a single form, but if I try to export all forms(75) it goes away forever. Of course Remedy support has not been much help. ARSystem v7.1 SunOS 5.10 Informix 10.00.FC7 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Remedy Support page down?
I was having problems this morning but then got through mid day and now am getting the same error. On Mon, Sep 29, 2008 at 1:36 PM, Joe DeSouza <[EMAIL PROTECTED]> wrote: > ** Is the page wherein you view/update current tickets down? I get the > following error when I hit that link to view/update requests.. See attached > dialog shot.. > > Cheers > > Joe > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Print Table Options
File/Print Setup/Orientation/Portrait (static change) Or, if yo uselect "Print Table" and the print window is open Properties Button/Orientation/Portrait (changed for this print job) On Wed, Sep 10, 2008 at 8:44 AM, Brittain, Mark <[EMAIL PROTECTED]>wrote: > Hi All, > > If I mouse over the table and right click, there is the option to 'Print > Table' Unfortunately it prints in landscape. Is there a way to change > this to portrait? > > ARS 6.3 > > Thanks > Mark > > Mark Brittain > Remedy Developer > NaviSite ESM Operations > 315-453-2912 x5418 (Office) > 315-317-2897 (Cell) > > > This e-mail is the property of NaviSite, Inc. It is intended only > for the person or entity to which it is addressed and may contain > information that is privileged, confidential, or otherwise protected > from disclosure. Distribution or copying of this e-mail, or the > information contained herein, to anyone other than the intended > recipient is prohibited. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: HTML text area, email templates and the email engine
Nope, that wasn't it... On Wed, Sep 3, 2008 at 11:24 AM, Brien Dieterle < [EMAIL PROTECTED]> wrote: > ** The "wrap" option is not a w3 standard I don't think, so you might try > pulling that out. > Brien > > On Wed, Sep 3, 2008 at 7:02 AM, Steve McDonald < > [EMAIL PROTECTED]> wrote: > >> ** >> Good morning All! >> >> I have set up automated email to my customers that allows them to reply by >> replying to the email, adding text to a text field and when sent, the ticket >> is updated. When I try to make the text field a text area the email engine >> throws an error. Message number 4946, that there was "No field values >> supplied" when there clearly was. >> >> Here is my HTML code for the 2 fields: >> >> Text Field: >> >> >> Text Area: >> >> >> >> >> >> Any help is appreciated >> >> >> Steve McDonald >> Sr. Remedy Applications Programmer >> Choice Hotels International >> 602-953-4955 >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
HTML text area, email templates and the email engine
Good morning All! I have set up automated email to my customers that allows them to reply by replying to the email, adding text to a text field and when sent, the ticket is updated. When I try to make the text field a text area the email engine throws an error. Message number 4946, that there was "No field values supplied" when there clearly was. Here is my HTML code for the 2 fields: Text Field: Text Area: Any help is appreciated Steve McDonald Sr. Remedy Applications Programmer Choice Hotels International 602-953-4955 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Capturing bidirectional email correspondence
Hello all, I'm able to send email notifications that include templates to users that submit via a web front end. I would like to have them be able to reply to the notification and have their text added to the diary. I have included exported email template data from the form but it's still not working. Here's the exported data: Schema: HelpDesk-Data and Channel Management Server: sunbath Key: 1029384756 Action: Modify Format: Short Request ID !1!:395 Detailed Problem Description for: !10007!:[$$ this is a test $$] I can see the email get to the mailbox and then it disappears but no entry in the messages form I do get this in the email log file but I'm not sure what it relates to: Jun 25, 2008 11:45:04 AM com.remedy.arsys.emaildaemon.LoggingModule doWork SEVERE: Field ID is not related to this form 18104 Your help is appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Integer date conversion in Business Object WebIntelligence
** Hello all, Just wondering if anyone has tackled the database stored integer for Remedy date fields to a human readable date? If so, I'd love your help. I figure with BO and Remedy being partners there would be something built in but I cant find it. Steve __20060125___This posting was submitted with HTML in it___
Re: Reporting
**
Maria, There are a couple places to look.
First, there are views created for each form created. These would be beter to tap for your universe as they use the form name and field database names and not the c53687... names.
Second you can join thearschema and field tables. I've attached a .def file that you can import that will do it for you in a Remedy form. Select a form in a search screen and click search. All associated fields are displayed in a table field.
On 8/2/06, Maria Calabrese <[EMAIL PROTECTED]> wrote:
Hello,We are working on upgrading to ARS6.3 and Help Desk 6.We are looking at the reporting aspect at this time. We curretly use
Business Objects. We will have to recreate the Business Objects universe.Does anyone know of a data dictionary that would give us a list of all thefields used in the application and how they're being used to that we can
build this universe?Any help will be greatly appreciated.ThanksMaria CalabreseBose Corporation___UNSUBSCRIBE or access ARSlist Archives at
http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___
#
# File exported Tue Sep 26 16:15:32 2006
#
begin schema
name : ADMIN-ARSchema.
core-version : 2
upgrade-version: 0
num-fields : 26
timestamp : 1159312424
owner : smcdonald
last-changed : steve_mcdonald
default-vui: Default Admin View
num-vuis : 1
export-version : 8
schema-type: 3
ext-table : arschema
key-field : schemaid
next-field-id : 536870938
get-list-flds :
5\1\10\0\\536870917\32\0\\536870920\10\0\\536870918\10\0\\536870919\10\0\
object-prop: 1\60018\4\0\\
archive: 0\0\0
arch-time : 0\0\0\0
arch-from :
vui {
id : 536870912
name : Default Admin View
label : Default Admin View
timestamp : 1159312424
vui-locale :
vui-type : 1
owner : smcdonald
last-changed : steve_mcdonald
display-prop : 7\20\4\18\Default Admin
View\60019\4\21\ViewWebAlias536870912\201\2\66375\202\2\86600\264\6\0\251\6\0\252\6\0\
}
field {
id : 1
name : schemaid
datatype : 4
fieldtype : 3
ext-field : schemaid
create-mode: 2
option : 3
timestamp : 1125437242
owner : smcdonald
last-changed : steve_mcdonald
maxlength : 15
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
display-instance :
536870912\12\20\4\8\schemaid\3\41\2\2475\5500\13500\7900\7\40\2147483647\231\6\0\143\40\4294967295\170\40\0\21\41\2\0\400\5850\2400\151\41\2\5962\0\11024\210&
display-instance : 0\65\41\2\0\0\0\0\66\41\2\0\0\0\0\61\40\7\228\40\1\
}
field {
id : 536870913
name : coreversion
datatype : 2
fieldtype : 3
ext-field : coreversion
create-mode: 2
option : 2
timestamp : 1125433071
owner : smcdonald
last-changed : steve_mcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\11\coreversion\3\41\2\31500\18000\55687\20100\4\6\1\5\6\2\62\6\0\60\40\1\61\40\29\27\8\16\28\6\4\29\6\1\7\40\2147483648\23&
display-instance :
1\6\0\143\40\4294967295\21\41\2\0\400\6187\2100\151\41\2\6750\0\24187\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\64\6\0\228\40\1\
}
field {
id : 536870914
name : defaultvui
datatype : 4
fieldtype : 3
ext-field : defaultvui
create-mode: 2
option : 2
timestamp : 1125433071
owner : smcdonald
last-changed : steve_mcdonald
maxlength : 254
menu-style : 1
qbe-match-op : 3
fulltext-optns : 0
display-instance :
536870912\19\14\40\1\170\40\0\20\4\10\defaultvui\3\41\2\32512\10500\58612\12600\4\6\1\5\6\2\60\40\1\61\40\29\27\8\16\28\6\4\29\6\1\7\40\2147483649\231\6\0\14&
display-instance :
3\40\4294967295\21\41\2\0\400\5175\2100\151\41\2\5737\0\23174\2100\65\41\2\7372350\0\7372350\0\66\41\2\23737\0\26099\2100\228\40\1\
}
field {
id : 536870915
name : lastchanged
datatype : 4
fieldtype : 3
ext-field : lastchanged
create-mode: 2
option : 2
timestamp : 1070988415
owner : smcdonald
last-changed : smcdonald
maxlength : 30
menu-style : 1
qbe-match-op : 3
fulltext-optns : 0
display-instance :
536870912\19\14\40\1\170\40\0\20\4\11\lastchanged\3\41\2\1350\13000\25875\15100\4\6\1\5\6\2\60\40\1\61\40\29\27\8\16\28\6\4\29\6\1\7\40\2147483650\231\6\0\14&
display-instance :
3\40\4294967295\21\41\2\0\400\6525\2100\151\41\2\7087\0\24524\2100\65\41\2\787\0\787\0\66\41\2\787\0\787\0\228\40\1\
}
field {
id : 536870916
name : maxstaten
Re: OT: BMC Userworld Questions
** Any truth to the rumor that there will be singing at the ARSList Awards? On 8/21/06, Ed White <[EMAIL PROTECTED]> wrote: Thanks for the helpful information seeing as this will be my first User groupmeeting.I appreciate it. -Original Message-From: Action Request System discussion list(ARSList)[mailto:arslist@ARSLIST.ORG] On Behalf Of Carey Matthew BlackSent: Sunday, August 20, 2006 7:28 PM To: arslist@ARSLIST.ORGSubject: Re: OT: BMC Userworld QuestionsShawn,I will also add a few comments to Kelly's...If you have not yet selected your sessions then you really need to talk to whoever signed you up for the conference. At least review thesessions that are going to be there so that you have some idea of whatyou want to do. ( Changes are always possible, but most of what you see will be there.)Birds of a Feather (Feature?) are not really "run" by anyone. They aretopic based discussions that are picked by RUG attendees via sign upsheets that are posted at some point during the conference. The conversation is driven by the group of people who show up. Yes thereis a theme for the conversation but often the conversation drifts intonear to the theme topics too. ( Example, Reporting and ARS driftedinto specific about Crystal XI and Business Objects feature comparison and how well those things could map to ARS. With details about how theauthentication, web centric approaches, etc.. played into them lastyear. Another example was a "Higher Educational Institutions use of ARS". That covered a lot of ground with several Universities doingmany divers tasks with OOB apps and completely custom apps too. ) TheBMC employees that are in the rooms are there to listen as much as to talk. So bring your ideas and maybe you can be the start of a greatFeather (Feature ?) conversation. :)I will 100% echo the following:"Other hints -*wear comfortable shoes, you will walk and stand a LOT. "The sessions normally have seating, but if they are "full" there mightbe standing room too. So if there is one "must see session" (and youdecide that the one you signed up for is really not the "must see session" then you might end up standing around the edges of the roomlistening when you would have been seated in an almost empty session.:) So be prepared to be flexible and nimble. :)I will also add that you need to get some sleep when you can. It is far to easy to be up until 11,12,1,2 AM and then have a 8:30am sessionthe next day. Do not miss out on the social aspects of the Conference,but keep the next day in mind too. :) I figure I will sleep when I am dead and spend as much time as I can every day, but that leads to avery exhausting week. (And a very rewarding week too.)Evening with R & D: If it is anything like "Evening with Engineering" was, then you need to go. You need to go and bring a note pad with your "top 10"questions for the people who actually make the software that youdepend on. Bring your enhancement ideas, your off the wall questions and your hearing aid that can hear in loud rooms. :) [ Last yearswas in WAY to small of an area and there was so much going on that Ileft with a headache from the noise. But a definite "MUST see" of the conference.]By Friday things are winding down. Some people leave "early" to gethome that night. Others stay until the last moment and stay overnight, or do the "red eye" (overnight flight) home too. They normally keep one or two nice details for Friday. So I suggest not missing asingle moment. :)See you there. :)--Carey Matthew BlackRemedy Skilled Professional (RSP)ARS = Action Request System(Remedy) Solution = People + Process + ToolsFast, Accurate, Cheap Pick two.Never ascribe to malice, that which can be explained by incompetence._ __UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Remedy Import - Limits to 15 records
** I agree with John. I ALWAYS audit my data with a text editor. I've found once after if I exported data as a csv, opened in Excel and decided I didn't need the last column and deleted it. I ended up with errors. Turned out I had sporadic commas at the ends of some rows. Now I leave my export alone and just ignore extra columns during the import. One other tip - If your export includes 'Request ID' change your .csv export to .txt before opening in Excel and you can preserve the "0" padded field by designating it text. I hate that Excel truncates like that. Good Luck. Steve On 8/3/06, Reiser, John J <[EMAIL PROTECTED]> wrote: ** Jason, Some one may have stated this already but when you check your file do you use Excel or notepad/wordpad. I have seen "section breaks" in a .csv file when opened in Excel that just appears as a blank line in notepad. That could explain the "every 15th record" phenomenon. Try a simple sort in excel and resave the file in .csv format. The import should work. And I've never had a problem with data missing in the last column as long as there are enough "," commas in each row of the text file. HTH, John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin - MS2The star that burns twice as bright burns half as long.Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Jason McDonaldSent: Thursday, August 03, 2006 4:14 AM To: arslist@ARSLIST.ORGSubject: Re: Remedy Import - Limits to 15 records ** I am sure that there was no change in the 16th row when compared to the 15th row w.r.t. less columns having data. One more point to note is that I get this error *ALL THE TIME*, when any csv has more than 15 records. Nevertheless, ensuring that the last column contains data seems to be the easiest way IMHO. Thanks for all your inputs. You guys are great! /J On 8/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote: I've seen the same, so when working with Excel I always have the last column filled with data, and check with CTRL/End that the last cell is selected, some times a row 'outside the dataarea' can be selected (and this can disturb the import),in that case copy the data and put in a new spr.sheet. We often have a field 'Importfile' in our forms, makes it easy to validate the import and maybe delete the imported records and start again if needed. /L ars-Original Message-From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Mike WhiteSent: Monday, July 31, 2006 3:51 PMTo: arslist@ARSLIST.ORGSubject: Re: Remedy Import - Limits to 15 records Length probably changed after the 15th record (column populated for rows1-14, but not for 15th, or vice-versa). I haven't seen your data, but this is where I'd look first.Matt makes good points about data condition. Hard returns result in two (or more) records where you intended one. Field mapping would misalign.Imbedded commas in text could be problematic, too. (.csv files are comma-separated).Mike WhiteOffice: 813-978-2192E-mail: [EMAIL PROTECTED] "Carey Matthew Black" To: arslist@ARSLIST.ORG <[EMAIL PROTECTED]cc: COM> Subject: Re: Remedy Import - Limits to 15 records Sent by: "Action Request System discussion list(ARSList)" <[EMAIL PROTECTED] ORG> 07/31/2006 09:43 Please respond to arslistJason,If the columns are "empty data values" in the file. Then do not mapthem in the import tool. (It might help.) However, apparently, some rows have data, or null data, defined for them.I have seen such behaviour when the csv file is edited with Excel.Another possible point of confusion is how "hard returns" are dealtwith in csv format. Some editors write them as hard returns and thus break up the single line format of csv.Keep in mind that filters that fire on merge can look at data suppliedto display only fields too. (A good, old school, way to do somesignaling for data merge work IMHO.) Then again... this could be as "simple" as a bad client install, or a bugtoo.--Carey Matthew BlackRemedy Skilled Professional (RSP)ARS = Action Request System(Remedy)Solution = People + Process + Tools Fast, Accurate, Cheap Pick two.Never ascribe to malice, that which can be explained by incompetence.On 7/31/06, Jason McDonald < [EMAIL PROTECTED]> wrote: > ** But in that case how does it work for the first 15 records?>>> On 7/31/06, Mike White < [EMAIL PROTECTED]> wrote:> > It's caused by variable-length records. Remedy Import doesn't tolerate > > them too well. When we import from .csv, we make sur
Re: 2 questions.
** Question 1 - Set the "Disable Change Flag" to ON On 8/1/06, David Yearsley <[EMAIL PROTECTED]> wrote: ** We have had a couple of strange items happen recently and rather than clutter the list with 2 emails I have combine the questions into a single email. System Configuration: Remedy ARServer 6.03.00 Patch 16 Remedy ITSM 6.0 no patches. Database: Oracle 9.2i on a LINUX server. Server: SUNW,Sun-Fire-480R OS: Solaris 5.9 Clients: Web, 6.03.00 Patch 17 and 7.00.00 Patch 1. Question 1: I added a "Display Only" field to the Remedy Purchase Requisition application. This field is updated when the form is opened. Since I have added the field those doing the approvals are unable to approve the Purchase Requisition. They get an error indicating they do not have permission to the new "Display Only" field I have added. This field is read only so why is it trying to save the information to the database. I have found a work around of setting the field back to $NULL$ when I am done, but if it is a display only field shouldn't I have to set it to $NULL$ as the field is not saving to the database. Question 2: We are using the Remedy Purchase Requisition system with some modifications. The system is set up so the Approvers have Read License and minimal permission which is working fine. The problem is that when the users on the web open view the Request and try to save the request, they get a message that someone else has modified the record and asks if the still want to update. If the do the same changes from the Usertool no such message. We have looked at the logs and cannot see anything that would be causing the problem. It is very annoying for our users. Has anyone ever seen this type of problem? Any ideas and or debugging ideas will be welcome. Thanks __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARDBC LDAP
** The problem is that when using the ARDBC plugin to LDAP, I can't select any additional fields. Only one field appears in the results list drop down, the RequestID field. I talked to Remedy and they say to submit an enhancement request. On 8/1/06, Rocky Rockwell <[EMAIL PROTECTED]> wrote: You should be able to add to the results list of the vendor form to showmore info (ie: phone, email). Just make the spacing between the results list colums small.*Rocky*Rocky RockwelleMA Team – Remedy Developer[EMAIL PROTECTED] [EMAIL PROTECTED]>Ph#1: 214-567-8874 Ph#2: 325-884-1263Steve McDonald wrote:> **> Good Morning All,>> My system:>> ARS v6.3> Informix 9.4> SunOS 5.8>> The problem: I have a form that when a caller's last name is > filled and 'Enter' is pressed, queries LDAP via set fields action.> I've mapped the LDAP field "employeeID" to the Request ID field. All> is well until I run into duplicate last names. The active link is set > up to show a list on multiple matches. The only field that is> available in the list is the field mapped to Request ID so I get a> list of employeeIDs. Not terribly helpful. I have no other field > that I can reliably map to Request ID. We use first_last for LDAP> user id and there are many with > 15 characters so that field is out.>> Anyone run into this and solved it?>> Thanks in advance! >>> Steve McDonald> Sr. Remedy Applications Programmer> Choice Hotels International> __20060125___This posting was submitted with HTML> in it___ ___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
ARDBC LDAP
** Good Morning All, My system: ARS v6.3 Informix 9.4 SunOS 5.8 The problem: I have a form that when a caller's last name is filled and 'Enter' is pressed, queries LDAP via set fields action. I've mapped the LDAP field "employeeID" to the Request ID field. All is well until I run into duplicate last names. The active link is set up to show a list on multiple matches. The only field that is available in the list is the field mapped to Request ID so I get a list of employeeIDs. Not terribly helpful. I have no other field that I can reliably map to Request ID. We use first_last for LDAP user id and there are many with > 15 characters so that field is out. Anyone run into this and solved it? Thanks in advance! Steve McDonald Sr. Remedy Applications Programmer Choice Hotels International __20060125___This posting was submitted with HTML in it___
