Attachments Blank Title 72651

Yahoo Archive
1
Check out XFileRef and XFileAttch



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

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Cfab It
Sent: Monday, October 05, 2009 10:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Attachments

What table holds attachment info? My users would like to have a BAQ show if there is any attachments on a given part......
Â
Thanks in advance for any info,
Lana
Â




[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
2
(8.03.403 - Progress) Does adding attachments create any performance issues with the database? Our salespeople are going to begin attaching correspondence, including drawings, to sales orders. I am also considering attaching vendor invoice copies to our AP invoice entries. However, I do not want to slow down the database or have it become so large it eats up disk space or becomes unmanageable.


Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>



[Non-text portions of this message have been removed]
3
Not at all. They're simply stored as links to the file itself, so it's
not much overhead.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Rose
Sent: Wednesday, January 07, 2009 1:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Attachments

(8.03.403 - Progress) Does adding attachments create any performance
issues with the database? Our salespeople are going to begin attaching
correspondence, including drawings, to sales orders. I am also
considering attaching vendor invoice copies to our AP invoice entries.
However, I do not want to slow down the database or have it become so
large it eats up disk space or becomes unmanageable.


Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>



[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
4
Hi Thom,

> (8.03.403 - Progress) Does adding attachments create any performance
> issues with the database? Our salespeople are going to begin attaching
> correspondence, including drawings, to sales orders. I am also considering
> attaching vendor invoice copies to our AP invoice entries. However, I do
> not want to slow down the database or have it become so large it eats up
> disk space or becomes unmanageable.

Like Vic said, these are just tables that link to the actual file location.
So the files are not in your database.

Having said that, I would REALLY make sure that all attachments are placed
in the same place on a server share (or in Sharepoint for Epicor 9). If
users attach a file from their C: drive, nobody is going to be able to see
it but that user.

Epicor 9's Company Configuration has a field for a Base URL for attachments
but I haven't figured out how it works.

Mark W.
5
A good BPM around this might be to check and see if the proposed
filename begins with C:\ and bail if it does. I was able to make a
Method Directive that check for "the XFileRef.XFileName field of the
changed row begins with the "C:\" value" on XFileRef.Update(), but
attachments don't see to invoke a common method. So you'd have to do
this checking on Part.Update, Customer.Update, etc.



That kind of sucks...



-bws



--

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, January 07, 2009 2:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Attachments



Hi Thom,

> (8.03.403 - Progress) Does adding attachments create any performance
> issues with the database? Our salespeople are going to begin attaching
> correspondence, including drawings, to sales orders. I am also
considering
> attaching vendor invoice copies to our AP invoice entries. However, I
do
> not want to slow down the database or have it become so large it eats
up
> disk space or becomes unmanageable.

Like Vic said, these are just tables that link to the actual file
location.
So the files are not in your database.

Having said that, I would REALLY make sure that all attachments are
placed
in the same place on a server share (or in Sharepoint for Epicor 9). If
users attach a file from their C: drive, nobody is going to be able to
see
it but that user.

Epicor 9's Company Configuration has a field for a Base URL for
attachments
but I haven't figured out how it works.



.


<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007181/msg
Id=72654/stime=1231355455/nc1=3848641/nc2=3848583/nc3=5522129>




[Non-text portions of this message have been removed]
6
Thanks, Mark and Vic! Exactly the info I needed.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Wednesday, January 07, 2009 11:11 AM
To: vantage@yahoogroups.com
Subject: {Disarmed} RE: [Vantage] Attachments


Hi Thom,

> (8.03.403 - Progress) Does adding attachments create any performance
> issues with the database? Our salespeople are going to begin attaching
> correspondence, including drawings, to sales orders. I am also considering
> attaching vendor invoice copies to our AP invoice entries. However, I do
> not want to slow down the database or have it become so large it eats up
> disk space or becomes unmanageable.

Like Vic said, these are just tables that link to the actual file location.
So the files are not in your database.

Having said that, I would REALLY make sure that all attachments are placed
in the same place on a server share (or in Sharepoint for Epicor 9). If
users attach a file from their C: drive, nobody is going to be able to see
it but that user.

Epicor 9's Company Configuration has a field for a Base URL for attachments
but I haven't figured out how it works.

Mark W.



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

We have been attaching .pdf and .tiff images to the invoice records for over one year (20,000++), with no speed issues. We began attaching .pdf and .tiff images to the receipt records (images of the packing slips) a few months ago. Trying to go as paperless as possible. We will be adding everything from images of supplier quotes, to quality documents etc. in the future.

Sometime real soon we'll be shutting down the copier :)

Agree with Vic...... setting up a documented folder locations that NEVER change is a must. we spent many hours deciding on that, creating detailed work instructions, communicating and training. So far no issues.

Our longer term plan is to incorporate the ADM+ (Advanced Document Management Plus) software from Altec, at that point we will no longer use the vantage screen attachment function. The docs will be indexed like a database for retrieval from many different angles. We purchase the ADM+ some time ago but have not implemented it yet........but that's another story...

Matt S.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Thomas Rose
Sent: Wednesday, January 07, 2009 2:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Attachments


Thanks, Mark and Vic! Exactly the info I needed.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Mark Wonsil
Sent: Wednesday, January 07, 2009 11:11 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: {Disarmed} RE: [Vantage] Attachments

Hi Thom,

> (8.03.403 - Progress) Does adding attachments create any performance
> issues with the database? Our salespeople are going to begin attaching
> correspondence, including drawings, to sales orders. I am also considering
> attaching vendor invoice copies to our AP invoice entries. However, I do
> not want to slow down the database or have it become so large it eats up
> disk space or becomes unmanageable.

Like Vic said, these are just tables that link to the actual file location.
So the files are not in your database.

Having said that, I would REALLY make sure that all attachments are placed
in the same place on a server share (or in Sharepoint for Epicor 9). If
users attach a file from their C: drive, nobody is going to be able to see
it but that user.

Epicor 9's Company Configuration has a field for a Base URL for attachments
but I haven't figured out how it works.

Mark W.

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





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

I am looking for a way to find where attachments have been established.

Any ideas?

Jeff
9
Hi Jeff,

>
> Vantage 8.03.406
>
> I am looking for a way to find where attachments have been established.
>

System Management | Document Management | External File Reference

Mark W.
10
Mark,

Thanks much for the help.

Jeff

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> Hi Jeff,
>
> >
> > Vantage 8.03.406
> >
> > I am looking for a way to find where attachments have been
established.
> >
>
> System Management | Document Management | External File Reference
>
> Mark W.
>
11
One thing I have seen with attachments is that if you make the
attachment at the Order level, it does not seem to place the attachment
onto the Job. Is this intentional, and is there a way to have the
system copy attachments from the Order to the Job automatically?



Paul Millsaps
Time Manufacturing
254.399.2170
paulm@... <mailto:paulm@...>

This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and
notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Wednesday, January 07, 2009 1:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Attachments



Hi Thom,

> (8.03.403 - Progress) Does adding attachments create any performance
> issues with the database? Our salespeople are going to begin attaching
> correspondence, including drawings, to sales orders. I am also
considering
> attaching vendor invoice copies to our AP invoice entries. However, I
do
> not want to slow down the database or have it become so large it eats
up
> disk space or becomes unmanageable.

Like Vic said, these are just tables that link to the actual file
location.
So the files are not in your database.

Having said that, I would REALLY make sure that all attachments are
placed
in the same place on a server share (or in Sharepoint for Epicor 9). If
users attach a file from their C: drive, nobody is going to be able to
see
it but that user.

Epicor 9's Company Configuration has a field for a Base URL for
attachments
but I haven't figured out how it works.

Mark W.






[Non-text portions of this message have been removed]
12
I would imagine this is intentional. There¹s no obvious direct
relationship between what I might attach to an order on the Sales side and
the fact that I might also be intending to send that attached document onto
the Job for Production. The attachment feature is fairly generic ‹ you can
create an attachment to many different entities in the system (Orders, Jobs,
Customers, Suppliers, Parts, etc. etc.)

-bws

On 1/20/09 6:05 PM, "Paul E. Millsaps" <paulm@...> wrote:

>
>
>
> One thing I have seen with attachments is that if you make the
> attachment at the Order level, it does not seem to place the attachment
> onto the Job. Is this intentional, and is there a way to have the
> system copy attachments from the Order to the Job automatically?
>
> Paul Millsaps
> Time Manufacturing
> 254.399.2170
> paulm@... <mailto:paulm%40timemfg.com> <mailto:paulm@...
> <mailto:paulm%40timemfg.com> >
>
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any mistransmission.
> If you receive this message in error, please immediately delete it and
> all copies of it from your system, destroy any hard copies of it and
> notify the sender. You must not, directly or indirectly, use, disclose,
> distribute, print, or copy any part of this message if you are not the
> intended recipient.
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
> Of Mark Wonsil
> Sent: Wednesday, January 07, 2009 1:11 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Attachments
>
> Hi Thom,
>
>> > (8.03.403 - Progress) Does adding attachments create any performance
>> > issues with the database? Our salespeople are going to begin attaching
>> > correspondence, including drawings, to sales orders. I am also
> considering
>> > attaching vendor invoice copies to our AP invoice entries. However, I
> do
>> > not want to slow down the database or have it become so large it eats
> up
>> > disk space or becomes unmanageable.
>
> Like Vic said, these are just tables that link to the actual file
> location.
> So the files are not in your database.
>
> Having said that, I would REALLY make sure that all attachments are
> placed
> in the same place on a server share (or in Sharepoint for Epicor 9). If
> users attach a file from their C: drive, nobody is going to be able to
> see
> it but that user.
>
> Epicor 9's Company Configuration has a field for a Base URL for
> attachments
> but I haven't figured out how it works.
>
> Mark W.
>
> [Non-text portions of this message have been removed]
>
>
>



[Non-text portions of this message have been removed]
13
We are experiencing the same problem. Attachments are supposed to carry over to jobs if they are attached to the Sales Order Line (not the Sales Order itself), but ours stopped carrying over since GoLive. Not sure if this is related to an update or a configuration setting. They are only supposed to carry over if the attachment is to the line.
14
What table holds attachment info? My users would like to have a BAQ show if there is any attachments on a given part......
Â
Thanks in advance for any info,
Lana
Â




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