File-Attachment on Calendar-Entry (over API)

syn-dmaier 2013-08-13 08:48:04 UTC #1

Hi all,

i have a module in eGroupWare 1.8 in which i would like to create Calendar-Entries and some other things. Still here, all works.
My problem - so far - are these tricky file-attachments. I have searched a lot of time for a suitable method to upload some files and link them to a calendar-entry, but i found simply nothing.

I would be very glad if you could help me…

Ralf_Becker_Stylite 2013-08-15 07:32:12 UTC #2

Hi,

Hi all,

i have a module in eGroupWare 1.8 in which i would like to create
Calendar-Entries and some other things. Still here, all works.
My problem - so far - are these tricky file-attachments. I have searched a
lot of time for a suitable method to upload some files and link them to a
calendar-entry, but i found simply nothing.

If you talk about a php module, it’s really easy:

egw_link::link($myapp,$myid,egw_link::VFS_APPNAME,$path,$comment=’’) or
egw_link::attach_file($myapp,$myid,$path,$comment=’’)
or
$f = egw_vfs::fopen("/apps/$myapp/$myid/somefile", “w”); fwrite($f,
$contents); fclose($f);
or
file_put_contents(egw_vfs::PREFIX."/apps/$myapp/$myid/somefile",
$content);

All methods described here are documented via phpDoc in their
source-files, eg. http://svn.stylite.de/egwdoc/

For non php you can simply use WebDAV PUT request to

http(s)://host/egroupware/webdav.php/apps/$myapp/$myid/somefile

Ralf

Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

Get 100% visibility into Java/.NET code with AppDynamics Lite!
It’s a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

syn-dmaier 2013-08-15 07:44:50 UTC #3

Hey Ralf,

thank you very much - this is exactly(!) for what i was looking.

I was talking about a php module, written for egroupware. Concretely it’s a module for providing an self-written soap-service which should provide an interface to our open source erp system AvERP (klick).

I will try your solution immediately and tell you if it all works fine.

syn-dmaier 2013-08-15 08:00:09 UTC #4

I’ve tried it now, but get some Warnings.

My Code now looks like this:

$filename = $myFile[‘name’];
$path = $myFile[‘tmp_name’];
$contents = file_get_contents($path);

$filehandle = egw_vfs::fopen("/apps/calendar/$id/$filename", “w”);
fwrite($filehandle, $contents);
fclose($filehandle);

And i get the following error:

Warning: fopen(links://default/apps/calendar/1/PascalInt.doc): failed to open stream: “links_stream_wrapper::stream_open” call failed in /var/www/phpgwapi/inc/class.vfs_stream_wrapper.inc.php on line 244 Warning: fopen(vfs://default/apps/calendar/1/PascalInt.doc): failed to open stream: “vfs_stream_wrapper::stream_open” call failed in /var/www/phpgwapi/inc/class.egw_vfs.inc.php on line 123 Warning: fwrite() expects parameter 1 to be resource, boolean given in /var/www/averp/soap/inc/soap_calendar.php on line 27 Warning: fclose() expects parameter 1 to be resource, boolean given in /var/www/averp/soap/inc/soap_calendar.php on line 28 int(1)

Then I tried another solution:

$filename = $myFile[‘name’];
$path = $myFile[‘tmp_name’];
$contents = file_get_contents($path);

file_put_contents(egw_vfs::PREFIX."/apps/calendar/$id/$filename",$contents);

But here i get a warning, too:

syn-dmaier 2013-08-22 12:41:50 UTC #5

Is there no one who would / could help me?

Ralf_Becker_Stylite 2013-08-22 12:53:35 UTC #6

Hi Daniel,

I’ve tried it now, but get some Warnings.

My Code now looks like this:

$filename = $myFile[‘name’];
$path = $myFile[‘tmp_name’];
$contents = file_get_contents($path);

$filehandle = egw_vfs::fopen("/apps/calendar/$id/$filename", “w”);
fwrite($filehandle, $contents);
fclose($filehandle);

And i get the following error:

Warning: fopen(links://default/apps/calendar/1/PascalInt.doc): failed to
open stream: “links_stream_wrapper::stream_open” call failed in
/var/www/phpgwapi/inc/class.vfs_stream_wrapper.inc.php on line 244
Warning:fopen(vfs://default/apps/calendar/1/PascalInt.doc): failed to open stream:
“vfs_stream_wrapper::stream_open” call failed in
/var/www/phpgwapi/inc/class.egw_vfs.inc.php on line 123

Does calendar entry with id 1 exists in EGroupware AND do you (the user
logged into egroupware) are at least a participant or has edit grants
from the event owner?

Warning: fwrite() expects parameter 1 to be resource, boolean given in
/var/www/averp/soap/inc/soap_calendar.php on line 27 Warning: fclose()
expects parameter 1 to be resource, boolean given in
/var/www/averp/soap/inc/soap_calendar.php on line 28 int(1)

This are just following errors because fopen returned false.

Then I tried another solution:

$filename = $myFile[‘name’];
$path = $myFile[‘tmp_name’];
$contents = file_get_contents($path);

file_put_contents(egw_vfs::PREFIX."/apps/calendar/$id/$filename",$contents);

But here i get a warning, too:

Warning: fopen(links://default/apps/calendar/1/PascalInt.doc): failed to
open stream: “links_stream_wrapper::stream_open” call failed in
/var/www/phpgwapi/inc/class.vfs_stream_wrapper.inc.php on line 244 Warning:
file_put_contents(vfs://default/apps/calendar/1/PascalInt.doc): failed to
open stream: “vfs_stream_wrapper::stream_open” call failed in
/var/www/averp/soap/inc/soap_calendar.php on line 30 int(1)

Does the same thing and therefore gives a similar result.

It could also be your VFS is not working correctly.

Does uploading files in Filemanager works?

Maybe it’s a permission issue in EGroupware’s files directory.

Ralf

Kind regards

i. A. Daniel Maier
AvERP – Programmer

SYNERPY GmbH
Chr.-Ritter-v.-Langheinrich-Str. 7 Fon: +49(0)921 6080093-0
D-95448 Bayreuth Fax: +49(0)921 6080093-93
www.synerpy.de E-Mail: info@synerpy.de

View this message in context: http://egroupware.219119.n3.nabble.com/File-Attachment-on-Calendar-Entry-over-API-tp3992092p3992142.html
Sent from the egroupware-developers mailing list archive at Nabble.com.

Get 100% visibility into Java/.NET code with AppDynamics Lite!
It’s a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

Introducing Performance Central, a new site from SourceForge and
AppDynamics. Performance Central is your source for news, insights,
analysis and resources for efficient Application Performance Management.
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

syn-dmaier 2013-08-23 07:05:22 UTC #7

Does calendar entry with id 1 exists in EGroupware AND do you (the user
logged into egroupware) are at least a participant or has edit grants
from the event owner?

The Entry does exist, but there is NO user logged in because the function will be called from a SOAP-Client. In my testcase i call it from another PHP-File directly without creating an SOAP-Client.

The Function looks like this:

function files($myFile,$id=0) {
init_config();

$filename = $myFile['name'];
$path = $myFile['tmp_name'];
$contents = file_get_contents($path);

$vfs = new egw_vfs();
$vfs->

$filehandle = egw_vfs::fopen("/apps/calendar/$id/$myFile", "w");
fwrite($filehandle, $contents);
fclose($filehandle);

file_put_contents(egw_vfs::PREFIX."/apps/calendar/$id/$filename",$contents); 

return $id;

}

And i call it like this:

echo “”;
echo " ";
echo " ";
echo “”;

if(isset($_POST['submit']) && is_array($_FILES['form_file'])) {
    $file = $_FILES['form_file'];   
    var_dump(files($file,1));
}

How could i say to class egw_vfs that I am an administrator and have full permissions?

For example in class categories i could something like this…

Ralf_Becker_Stylite 2013-08-23 11:47:00 UTC #8

Hi,

Does calendar entry with id 1 exists in EGroupware AND do you (the user
logged into egroupware) are at least a participant or has edit grants
from the event owner?

The Entry does exist, but there is NO user logged in because the function
will be called from a SOAP-Client. In my testcase i call it from another
PHP-File directly without creating an SOAP-Client.

Without setting a user context, you will simply lack rights to attach
files and therefore it fails as you expericed it.

Does the soap client act for an EGroupware user, in that case that user
should be set. If it acts on it’s own you can either set a user with
enough rights or set

egw_vfs::$is_root = true;

That will give the soap client unlimited rights to add or delete
everything, incl. the whole vfs tree!

Ralf

The Function looks like this:
*
function files($myFile,$id=0) {
init_config();
 $filename = $myFile['name'];
 $path = $myFile['tmp_name'];
 $contents = file_get_contents($path);

 $vfs = new egw_vfs();
 $vfs->

 $filehandle = egw_vfs::fopen("/apps/calendar/$id/$myFile", "w");
 fwrite($filehandle, $contents);
 fclose($filehandle);
file_put_contents(egw_vfs::PREFIX."/apps/calendar/$id/$filename",$contents);
 return $id;
}

And i call it like this:

echo “”;
echo " ";
echo " ";
echo “”;
 if(isset($_POST['submit']) && is_array($_FILES['form_file'])) {
     $file = $_FILES['form_file'];
     var_dump(files($file,1));
 }
How could i say to class egw_vfs that I am an administrator and have full
permissions?

For example in class categories i could something like this…

Kind regards

i. A. Daniel Maier
AvERP – Programmer

SYNERPY GmbH
Chr.-Ritter-v.-Langheinrich-Str. 7 Fon: +49(0)921 6080093-0
D-95448 Bayreuth Fax: +49(0)921 6080093-93
www.synerpy.de E-Mail: info@synerpy.de

View this message in context: http://egroupware.219119.n3.nabble.com/File-Attachment-on-Calendar-Entry-over-API-tp3992092p3992330.html
Sent from the egroupware-developers mailing list archive at Nabble.com.

Introducing Performance Central, a new site from SourceForge and
AppDynamics. Performance Central is your source for news, insights,
analysis and resources for efficient Application Performance Management.
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

syn-dmaier 2013-08-23 11:59:50 UTC #9

Hey Ralf,

thank you for this quick reply. It works now with calendar id 1 - but NOT with id 5 for example (which exists too).

Both of them are not “deleted” or “private” (these were cases in which i could apply to an error)…

The Solution i took is to set root-access with “egw_vfs::$is_root = true;”