Using "Pure" Remedy code you could have a field in the import be the full picture file name. You could then use the PERFORM-ACTION-ADD-ATTACHMENT <field_ID> [<file_name>] command to save the picture to an attachment. Personally we have a form with a single attachment on it. We show a table on the ticket that shows the records in the attachment form that relate to the existing ticket record. When a user clicks on a row in the table a custom AL display's the attachment using the PERFORM-ACTION-OPEN-ATTACHMENT <field_ID> command. Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Wednesday, February 20, 2008 3:32 PM To: [email protected] Subject: Importing picture files; creating new records ** Hi Everyone, Quick question and I do apologize for only doing light research on this. Is there a method I can import picture files (jpg) which will be stored in an attachment field on a new record that will be created? I know I can export attachments in .arx file and import those. But these would be just pictures in a folder. This record will be a child record to our Site form and a table field will display the entries. I've never tried to display an attachment filed in a table field so I'm not sure I can do that, but that would be the objective. That way they could just double click on the file and open it. We have to take various pictures related to customer installations and they are looking for a better way to store this info than the server/folder structure they are currently using. I'm thinking one attachment field per record so we can categorize those records for easy searching beyond looking at the individual Site records. Thanks for your suggestions and help. Susan Susan Palmer ShopperTrak ARS v7.0.1P3 - server, users, admin Oracle 10g Windows 2003 server __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"
