Attachment to Customer

Yahoo Archive
1
I love the idea of a BPM that barks. I've been researching a new project to design a monitor that reaches out and slaps the user across the face when they do something dumb.

It's Friday, can you tell?

Lorraine



________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Fri, October 16, 2009 3:28:22 PM
Subject: RE: [Vantage] Attachment to Customer

Â
XFileRef and XFileAttach are the two tables.

XFileRef stores a unique reference for each attachment. XFileAttach stores the relationship between that attachment and a given record.

Note that Vantage doesn't actually store the file, just a pointer to it. So its up to you to establish the mechanics of organizing the attachments, central storage, etc. If your users save an e-mail attachment to their desktop and then attach it to a Customer record (or whatever), that link is just going to be pointing to C:\Documents and Settings\someuser\ Desktop\somedoc. pdf.

I wrote a BPM that barks at the user if they try to create an attachment on the c:\ drive.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Vishal Mehta
Sent: Friday, October 16, 2009 2:58 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Attachment to Customer

In Vantage 8.0 , there is a functionality to attach documents at Customer level... Can anyone help in identifying what table stores the path to these documents --

thanks

vishal




[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







[Non-text portions of this message have been removed]
2
Can someone help me with 4gl example to change year to the last two digits? Ie.. 2009 to 09.

Thanks

Steve
3
Assuming you're not trying to do this in a calculated field on a BAQ...
this should work



Define Variable ddate as Date Format "99/99/99".

ddate = Date(today).



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vantage03
Sent: Friday, October 16, 2009 9:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 4gl date





Can someone help me with 4gl example to change year to the last two
digits? Ie.. 2009 to 09.

Thanks

Steve





[Non-text portions of this message have been removed]
4
Assuming you're not trying to do this in a calculated field on a BAQ...
this should work



Define Variable ddate as Date Format "99/99/99".

ddate = Date(today).





Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vantage03
Sent: Friday, October 16, 2009 9:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 4gl date





Can someone help me with 4gl example to change year to the last two
digits? Ie.. 2009 to 09.

Thanks

Steve





[Non-text portions of this message have been removed]
5
In Vantage 8.0 , there is a functionality to attach documents at Customer level.. Can anyone help in identifying what table stores the path to these documents --



thanks



vishal





[Non-text portions of this message have been removed]
6
XFileRef and XFileAttach are the two tables.

XFileRef stores a unique reference for each attachment. XFileAttach stores the relationship between that attachment and a given record.

Note that Vantage doesn't actually store the file, just a pointer to it. So its up to you to establish the mechanics of organizing the attachments, central storage, etc. If your users save an e-mail attachment to their desktop and then attach it to a Customer record (or whatever), that link is just going to be pointing to C:\Documents and Settings\someuser\Desktop\somedoc.pdf.

I wrote a BPM that barks at the user if they try to create an attachment on the c:\ drive.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vishal Mehta
Sent: Friday, October 16, 2009 2:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Attachment to Customer


In Vantage 8.0 , there is a functionality to attach documents at Customer level.. Can anyone help in identifying what table stores the path to these documents --



thanks



vishal





[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
7
Are you using the Document Management module?



Gerry



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vishal Mehta
Sent: Friday, October 16, 2009 2:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Attachment to Customer






In Vantage 8.0 , there is a functionality to attach documents at Customer
level.. Can anyone help in identifying what table stores the path to these
documents --

thanks

vishal




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





[Non-text portions of this message have been removed]
8
XFileattch and xfileref



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vishal Mehta
Sent: Friday, October 16, 2009 2:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Attachment to Customer






In Vantage 8.0 , there is a functionality to attach documents at Customer
level.. Can anyone help in identifying what table stores the path to these
documents --

thanks

vishal




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





[Non-text portions of this message have been removed]
9
XfileRef has the path (XFileName), but you will also have to reference XFileAttch via the Ref Number and look at the RelatedToFile to determine which table it belongs to. In the case of the Customer table you would look for "Customer" in XFileAttch.RelatedToFile.




________________________________
From: Vishal Mehta <vishy65@...>
To: vantage@yahoogroups.com
Sent: Fri, October 16, 2009 2:57:40 PM
Subject: [Vantage] Attachment to Customer

Â

In Vantage 8.0 , there is a functionality to attach documents at Customer level.. Can anyone help in identifying what table stores the path to these documents --

thanks

vishal




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







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