Multiple file Attachment option with SC

Applications Control
#1

Subject: Reg. Files and Image attachement
Date: 2009-10-28 Time: 09:40:03
Hi,

I have a requirement where users should attach n numbers of files in the Application.

That is there will be new and delete option availble in the screen which should have Size limitation and etc. Like in this form you have attach link with multiple attachment…!
Is it possible

Pls advise

Thanks & Regards
Dhana

Subject: RE: Reg. Files and Image attachement
Date: 2009-10-30 Time: 00:39:54
Hi Mr. Dhanaraj,

You want do a application with multiples fields to attach archives?
In this version don’t have this resource, but you can do with code javascript and PHP.

Regards,

Vin?cius Muniz
Netmake Solu??es em Inform?tica

Subject: RE: Reg. Files and Image attachement
Date: 2009-11-04 Time: 01:18:29
Hi Vinicius,

THanks … Let me try this and get back to you

Regards
Dhana

Subject: RE: Reg. Files and Image attachement
Date: 2009-11-04 Time: 01:19:04

Subject: RE: Reg. Files and Image attachement
Date: 2009-11-04 Time: 01:19:16

Subject: RE: Reg. Files and Image attachement
Date: 2009-11-04 Time: 01:19:30
Hi Vinicius,

THanks … Let me try this and get back to you

Regards
Dhana

Subject: RE: Reg. Files and Image attachement
Date: 2009-12-02 Time: 18:02:29
HI Vinicius,
Can I get some examples of Document(FileName) data type…?

Regards
Dhana

Subject: RE: Reg. Files and Image attachement
Date: 2009-12-03 Time: 10:26:12
Hi Mr. Dhana,

Don’t have this example. But to use, you can select this type, and in DB the field is varchar. the archive is upload to path of applications, and the name is stored in DB.

Regards,

Vin?cius Muniz
Netmake Solu??es em Inform?tica

Subject: RE: Reg. Files and Image attachement
Date: 2009-12-04 Time: 01:30:34
Hi Vinicius,
Thanks…! I have a field as varchar in DB and Files is uploaded in the destination propoerly. Still I had the following issues

  1. In Editable Grid Form, the file is attached and Link is not shown, But in Edit mode it is visible

  2. On Images datatype. when i changed to desired path it says the permission denied. I have cheked the permission by changing the same folder to

  3. At the time upload there is noway to change the Filename to Unique name, It also lead into Overwrite the exiting files wiht the same name…

  4. To eliminate this I had also tried to create Unique folder with Autogenerated Field from the SQL database. It returns 0
    because the Upload happens before inserting physical record…

  5. If we dump everything in one folder how to create integrety and maintain for backup and etc.,

Please advise

Thanks & Regards
Dhana

Subject: RE: Reg. Files and Image attachement
Date: 2009-12-04 Time: 13:30:33
Hi Vinicius,

Solved the problem my self.

Thanks & Regards
Dhana

#2

Re: Multiple file Attachment option with SC

I have achived it by the following method…

  1. Have a common table with field Key, Tablename, FileName, we may call it “SC_Attachments”

  2. Define the Field as File(Database)

  3. Create a New application GridEditable Form with the table SC_Attachemnts

  4. when ever the you are trying to attach multiple files to your application, it belogs to a table and auto geneated number

  5. Create Link From the source Application (Where you want to give mutlilple attachments) give Link as the Auto generated no from source table is Key and table as [table name ] to Grid editable form application

  6. The values of SC_attachment is as below. which says 1. table name, 2. Auto gen no of Tablename and 3 . Filename.

    WF_Instance_Master 128 scriptcase_dateissue.pdf 47
    WF_Instance_Details 10 Dino.xls 46
    WF_Instance_Master 128 lineinteractive-extbatups-2.pdf 48
    WF_Instance_Details 15 09tr001.pdf 58
    WF_Instance_Details 23 1.sql 61
    WF_Instance_Details 12 1.csv 56
    WF_Instance_Master 127 download-mini.gif 45
    WF_Instance_Details 15 ~Deactive_Caution_Report.txt 57
    WF_Instance_Details 23 ~Deactive_Caution_Report.txt 62

  7. Here the Grid is part of your parent application…!

Note : The parent autogenerated no is only generated after insertion of new record. So you have to insert record first and go for edit record mode
refer : sc_apl_conf()

Regards
Dhana