Manually files Upload on DB

Fabrizio09

Good evening.
I'm trying to create a custom script with osTicket 1.17.2, to manually insert files on the Database (like attachments).

This is the script:
`
require_once('main.inc.php');
require_once(INCLUDE_DIR.'class.http.php');
require_once(INCLUDE_DIR.'class.api.php');

$data = array(
"attachments" => array(
array(
"name" => "myimage.jpg",
"encoding" => "base64",
"type" => "image/jpeg",
"size" => 32768,
"data" => "myBase64hash"
)
)
);

$a = new TicketApiController();
$a->validate2($data);
`
The "validate2" method is the same of "validate", without structure validation control.
The script seems to work, it's create the raw into "file" table but on the "file_chunk" upload only a partial data.
Is there a way to complete/create a script for manually insert file?

Thanks, best regards.
Fabrizio

KevinTheJedi

Fabrizio09

Yes, we already have a CLI utility for this. Run the following within the osTicket directory on the server more information:

/path/to/php manage.php file --help
/path/to/php manage.php file import --help

Note:
/path/to/php is just a placeholder. You will need to replace this with the PHP executable. For most linux systems PHP is added to the system path variable on install so most often you can just run php (assuming this points to the appropriate PHP version if multiple versions are installed).

Cheers.

Fabrizio09

KevinTheJedi

Good evening.
I've done some test with some file on my fs, with the command:

php manage.php file import -f myimg.jpg

The output return "Bad file record".
The file that I'm trying to save it's new for the system.
If I export an existent file from system, after I re-import it with cli it works.
In this case, I would to save new files into the system.
There are some commands to import new files?

Thanks, best regards.
Fabrizio

KevinTheJedi

Fabrizio09

You would need to match the structure of the exported ones. It states this in the command's help information:

Load files exported via `export`

Also it explains further in the method's definition:

* Import a collection of file contents exported by the export.
* See the export function above for details about the stream
* format.

Cheers.

Fabrizio09

KevinTheJedi

Thanks.
I finally complete my script for manually upload new files to system, with the native functions.

Best regards.
Fabrizio

ntozier

You might want to post it here in case someone else needs something like this.

Fabrizio09

Good evening,
basically this example script it's what I needed.
It works with latest v1.17.2 and don't require any particular customization of source.
This example, in this case doesn't require auth like the APIs.

<?php
//requires some scripts / classes needed
require_once('main.inc.php');
require_once(INCLUDE_DIR.'class.http.php');
require_once(INCLUDE_DIR.'class.api.php');


//declare an array with file data info and content
$data = array(
	"name" => "myfile.mp4",
	"encoding" => "base64",
	"signature" => "mySingKey",
	"type" => "video/mp4",
	"size" => 8048725,
	"data" => "myBase64data"
);

//create and instance of FileUploadField class
$f = new FileUploadField();

//upload file to DB
$f->uploadAttachment($data);

Best regards.
Fabrizio