Re: parsing from csv
Thank you Naveen, I will check that out. Do I know you from somewhere? Rezaul -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of NNMN Sent: Thursday, July 01, 2010 2:08 AM To: arslist@ARSLIST.ORG Subject: Re: parsing from csv Hi Rezaul, You can use PERFORM-ACTION-SAVE-ATTACHMENT, save it into a directory from where you can write and read it, then you can try running Atrium integration Engine command 'aiexfer' or AR Import command utility 'arimportcmd' command in a Run Process. Check on how to use either of these commands in their documentation , try both options and check which one suits you performance wise. Cheers, Naveen Haque, Rezaul R wrote: Friends, What is the best way to pars columns from a csv format file from an attachment field then put in a Remedy form? Thanks, Rezaul Haque | Systems Engineer III | OSS-Remedy | ITIL Certified 12405 Powerscourt Drive, St. Louis, MO 63376 Office 314.288.3487 Fax 314-543-2500 [cid:image001.jpg@01CB18BD.825671E0] E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are - With Warm Regards, Naveen -- View this message in context: http://old.nabble.com/parsing-from-csv-tp29042412p29042581.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: parsing from csv
Thanks Misi, But I was more looking to trigger from a attachment ( ie by click of a button or so) not by using manually through Import tool. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Thursday, July 01, 2010 1:50 AM To: arslist@ARSLIST.ORG Subject: Re: parsing from csv Hi, The best way would seem to be the BMC Remedy Import Tool. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Friends, What is the best way to pars columns from a csv format file from an attachment field then put in a Remedy form? Thanks, Rezaul Haque | Systems Engineer III | OSS-Remedy | ITIL Certified 12405 Powerscourt Drive, St. Louis, MO 63376 Office 314.288.3487 Fax 314-543-2500 [cid:image001.jpg@01CB18BD.825671E0] E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: parsing from csv
Hi Rezaul, The actual parsing of CSV can be taken care of outside of Remedy by some Java API like Apache POI. List, please share if anyone has done parsing CSV using Remedy. For opening attachments, maybe this link would help? http://old.nabble.com/Re:-How-to-open-an-attachment-in-a-child-form-record-from-a-tablefield-on-the-parent-record--RESOLVED-td17275536.html Basically, idea is to open attachment and give it to a different process to parse CSV columns. You can put parsed data back on Remedy form by using any Remedy API(C, Java, Perl). My 2 cents. Thanks Chintan. --- On Thu, 7/1/10, Haque, Rezaul R rezaul.ha...@chartercom.com wrote: From: Haque, Rezaul R rezaul.ha...@chartercom.com Subject: Re: parsing from csv To: arslist@ARSLIST.ORG Date: Thursday, July 1, 2010, 11:51 PM Thanks Misi, But I was more looking to trigger from a attachment ( ie by click of a button or so) not by using manually through Import tool. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Thursday, July 01, 2010 1:50 AM To: arslist@ARSLIST.ORG Subject: Re: parsing from csv Hi, The best way would seem to be the BMC Remedy Import Tool. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Friends, What is the best way to pars columns from a csv format file from an attachment field then put in a Remedy form? Thanks, Rezaul Haque | Systems Engineer III | OSS-Remedy | ITIL Certified 12405 Powerscourt Drive, St. Louis, MO 63376 Office 314.288.3487 Fax 314-543-2500 [cid:image001.jpg@01CB18BD.825671E0] E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. ___ 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
Curious Advanced Search
Hi ARSers, Hi have a pretty silly and curious advanced search issue. This is a Advanced Search i am trying on User Form. I am trying to give a search on the basis of 'Group List'. I have,say 6 groups, Group1 to Group 6. I want to list out record of users belonging to Group List namely 'Group1', 'Group2' and 'Group3' So I gave, 1.'Group List' = (Group1) OR 'Group List' = (Group2) OR 'Group List' = (Group3). It doesn't fetch me any record. 2. I have been trying to search for records which has 'Group1' only also. But its not giving me any records. 3. Then I tried 'Group List' != (Group1) whihc fetched me all the records. :S I am going crazy over here. Can anyone help me. Thank you Cheers, Naveen - With Warm Regards, Naveen -- View this message in context: http://old.nabble.com/Curious-Advanced-Search-tp29054806p29054806.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
AW: Curious Advanced Search
Naveen,
The Grouplist is stored internal as a list of groupids separated by a semicolon
(and sometimes an additional space)
For example to search for all User belonging to group Administror your advanced
query should look like this
('Group List' like 1;% or 'Group List' like % 1;% or 'Group List' like
%;1;%)
HTH
Kind Regards Conny
-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von NNMN
Gesendet: Freitag, 2. Juli 2010 12:31
An: arslist@ARSLIST.ORG
Betreff: Curious Advanced Search
Hi ARSers,
Hi have a pretty silly and curious advanced search issue. This is a Advanced
Search i am trying on User Form. I am trying to give a search on the basis of
'Group List'. I have,say 6 groups, Group1 to Group 6.
I want to list out record of users belonging to Group List namely 'Group1',
'Group2' and 'Group3'
So I gave,
1.'Group List' = (Group1) OR 'Group List' = (Group2) OR 'Group List' =
(Group3). It doesn't fetch me any record.
2. I have been trying to search for records which has 'Group1' only also.
But its not giving me any records.
3. Then I tried 'Group List' != (Group1) whihc fetched me all the records.
:S
I am going crazy over here. Can anyone help me.
Thank you
Cheers,
Naveen
-
With Warm Regards,
Naveen
--
View this message in context:
http://old.nabble.com/Curious-Advanced-Search-tp29054806p29054806.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
___
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
Re: AW: Curious Advanced Search
Thanks a lot Conny for bringing the end to my silly misery!
Cheers,
Naveen
Conny Martin wrote:
Naveen,
The Grouplist is stored internal as a list of groupids separated by a
semicolon (and sometimes an additional space)
For example to search for all User belonging to group Administror your
advanced query should look like this
('Group List' like 1;% or 'Group List' like % 1;% or 'Group List' like
%;1;%)
HTH
Kind Regards Conny
-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von NNMN
Gesendet: Freitag, 2. Juli 2010 12:31
An: arslist@ARSLIST.ORG
Betreff: Curious Advanced Search
Hi ARSers,
Hi have a pretty silly and curious advanced search issue. This is a
Advanced Search i am trying on User Form. I am trying to give a search
on the basis of 'Group List'. I have,say 6 groups, Group1 to Group 6.
I want to list out record of users belonging to Group List namely
'Group1', 'Group2' and 'Group3'
So I gave,
1.'Group List' = (Group1) OR 'Group List' = (Group2) OR 'Group List' =
(Group3). It doesn't fetch me any record.
2. I have been trying to search for records which has 'Group1' only also.
But its not giving me any records.
3. Then I tried 'Group List' != (Group1) whihc fetched me all the
records.
:S
I am going crazy over here. Can anyone help me.
Thank you
Cheers,
Naveen
-
With Warm Regards,
Naveen
--
View this message in context:
http://old.nabble.com/Curious-Advanced-Search-tp29054806p29054806.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.
___
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
-
With Warm Regards,
Naveen
--
View this message in context:
http://old.nabble.com/Curious-Advanced-Search-tp29054806p29055120.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
unsubscribe
___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: parsing from csv
The best way? There are certainly many many ways available. Misi mentions the Remedy Import Tool. Naveen gives us a bit more details. I, of-course, will talk of Meta-Update which will handle the extraction of the attached CSV, the parsing of said CSV, and the updating of what ever forms you desire based on data in the CSV with a single bit of workflow to launch the process. Imagine. No staging forms, no workflow, a simple ASCII script handles this requirement. Each row of the CSV can determine which table or rather table and record set to update/insert. Full validation, a copy of the CSV with failures being automatically created, intimate assignment control, attachments extracted, transferred to different records, renamed, etc. Meta-Update will handle CSV's with embedded quotes, line feeds, etc. The BMC Import Tool will not and neither will Excel. Meta-Update on Unix or Windows will handle each other's script files and csv file no problem. CSVs you generate can be generated on either OS for either OS. With Meta-Update this type of requirement takes 1/10th the time to develop. For a trail license with a WebEx introduction, check out the web page. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email:mailto:ben.cher...@softwaretoolhouse.com Ben.Chernys _AT_ softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Haque, Rezaul R Sent: July 1, 2010 8:34 AM To: arslist@ARSLIST.ORG Subject: parsing from csv ** Friends, What is the best way to pars columns from a csv format file from an attachment field then put in a Remedy form? Thanks, Rezaul Haque | Systems Engineer III | OSS-Remedy | ITIL Certified 12405 Powerscourt Drive, St. Louis, MO 63376 Office 314.288.3487 Fax 314-543-2500 charter_email_logo E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. _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 image001.jpg
Webservice qualificatin with LIKE
I am trying to use LIKE in a web service qualification, querying the
SRD:ServiceRequestDefintion form. Here is what I have:
'TakeSRDOfflineFlag' = Online AND ('Category1' LIKE
(XPATH(/ROOT/Tier_1)+%) OR XPATH(/ROOT/Tier_1) = $NULL$) AND ('Category2'
LIKE (XPATH(/ROOT/Tier_2)+%) OR XPATH(/ROOT/Tier_2) = $NULL$) AND
('Category3' LIKE (XPATH(/ROOT/Tier_3)+%) OR XPATH(/ROOT/Tier_3) = $NULL$)
This gives me an error
ARERR [9130] Error encountered while executing a Web Service :
ERROR (313): Data types are not appropriate for relational operation;
ERROR (312): Data types are not appropriate for arithmetic operation;
In a set fields qualification the syntax would work. Can anyone tell what's
the problem with this qualification? Can I not use LIKE for XPATH elements?
Thank You
Raido
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Webservice qualificatin with LIKE
Try this instead
'Category' LIKE XPATH(/ROOT/Tier_1)
and have the webservice pass in the % character.
On Jul 2, 8:32 am, Raido Oja raido@gmail.com wrote:
I am trying to use LIKE in a web service qualification, querying the
SRD:ServiceRequestDefintion form. Here is what I have:
'TakeSRDOfflineFlag' = Online AND ('Category1' LIKE
(XPATH(/ROOT/Tier_1)+%) OR XPATH(/ROOT/Tier_1) = $NULL$) AND ('Category2'
LIKE (XPATH(/ROOT/Tier_2)+%) OR XPATH(/ROOT/Tier_2) = $NULL$) AND
('Category3' LIKE (XPATH(/ROOT/Tier_3)+%) OR XPATH(/ROOT/Tier_3) = $NULL$)
This gives me an error
ARERR [9130] Error encountered while executing a Web Service :
ERROR (313): Data types are not appropriate for relational operation;
ERROR (312): Data types are not appropriate for arithmetic operation;
In a set fields qualification the syntax would work. Can anyone tell what's
the problem with this qualification? Can I not use LIKE for XPATH elements?
Thank You
Raido
___
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
Re: parsing from csv
Ahh, in the olden days we used Perl the KING of parsing engines On Jul 2, 7:56 am, Ben Chernys ben.cher...@softwaretoolhouse.com wrote: The best way? There are certainly many many ways available. Misi mentions the Remedy Import Tool. Naveen gives us a bit more details. I, of-course, will talk of Meta-Update which will handle the extraction of the attached CSV, the parsing of said CSV, and the updating of what ever forms you desire based on data in the CSV with a single bit of workflow to launch the process. Imagine. No staging forms, no workflow, a simple ASCII script handles this requirement. Each row of the CSV can determine which table or rather table and record set to update/insert. Full validation, a copy of the CSV with failures being automatically created, intimate assignment control, attachments extracted, transferred to different records, renamed, etc. Meta-Update will handle CSV's with embedded quotes, line feeds, etc. The BMC Import Tool will not and neither will Excel. Meta-Update on Unix or Windows will handle each other's script files and csv file no problem. CSVs you generate can be generated on either OS for either OS. With Meta-Update this type of requirement takes 1/10th the time to develop. For a trail license with a WebEx introduction, check out the web page. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: mailto:ben.cher...@softwaretoolhouse.com Ben.Chernys _AT_ softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/http://www.softwaretoolhouse.com/ _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Haque, Rezaul R Sent: July 1, 2010 8:34 AM To: arsl...@arslist.org Subject: parsing from csv ** Friends, What is the best way to pars columns from a csv format file from an attachment field then put in a Remedy form? Thanks, Rezaul Haque | Systems Engineer III | OSS-Remedy | ITIL Certified 12405 Powerscourt Drive, St. Louis, MO 63376 Office 314.288.3487 Fax 314-543-2500 charter_email_logo E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. _attend WWRUG10www.wwrug.comARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are image001.jpg 3KViewDownload ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Using Business Time
Hi All TGIF,
Have an interesting challenge that I am hoping to solve using the business time
function.
Currently when a ticket is created the number of the day is set in the 'Week'
field and the hour is set in the 'Hour' field. Also a filter checks a home
grown Holiday List table against the current date then it sets the Holiday'
field to YES if it is a holiday. Of course if is not a Holiday then the
'Holiday' field is set to null.
Here is where it gets ugly. I have several notify escalations that use a
qualification similar to this one.
('Status' Closed) AND (('Create Date ($TIMESTAMP$ - 3600)) AND ((
'Hour' = 8) AND ( 'Hour' 18)) AND (( 'Week' = 2) AND ( 'Week' = 6)) AND
(($TIMESTAMP$ - 'Create Date') 3600) AND ( 'Holiday' = $NULL$ )
What I would like to get to is something like
('Status' Closed) AND (('Create Date ($TIMESTAMP$ - 3600)) AND 'Work
Day' = Yes
Any ideas greatly appreciated.
Mark
Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.commailto:mbritt...@navisite.com
(315) 453-2912 x5335 (Phone)
(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
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Discoverying Physical Locations
Hi, I was wondering if there is a way to configure Discover rack space, etc.. for assets. Can the rack space be considered a physical CI? Is there a way when an asset is scanned we can associate the asset with the physical rack space? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
BMC Remedy and Zenoss Integration
Hello Everyone, Our company has purchased the Zenoss application for server and network monitoring. I have a general questions on whether or not any one else out there is using Zenoss. If so, have you integrated with the Service Desk application to generate incidents. If you have integrated, how are you passing data, email engine, api, web services etc. Any other information you can sure is appreciated. Thanks, Todd Arner Great Lakes The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Client versions
In the API log, it lists what versions people are using. Protocol 13, protocol 12, etc. Is there a list of what version these protocols map to somewhere? I have seen log entries all the way back to protocol 5, 8, 9, 10, etc. What versions are these? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
ITSM Upgrade Issues
okay so I have been having ITSM upgrade issues and I have finally narrowed it down. Basically what is happening is I am running the ITSM install and it is trying to import .def .arx files etc and it is failing some definition files because it is trying to import a form with a field that already exists and failing saying that it already exists but the DB ID's are different. Example: One of the installs is importing the form FIN:LoadCosts and is failing because in the current system the field Related Cost is there, which it should be but it is Field ID 270002018. The field ID trying to be imported is 303778300. I have looked at other system the same version as mine and the current field ID is the same as mine 270002018. So why is this form failing to import, shouldn't it be over writing that field? Has anyone else seen this or run into this issue? Current system: ARS 7.5 Patch 4 CMDB 7.6 Patch 1 ITSM 7.03 Patch 9, plus the compatibility Patch Windows 2003 Server SQL 2005 DB VMWare Virtual Server I am trying to upgrade to ITSM 7.6 Patch 1 I have tried ITSM 7.6 Patch 1, ITSM 7.6, and now I am trying ITSM 7.5 and the same issue is happening on all three upgrades. -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Client versions
Ar.hAR_CURRENT_API_VERSION My personal list 14 7.5 13 7.1 12 7.0 11 6.3 10 6.0 9 5.12 That's as far back as my builds go these days But I was always under the impression Protocol was something completely different: /* client Id for an API program */ #define AR_CLIENT_TYPE_UNKNOWN 0 #define AR_CLIENT_TYPE_PRE_50 1 /* Pre 5.0 ar client tools */ #define AR_CLIENT_TYPE_WAT 2 /* Windows admin tool */ #define AR_CLIENT_TYPE_WUT 3 /* Windows user tool */ #define AR_CLIENT_TYPE_WIP 4 /* Windows import tool */ #define AR_CLIENT_TYPE_DSO 5 /* Distributed server */ #define AR_CLIENT_TYPE_ODBC6 /* ARODBC */ #define AR_CLIENT_TYPE_APPROVAL7 /* Approval server */ #define AR_CLIENT_TYPE_WEB_SERVER 8 /* AR web server, waserver */ #define AR_CLIENT_TYPE_MID_TIER9 /* Mid-tier 5.0 and later */ #define AR_CLIENT_TYPE_PALM_PILOT 10 /* Palm pilot */ #define AR_CLIENT_TYPE_FLASHBOARDS11 /* Flashboards */ #define AR_CLIENT_TYPE_FLASHBOARDS_MID_TIER 12 /* Flashboards mid-tier */ #define AR_CLIENT_TYPE_EIE13 /* Enterprise Integration */ /* Engine */ #define AR_CLIENT_TYPE_RELOAD 14 /* arreload */ #define AR_CLIENT_TYPE_CACHE 15 /* arcache */ #define AR_CLIENT_TYPE_DIST 16 /* ardist */ #define AR_CLIENT_TYPE_RUN_MACRO 17 /* runmacro */ #define AR_CLIENT_TYPE_MAIL 18 /* armaild/armailex */ #define AR_CLIENT_TYPE_IMPORT_CMD 19 /* arimportcmd */ #define AR_CLIENT_TYPE_REPORT_PLUGIN 20 /* Report creator plugin */ #define AR_CLIENT_TYPE_ALERT 21 /* Alert tool */ #define AR_CLIENT_TYPE_MAIL_DAEMON22 /* New AR Mail Daemon, not armaild */ #define AR_CLIENT_TYPE_SIGNAL 23 /* arsignal */ #define AR_CLIENT_TYPE_DEBUGGER 24 /* debugger */ #define AR_CLIENT_TYPE_OBJSTR 25 /* object store API */ #define AR_CLIENT_TYPE_OBJSTR_SYNC26 /* object store sync utility */ #define AR_CLIENT_TYPE_SERVER_ADMIN_PLUGIN27 /* Server Admin plugin */ #define AR_CLIENT_TYPE_SIM_PUBLISHING_SERVER 28 /* bmc sim publishing server */ #define AR_CLIENT_TYPE_SIM_SME29 /* bmc sim service model editor */ #define AR_CLIENT_TYPE_CMDB_ENGINE30 /* cmdb engine */ #define AR_CLIENT_TYPE_CMDB_DRIVER31 /* cmdb driver */ #define AR_CLIENT_TYPE_RECON_ENGINE 32 /* cmdb reconciliation engine */ #define AR_CLIENT_TYPE_ASSIGNMENT_ENGINE 33 /*Assignment Engine */ #define AR_CLIENT_TYPE_WEBSERVICE 34 /* Webservice client type */ #define AR_CLIENT_TYPE_END_OF_PRODUCT 3999 #define AR_CLIENT_TYPE_UNPRODUCTIZED_START 4000 #define AR_CLIENT_TYPE_DRIVER 4000 /* Driver: sample program */ #define AR_CLIENT_TYPE_DISPATCHER 4001 /* distributor of appl. */ /* command signals */ #define AR_CLIENT_TYPE_HELP 4002 /* arhelp */ #define AR_CLIENT_TYPE_JANITOR 4003 /* arjanitor */ #define AR_CLIENT_TYPE_MENU 4004 /* armenu */ #define AR_CLIENT_TYPE_STRUCT 4005 /* arstruct */ #define AR_CLIENT_TYPE_TEXT 4006 /* artext */ #define AR_CLIENT_TYPE_SQLED4007 /* arsqled */ #define AR_CLIENT_TYPE_CHANGE_SEL 4008 /* archgsel */ #define AR_CLIENT_TYPE_CHANGE_ID4009 /* archgid */ #define AR_CLIENT_TYPE_LABEL4010 /* arlabel */ #define AR_CLIENT_TYPE_END_OF_RESERVED_RANGE 5000 Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Donald Morton Sent: July 2, 2010 10:19 PM To: arslist@ARSLIST.ORG Subject: Client versions In the API log, it lists what versions people are using. Protocol 13, protocol 12, etc. Is there a list of what version these protocols map to somewhere? I have seen log entries all the way back to protocol 5, 8, 9, 10, etc. What versions are these? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com
