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
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 jon.sla...@amway.com 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
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
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 required field 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 elryal...@gmail.com 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 jo...@stevnsvig.com 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
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 d1mo...@gmail.com 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 jdso...@shyle.net 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 jdso...@shyle.net 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 jdso...@shyle.net 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com
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 d1mo...@gmail.com 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 jdso...@shyle.net 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 jdso...@shyle.net 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 jdso...@shyle.net 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
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 jha...@gmail.com 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 axton.gr...@gmail.com 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
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: 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 jdso...@shyle.net 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
It's an upgrade and the system works fine. On Mon, Jun 14, 2010 at 2:35 PM, Joe D'Souza jdso...@shyle.net 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 jdso...@shyle.net 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
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 jarl.gron...@gmail.comwrote: 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 lj.longw...@gmail.com: 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 frederick.w.gro...@xo.com: 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.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net sponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are 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.
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 caruso.fr...@gmail.comwrote: ** 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: 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 shei...@pbsj.com 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
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
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 kdea...@kellydeaver.comwrote:
** 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 s.mcdonald.arsl...@gmail.com
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
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
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
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
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
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
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: 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
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
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: input type=text name=!536871089! size=128 value= Text Area: textarea name=!536871089! rows=25 cols=80 wrap=physical /textarea 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
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: input type=text name=!536871089! size=128 value= Text Area: textarea name=!536871089! rows=25 cols=80 wrap=physical /textarea 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
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: 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 10questions 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 onceafter if I exported data as a csv, opened in Excel and decided I didn't needthe last column and deleted it. I ended up with errors. Turned outI 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 sure the last columnis fully populated - moving columns if necessary.This will fix/set your record length. Mike White Office:813-978-2192 E-mail: [EMAIL PROTECTED]Jason McDonald [EMAIL PROTECTED]To: arslist@ARSLIST.ORG COM cc: Sent by: Action Subject:Remedy Import - Limits to 15 records Request System discussion list(ARSList) [EMAIL PROTECTED] . ORG 07/31/2006 09:15 Please
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 filledand '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___
