Re: View form creation issue
You are welcome.. - Original Message From: "Moore, Christopher Allen" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, August 18, 2008 3:01:19 PM Subject: Re: View form creation issue ** Thank you Joe! From:Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, August 18, 2008 1:06 PM To: arslist@ARSLIST.ORG Subject: Re: View form creation issue Chris, Alter the table and have the columns as VARCHAR2 and not VARCHAR.. This will resolve your problem of not being able to see character fields.. Also your field that you want to dedicate towards the request ID should have a max length or 15 and a min length of 5.. I do not think ARS will like a violation of this.. Cheers Joe - Original Message From: "Moore, Christopher Allen" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, August 18, 2008 11:22:12 AM Subject: View form creation issue ** Hey list, We’re trying to pull data populated into a table by a product called TotalStorage Productivity Center . It’s an IBM product that does server scanning to return information about drive space. The end goal is to use it to update values in the CMDB. A table was created in the ARS DB that is being populated by TPC. I’m attempting to create a view form to read from the table with the following columns: [GUID] [varchar](255) NULL, [COMPUTER_NAME] [varchar](255) NULL, [IP_ADDRESS] [varchar](30) NULL, [SERIAL_NUMBER] [varchar](100) NULL, [PROCESSOR_TYPE] [varchar](100) NULL, [OS_TYPE] [varchar](100) NULL, [OS_VERSION] [varchar](100) NULL, [MODEL] [varchar](100) NULL, [MANUFACTURER] [varchar](100) NULL, [DEDICATED] [float] NULL, [SHARED] [float] NULL, [SHARED_MANUFACTURER] [varchar](255) NULL, [LAST_SCAN_DATE] [varchar](50) NULL When creating the view form, the only two available columns are Dedicated and Shared (the floats). Nothing appears in the dropdown for a key field (I manually typed in GUID to create a form, but the other fields were not there and could not be added, and GUID wasn’t there either). The table does contain data. Is there some issue with varchar or am I doing something incorrectly? According to the help files, varchar is supported: * Only the following data types are supported in view forms: * SQL Server—char, varchar, tinyint, smallint, int, text, real, float, decimal Should this be a vendor form, even though the table is already populated in our DB? 7.0.1 p6 SQL 2005 SP2 Win Server 2003 Thanks, Chris ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: View form creation issue
Thank you Joe! From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, August 18, 2008 1:06 PM To: arslist@ARSLIST.ORG Subject: Re: View form creation issue Chris, Alter the table and have the columns as VARCHAR2 and not VARCHAR.. This will resolve your problem of not being able to see character fields.. Also your field that you want to dedicate towards the request ID should have a max length or 15 and a min length of 5.. I do not think ARS will like a violation of this.. Cheers Joe - Original Message From: "Moore, Christopher Allen" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, August 18, 2008 11:22:12 AM Subject: View form creation issue ** Hey list, We're trying to pull data populated into a table by a product called TotalStorage Productivity Center . It's an IBM product that does server scanning to return information about drive space. The end goal is to use it to update values in the CMDB. A table was created in the ARS DB that is being populated by TPC. I'm attempting to create a view form to read from the table with the following columns: [GUID] [varchar](255) NULL, [COMPUTER_NAME] [varchar](255) NULL, [IP_ADDRESS] [varchar](30) NULL, [SERIAL_NUMBER] [varchar](100) NULL, [PROCESSOR_TYPE] [varchar](100) NULL, [OS_TYPE] [varchar](100) NULL, [OS_VERSION] [varchar](100) NULL, [MODEL] [varchar](100) NULL, [MANUFACTURER] [varchar](100) NULL, [DEDICATED] [float] NULL, [SHARED] [float] NULL, [SHARED_MANUFACTURER] [varchar](255) NULL, [LAST_SCAN_DATE] [varchar](50) NULL When creating the view form, the only two available columns are Dedicated and Shared (the floats). Nothing appears in the dropdown for a key field (I manually typed in GUID to create a form, but the other fields were not there and could not be added, and GUID wasn't there either). The table does contain data. Is there some issue with varchar or am I doing something incorrectly? According to the help files, varchar is supported: * Only the following data types are supported in view forms: * SQL Server-char, varchar, tinyint, smallint, int, text, real, float, decimal Should this be a vendor form, even though the table is already populated in our DB? 7.0.1 p6 SQL 2005 SP2 Win Server 2003 Thanks, Chris __Platinum Sponsor: www.rmsportal.com<http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: View form creation issue
Chris, Alter the table and have the columns as VARCHAR2 and not VARCHAR.. This will resolve your problem of not being able to see character fields.. Also your field that you want to dedicate towards the request ID should have a max length or 15 and a min length of 5.. I do not think ARS will like a violation of this.. Cheers Joe - Original Message From: "Moore, Christopher Allen" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, August 18, 2008 11:22:12 AM Subject: View form creation issue ** Hey list, We’re trying to pull data populated into a table by a product called TotalStorage Productivity Center . It’s an IBM product that does server scanning to return information about drive space. The end goal is to use it to update values in the CMDB. A table was created in the ARS DB that is being populated by TPC. I’m attempting to create a view form to read from the table with the following columns: [GUID] [varchar](255) NULL, [COMPUTER_NAME] [varchar](255) NULL, [IP_ADDRESS] [varchar](30) NULL, [SERIAL_NUMBER] [varchar](100) NULL, [PROCESSOR_TYPE] [varchar](100) NULL, [OS_TYPE] [varchar](100) NULL, [OS_VERSION] [varchar](100) NULL, [MODEL] [varchar](100) NULL, [MANUFACTURER] [varchar](100) NULL, [DEDICATED] [float] NULL, [SHARED] [float] NULL, [SHARED_MANUFACTURER] [varchar](255) NULL, [LAST_SCAN_DATE] [varchar](50) NULL When creating the view form, the only two available columns are Dedicated and Shared (the floats). Nothing appears in the dropdown for a key field (I manually typed in GUID to create a form, but the other fields were not there and could not be added, and GUID wasn’t there either). The table does contain data. Is there some issue with varchar or am I doing something incorrectly? According to the help files, varchar is supported: * Only the following data types are supported in view forms: * SQL Server—char, varchar, tinyint, smallint, int, text, real, float, decimal Should this be a vendor form, even though the table is already populated in our DB? 7.0.1 p6 SQL 2005 SP2 Win Server 2003 Thanks, Chris__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"
View form creation issue
Hey list, We're trying to pull data populated into a table by a product called TotalStorage Productivity Center. It's an IBM product that does server scanning to return information about drive space. The end goal is to use it to update values in the CMDB. A table was created in the ARS DB that is being populated by TPC. I'm attempting to create a view form to read from the table with the following columns: [GUID] [varchar](255) NULL, [COMPUTER_NAME] [varchar](255) NULL, [IP_ADDRESS] [varchar](30) NULL, [SERIAL_NUMBER] [varchar](100) NULL, [PROCESSOR_TYPE] [varchar](100) NULL, [OS_TYPE] [varchar](100) NULL, [OS_VERSION] [varchar](100) NULL, [MODEL] [varchar](100) NULL, [MANUFACTURER] [varchar](100) NULL, [DEDICATED] [float] NULL, [SHARED] [float] NULL, [SHARED_MANUFACTURER] [varchar](255) NULL, [LAST_SCAN_DATE] [varchar](50) NULL When creating the view form, the only two available columns are Dedicated and Shared (the floats). Nothing appears in the dropdown for a key field (I manually typed in GUID to create a form, but the other fields were not there and could not be added, and GUID wasn't there either). The table does contain data. Is there some issue with varchar or am I doing something incorrectly? According to the help files, varchar is supported: * Only the following data types are supported in view forms: * SQL Server-char, varchar, tinyint, smallint, int, text, real, float, decimal Should this be a vendor form, even though the table is already populated in our DB? 7.0.1 p6 SQL 2005 SP2 Win Server 2003 Thanks, Chris ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"