Re: DMT data upload issue.

[Anuj Chaba]

HI Abhishek

Can you please try the below steps and check if this can help to solve the
issue
Check the given forms.
DLD:Lock-if any entry here, then delete those entry and run again


View audit log-to check what process was running last time.

DLD:ThreadManager-to check any entry for Data load console, if any error
takes place, check this form.

or you can navigate to DMT:SYS:StagingFormDependency form and click Rebuild
Sequence Table. You can then return your job and try running it again.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: DMT data upload issue.

[Abhi$hek]

Hi Anuj,

Thanks for your kind response.

No entry in DLD:Lock.
No entry in DLD:ThreadManage.

No improvement even after rebuild sequencing and still job getting stuck in
In Progress.

Early response will be highly appreciated.

Regards,
Abhishek A



On Thu, Jul 3, 2014 at 12:30 PM, Anuj Chaba anuj.ch...@gmail.com wrote:

 **
 HI Abhishek

 Can you please try the below steps and check if this can help to solve the
 issue
 Check the given forms.
 DLD:Lock-if any entry here, then delete those entry and run again


 View audit log-to check what process was running last time.

 DLD:ThreadManager-to check any entry for Data load console, if any error
 takes place, check this form.

 or you can navigate to DMT:SYS:StagingFormDependency form and click
 Rebuild Sequence Table. You can then return your job and try running it
 again.



 _ARSlist: Where the Answers Are and have been for 20 years_




-- 



Regards,
Abhishek Anand

 http://www.vyomlabs.com/

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Import CSV on DB level in Remedy ARS 7.5

[Wesley Reyes]

Hi,

Would like to know if you do have any DB import script that I can import a 500K 
rows of data to the Remedy DB (T and H table) on a DB level.

Thanks for the reply guys!!! :)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: DMT data upload issue.

[Suresh Loganathan]

Hi Abishek,

Can you please check the server setting form. it contain DMT file path
field. Please cross check the server name into path as per ar.cfg.

if any wrong, change the correct one. if not fixed, change the path and try
again.

Regards,

Suresh Loganathan
On Jul 3, 2014 1:04 PM, Abhi$hek abhi.masc...@gmail.com wrote:

 **
 Hi Anuj,

 Thanks for your kind response.

 No entry in DLD:Lock.
 No entry in DLD:ThreadManage.

 No improvement even after rebuild sequencing and still job getting stuck
 in In Progress.

 Early response will be highly appreciated.

 Regards,
 Abhishek A



 On Thu, Jul 3, 2014 at 12:30 PM, Anuj Chaba anuj.ch...@gmail.com wrote:

 **
 HI Abhishek

 Can you please try the below steps and check if this can help to solve
 the issue
 Check the given forms.
 DLD:Lock-if any entry here, then delete those entry and run again


 View audit log-to check what process was running last time.

 DLD:ThreadManager-to check any entry for Data load console, if any error
 takes place, check this form.

 or you can navigate to DMT:SYS:StagingFormDependency form and click
 Rebuild Sequence Table. You can then return your job and try running it
 again.



 _ARSlist: Where the Answers Are and have been for 20 years_




 --



 Regards,
 Abhishek Anand

  http://www.vyomlabs.com/

  _ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Import CSV on DB level in Remedy ARS 7.5

[Misi Mladoniczky]

Hi,

I would recommend API-based tools such as the Data Import tool.

Or if you need more flexibility write your own tool.

Or maybe buy the scripting tool from Ben Cherneys @
http://www.softwaretoolhouse.com.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* 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.

 Hi,

 Would like to know if you do have any DB import script that I can import a
 500K rows of data to the Remedy DB (T and H table) on a DB level.

 Thanks for the reply guys!!! :)

 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Import CSV on DB level in Remedy ARS 7.5

[Peter Romain]

You could use AI to do this.

 

If this is a custom form and you don’t need the status history you could turn 
this off which would remove the H table making the import a little easier.

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 08:58
To: arslist@ARSLIST.ORG
Subject: Import CSV on DB level in Remedy ARS 7.5

 

** 

Hi,

 

Would like to know if you do have any DB import script that I can import a 500K 
rows of data to the Remedy DB (T and H table) on a DB level.

 

Thanks for the reply guys!!! :)

_ARSlist: Where the Answers Are and have been for 20 years_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: DMT data upload issue.

[Abhi$hek]

Hi Suresh,

Thanks for your kind response.
Are you highlighting the SYS:System Settings form but it will contain only
DMT file path and not server details.

Please navigate to the exact location where you want to cross check the
server name.

Early response will be highly appreciated.

Regards,
Abhishek A


On Thu, Jul 3, 2014 at 2:11 PM, Suresh Loganathan ersures...@gmail.com
wrote:

 **

 Hi Abishek,

 Can you please check the server setting form. it contain DMT file path
 field. Please cross check the server name into path as per ar.cfg.

 if any wrong, change the correct one. if not fixed, change the path and
 try again.

 Regards,

 Suresh Loganathan
 On Jul 3, 2014 1:04 PM, Abhi$hek abhi.masc...@gmail.com wrote:

 **
 Hi Anuj,

 Thanks for your kind response.

 No entry in DLD:Lock.
 No entry in DLD:ThreadManage.

 No improvement even after rebuild sequencing and still job getting stuck
 in In Progress.

 Early response will be highly appreciated.

 Regards,
 Abhishek A



 On Thu, Jul 3, 2014 at 12:30 PM, Anuj Chaba anuj.ch...@gmail.com wrote:

 **
 HI Abhishek

 Can you please try the below steps and check if this can help to solve
 the issue
 Check the given forms.
 DLD:Lock-if any entry here, then delete those entry and run again


 View audit log-to check what process was running last time.

 DLD:ThreadManager-to check any entry for Data load console, if any error
 takes place, check this form.

 or you can navigate to DMT:SYS:StagingFormDependency form and click
 Rebuild Sequence Table. You can then return your job and try running it
 again.



 _ARSlist: Where the Answers Are and have been for 20 years_




 --



 Regards,
 Abhishek Anand

  http://www.vyomlabs.com/

  _ARSlist: Where the Answers Are and have been for 20 years_

 _ARSlist: Where the Answers Are and have been for 20 years_




-- 



Regards,
Abhishek Anand

 http://www.vyomlabs.com/

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Import CSV on DB level in Remedy ARS 7.5

[Wesley Reyes]

Hi Missy,

Thanks for the help. We are currently using the DataImport tool already and it 
is still a bit slow.

Hi Peter,

Thanks for the help. How can I turn-off the H table? Is it in the parameters or 
in the properties of the form?

Thanks,

Wesley


On Thursday, 3 July 2014, 17:00, Peter Romain 
p.romain.arsl...@parsolutions.co.uk wrote:
 


** 
You could use AI to do this.
 
If this is a custom form and you don’t need the status history you could turn 
this off which would remove the H table making the import a little easier.
 
From:Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 08:58
To: arslist@ARSLIST.ORG
Subject: Import CSV on DB level in Remedy ARS 7.5
 
** 
Hi,
 
Would like to know if you do have any DB import script that I can import a 500K 
rows of data to the Remedy DB (T and H table) on a DB level.
 
Thanks for the reply guys!!! :)
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Import CSV on DB level in Remedy ARS 7.5

[Peter Romain]

Hi Wesley,

 

Yes, in ARS 8.1 it’s in the Basic area of the Definitions tab of the form – 
Disable Status History

 

In earlier versions I think you’ll find it in the form properties

 

Cheers

 

Peter

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 10:24
To: arslist@ARSLIST.ORG
Subject: Re: Import CSV on DB level in Remedy ARS 7.5

 

** 

Hi Missy,





Thanks for the help. We are currently using the DataImport tool already and it 
is still a bit slow.





Hi Peter,





Thanks for the help. How can I turn-off the H table? Is it in the parameters or 
in the properties of the form?





Thanks,





Wesley

 

On Thursday, 3 July 2014, 17:00, Peter Romain 
p.romain.arsl...@parsolutions.co.uk 
mailto:p.romain.arsl...@parsolutions.co.uk  wrote:

 

** 

You could use AI to do this.

 

If this is a custom form and you don’t need the status history you could turn 
this off which would remove the H table making the import a little easier.

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 08:58
To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 
Subject: Import CSV on DB level in Remedy ARS 7.5

 

** 

Hi,

 

Would like to know if you do have any DB import script that I can import a 500K 
rows of data to the Remedy DB (T and H table) on a DB level.

 

Thanks for the reply guys!!! :)

_ARSlist: Where the Answers Are and have been for 20 years_

_ARSlist: Where the Answers Are and have been for 20 years_

 

_ARSlist: Where the Answers Are and have been for 20 years_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Remdy regular form fields properties

[vidyasagar kommu]

Hello All,

I have a regular  form which has a table field which gets data populated
from some backend table the table qualification is ('Supplier=$Supplier$
and Product=$Product Name$) displaying the name of back end values are more
what i want to display only 10 records when i click on some button (For e.g
Displaying total records are 20 when i moment click the button it should
display only 10 records and when i moment second time click on button it
should display reaming 10 records)
Kindly Suggest on this


Regards
Chiru

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Import CSV on DB level in Remedy ARS 7.5

[Ben Chernys]

Thanks Misi,

 

Meta-Update will handle 500k files no problem.  It has a “light footprint” not 
requiring any changes to the Remedy server’s forms or workflow and can 
completely eliminate the need for staging forms and workflow for imports.

 

A simple file import can usually be scripted in under an hour.  

 

Meta-Update includes a single stepping debugger and robust facilities for every 
data type in Remedy (attachments, currency, diary fields, even status history 
fields)  and can be used to automate any data operation through the API.

 

As an import tool it can handle poorly quoted CSVs, CSVs with values containing 
embedded quotes or line feeds, and it can also update multiple records from 
each CSV row or different forms for each row.

 

It is replete with auditing and logging facilities.  

 

Trial licenses are free and come with our Live Install service which usually 
results in your first business problem being solved.

 

New:  We have an ITSM Archiving package – that handles a root request as a 
single tree of data and will include your own tables and multi-tenant rules.  
We also have a data migration package that will migrate from 7.0.3 to 8.1 
including changing Change to Releases, fixing the CMDB, merging and renaming 
product and operational catalogues, support groups, even operating companies.

 

For more information visit us at www.softwaretoolhouse.com

 

 


Ben Chernys
Senior Software Architect
logoSthInc-sm  

Canada / Deutschland
Mobile:  +49 171 380 2329GMT + 1 + [ DST ]
Email:mailto:Ben.Chernys_AT_softwaretoolhouse.com 
Ben.Chernys_AT_softwaretoolhouse.com
Web:  http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com

We are a BMC Technology Alliance Partner

 

 

Check out Software Tool House's free Diary Editor and our  Freebies Section for 
ITSM Forms and Fields spreadsheet.

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. 

 

Meta-Archive does ITSM Archiving your way: with your forms and your 
multi-tenant rules, treating each root request as the tree of data and forms 
that it is it is.

 

Pre ITSM 7.6.04?  Clarify?  Roll your own?  No problem!

You can keep your valuable data!


 http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/  

 

 

 

 

 

 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: July-03-14 10:45
To: arslist@ARSLIST.ORG
Subject: Re: Import CSV on DB level in Remedy ARS 7.5

 

Hi,

 

I would recommend API-based tools such as the Data Import tool.

 

Or if you need more flexibility write your own tool.

 

Or maybe buy the scripting tool from Ben Cherneys @  
http://www.softwaretoolhouse.com http://www.softwaretoolhouse.com.

 

Best Regards - Misi, RRR AB,  http://www.rrr.se http://www.rrr.se 
(ARSList MVP 2011)

 

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):

* 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 
http://rrr.se.

 

 Hi,

 

 Would like to know if you do have any DB import script that I can 

 import a 500K rows of data to the Remedy DB (T and H table) on a DB level.

 

 Thanks for the reply guys!!! :)

 

 __

 _ UNSUBSCRIBE or access ARSlist Archives at  http://www.arslist.org 
 www.arslist.org 

 Where the Answers Are, and have been for 20 years

 

___

UNSUBSCRIBE or access ARSlist Archives at  http://www.arslist.org 
www.arslist.org Where the Answers Are, and have been for 20 years

 

 

-

No virus found in this message.

Checked by AVG -  http://www.avg.com www.avg.com

Version: 2013.0.3485 / Virus Database: 3955/7787 - Release Date: 07/03/14

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


smime.p7s
Description: S/MIME cryptographic signature

Re: Import CSV on DB level in Remedy ARS 7.5

[Wesley Reyes]

Hi Peter,

Thanks. I will check on that.  Can I just use a straight data import from 
oracle to insert on the T Table once the status History is disabled?




Sent from Samsung Mobile

div Original message /divdivFrom: Peter Romain 
p.romain.arsl...@parsolutions.co.uk /divdivDate:03/07/2014  18:06  
(GMT+08:00) /divdivTo: arslist@ARSLIST.ORG /divdivSubject: Re: Import 
CSV on DB level in Remedy ARS 7.5 /divdiv
/div**
Hi Wesley,
 
Yes, in ARS 8.1 it’s in the Basic area of the Definitions tab of the form – 
Disable Status History
 
In earlier versions I think you’ll find it in the form properties
 
Cheers
 
Peter
 
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 10:24
To: arslist@ARSLIST.ORG
Subject: Re: Import CSV on DB level in Remedy ARS 7.5
 
**
Hi Missy,


Thanks for the help. We are currently using the DataImport tool already and it 
is still a bit slow.


Hi Peter,


Thanks for the help. How can I turn-off the H table? Is it in the parameters or 
in the properties of the form?


Thanks,


Wesley
 

On Thursday, 3 July 2014, 17:00, Peter Romain 
p.romain.arsl...@parsolutions.co.uk wrote:
 

**
You could use AI to do this.
 
If this is a custom form and you don’t need the status history you could turn 
this off which would remove the H table making the import a little easier.
 
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 08:58
To: arslist@ARSLIST.ORG
Subject: Import CSV on DB level in Remedy ARS 7.5
 
**
Hi,
 
Would like to know if you do have any DB import script that I can import a 500K 
rows of data to the Remedy DB (T and H table) on a DB level.
 
Thanks for the reply guys!!! :)
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
 

_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Import CSV on DB level in Remedy ARS 7.5

[Peter Romain]

Yes, but on each record you will need to set the Request ID (Field 1) to a 
unique number (padded up to 15 characters if you need to sort on this field) 
and also set the other core fields.

If real data isn’t needed in the core fields you could set them to dummy values.

 

If your source database is accessible to the Remedy database then you could use 
a view form to access the data directly rather than import it. You’d still need 
to identify a unique key though.

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 12:29
To: arslist@ARSLIST.ORG
Subject: Re: Import CSV on DB level in Remedy ARS 7.5

 

** 

Hi Peter,

 

Thanks. I will check on that.  Can I just use a straight data import from 
oracle to insert on the T Table once the status History is disabled?

 

 

 

 

Sent from Samsung Mobile

 

 Original message 

From: Peter Romain 

Date:03/07/2014 18:06 (GMT+08:00) 

To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG  

Subject: Re: Import CSV on DB level in Remedy ARS 7.5 

 

** 

Hi Wesley,

 

Yes, in ARS 8.1 it’s in the Basic area of the Definitions tab of the form – 
Disable Status History

 

In earlier versions I think you’ll find it in the form properties

 

Cheers

 

Peter

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 10:24
To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 
Subject: Re: Import CSV on DB level in Remedy ARS 7.5

 

** 

Hi Missy,






Thanks for the help. We are currently using the DataImport tool already and it 
is still a bit slow.






Hi Peter,






Thanks for the help. How can I turn-off the H table? Is it in the parameters or 
in the properties of the form?






Thanks,






Wesley

 

On Thursday, 3 July 2014, 17:00, Peter Romain 
p.romain.arsl...@parsolutions.co.uk 
mailto:p.romain.arsl...@parsolutions.co.uk  wrote:

 

** 

You could use AI to do this.

 

If this is a custom form and you don’t need the status history you could turn 
this off which would remove the H table making the import a little easier.

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 08:58
To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 
Subject: Import CSV on DB level in Remedy ARS 7.5

 

** 

Hi,

 

Would like to know if you do have any DB import script that I can import a 500K 
rows of data to the Remedy DB (T and H table) on a DB level.

 

Thanks for the reply guys!!! :)

_ARSlist: Where the Answers Are and have been for 20 years_

_ARSlist: Where the Answers Are and have been for 20 years_

 

_ARSlist: Where the Answers Are and have been for 20 years_

_ARSlist: Where the Answers Are and have been for 20 years_

_ARSlist: Where the Answers Are and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: DMT data upload issue.

[Suresh Loganathan]

Application admin console-- Custom config tab-- Foundation -- Advanced
options -- System setting.
On Jul 3, 2014 2:36 PM, Abhi$hek abhi.masc...@gmail.com wrote:

 **
 Hi Suresh,

 Thanks for your kind response.
 Are you highlighting the SYS:System Settings form but it will contain only
 DMT file path and not server details.

 Please navigate to the exact location where you want to cross check the
 server name.

 Early response will be highly appreciated.

 Regards,
 Abhishek A


 On Thu, Jul 3, 2014 at 2:11 PM, Suresh Loganathan ersures...@gmail.com
 wrote:

 **

 Hi Abishek,

 Can you please check the server setting form. it contain DMT file path
 field. Please cross check the server name into path as per ar.cfg.

 if any wrong, change the correct one. if not fixed, change the path and
 try again.

 Regards,

 Suresh Loganathan
 On Jul 3, 2014 1:04 PM, Abhi$hek abhi.masc...@gmail.com wrote:

 **
 Hi Anuj,

 Thanks for your kind response.

 No entry in DLD:Lock.
 No entry in DLD:ThreadManage.

 No improvement even after rebuild sequencing and still job getting stuck
 in In Progress.

 Early response will be highly appreciated.

 Regards,
 Abhishek A



 On Thu, Jul 3, 2014 at 12:30 PM, Anuj Chaba anuj.ch...@gmail.com
 wrote:

 **
 HI Abhishek

 Can you please try the below steps and check if this can help to solve
 the issue
 Check the given forms.
 DLD:Lock-if any entry here, then delete those entry and run again


 View audit log-to check what process was running last time.

 DLD:ThreadManager-to check any entry for Data load console, if any
 error takes place, check this form.

 or you can navigate to DMT:SYS:StagingFormDependency form and click
 Rebuild Sequence Table. You can then return your job and try running it
 again.



 _ARSlist: Where the Answers Are and have been for 20 years_




 --



 Regards,
 Abhishek Anand

  http://www.vyomlabs.com/

  _ARSlist: Where the Answers Are and have been for 20 years_

 _ARSlist: Where the Answers Are and have been for 20 years_




 --



 Regards,
 Abhishek Anand

  http://www.vyomlabs.com/

  _ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Import CSV on DB level in Remedy ARS 7.5

[Wesley Reyes]

**
Hi Ben,Thanks for the reply. But unfortunately buying a tool is currently not an option for us. Thanks againSent from Samsung Mobile Original message From: Ben Chernys  Date:03/07/2014  19:04  (GMT+08:00) To: arslist@ARSLIST.ORG Subject: Re: Import CSV on DB level in Remedy ARS 7.5 **
Thanks Misi,Meta-Update will handle 500k files no problem. It has a “light footprint” not requiring any changes to the Remedy server’s forms or workflow and can completely eliminate the need for staging forms and workflow for imports.A simple file import can usually be scripted in under an hour. Meta-Update includes a single stepping debugger and robust facilities for every data type in Remedy (attachments, currency, diary fields, even status history fields) and can be used to automate any data operation through the API.As an import tool it can handle poorly quoted CSVs, CSVs with values containing embedded quotes or line feeds, and it can also update multiple records from each CSV row or different forms for each row.It is replete with auditing and logging facilities. Trial licenses are free and come with our Live Install service which usually results in your first business problem being solved.New: We have an ITSM Archiving package – that handles a root request as a single tree of data and will include your own tables and multi-tenant rules. We also have a data migration package that will migrate from 7.0.3 to 8.1 including changing Change to Releases, fixing the CMDB, merging and renaming product and operational catalogues, support groups, even operating companies.For more information visit us at www.softwaretoolhouse.comBen ChernysSenior Software Architect Canada / DeutschlandMobile: +49 171 380 2329 GMT + 1 + [ DST ]Email: Ben.Chernys_AT_softwaretoolhouse.comWeb: www.softwaretoolhouse.comWe are a BMC Technology Alliance PartnerCheck out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet.Meta-Update, our premium ARS Data tool, lets youautomate your imports, migrations,in no time at all, without programming, without staging forms, without merge workflow.Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as the tree of data and forms that it is it is.Pre ITSM 7.6.04? Clarify? Roll your own? No problem!You can keep your valuable data!http://www.softwaretoolhouse.com/ -Original Message-From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi MladoniczkySent: July-03-14 10:45To: arslist@ARSLIST.ORGSubject: Re: Import CSV on DB level in Remedy ARS 7.5Hi,I would recommend API-based tools such as the Data Import tool.Or if you need more flexibility write your own tool.Or maybe buy the scripting tool from Ben Cherneys @ http://www.softwaretoolhouse.com. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):* 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. Hi, Would like to know if you do have any DB import script that I can  import a 500K rows of data to the Remedy DB (T and H table) on a DB level. Thanks for the reply guys!!! :) __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org  "Where the Answers Are, and have been for 20 years"___UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"-No virus found in this message.Checked by AVG - www.avg.comVersion: 2013.0.3485 / Virus Database: 3955/7787 - Release Date: 07/03/14
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

Re: Import CSV on DB level in Remedy ARS 7.5

[Wesley Reyes]

Hi Peter,

Thanks.  Our source actually is not from another DB but from a csv file. That 
is why we are looking for a way to import the csv file without using the 
dataimport tool as it takes us sometime to load the data inside the DB.

Thanks again :)


Sent from Samsung Mobile

div Original message /divdivFrom: Peter Romain 
p.romain.arsl...@parsolutions.co.uk /divdivDate:03/07/2014  19:58  
(GMT+08:00) /divdivTo: arslist@ARSLIST.ORG /divdivSubject: Re: Import 
CSV on DB level in Remedy ARS 7.5 /divdiv
/div**
Yes, but on each record you will need to set the Request ID (Field 1) to a 
unique number (padded up to 15 characters if you need to sort on this field) 
and also set the other core fields.
If real data isn’t needed in the core fields you could set them to dummy values.
 
If your source database is accessible to the Remedy database then you could use 
a view form to access the data directly rather than import it. You’d still need 
to identify a unique key though.
 
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 12:29
To: arslist@ARSLIST.ORG
Subject: Re: Import CSV on DB level in Remedy ARS 7.5
 
**
Hi Peter,
 
Thanks. I will check on that.  Can I just use a straight data import from 
oracle to insert on the T Table once the status History is disabled?
 
 
 
 
Sent from Samsung Mobile
 

 Original message 
From: Peter Romain
Date:03/07/2014 18:06 (GMT+08:00)
To: arslist@ARSLIST.ORG
Subject: Re: Import CSV on DB level in Remedy ARS 7.5
 
**
Hi Wesley,
 
Yes, in ARS 8.1 it’s in the Basic area of the Definitions tab of the form – 
Disable Status History
 
In earlier versions I think you’ll find it in the form properties
 
Cheers
 
Peter
 
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 10:24
To: arslist@ARSLIST.ORG
Subject: Re: Import CSV on DB level in Remedy ARS 7.5
 
**
Hi Missy,



Thanks for the help. We are currently using the DataImport tool already and it 
is still a bit slow.



Hi Peter,



Thanks for the help. How can I turn-off the H table? Is it in the parameters or 
in the properties of the form?



Thanks,



Wesley
 

On Thursday, 3 July 2014, 17:00, Peter Romain 
p.romain.arsl...@parsolutions.co.uk wrote:
 

**
You could use AI to do this.
 
If this is a custom form and you don’t need the status history you could turn 
this off which would remove the H table making the import a little easier.
 
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
Sent: 03 July 2014 08:58
To: arslist@ARSLIST.ORG
Subject: Import CSV on DB level in Remedy ARS 7.5
 
**
Hi,
 
Would like to know if you do have any DB import script that I can import a 500K 
rows of data to the Remedy DB (T and H table) on a DB level.
 
Thanks for the reply guys!!! :)
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
 

_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

ARERR(330)

[Gordon Frank]

I am posting this because this drove me crazy and it ended up being
something simple.

1. I created a new user in CTM:People.
2. I added the ITSM Permissions that I thought they'd need and tried to
login as them and open a new Change Request.
3. Upon saving the Change, I got

You dont have write access to field:several background fields(ARERR 330)

4. After trying various things from BMC:Communites, I finally thought to
myself: I wonder if General Access permission is saved in the User form?

5. I looked and it wasn't there. I had assumed that General Access was
default, but you know the old saying about Assuming: A.s out of U and me!

6. Once I added this, everything worked normally.

I decided to add this to ARSList, because it drove me nuts for a while and
Communites was no help.

Let me know if this helps you some day?

Gordon Frank

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

ITSM upgrade 7.6.04

[Hodgdon, Paul]

All,
I wanted to get a feel for how feasible the following upgrade would be.

We have a 7.6.04 environment with the only SP being AR SP5.  Our development 
environment is one mid-tier/one AR server, test is one mid-tier/one AR server 
and production 2 mid-tiers/2 AR servers.
The application was installed as root and we want to install the app on new 
servers in each environment with a non-root user and install 7.6.04 ITSM SP5.  
Is it possible to setup a dev environment of one mid-tier/one AR server with 
7.6.04 SP5 and take our current production database on 7.6.04 to load into 
development and using the MPS restore tool convert the 7.6.04 DB to our 7.6.04 
SP5 installed DB?

One of the things we want to do through this process is also get production 
data into our dev/test systems.

The other alternative I was thinking of is building a new 7.6.04 environment, 
moving over the DBs from our existing environment then doing an in-place 
upgrade on ITSM SP5.

Thoughts?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: ARERR(330)

[Tony Smith]

Gordon

 

Have you checked that the Access Restriction on the People form under
Login/Access Details is restricted to the specific Company that the User
belongs to?

 

Tony Smith

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon Frank
Sent: 03 July 2014 14:30
To: arslist@ARSLIST.ORG
Subject: ARERR(330)

 

** 

I am posting this because this drove me crazy and it ended up being
something simple.

 

1. I created a new user in CTM:People.

2. I added the ITSM Permissions that I thought they'd need and tried to
login as them and open a new Change Request.

3. Upon saving the Change, I got

You dont have write access to field:several background fields(ARERR 330)

4. After trying various things from BMC:Communites, I finally thought to
myself: I wonder if General Access permission is saved in the User form?

5. I looked and it wasn't there. I had assumed that General Access was
default, but you know the old saying about Assuming: A.s out of U and me!

6. Once I added this, everything worked normally.

I decided to add this to ARSList, because it drove me nuts for a while and
Communites was no help.

Let me know if this helps you some day?

Gordon Frank


 

_ARSlist: Where the Answers Are and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: ITSM upgrade 7.6.04

[William Rentfrow]

This is totally doable, provided you take care (as it seems you have) to make 
sure all of the patch levels you install on the new server will get installed 
on the server you are cutting over from prior to the switch.

The root vs non-root part isn't a big deal for the most part.  Non-root 
installs are the only way to install that make any sense security wise to most 
of the customers I have worked with, so there are occassional challenges, but 
nothing you can get around.

There are a bunch of places you will have to change the server name reference 
manually after you are done.  I did this a couple of years ago.  Not counting 
custom workflow you don't have to mess with code though.  You just need to 
update the server name in a bunch of forms.  BMC actually had a document they 
gave to us which told us all of the places to edit things.  It was stuff like 
the help file URL in the SHARE:Application Properties, etc.  I think it was 
about an hour's worth of work if you just sat down and did it.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Hodgdon, Paul
Sent: Thursday, July 03, 2014 9:29 AM
To: arslist@ARSLIST.ORG
Subject: ITSM upgrade 7.6.04

**
All,
I wanted to get a feel for how feasible the following upgrade would be.

We have a 7.6.04 environment with the only SP being AR SP5.  Our development 
environment is one mid-tier/one AR server, test is one mid-tier/one AR server 
and production 2 mid-tiers/2 AR servers.
The application was installed as root and we want to install the app on new 
servers in each environment with a non-root user and install 7.6.04 ITSM SP5.  
Is it possible to setup a dev environment of one mid-tier/one AR server with 
7.6.04 SP5 and take our current production database on 7.6.04 to load into 
development and using the MPS restore tool convert the 7.6.04 DB to our 7.6.04 
SP5 installed DB?

One of the things we want to do through this process is also get production 
data into our dev/test systems.

The other alternative I was thinking of is building a new 7.6.04 environment, 
moving over the DBs from our existing environment then doing an in-place 
upgrade on ITSM SP5.

Thoughts?

No virus found in this message.
Checked by AVG - www.avg.comhttp://www.avg.com
Version: 2014.0.4592 / Virus Database: 3972/7728 - Release Date: 06/23/14
Internal Virus Database is out of date.
_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Archival Checkpoint

[Ravi Rai]

Sweety,
From Server Information --Server Event tab you can enable event for
Archive. Check the Archive Checkbox.
One This Is enabled and after first run open Server Event Form and Search
for Event Type 14

You will find Entry for the Form on which Archive is enabled.
Event Type=14
Event Cause=2
Event Details1= Schema Name
Event Detail 2= (Example 78 of 80) meaning 80 qualifying record 78
successfully processed
Event Date=Archive Run Date and Time ( this will give you the time when
last record was archived so you can calculate run time by subtracting
archive start time )
Submitter=AR_ARCHIVER

Ravi Rai


On Wed, Jul 2, 2014 at 6:02 PM, Sweety sweetykhann...@gmail.com wrote:

 Hi List,

 I have enabled archiving and records are getting archived but how can I
 see if archuval is running through the logs or any form like when we update
 data from data wizard console?

 How can I check how many records archived and how many failed? If some
 records failed then why did they fail?


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Issue to access Change Calendar Issue.

[ersureshbe]

Hi Team,

I have faced an issue to access change calendar. When i go that option
facing below error.

http://ars-action-request-system.1093659.n2.nabble.com/file/n7597353/Calendar_Issue.png
 

Used the browser tools. i can see the issue with NGC Plugin. 

Can you please advise how to fix this issue?

Regards,

Suresh Loganathan...



--
View this message in context: 
http://ars-action-request-system.1093659.n2.nabble.com/Issue-to-access-Change-Calendar-Issue-tp7597353.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

FTS 8.1 Administration Questions

[Hynes, Douglas]

Greetings,

Our group is beginning the testing of Knowledge Management (RKM). Of the many 
things this entails is nailing down the FTS configuration. The most I've been 
able to find in terms of configuring the FTS is the AR System Administration 
FTS Configuration Form, but this still leaves me with questions:


* In a previous ARS Listing someone asked how to determine the size 
requirements for the BMC Software\ARSystem\ftsconfiguration\collection 
directory. I get that no one can really estimate this for you as it's dependent 
on how much stuff you have in your system. My question here is: how do I get 
a good estimate of how much stuff I have. Is there a directory or a command 
that I can use? Should I base it off of some part of the SQL DB? How did any of 
you decide on what size storage to use?

o   Link: 
http://ars-action-request-system.1093659.n2.nabble.com/Recommended-size-for-FTS-index-collection-directory-td7581791.html

* Occasionally, the BMC Software\ARSystem\ftsconfiguration\collection 
directory grows wildly and then appears to wipe old records from this folder 
and the size returns to something manageable.

o   Is this due to an auto-indexing?

o   Can a threshold be set on how much storage is used for the indexing?

o   Can a schedule be set for when it needs to dump old records (if this is 
even what it's actually doing)?

* If we use the failover FTS functionality recently released (in 8.1.01 
I think), is it safe to assume that we'll need this space on the backup servers 
as well?

Cheers,
-Doug




Confidentiality Notice:  This e-mail message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited.  If you are not the intended recipient, please 
contact the sender by reply e-mail and destroy all copies of the original 
message.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Import CSV on DB level in Remedy ARS 7.5

[Misi Mladoniczky]

Hi,

Why not import it into a table you create yourself. Then you create a View
Form to access the data from the system. This way you can control things much
better, and it is also supported.

Best Regards - Misi, RRR AB, http://rrr.se

 Yes, but on each record you will need to set the Request ID (Field 1) to a
 unique number (padded up to 15 characters if you need to sort on this field)
 and also set the other core fields.

 If real data isn’t needed in the core fields you could set them to dummy
 values.



 If your source database is accessible to the Remedy database then you could
 use a view form to access the data directly rather than import it. You’d
 still need to identify a unique key though.



 From: Action Request System discussion list(ARSList)
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
 Sent: 03 July 2014 12:29
 To: arslist@ARSLIST.ORG
 Subject: Re: Import CSV on DB level in Remedy ARS 7.5



 **

 Hi Peter,



 Thanks. I will check on that.  Can I just use a straight data import from
 oracle to insert on the T Table once the status History is disabled?









 Sent from Samsung Mobile



  Original message 

 From: Peter Romain

 Date:03/07/2014 18:06 (GMT+08:00)

 To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG

 Subject: Re: Import CSV on DB level in Remedy ARS 7.5



 **

 Hi Wesley,



 Yes, in ARS 8.1 it’s in the Basic area of the Definitions tab of the form
 – Disable Status History



 In earlier versions I think you’ll find it in the form properties



 Cheers



 Peter



 From: Action Request System discussion list(ARSList)
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
 Sent: 03 July 2014 10:24
 To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG
 Subject: Re: Import CSV on DB level in Remedy ARS 7.5



 **

 Hi Missy,






 Thanks for the help. We are currently using the DataImport tool already and it
 is still a bit slow.






 Hi Peter,






 Thanks for the help. How can I turn-off the H table? Is it in the parameters
 or in the properties of the form?






 Thanks,






 Wesley



 On Thursday, 3 July 2014, 17:00, Peter Romain
 p.romain.arsl...@parsolutions.co.uk
 mailto:p.romain.arsl...@parsolutions.co.uk  wrote:



 **

 You could use AI to do this.



 If this is a custom form and you don’t need the status history you could
 turn this off which would remove the H table making the import a little
 easier.



 From: Action Request System discussion list(ARSList)
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes
 Sent: 03 July 2014 08:58
 To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG
 Subject: Import CSV on DB level in Remedy ARS 7.5



 **

 Hi,



 Would like to know if you do have any DB import script that I can import a
 500K rows of data to the Remedy DB (T and H table) on a DB level.



 Thanks for the reply guys!!! :)

 _ARSlist: Where the Answers Are and have been for 20 years_

 _ARSlist: Where the Answers Are and have been for 20 years_



 _ARSlist: Where the Answers Are and have been for 20 years_

 _ARSlist: Where the Answers Are and have been for 20 years_

 _ARSlist: Where the Answers Are and have been for 20 years_


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years

 --
 This message was scanned by ESVA and is believed to be clean.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years