[OT] Access Data in ASP.Net Web Page

system · June 22, 2009, 10:58am

Todd,

We are using the web services that are part of the Service Connect package through our Intranet (written in coldfusion, we don't use Service Connect at all). I have not found a lot of good documentation but I have found that if you turn on the track log in Vantage and complete the task you want to replicate the task log can help you find the right services and methods to use. There is also a good tool called SoapUI (www.soapui.org) that can help you figure out the fields and structure of the SOAP packets you need to send to the web services.

Joe

Joseph M Milton, CISSP
Senior Programmer
Pratt Corporation

--- In vantage@yahoogroups.com, Todd Caughey <caugheyt@...> wrote:
>
> For now this is OT but down the road has potential for connect to Vantage...espcially 8.x & beyond. I am playing with Microsoft Expression Web and ASP.Net Data access to a very small test Access database. With Expression if I preview in browser it works great and shows data from the one table in the .mdb file. But when I try to open the one web page .aspx file in IE it shows the heading graphics but no data grid. I see that when I fire it up within Expression that a MS Expression Development Server starts up. But I can't figure out (or find any documentation) for what would need to be running on the web server I am using that would provide the data. I am wondering if something like ADO.NET Data Services needs to be available on the web server. I am in way over my head but the initial success in the preview mode has me pretty excited to pursue displaying database data to a web page.
>
> Any hints or suggestions as to components or services that need to be available for the end user accessing the .aspx web page would be much appreciated.
>
> Thanks,
> Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>

system · December 30, 2008, 4:17pm

For now this is OT but down the road has potential for connect to Vantage...espcially 8.x & beyond. I am playing with Microsoft Expression Web and ASP.Net Data access to a very small test Access database. With Expression if I preview in browser it works great and shows data from the one table in the .mdb file. But when I try to open the one web page .aspx file in IE it shows the heading graphics but no data grid. I see that when I fire it up within Expression that a MS Expression Development Server starts up. But I can't figure out (or find any documentation) for what would need to be running on the web server I am using that would provide the data. I am wondering if something like ADO.NET Data Services needs to be available on the web server. I am in way over my head but the initial success in the preview mode has me pretty excited to pursue displaying database data to a web page.

Any hints or suggestions as to components or services that need to be available for the end user accessing the .aspx web page would be much appreciated.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[Non-text portions of this message have been removed]

system · December 30, 2008, 4:54pm

Hi Todd,

BTW, this is how we are accessing our history for our legacy system - via a
web page.

> Any hints or suggestions as to components or services that need to be
> available for the end user accessing the .aspx web page would be much
> appreciated.

What connection string are you using? Are you developing at the Web Server
or on your workstation?

Mark W.

system · December 30, 2008, 5:41pm

Developing using Expression Web on my PC with web site files published on a server running IIS (the one serving our Citrix web side). I just discovered yesterday that I can create ASP.NET pages that can link to an Access database and display data. Sounded useful. According to the MS-Press book I have for Expression Web (EW) it should all be "code free" using something called "Providers". Works great when I "preview in browser" from within EW because it fires up the development server (whatever that is). What I'm looking for is the "real live server". So I don't really have any connection string pre se...at least none I've written. My coding days are pretty far behind me.

The generated code for the data connection looks like:
__________
<asp:AccessDataSource ID="ITRequests" runat="server" DataFile="\\vision\ITRequests\IT<file://\\vision\ITRequests\IT> Service Request.mdb" SelectCommand="SELECT [RequestID], [Requestor], [RequestDate], [RequestTime], [Class], [Department], [Description], [ITRank], [Timeframe], [CompletionComments], [ClosedDate], [ClosedTime] FROM [Request] ORDER BY [ClosedDate], [ITRank]">
</asp:AccessDataSource>
___________

As a trial project I am creating an IT Service Request database. Phase one is to display request statuses and phase two will be entry of new requests by users via web interface. partly learning exercise, partly practical.

The thought just occured to me that the IIS settings on that server may need to have some extra service enabled...such as the way ActiveSync is on the mail server. Probably a dead end but I'll check anyway. Seems there ought to be something on the server listening for data requests.

Thanks,
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Tuesday, December 30, 2008 3:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [OT] Access Data in ASP.Net Web Page

Hi Todd,

BTW, this is how we are accessing our history for our legacy system - via a
web page.

> Any hints or suggestions as to components or services that need to be
> available for the end user accessing the .aspx web page would be much
> appreciated.

What connection string are you using? Are you developing at the Web Server
or on your workstation?

Mark W.

[Non-text portions of this message have been removed]

system · December 30, 2008, 6:20pm

Do you want to spend the best $399 you've ever spent?

http://www.asprunner.com/

I created a whole entire ASP labor entry system for our 75 engineers that ties directly into our Vantage system. Whatever the per-seat cost is for Vantage, I just saved 75 of those.

I have an entire intranet hitting our Vantage SQL tables for Exec reports, Labor Entry, Job Updates, etc. All circumventing Vantage yet working LIVE with it.

A little tricky, but for ASP development....... there's no other easier, quicker, slick solution IMHO. :-)

Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Office:Â 336.668.4410 x3091
Mobile:Â 704.530.3092

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Todd Caughey
Sent: Tuesday, December 30, 2008 4:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [OT] Access Data in ASP.Net Web Page

For now this is OT but down the road has potential for connect to Vantage...espcially 8.x & beyond. I am playing with Microsoft Expression Web and ASP.Net Data access to a very small test Access database. With Expression if I preview in browser it works great and shows data from the one table in the .mdb file. But when I try to open the one web page .aspx file in IE it shows the heading graphics but no data grid. I see that when I fire it up within Expression that a MS Expression Development Server starts up. But I can't figure out (or find any documentation) for what would need to be running on the web server I am using that would provide the data. I am wondering if something like ADO.NET Data Services needs to be available on the web server. I am in way over my head but the initial success in the preview mode has me pretty excited to pursue displaying database data to a web page.

Any hints or suggestions as to components or services that need to be available for the end user accessing the .aspx web page would be much appreciated.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

system · December 31, 2008, 10:56am

> Developing using Expression Web on my PC with web site files published on
> a server running IIS (the one serving our Citrix web side). I just
> discovered yesterday that I can create ASP.NET pages that can link to an
> Access database and display data. Sounded useful.

It is!

> According to the MS-
> Press book I have for Expression Web (EW) it should all be "code free"
> using something called "Providers". Works great when I "preview in
> browser" from within EW because it fires up the development server
> (whatever that is).

Actually, it's IIS!

> What I'm looking for is the "real live server". So I
> don't really have any connection string pre se...at least none I've
> written. My coding days are pretty far behind me.
>
> The generated code for the data connection looks like:
> __________
> <asp:AccessDataSource ID="ITRequests" runat="server"
> DataFile="\\vision\ITRequests\IT<file://\\vision\ITRequests\IT> Service
> Request.mdb" SelectCommand="SELECT [RequestID], [Requestor],
> [RequestDate], [RequestTime], [Class], [Department], [Description],
> [ITRank], [Timeframe], [CompletionComments], [ClosedDate], [ClosedTime]
> FROM [Request] ORDER BY [ClosedDate], [ITRank]">
> </asp:AccessDataSource>

If you think this will make it into production, let me recommend that you
also download SQL Server Express 2008. You can import your Access tables
into SQL very easily. Now you will have one data source that doesn't move
whether you're in development or live. (Although, I would create two
databases, one for development and one for live). EW web has a SQL data
provider that's just as "code free" as the Access one. Also, SQL is far more
robust and you won't find yourself restarting IIS to fix database
connectivity issues.

Mark W.

system · December 31, 2008, 11:33am

I will underscore this. The underlying database connectivity for
Access databases is single-threaded. You can wind up with all sorts of
troubling and intermittent issues in production that you won't see in
test. Move the data to MSSQL Express - which is just a somewhat
stripped down version of the commercial product. It is limited I think
to 10 simultaneous connections per engine (not clear if you're running
on a Windows Server OS), but the underlying IIS database connectivity is
far more robust.

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Wednesday, December 31, 2008 10:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [OT] Access Data in ASP.Net Web Page

If you think this will make it into production, let me recommend that
you
also download SQL Server Express 2008. You can import your Access tables
into SQL very easily. Now you will have one data source that doesn't
move
whether you're in development or live. (Although, I would create two
databases, one for development and one for live). EW web has a SQL data
provider that's just as "code free" as the Access one. Also, SQL is far
more
robust and you won't find yourself restarting IIS to fix database
connectivity issues.

.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007181/msg
Id=72479/stime=1230738975/nc1=3848641/nc2=3848586/nc3=5202322>

[Non-text portions of this message have been removed]

system · December 31, 2008, 11:36am

Thanks for the tips. We have SQL Server running for FRx and for Exchange 2007 so when things get firmed up I can import it there as the data respository for tracking IT (my, that is) activities. I will also check to see what is running in the way of IIS on that server and try moving the Access DB and web site there. Then I'll look into importing to SQL Server.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Wednesday, December 31, 2008 9:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [OT] Access Data in ASP.Net Web Page

> Developing using Expression Web on my PC with web site files published on
> a server running IIS (the one serving our Citrix web side). I just
> discovered yesterday that I can create ASP.NET pages that can link to an
> Access database and display data. Sounded useful.

It is!

> According to the MS-
> Press book I have for Expression Web (EW) it should all be "code free"
> using something called "Providers". Works great when I "preview in
> browser" from within EW because it fires up the development server
> (whatever that is).

Actually, it's IIS!

> What I'm looking for is the "real live server". So I
> don't really have any connection string pre se...at least none I've
> written. My coding days are pretty far behind me.
>
> The generated code for the data connection looks like:
> __________
> <asp:AccessDataSource ID="ITRequests" runat="server"
> DataFile="\\vision\ITRequests\IT<file://\\vision\ITRequests\IT> Service
> Request.mdb" SelectCommand="SELECT [RequestID], [Requestor],
> [RequestDate], [RequestTime], [Class], [Department], [Description],
> [ITRank], [Timeframe], [CompletionComments], [ClosedDate], [ClosedTime]
> FROM [Request] ORDER BY [ClosedDate], [ITRank]">
> </asp:AccessDataSource>

If you think this will make it into production, let me recommend that you
also download SQL Server Express 2008. You can import your Access tables
into SQL very easily. Now you will have one data source that doesn't move
whether you're in development or live. (Although, I would create two
databases, one for development and one for live). EW web has a SQL data
provider that's just as "code free" as the Access one. Also, SQL is far more
robust and you won't find yourself restarting IIS to fix database
connectivity issues.

Mark W.

[Non-text portions of this message have been removed]

system · December 31, 2008, 12:31pm

I think I already know the answer to this, but I am open to quicker suggestions:

I have a problem with people changing flags and values in the part master table. I have denied everyone access to the Part.Update method. I have created a security group called Part Master Editors and its members are the only ones with permission to access the update method. This works fine.

However, I have one user who I need to be able to change the sales price. However, I do not want her to change anything ELSE in the part master based on how she THINKS it should be set up. However, lessons leared indicate that instead of asking for everyything else to be left alone, she just will not tell me what she did, I end up finding out about it later.

So, I guess I could create a customization that has all of the other items locked down, but I will need to make sure that she can not access the original part master program from any other program location.
Does anyone suggest an easier way, or have an opinion on the fastest way to get through this problem?

Thanks
Carey
_________________________________________________________________
Life on your PC is safer, easier, and more enjoyable with Windows VistaÂ®.
http://clk.atdmt.com/MRT/go/127032870/direct/01/

[Non-text portions of this message have been removed]

system · December 31, 2008, 12:33pm

remind her that good jobs are hard to find

bill

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Carey S
Sent: Wednesday, December 31, 2008 11:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Master Access

I think I already know the answer to this, but I am open to quicker suggestions:

I have a problem with people changing flags and values in the part master table. I have denied everyone access to the Part.Update method. I have created a security group called Part Master Editors and its members are the only ones with permission to access the update method. This works fine.

However, I have one user who I need to be able to change the sales price. However, I do not want her to change anything ELSE in the part master based on how she THINKS it should be set up. However, lessons leared indicate that instead of asking for everyything else to be left alone, she just will not tell me what she did, I end up finding out about it later.

So, I guess I could create a customization that has all of the other items locked down, but I will need to make sure that she can not access the original part master program from any other program location.
Does anyone suggest an easier way, or have an opinion on the fastest way to get through this problem?

Thanks
Carey
__________________________________________________________
Life on your PC is safer, easier, and more enjoyable with Windows Vista(r).
http://clk.atdmt.com/MRT/go/127032870/direct/01/

[Non-text portions of this message have been removed]

________________________________
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.

[Non-text portions of this message have been removed]

system · December 31, 2008, 12:43pm

You could use field-level security and set permissions on that field
so that she explicitly can't write to it.

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Carey S
Sent: Wednesday, December 31, 2008 12:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Master Access

I think I already know the answer to this, but I am open to quicker
suggestions:

I have a problem with people changing flags and values in the part
master table. I have denied everyone access to the Part.Update method. I
have created a security group called Part Master Editors and its members
are the only ones with permission to access the update method. This
works fine.

However, I have one user who I need to be able to change the sales
price. However, I do not want her to change anything ELSE in the part
master based on how she THINKS it should be set up. However, lessons
leared indicate that instead of asking for everyything else to be left
alone, she just will not tell me what she did, I end up finding out
about it later.

So, I guess I could create a customization that has all of the other
items locked down, but I will need to make sure that she can not access
the original part master program from any other program location.
Does anyone suggest an easier way, or have an opinion on the fastest way
to get through this problem?

.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007181/msg
Id=72488/stime=1230744669/nc1=3848640/nc2=3848584/nc3=5349274>

[Non-text portions of this message have been removed]

system · December 31, 2008, 1:13pm

> However, I have one user who I need to be able to change the sales price.
> However, I do not want her to change anything ELSE in the part master
> based on how she THINKS it should be set up. However, lessons leared
> indicate that instead of asking for everyything else to be left alone, she
> just will not tell me what she did, I end up finding out about it later.
>
> So, I guess I could create a customization that has all of the other items
> locked down, but I will need to make sure that she can not access the
> original part master program from any other program location.
> Does anyone suggest an easier way, or have an opinion on the fastest way
> to get through this problem?

Bill writes:

>
> remind her that good jobs are hard to find
>

;-)

My mind is wandering and thinking that there might be a BPM solution using
the "User is the Specified Group" but that's just another route toward
customization and would take a lot of work.

Do you have Portal? That seems like a cool way to specify a sharepoint web
page that only she could get and the record set would just be the Part and
the Sales Price keeping her out of Part Maintenance all together.

Or do you have Service Connect? You could have her do sales price updates in
Excel and submit the file to be updated by SC.

Hmmm.

Mark W.

system · December 31, 2008, 1:32pm

I'd love to. Did I tell you it was the boss's daughter?
C

To: vantage@yahoogroups.comFrom: bking@...: Wed, 31 Dec 2008 11:33:45 -0600Subject: RE: [Vantage] Part Master Access

remind her that good jobs are hard to findbill________________________________From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Carey SSent: Wednesday, December 31, 2008 11:31 AMTo: vantage@yahoogroups.comSubject: [Vantage] Part Master AccessI think I already know the answer to this, but I am open to quicker suggestions:I have a problem with people changing flags and values in the part master table. I have denied everyone access to the Part.Update method. I have created a security group called Part Master Editors and its members are the only ones with permission to access the update method. This works fine.However, I have one user who I need to be able to change the sales price. However, I do not want her to change anything ELSE in the part master based on how she THINKS it should be set up. However, lessons leared indicate that instead of asking for everyything else to be left alone, she just will not tell me what she did, I end up finding out about it later.So, I guess I could create a customization that has all of the other items locked down, but I will need to make sure that she can not access the original part master program from any other program location.Does anyone suggest an easier way, or have an opinion on the fastest way to get through this problem?ThanksCarey__________________________________________________________Life on your PC is safer, easier, and more enjoyable with Windows Vista(r).http://clk.atdmt.com/MRT/go/127032870/direct/01/%5bNon-text portions of this message have been removed]________________________________The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.This message (including any attachments) is intended only forthe use of the individual or entity to which it is addressed andmay contain information that is non-public, proprietary,privileged, confidential, and exempt from disclosure underapplicable law or may constitute as attorney work product.If you are not the intended recipient, you are hereby notifiedthat any use, dissemination, distribution, or copying of thiscommunication is strictly prohibited. If you have received thiscommunication in error, notify us immediately by telephone and(i) destroy this message if a facsimile or (ii) delete this messageimmediately if this is an electronic communication.Thank you.[Non-text portions of this message have been removed]

_________________________________________________________________
Itï¿½s the same Hotmailï¿½. If by ï¿½sameï¿½ you mean up to 70% faster.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad1_122008

[Non-text portions of this message have been removed]

system · December 31, 2008, 1:44pm

Neither.
I only have the SC runtime which comes with 803, and I am not using it for anything anyway.
There was an interesting suggestion about field-level security. However, I am unsure about it.
A while ago, I wanted to lock people out of updating certain master files, such as ship-via and terms.
However, what I noticed when I did this is that the restricted users would attempt to do something like a sales order, and they could not select these restricted fields from the drop-downs and it caused all sorts of problems.

So, I went and created a customization that is called PriceUpdOnly. In this customization I simply set all of the fields I did not want her to modify Enabled=False.
No problem there.
But I am unsure as to how to deploy this in a limited manner (by user). I think there is a way to do this per PC by specifying the <CustomizationSettings> in the default.mfgsys on the specific PC (not a perfect solution, I know).
The tools guide showed that I need to do a couple of things, but these are not coming clear to me (page 720).

It wants me to add this:
<CustomizationSettings>
<customization name="PriceUpdOnly" version="version number" (however I have no idea how to locate this. the book illustrates 1.0.3., but I do not see this number anywhere) directoryName="folder name" deploymentType="xcopy"/> (but I can not seem to locate hte directory name they are looking for. They say the subdirectoy under the custom\client directory on the deployment server, but I am just not seeing this.

Can anyone fill in my gaps for these values or suggest how I would deploy this customization to the single user?

Thanks
Carey

To: vantage@yahoogroups.comFrom: mark_wonsil@...: Wed, 31 Dec 2008 13:06:58 -0500Subject: RE: [Vantage] Part Master Access

> However, I have one user who I need to be able to change the sales price.> However, I do not want her to change anything ELSE in the part master> based on how she THINKS it should be set up. However, lessons leared> indicate that instead of asking for everyything else to be left alone, she> just will not tell me what she did, I end up finding out about it later.> > So, I guess I could create a customization that has all of the other items> locked down, but I will need to make sure that she can not access the> original part master program from any other program location.> Does anyone suggest an easier way, or have an opinion on the fastest way> to get through this problem?Bill writes:> > remind her that good jobs are hard to find> ;-)My mind is wandering and thinking that there might be a BPM solution usingthe "User is the Specified Group" but that's just another route towardcustomization and would take a lot of work.Do you have Portal? That seems like a cool way to specify a sharepoint webpage that only she could get and the record set would just be the Part andthe Sales Price keeping her out of Part Maintenance all together.Or do you have Service Connect? You could have her do sales price updates inExcel and submit the file to be updated by SC.Hmmm.Mark W.

_________________________________________________________________
Life on your PC is safer, easier, and more enjoyable with Windows VistaÂ®.
http://clk.atdmt.com/MRT/go/127032870/direct/01/

[Non-text portions of this message have been removed]

system · December 31, 2008, 1:58pm

I have a similar situation with the Part Description, but I just locked that field down and then granted access to only certain individuals, whom I can trust to maintain the standards we've established for part nomenclature. You can exert field-level control by user pretty easily. Well, if you're in Vantage 8, anyway. No customization needed, either. Under System Management>Security Maintenance>Field Security, stipulate the table [Part], and field[s] in question, and away you go. It's a bit tedious to do if you want to exclude all but a small list of fields, but quite possible. I'd suggest you set up a separate Security Group, though, so that if the user should change [unlikely enough since this one's the boss' daughter, but still], you don't have to go through the whole thing again with the next 'challenging' user.

Or, you could create a 'personalized' interface for her that locks out everything else BUT the sales price.

Good luck!

Lynn Thomas
Senior Engineer
SAIC
317-357-4041 X255

[Non-text portions of this message have been removed]

system · December 31, 2008, 2:23pm

Since it is just one person, perhaps best to stick with a variation of your original idea of setting sensitive fields to readonly via ExtendedProperties.

Either use the form load 'WhoAmI' returned value or session 'UserID' returned value as the determinent on whether to mass set a bunch of fields to readonly (or the controls to hidden or change disabled).

Field readonly tends to be safer and less likely to screw up native application processes.

form load 'WhoAmI':

Private Sub SetExtendedProps()
'// ** Get Property
Dim [varName] As String = ILaunch.WhoAmI
Dim edv[table] As EpiDataView = CType(oTrans.EpiDataViews("[tablename]"), EpiDataView)
'do above for all tables you want to lock down fields within

If [varName] <> "bossesDaughter" then

else

'set all your table.fields to readonly
'using .ExtendedProperties

edv[table].dataView.Table.Columns("Field").ExtendedProperties("ReadOnly") = False
'do above for all table.fields you wanto to lock down
end if
end sub

session UserID:

Private SetExtendedProps()
'// ** Get Property
Dim [varName] As String = PartForm.Session.UserID
Dim edv[table] As EpiDataView = CType(oTrans.EpiDataViews("[tablename]"), EpiDataView)
'do above for all tables you want to lock down fields within

If [varName] <> "bossesDaughter" then

else

'set all your table.fields to readonly
'using .ExtendedProperties

edv[table].dataView.Table.Columns("Field").ExtendedProperties("ReadOnly") = False
'do above for all table.fields you wanto to lock down

end if
end sub

insert:

SetExtendedProps()

within the native:

Sub InitializeCustomCode()

SetExtendedProps()

End sub

to get it to fire off on application open.

OR politely tell 'the boss' his daughter is wasting time and money and let HIM deal with her.

Rob

--- On Wed, 12/31/08, Carey S <rotary1@...> wrote:

From: Carey S <rotary1@...>
Subject: RE: [Vantage] Part Master Access
To: vantage@yahoogroups.com
Date: Wednesday, December 31, 2008, 1:43 PM

Neither.
I only have the SC runtime which comes with 803, and I am not using it for anything anyway.
There was an interesting suggestion about field-level security. However, I am unsure about it.
A while ago, I wanted to lock people out of updating certain master files, such as ship-via and terms.
However, what I noticed when I did this is that the restricted users would attempt to do something like a sales order, and they could not select these restricted fields from the drop-downs and it caused all sorts of problems.

So, I went and created a customization that is called PriceUpdOnly. In this customization I simply set all of the fields I did not want her to modify Enabled=False.
No problem there.
But I am unsure as to how to deploy this in a limited manner (by user). I think there is a way to do this per PC by specifying the <CustomizationSetti ngs> in the default.mfgsys on the specific PC (not a perfect solution, I know).
The tools guide showed that I need to do a couple of things, but these are not coming clear to me (page 720).

It wants me to add this:
<CustomizationSetti ngs>
<customization name="PriceUpdOnly" version="version number" (however I have no idea how to locate this. the book illustrates 1.0.3., but I do not see this number anywhere) directoryName= "folder name" deploymentType= "xcopy"/> (but I can not seem to locate hte directory name they are looking for. They say the subdirectoy under the custom\client directory on the deployment server, but I am just not seeing this.

Can anyone fill in my gaps for these values or suggest how I would deploy this customization to the single user?

Thanks
Carey

To: vantage@yahoogroups .comFrom: mark_wonsil@ yahoo.comDate: Wed, 31 Dec 2008 13:06:58 -0500Subject: RE: [Vantage] Part Master Access

> However, I have one user who I need to be able to change the sales price.> However, I do not want her to change anything ELSE in the part master> based on how she THINKS it should be set up. However, lessons leared> indicate that instead of asking for everyything else to be left alone, she> just will not tell me what she did, I end up finding out about it later.> > So, I guess I could create a customization that has all of the other items> locked down, but I will need to make sure that she can not access the> original part master program from any other program location.> Does anyone suggest an easier way, or have an opinion on the fastest way> to get through this problem?Bill writes:> > remind her that good jobs are hard to find> ;-)My mind is wandering and thinking that there might be a BPM solution usingthe "User is the Specified Group" but that's just another route towardcustomization and would take a lot of work.Do you have Portal? That seems like
a cool way to specify a sharepoint webpage that only she could get and the record set would just be the Part andthe Sales Price keeping her out of Part Maintenance all together.Or do you have Service Connect? You could have her do sales price updates inExcel and submit the file to be updated by SC.Hmmm.Mark W.

____________ _________ _________ _________ _________ _________ _
Life on your PC is safer, easier, and more enjoyable with Windows VistaÂ®.
http://clk.atdmt com/MRT/go/ 127032870/ direct/01/

[Non-text portions of this message have been removed]

system · December 31, 2008, 2:28pm

>
> I'd love to. Did I tell you it was the boss's daughter?
>

Whew! I was afraid you were going to say that she was your wife...