My client has GoldMine 8.5, running on a MSSQL dataset, on a Windows 2003 server with Windows XP and Windows 7 workstations. They
need a file handling utility created.
Application will be passed two parameters: 1 - a unique <accountno> and 2 - a unique <recid> which identifies the record to be operated on.
The app will query a MSSQL 2005 SQL database and fetch the details of the subject record.
The App will allow the user to relocated the attached document (attached in the mailbox record refc822 field). Once the user provides the new path, relocate the physical file and update the file pointers in Mailbox.Rfc822 and ContSupp.<linkeddocumentRecord>
We can provide significant SQL Script samples to do the record updates.
The application shall be used on the internal network only, no webservices required.
The application will query the user for:
A - the new path (show the existing one), Use new or existing
A.1 - If a new folder needs to be created, do so.
B - the new filename (show the current one) , Use new or existing
C - present a chooser to allow the connection to be made from the record where the launch began (as determined by using the accountno that was passed in on launch)
C.1 - Show Company/Contact information where the document will be linked
C.2 - Allow a change by lookup into Contact1 where a Company or Contact value is submitted.
In your response the first line MUST include your estimate and the word Mailbox to be considered. All others will be immediately removed.