Working code: KT REST API Integration and CCK integration

Sounds great to me. In fact I started working on something similar a while ago but never got the time to get a development release ready. Rather than creating a fork I would favour you becoming a co-maintainer and this functionality either being coded into the existing module or going into it's own module as part of the KT integration suite. I'm more than happy to have a look at your code too.

It's great to see people interested in this module!

Alex

Hi,

Just having a look at this - I want to add all the work together in a sensible way. So I propose:

The kt_REST.module becomes kt_api.module and provides exactly the same functionality that you've coded.
The original iframe providing module stays as kt.module (so upgrade is easy) but depends on the new kt_api.module so that the root path only has to be configured in one place.

I've attached the proposed changes - if you agree I'll commit the lot to the latest dev version.

I think one limitation of the current cck implementation might be that when you download a document using it knowledge tree will log the download as being by the user configured on the api settings page rather than the drupal user.

I really like the cck field... excellent idea.

Cheers,

Alex

Greetings..

Wow, i think your working module meet the urgent requirements in my development site. But you see instead a developer, i am just a designer (using worked drupal module). Can you give me some explanation how to use your module in my site? because usually drupal module is ini tar/gz files and i just dropped in sites/all/modules. Or maybe you can give me some explanation how to implement this code in my site. I understand PHP and SQL a little.

Will very appreciate your time even a little. :) Thanks.

Regards,

adi

#8 this is experimental code - that will go into the development release very soon...

It is a diff which will create the new modules when applied against the kt directory. Read http://drupal.org/patch/apply to find out how to apply.

Hi guys, thanks very much for your time explaining to me.

I have tried one of your module in #5 (http://drupal.org/files/issues/kt_new_cck_and_rest.tar_.gz) and i have test the kt_rest by going to this link (http://localhost/drupal/?q=admin/settings/kt/REST_test), which written:

"If this test is successful you should see an array with document details matching the document with ID#1 in KnowledgeTree: "

but in my site it wasnt succesful, above it's written:

"warning: strtr() [function.strtr]: The second argument is not an array in C: \ms4w\Apache\htdocs\drupal\modules\syslog\syslog.module on line 106."

i've used kt about two weeks and many activities for trying KnowledgeTree since that time. The document with id#1 it's not exist anymore because i've deleted it.

What could be problem of my site? Should i reinstall fresh KT to make your kt_rest module works?

i'm sorry since i think i'm the most stupid person in this issues. :(

Just committed the changes. Should be in dev sometime soon.

Changes to aantonop's code and the original module are:

• I've changed the name of the kt.module on the module screen to reflect it's purpose.
• I've put all the kt admin options together
• The iframe module depends on the api and uses the root url configured on that screen
• Created some new, more explanatory, permissions
• Done an extensive code clean-up user the coder module
• Changed the test page back to listing the document array as the download function wasn't working for me
• Unfortuantely messed up the commit so all the modules are in the same directory - still works so no loss

Certainly not against aantonop becoming a co-maintainer for the module.

@aantonop

haha,, thanks for helping..

Aye sir, wont give up..:))

I would like to be a tester for this module if it helps you developing since i need the function too :).

Okay, first job, i've debugging the site (though i'm not sure i'm doing debug correctly). I've installed devel and firebugfordrupal module and whenever loading a page, there is Node Access Summary below, i cant copy paste on text so i took snapshot on them for you. The summary when i open page http://localhost/drupal/?q=admin/settings/kt_REST/test is this http://i94.photobucket.com/albums/l87/adideswar/debug.jpg
Tell me if it is the right report you want or not, and if it is not tell me how i can get the right one for you.

As for kt_rest test, eventually its my dumb mistake, i dont add slash in the last for the root of kt, so now the root is http://localhost/dms/. When i run the test again, the report shows the is worked. (All the reports above is yellow in color) And the array below is shown to like this:

Array
(
[document_id] => 1
[custom_document_no] => n/a
[oem_document_no] => n/a
[title] => AdvancedCreateShapefile_id
[document_type] => IT Solution - Midleware - Datawarehouse
[filename] => AdvancedCreateShapefile_id.swf
[filesize] => 1043722
[folder_id] => 0
[created_by] => admin
[created_date] => 2009-07-15 17:23:46
[checked_out_by] => n/a
[checked_out_date] => n/a
[modified_by] => admin
[modified_date] => 2009-07-15 17:23:46
[owned_by] => admin
[version] => 0.1
[content_id] => 1
[is_immutable] =>
[permissions] => RW
[workflow] => n/a
[workflow_state] => n/a
[full_path] => /AdvancedCreateShapefile_id
[mime_type] => application/x-shockwave-flash
[mime_icon_path] => unspecified_type
[mime_display] => SWF File
[storage_path] => 00/1
[metadata] =>
[links] =>
[transitions] =>
[version_history] =>
[transaction_history] =>
)

Second, I've tried adding field as you told. But after i save it, error is shown like this:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "(" LINE 1: ...ontent_type_testkt ADD COLUMN field_ktdocfield_value int(11) ^ in C:\ms4w\Apache\htdocs\drupal\includes\database.pgsql.inc on line 139.
* user warning: query: update_sql ALTER TABLE content_type_testkt ADD COLUMN field_ktdocfield_value int(11) in C:\ms4w\Apache\htdocs\drupal\includes\database.pgsql.inc on line 689.

I cant save the field after this, because when i clicked the save field button, the error came like this:

Warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in C:\ms4w\Apache\htdocs\drupal\includes\database.pgsql.inc on line 139

Warning: ERROR: value too long for type character varying(128) query: dblog_watchdog INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:"%error";s:7:"warning";s:8:"%message";s:264:"pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "(" LINE 1: ...ontent_type_testkt ADD COLUMN field_ktdocfield_value int(11) ^";s:5:"%file";s:56:"C:\\ms4w\\Apache\\htdocs\\drupal\\includes\\database.pgsql.inc";s:5:"%line";i:139;}', 3, '', 'http://localhost/drupal/?q=admin/content/node-type/testkt/fields/field_k...', 'http://localhost/drupal/?q=ad in C:\ms4w\Apache\htdocs\drupal\includes\database.pgsql.inc on line 160

Regardless from error before, i also tried to create content with this field but, when i wanna fill the field with a letter, instead showing document name contain the letter, it shows popup windows like this:

An error occurred.
http://localhost/drupal/?q=kt_docreference/autocomplete/field_ktdocfield
[ ]<script type="text/javascript">jQuery.extend(Drupal.settings, { "thmr_2": { "name": "theme_syslog_format", "type": "func", "duration": 0.14, "used": "theme_syslog_format", "candidates": [ "black_mamba_syslog_format", "phptemplate_syslog_format", "theme_syslog_format" ], "preprocessors": [ ] }, "thmr_1": { "name": "theme_syslog_format", "type": "func", "duration": 3.96, "used": "theme_syslog_format", "candidates": [ "black_mamba_syslog_format", "phptemplate_syslog_format", "theme_syslog_format" ], "preprocessors": [ ] }, "request_id": "11714a852e509c098", "devel_themer_uri": "/drupal/?q=devel_themer/variables/11714a852e509c098" });</script>

Is there any possibilities that the problem is from database? Because i used postgresql for drupal and mysql for kt. Should i use one database for both of kt and drupal?If that so, i will change drupal to mysql too...

Thanks in advance.

@adideswar

This would appear to be happening because the module doesn't work with postgres... are you using that?

Plus are you using the latest dev version?

Updating issues version...

@adideswar

Try changing the in kt_docreference.module from this

function kt_docreference_field_settings($op, $field) {
  switch ($op) {

    case 'database columns':
      $columns = array(
        'value' => array('type' => 'int', 'length' => 11, 'sortable' => FALSE),
      );
      return $columns;
  }
}

to this

function kt_docreference_field_settings($op, $field) {
  switch ($op) {

    case 'database columns':
      $columns = array(
        'value' => array('type' => 'bigint', 'not null' => FALSE, 'sortable' => FALSE),
      );
      return $columns;
  }
}

And let us know if that works...

Oops.... actually change it to this

function kt_docreference_field_settings($op, $field) {
  switch ($op) {

    case 'database columns':
      $columns = array(
        'value' => array('type' => 'int', 'size'=>'big', 'not null' => FALSE, 'sortable' => FALSE),
      );
      return $columns;
  }
}

@adideswar

Once you've changed the code remove the field from your content type and add it back again

I've committed the postgres fix to the development release

Sorry for the late reply, just celebrate independence day of my country few days back.

@ alexpott

Yes sir, i used PostgreSQL for Drupal and Mysql for KT. I've just know that the dev version has been released.

Referring to Mr. aantonop's kt_rest module in #4 (which i used until now), fix from Mr. alexpott in #18 was correct. I can put reference field to the kt document now even not changing my database (Postgre for Drupal, and MySQL for KT).

And now, the new problem is the document link. It always refers to "http://localhost/kt/view.php?fDocumentId=[the document id]". The problem is this string: "localhost/kt/". So if the root URL not 'localhost/kt' i can't directly refer to my KT installation. I've changed the Knowledgetree root URL in kt_rest settings to "http://172.27.4.105/dms/" (this is my KT root URL, the IP address sometimes change too) but it doesn't fix this.

@ aantonop

The "debug" already activated, and all messages were in yellow (i assumed that means all worked well ;), CMIIW).

Without change my database, the autocomplete have been run and it worked well (i think :p). I mean when i put letter 'c' in the end of the url like this: "http://172.27.4.105/drupal/?q=kt_docreference/autocomplete/field_ktdocfi...", all document with letter 'c' comes out in the bracket like this:

{ "common [DocumentID:19]": "\x3cdiv class=\"reference-autocomplete\"\x3ecommon\x3c/div\x3e", "nssckbi [DocumentID:18]": "\x3cdiv class=\"reference-autocomplete\"\x3enssckbi\x3c/div\x3e", "PROPOSAL-MaintenanceADD ver2b [DocumentID:9]": "\x3cdiv class=\"reference-autocomplete\"\x3ePROPOSAL-MaintenanceADD ver2b\x3c/div\x3e" }

Dont mention it, it's me who thanks to you all for developing it :)

@ all

since the dev release have come, i will change the testing subject from aantonop's "kt_REST" to "6.x-2.x-dev". is that okay?

Thanks again in advance...

Excuse me, before changing subject I've check some file in 'kt_REST' folder:

1. Because, the document link didn't refer to my KT installation i looked at the " kt_REST.module " file and found the " $form['kt_root_url'] ". I think the form is not global so i make it global so the document link cant refer to the kt root url.

kt_REST.module
===========

function kt_REST_settings() {

  $form = array();

  $form['kt_root_url'] = array (
      '#type' => 'textfield',
      '#title' => t('Knowledgetree root URL'),
      '#default_value' => variable_get('kt_root_url', 'http://localhost/dms/'),
      '#description' => t("The root URL of your Knowledgtree Installation, including a trailing slash. eg. http://localhost/kt/" ),
    );
  
  /**
   * testing globals
   */
  $GLOBALS['form']=$form['kt_root_url']['#default_value'];

I put the form variables in " function _kt_docreference_details_link " in " kt_docreference_module " file But, i doesn't make a change. Maybe you guys know what's wrong.

2. To get rid of it, i manually created variable to refer to kt root url like this

kt_docreference_module
================

 /*
  * initiate base url for KT
  */

   $base_url_kt = $GLOBALS['base_url'].'/..'. '/dms/';

function _kt_docreference_details_link($title, $document_id) {
   return l($title, $base_url_kt.'view.php?fDocumentId='. $document_id );
}

function _kt_docreference_download_link($title, $document_id) {
   return l($title, $base_url_kt.'action.php?kt_path_info=ktcore.actions.document.view&fDocumentId='. $document_id);
}

Hahaha, i know this not the correct way to fix, but temporary fulfil the requirement now.

3. A question from me, field knowledgetree doc reference only provide link for view document, is there any field to provide link for directly download the document?

@adideswar

My fault - I committed an old version of the docreference module. Just committed a new version to fix this. I've also reorganised the module's directory structure so when you install the latest dev remove your current kt folder beforehand. If you don't you'll have multiple versions of the api and docreference hanging around... which would be confusing! After updating you will have to clear Drupal's cache...

In order to get to download the doc you can change the field formatter to present a download link.

Thanks alex,

You said:
"In order to get to download the doc you can change the field formatter to present a download link."

can you tell me step-by-step how to do this? As i know, first I added New field with type Knowledgetree doc reference, then I filled the field with a name of document which (represent the real document with same name), after that the field will ONLY provide A LINK which is view document link. How can i change the link to become download link?

Why it seems only function _kt_docreference_details_link in kt_docreference.module which is implemented in the node?

Can i show some link like, FOR EXAMPLE, if i put a document at the field, after i save the page, the field will show:

* document name (label/no link),
* link for view, and
* link for download?

How can i do that? it seems that in the kt_docreference.module all those function is implemented. How can i used them in the node?

Thanks again.. I'm in your debt..;)

As long as you have the latest version of 6.x-2.x-dev you will be able to change how the docreference field in displayed by changing the setting on the "display fields" tab when you are editing a content type (for example admin/content/node-type/page/display)

thanks, after go to tab "display fields" i must wait for a minute before the configuration shows up (that's why i missed it) :)

Okay, i used the dev version few days back and it works fine (kt rest test and doc reference field works as usual), but today when i go to tab 'kt rest test' it shows up error message like this.

    * warning: strtr() [function.strtr]: The second argument is not an array in C:\ms4w\Apache\htdocs\drupal\modules\syslog\syslog.module on line 106.
    * HTTP Error 0 - on REST Call with URL http://172.27.4.105/dms/ktwebservice/KTWebService.php?method=login&username=admin&password=admin

    * warning: strtr() [function.strtr]: The second argument is not an array in C:\ms4w\Apache\htdocs\drupal\modules\syslog\syslog.module on line 106.
    * Login Failed

    * warning: strtr() [function.strtr]: The second argument is not an array in C:\ms4w\Apache\htdocs\drupal\modules\syslog\syslog.module on line 106.
    * Trying to execute method get_document_detail without an established session. You must call login method first!

You know what's wrong?

just revert to my backup when kt-dev still normal. Because i dont know what's wrong.

Another question:

Why every user in drupal login as only ONE user in KT? (which is set in KnowledgeTree Authentication in admin/settings/kt/api) I know this is from KT REST module by Mr. aantonop , because the earlier version of kt before this is using same username (and also copy their roles) who is login to drupal at same time in KT. I mean for example when we login as 'michael' in drupal, then when we open KT we also login as 'michael' too.

Really no offense, but is it more secure if we login as same user in drupal and KT like the earlier version? Because the earlier version can keep their privileges diffference so it maintain security in dms.

(Bad english, i know, sorry)

@ aantonop

u'r welcome :)

Just wanna ask little thing, what causing your kt rest test is failed?

it's written:

Executing REST call: http://172.27.4.105/dms/ktwebservice/KTWebService.php?method=login&username=admin&password=admin

HTTP Error 0 - on REST Call with URL http://172.27.4.105/dms/ktwebservice/KTWebService.php?method=login&username=admin&password=admin

Login Failed

Trying to execute method get_document_detail without an established session. You must call login method first!

I think something wrong with the session, but what is it exactly and how i can fix it i have no idea.
At this point I cant login through ktwebservice, i can't use doc reference and i have to revert to my back up again.

when i go to this address:
http://localhost/dms/ktwebservice/KTWebService.php?method=login&username...

it shows like this:

This XML file does not appear to have any style information associated with it. The document tree is shown below.
      
−
<response>
<status_code>0</status_code>
<message/>
<results>e204ddc515a92a41b98fea380f8096bb</results>
</response>

You know why? maybe you can give me little clue..:)

I know the cause now..

in folder drupal\includes\ file common.inc

this file is changed because i used RSS Feed module (one step of configuration of RSS Feed need to edit this file).

This file must be replaced by an original one.

Thank you very much for Mr. Aantonop and Mr. Alex Pott for developing this KT module.