wtsclib character encode problem
|
View:
New views
14 Messages
—
Rating Filter:
Alert me
|
 |
wtsclib character encode problem
by fusioncore
::
Rate this Message:
Hi,
I have create a bridge who sent my website user on the account table on vtiger. This bridge extract data from the website database (utf8_general encode) and send it to vtiger with vtwsclib. (vtiger database was full utf8) I have a problem with the accent on some string. For example, I have an address "Avenue Jean Sébastien BACH" on my website and when I sync with crm, the address save on the crm was "Avenue Jean S" Does vtwsclib support accent ? Thanks, Bruno French-vtiger manager _______________________________________________ Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by Prasad-14
::
Rate this Message:
Hi Bruno,
PHP CURL API's are used to handle the communication. You might need to tune the UTF-8 support in function __construct of class Vtiger_HTTP_Client (file: vtwsclib/Vtiger/Net/HTTP_Client.php) I found the following article to be related: http://markmail.org/message/m27ctd3qzzg7ts3i Please update if you find any information. Another hint: urlencode API is being used which could be causing issue with UTF-8, please watch out during your analysis. Regards, Prasad vtiger Team
On 10/7/09, Fusioncore <ml@...> wrote: Hi, _______________________________________________ Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by fusioncore
::
Rate this Message:
php curl must be install on both server ?
My class was on the website server and vtiger was on an other server. Actually curl was present only on the website server I don't understand your other hint urlencode API, where she is use ? I search on the HTTP_Client.php and I return my feedback soon Thanks, Bruno French-vtiger manager Prasad a écrit : > Hi Bruno, > > PHP CURL API's are used to handle the communication. > You might need to tune the UTF-8 support in function __construct of > class Vtiger_HTTP_Client (file: vtwsclib/Vtiger/Net/HTTP_Client.php) > > I found the following article to be related: > http://markmail.org/message/m27ctd3qzzg7ts3i > Please update if you find any information. > > Another hint: urlencode API is being used which could be causing issue > with UTF-8, please watch out during your analysis. > > Regards, > Prasad > vtiger Team > > On 10/7/09, *Fusioncore* <ml@... <mailto:ml@...>> wrote: > > Hi, > I have create a bridge who sent my website user on the account > table on > vtiger. > This bridge extract data from the website database (utf8_general > encode) > and send it to vtiger with vtwsclib. (vtiger database was full utf8) > I have a problem with the accent on some string. For example, I > have an > address "Avenue Jean Sébastien BACH" on my website and when I sync > with > crm, the address save on the crm was "Avenue Jean S" > Does vtwsclib support accent ? > > Thanks, > > Bruno > French-vtiger manager > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com > > > ------------------------------------------------------------------------ > > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by Prasad-14
::
Rate this Message:
Hi Bruno,
php curl is required by vtwsclib and recommended to be present for vtiger CRM as well. I was pointing to http://in2.php.net/manual/en/function.urlencode.php#92424, for urlencode API Its used in:
Prasad vtiger Team On 10/7/09, Fusioncore <ml@...> wrote: php curl must be install on both server ? _______________________________________________ Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by fusioncore
::
Rate this Message:
Hi Prasad,
The encode problem was solve by the update with the last release of the vtwsclib. But I have a new problem. When I use DoCreate action to create a salesorder, I have this error : ACCESS_DENIED : Permission to perform the operation is denied The vtwslib user have all write permission on the crm. Do you have an idea ? Thanks, Bruno French-vtiger manager Prasad a écrit : > Hi Bruno, > > php curl is required by vtwsclib and recommended to be present for > vtiger CRM as well. > > I was pointing to > http://in2.php.net/manual/en/function.urlencode.php#92424, for > urlencode API > > Its used in: > > * function doGet (Vtiger_HTTP_Client) and > * function send_post_data (Curl_HTTP_Client, file: > vtwsclib/third-party/curl_http_client.php) > > Regards, > Prasad > vtiger Team > > On 10/7/09, *Fusioncore* <ml@... <mailto:ml@...>> wrote: > > php curl must be install on both server ? > My class was on the website server and vtiger was on an other server. > Actually curl was present only on the website server > I don't understand your other hint urlencode API, where she is use ? > I search on the HTTP_Client.php and I return my feedback soon > > > Thanks, > > Bruno > French-vtiger manager > > > Prasad a écrit : > > > Hi Bruno, > > > > PHP CURL API's are used to handle the communication. > > You might need to tune the UTF-8 support in function __construct of > > class Vtiger_HTTP_Client (file: vtwsclib/Vtiger/Net/HTTP_Client.php) > > > > I found the following article to be related: > > http://markmail.org/message/m27ctd3qzzg7ts3i > > Please update if you find any information. > > > > Another hint: urlencode API is being used which could be causing > issue > > with UTF-8, please watch out during your analysis. > > > > Regards, > > Prasad > > vtiger Team > > > > > On 10/7/09, *Fusioncore* <ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>> wrote: > > > > Hi, > > I have create a bridge who sent my website user on the account > > table on > > vtiger. > > This bridge extract data from the website database (utf8_general > > encode) > > and send it to vtiger with vtwsclib. (vtiger database was > full utf8) > > I have a problem with the accent on some string. For example, I > > have an > > address "Avenue Jean Sébastien BACH" on my website and when > I sync > > with > > crm, the address save on the crm was "Avenue Jean S" > > Does vtwsclib support accent ? > > > > Thanks, > > > > Bruno > > French-vtiger manager > > _______________________________________________ > > Reach hundreds of potential candidates - http://jobs.vtiger.com > > > > > > > > ------------------------------------------------------------------------ > > > > > _______________________________________________ > > Reach hundreds of potential candidates - http://jobs.vtiger.com > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com > > > ------------------------------------------------------------------------ > > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by Prasad-14
::
Rate this Message:
Hi Bruno,
Can you share the script? On 11/2/09, Fusioncore <ml@...> wrote: Hi Prasad, _______________________________________________ Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by fusioncore
::
Rate this Message:
This is the script.
I don't find the info about the product and service add syntax. but it's plan on a second time $client = new Vtiger_WSClient($crm_url); $login = $client->doLogin($crm_username, $crm_accesskey); if(!$login) echo 'Login Failed'; else { echo "Login Successful<br />"; $module = 'SalesOrder'; $record = $client->doCreate($module, array( 'subject'=>"$pack_number", 'duedate'=>"$_t", 'description'=>"$comment_t", 'recurring_frequency'=>"$bill_reccuring_t", 'cf_548'=>"$pay_method", 'cf_547'=>"$ip", 'cf_546'=>"$date", 'cf_540'=>"$pack_number", 'accountid'=>"$account_number", 'sostatus'=>"$sostatus", 'total'=>"$total", 'subtotal'=>"$subtotal", 'taxtype'=>"$taxtype", 'contactid'=>"$fact_contactid", ) ); $error = $client->lasterror(); if($error) {echo $error['code'] . ' : ' . $error['message']; } if($record) { $salesorderid = $client->getRecordId($record['id']); } echo "<br />new SaleOrder id : $salesorderid <br />"; } When my website will be open, I think I clean my code and enhance the css and translation to publish it on the extension vtiger site. It's a complete commerce solution totaly integrate with vtiger. Thanks for your help, Bruno French-vtiger Manager Prasad a écrit : > Hi Bruno, > > Can you share the script? > > On 11/2/09, *Fusioncore* <ml@... <mailto:ml@...>> wrote: > > Hi Prasad, > > The encode problem was solve by the update with the last release > of the > vtwsclib. > But I have a new problem. When I use DoCreate action to create a > salesorder, I have this error : ACCESS_DENIED : Permission to perform > the operation is denied > > The vtwslib user have all write permission on the crm. Do you have > an idea ? > > > Thanks, > > Bruno > French-vtiger manager > > > > Prasad a écrit : > > Hi Bruno, > > > > > php curl is required by vtwsclib and recommended to be present for > > vtiger CRM as well. > > > > I was pointing to > > http://in2.php.net/manual/en/function.urlencode.php#92424, for > > urlencode API > > > > Its used in: > > > > * function doGet (Vtiger_HTTP_Client) and > > * function send_post_data (Curl_HTTP_Client, file: > > vtwsclib/third-party/curl_http_client.php) > > > > Regards, > > Prasad > > vtiger Team > > > > > On 10/7/09, *Fusioncore* <ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>> wrote: > > > > php curl must be install on both server ? > > My class was on the website server and vtiger was on an > other server. > > Actually curl was present only on the website server > > I don't understand your other hint urlencode API, where she > is use ? > > I search on the HTTP_Client.php and I return my feedback soon > > > > > > Thanks, > > > > Bruno > > French-vtiger manager > > > > > > Prasad a écrit : > > > > > Hi Bruno, > > > > > > PHP CURL API's are used to handle the communication. > > > You might need to tune the UTF-8 support in function > __construct of > > > class Vtiger_HTTP_Client (file: > vtwsclib/Vtiger/Net/HTTP_Client.php) > > > > > > I found the following article to be related: > > > http://markmail.org/message/m27ctd3qzzg7ts3i > > > Please update if you find any information. > > > > > > Another hint: urlencode API is being used which could be > causing > > issue > > > with UTF-8, please watch out during your analysis. > > > > > > Regards, > > > Prasad > > > vtiger Team > > > > > > > > On 10/7/09, *Fusioncore* <ml@... > <mailto:ml@...> <mailto:ml@... <mailto:ml@...>> > > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>>> wrote: > > > > > > Hi, > > > I have create a bridge who sent my website user on the > account > > > table on > > > vtiger. > > > This bridge extract data from the website database > (utf8_general > > > encode) > > > and send it to vtiger with vtwsclib. (vtiger database was > > full utf8) > > > I have a problem with the accent on some string. For > example, I > > > have an > > > address "Avenue Jean Sébastien BACH" on my website and > when > > I sync > > > with > > > crm, the address save on the crm was "Avenue Jean S" > > > Does vtwsclib support accent ? > > > > > > Thanks, > > > > > > Bruno > > > French-vtiger manager > > > _______________________________________________ > > > Reach hundreds of potential candidates - > http://jobs.vtiger.com > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > > > _______________________________________________ > > > Reach hundreds of potential candidates - > http://jobs.vtiger.com > > _______________________________________________ > > Reach hundreds of potential candidates - http://jobs.vtiger.com > > > > > > > > ------------------------------------------------------------------------ > > > > > _______________________________________________ > > Reach hundreds of potential candidates - http://jobs.vtiger.com > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com > > > ------------------------------------------------------------------------ > > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by David V.-2
::
Rate this Message:
Salut Bruno ! ;-)
In your script your are using the database's names of your custom fields. You should make sure theses are the names to use by trying a DoDescribe. Try : $decribe_infos = $client->doDescribe('SalesOrder'); print_r($describe_infos); You'll get the actual names for the fields. David V. 2009/11/2 Fusioncore <ml@...> This is the script. _______________________________________________ Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by Prasad-14
::
Rate this Message:
I was able to successfully create the SalesOrder base information record with the following:
---- START ---- <?php require_once('vtwsclib/Vtiger/WSClient.php'); $vtwsclib = new Vtiger_WSClient('http://vtiger.server.url'); $login= $vtwsclib->doLogin('admin', 'accessKey'); $data = array( 'subject' => 'Test SalesOrder', 'sostatus' => 'Created', 'invoicestatus'=>'AutoCreated', 'account_id'=> '3x2', // Existing account id 'bill_street' => 'Bill Street', 'ship_street' => 'Ship Street', ); $result = $vtwsclib->doCreate('SalesOrder', $data); var_dump($vtwsclib->lastError()); var_dump($result); ---- END ---- Hope this helps. Regards, Prasad vtiger Team On 11/2/09, Fusioncore <ml@...> wrote: This is the script. _______________________________________________ Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by fusioncore
::
Rate this Message:
Thanks, I look this today
Bruno Franch-vtiger Manager Prasad a écrit : > I was able to successfully create the SalesOrder base information > record with the following: > > ---- START ---- > <?php > require_once('vtwsclib/Vtiger/WSClient.php'); > > $vtwsclib = new Vtiger_WSClient('http://vtiger.server.url'); > $login= $vtwsclib->doLogin('admin', 'accessKey'); > > $data = array( > 'subject' => 'Test SalesOrder', > 'sostatus' => 'Created', > 'invoicestatus'=>'AutoCreated', > 'account_id'=> '3x2', // Existing account id > > 'bill_street' => 'Bill Street', > 'ship_street' => 'Ship Street', > ); > $result = $vtwsclib->doCreate('SalesOrder', $data); > > var_dump($vtwsclib->lastError()); > var_dump($result); > ---- END ---- > > Hope this helps. > > Regards, > Prasad > vtiger Team > > On 11/2/09, *Fusioncore* <ml@... <mailto:ml@...>> wrote: > > This is the script. > I don't find the info about the product and service add syntax. > but it's > plan on a second time > > $client = new Vtiger_WSClient($crm_url); > > $login = $client->doLogin($crm_username, $crm_accesskey); > if(!$login) > echo 'Login Failed'; > else > { > echo "Login Successful<br />"; > $module = 'SalesOrder'; > > $record = $client->doCreate($module, > array( > 'subject'=>"$pack_number", > 'duedate'=>"$_t", > 'description'=>"$comment_t", > 'recurring_frequency'=>"$bill_reccuring_t", > 'cf_548'=>"$pay_method", > 'cf_547'=>"$ip", > 'cf_546'=>"$date", > 'cf_540'=>"$pack_number", > 'accountid'=>"$account_number", > 'sostatus'=>"$sostatus", > 'total'=>"$total", > 'subtotal'=>"$subtotal", > 'taxtype'=>"$taxtype", > 'contactid'=>"$fact_contactid", > ) > ); > $error = $client->lasterror(); > if($error) {echo $error['code'] . ' : ' . $error['message']; > } > > if($record) { > $salesorderid = $client->getRecordId($record['id']); > } > echo "<br />new SaleOrder id : $salesorderid <br />"; > } > > When my website will be open, I think I clean my code and enhance the > css and translation to publish it on the extension vtiger site. It's a > complete commerce solution totaly integrate with vtiger. > > Thanks for your help, > > > Bruno > French-vtiger Manager > > > Prasad a écrit : > > Hi Bruno, > > > > > Can you share the script? > > > > > On 11/2/09, *Fusioncore* <ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>> wrote: > > > > Hi Prasad, > > > > The encode problem was solve by the update with the last release > > of the > > vtwsclib. > > But I have a new problem. When I use DoCreate action to create a > > salesorder, I have this error : ACCESS_DENIED : Permission > to perform > > the operation is denied > > > > The vtwslib user have all write permission on the crm. Do > you have > > an idea ? > > > > > > Thanks, > > > > Bruno > > French-vtiger manager > > > > > > > > Prasad a écrit : > > > Hi Bruno, > > > > > > > > php curl is required by vtwsclib and recommended to be > present for > > > vtiger CRM as well. > > > > > > I was pointing to > > > http://in2.php.net/manual/en/function.urlencode.php#92424, for > > > urlencode API > > > > > > Its used in: > > > > > > * function doGet (Vtiger_HTTP_Client) and > > > * function send_post_data (Curl_HTTP_Client, file: > > > vtwsclib/third-party/curl_http_client.php) > > > > > > Regards, > > > Prasad > > > vtiger Team > > > > > > > > On 10/7/09, *Fusioncore* <ml@... > <mailto:ml@...> <mailto:ml@... <mailto:ml@...>> > > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>>> wrote: > > > > > > php curl must be install on both server ? > > > My class was on the website server and vtiger was on an > > other server. > > > Actually curl was present only on the website server > > > I don't understand your other hint urlencode API, > where she > > is use ? > > > I search on the HTTP_Client.php and I return my > feedback soon > > > > > > > > > Thanks, > > > > > > Bruno > > > French-vtiger manager > > > > > > > > > Prasad a écrit : > > > > > > > Hi Bruno, > > > > > > > > PHP CURL API's are used to handle the communication. > > > > You might need to tune the UTF-8 support in function > > __construct of > > > > class Vtiger_HTTP_Client (file: > > vtwsclib/Vtiger/Net/HTTP_Client.php) > > > > > > > > I found the following article to be related: > > > > http://markmail.org/message/m27ctd3qzzg7ts3i > > > > Please update if you find any information. > > > > > > > > Another hint: urlencode API is being used which could be > > causing > > > issue > > > > with UTF-8, please watch out during your analysis. > > > > > > > > Regards, > > > > Prasad > > > > vtiger Team > > > > > > > > > > > On 10/7/09, *Fusioncore* <ml@... > <mailto:ml@...> > > <mailto:ml@... <mailto:ml@...>> > <mailto:ml@... <mailto:ml@...> <mailto:ml@... > <mailto:ml@...>>> > > > > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>> > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>>>> wrote: > > > > > > > > Hi, > > > > I have create a bridge who sent my website user > on the > > account > > > > table on > > > > vtiger. > > > > This bridge extract data from the website database > > (utf8_general > > > > encode) > > > > and send it to vtiger with vtwsclib. (vtiger > database was > > > full utf8) > > > > I have a problem with the accent on some string. For > > example, I > > > > have an > > > > address "Avenue Jean Sébastien BACH" on my > website and > > when > > > I sync > > > > with > > > > crm, the address save on the crm was "Avenue Jean S" > > > > Does vtwsclib support accent ? > > > > > > > > Thanks, > > > > > > > > Bruno > > > > French-vtiger manager > > > > _______________________________________________ > > > > Reach hundreds of potential candidates - > > http://jobs.vtiger.com > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > > > > > > _______________________________________________ > > > > Reach hundreds of potential candidates - > > http://jobs.vtiger.com > > > _______________________________________________ > > > Reach hundreds of potential candidates - > http://jobs.vtiger.com > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > > > _______________________________________________ > > > Reach hundreds of potential candidates - > http://jobs.vtiger.com > > _______________________________________________ > > Reach hundreds of potential candidates - http://jobs.vtiger.com > > > > > > > > ------------------------------------------------------------------------ > > > > > _______________________________________________ > > Reach hundreds of potential candidates - http://jobs.vtiger.com > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com > > > ------------------------------------------------------------------------ > > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Custom Field Formulas
by Russell Dodd-2
::
Rate this Message:
I've managed to create a basic formula for
calculating a cost price for a product based upon a list price
multiplied by a discount. Easy enough. But now I want to create a
calculated Unit Price based either upon a discount from list OR a
mark-up from cost (which could change from day to day). I tried
entering a formula along the lines of:
if cf_548 == "" then (cf_547 * cf_543) else (cf_548 * cf_544) end But this causes a 'SyntaxError: JSON.parse' dialog popup when I try to save. Am I approaching this problem in the correct way? _______________________________________________ Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by fusioncore
::
Rate this Message:
I use your method to create SalesOrder
The return : array(2) { ["code"]=> string(13) "ACCESS_DENIED" ["message"]=> string(45) "Permission to perform the operation is denied" } bool(false) what are the string(13) and string(45) ? and where can I found the list of modules id ? My user have all rights on Account, Contact, salesorder, Invoice modules I test with admin and the error is the same My code : <?php require_once('/var/www/regie/www/vtwsclib/Vtiger/WSClient.php'); $vtwsclib = new Vtiger_WSClient('http://crm.url.fr'); $login= $vtwsclib->doLogin('admin', 'key'); $data = array( 'subject' => 'Test SalesOrder', 'sostatus' => 'Created', 'invoicestatus'=>'AutoCreated', 'account_id'=> '3x1357', // Existing account id 'bill_street' => 'Bill Street', 'ship_street' => 'Ship Street', ); $result = $vtwsclib->doCreate('SalesOrder', $data); var_dump($vtwsclib->lastError()); var_dump($result); ?> Thanks for your help, Bruno French-vtiger manager Prasad a écrit : > I was able to successfully create the SalesOrder base information > record with the following: > > ---- START ---- > <?php > require_once('vtwsclib/Vtiger/WSClient.php'); > > $vtwsclib = new Vtiger_WSClient('http://vtiger.server.url'); > $login= $vtwsclib->doLogin('admin', 'accessKey'); > > $data = array( > 'subject' => 'Test SalesOrder', > 'sostatus' => 'Created', > 'invoicestatus'=>'AutoCreated', > 'account_id'=> '3x2', // Existing account id > > 'bill_street' => 'Bill Street', > 'ship_street' => 'Ship Street', > ); > $result = $vtwsclib->doCreate('SalesOrder', $data); > > var_dump($vtwsclib->lastError()); > var_dump($result); > ---- END ---- > > Hope this helps. > > Regards, > Prasad > vtiger Team > > On 11/2/09, *Fusioncore* <ml@... <mailto:ml@...>> wrote: > > This is the script. > I don't find the info about the product and service add syntax. > but it's > plan on a second time > > $client = new Vtiger_WSClient($crm_url); > > $login = $client->doLogin($crm_username, $crm_accesskey); > if(!$login) > echo 'Login Failed'; > else > { > echo "Login Successful<br />"; > $module = 'SalesOrder'; > > $record = $client->doCreate($module, > array( > 'subject'=>"$pack_number", > 'duedate'=>"$_t", > 'description'=>"$comment_t", > 'recurring_frequency'=>"$bill_reccuring_t", > 'cf_548'=>"$pay_method", > 'cf_547'=>"$ip", > 'cf_546'=>"$date", > 'cf_540'=>"$pack_number", > 'accountid'=>"$account_number", > 'sostatus'=>"$sostatus", > 'total'=>"$total", > 'subtotal'=>"$subtotal", > 'taxtype'=>"$taxtype", > 'contactid'=>"$fact_contactid", > ) > ); > $error = $client->lasterror(); > if($error) {echo $error['code'] . ' : ' . $error['message']; > } > > if($record) { > $salesorderid = $client->getRecordId($record['id']); > } > echo "<br />new SaleOrder id : $salesorderid <br />"; > } > > When my website will be open, I think I clean my code and enhance the > css and translation to publish it on the extension vtiger site. It's a > complete commerce solution totaly integrate with vtiger. > > Thanks for your help, > > > Bruno > French-vtiger Manager > > > Prasad a écrit : > > Hi Bruno, > > > > > Can you share the script? > > > > > On 11/2/09, *Fusioncore* <ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>> wrote: > > > > Hi Prasad, > > > > The encode problem was solve by the update with the last release > > of the > > vtwsclib. > > But I have a new problem. When I use DoCreate action to create a > > salesorder, I have this error : ACCESS_DENIED : Permission > to perform > > the operation is denied > > > > The vtwslib user have all write permission on the crm. Do > you have > > an idea ? > > > > > > Thanks, > > > > Bruno > > French-vtiger manager > > > > > > > > Prasad a écrit : > > > Hi Bruno, > > > > > > > > php curl is required by vtwsclib and recommended to be > present for > > > vtiger CRM as well. > > > > > > I was pointing to > > > http://in2.php.net/manual/en/function.urlencode.php#92424, for > > > urlencode API > > > > > > Its used in: > > > > > > * function doGet (Vtiger_HTTP_Client) and > > > * function send_post_data (Curl_HTTP_Client, file: > > > vtwsclib/third-party/curl_http_client.php) > > > > > > Regards, > > > Prasad > > > vtiger Team > > > > > > > > On 10/7/09, *Fusioncore* <ml@... > <mailto:ml@...> <mailto:ml@... <mailto:ml@...>> > > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>>> wrote: > > > > > > php curl must be install on both server ? > > > My class was on the website server and vtiger was on an > > other server. > > > Actually curl was present only on the website server > > > I don't understand your other hint urlencode API, > where she > > is use ? > > > I search on the HTTP_Client.php and I return my > feedback soon > > > > > > > > > Thanks, > > > > > > Bruno > > > French-vtiger manager > > > > > > > > > Prasad a écrit : > > > > > > > Hi Bruno, > > > > > > > > PHP CURL API's are used to handle the communication. > > > > You might need to tune the UTF-8 support in function > > __construct of > > > > class Vtiger_HTTP_Client (file: > > vtwsclib/Vtiger/Net/HTTP_Client.php) > > > > > > > > I found the following article to be related: > > > > http://markmail.org/message/m27ctd3qzzg7ts3i > > > > Please update if you find any information. > > > > > > > > Another hint: urlencode API is being used which could be > > causing > > > issue > > > > with UTF-8, please watch out during your analysis. > > > > > > > > Regards, > > > > Prasad > > > > vtiger Team > > > > > > > > > > > On 10/7/09, *Fusioncore* <ml@... > <mailto:ml@...> > > <mailto:ml@... <mailto:ml@...>> > <mailto:ml@... <mailto:ml@...> <mailto:ml@... > <mailto:ml@...>>> > > > > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>> > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>>>> wrote: > > > > > > > > Hi, > > > > I have create a bridge who sent my website user > on the > > account > > > > table on > > > > vtiger. > > > > This bridge extract data from the website database > > (utf8_general > > > > encode) > > > > and send it to vtiger with vtwsclib. (vtiger > database was > > > full utf8) > > > > I have a problem with the accent on some string. For > > example, I > > > > have an > > > > address "Avenue Jean Sébastien BACH" on my > website and > > when > > > I sync > > > > with > > > > crm, the address save on the crm was "Avenue Jean S" > > > > Does vtwsclib support accent ? > > > > > > > > Thanks, > > > > > > > > Bruno > > > > French-vtiger manager > > > > _______________________________________________ > > > > Reach hundreds of potential candidates - > > http://jobs.vtiger.com > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > > > > > > _______________________________________________ > > > > Reach hundreds of potential candidates - > > http://jobs.vtiger.com > > > _______________________________________________ > > > Reach hundreds of potential candidates - > http://jobs.vtiger.com > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > > > _______________________________________________ > > > Reach hundreds of potential candidates - > http://jobs.vtiger.com > > _______________________________________________ > > Reach hundreds of potential candidates - http://jobs.vtiger.com > > > > > > > > ------------------------------------------------------------------------ > > > > > _______________________________________________ > > Reach hundreds of potential candidates - http://jobs.vtiger.com > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com > > > ------------------------------------------------------------------------ > > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by Prasad-14
::
Rate this Message:
Hi,
(13) and (45) refers to the length of the string from the output of var_dump. You will need to use to doListTypes operation to find the information about the Module. Please refer vtwsclib documentation on the API. Regards, Prasad vtiger Team On 11/6/09, Fusioncore <ml@...> wrote: I use your method to create SalesOrder _______________________________________________ Reach hundreds of potential candidates - http://jobs.vtiger.com |
|
|
Re: wtsclib character encode problem
by fusioncore
::
Rate this Message:
The DoListTypes return this :
ModuleName: Accounts ModuleName: Contacts ModuleName: Potentials ModuleName: Products ModuleName: Documents ModuleName: Emails ModuleName: HelpDesk ModuleName: Faq ModuleName: Quotes ModuleName: SalesOrder ModuleName: Invoice ModuleName: Users ModuleName: ServiceContracts ModuleName: Services ModuleName: Groups ModuleName: Currency ModuleName: DocumentFolders I have test the method below on an other installation and it work. I just change the key and the id of the account. I don't understand why it don't work on the first installation, the parameters and the server are the same I will make more test on ti but if you have an idea ... Regards, Bruno French-vtiger manager Prasad a écrit : > Hi, > > (13) and (45) refers to the length of the string from the output of > var_dump. > > You will need to use to doListTypes operation to find the information > about the Module. > > Please refer vtwsclib documentation on the API. > > Regards, > Prasad > vtiger Team > > On 11/6/09, *Fusioncore* <ml@... <mailto:ml@...>> wrote: > > I use your method to create SalesOrder > The return : array(2) { ["code"]=> string(13) "ACCESS_DENIED" > ["message"]=> string(45) "Permission to perform the operation is > denied" > } bool(false) > > what are the string(13) and string(45) ? and where can I found the > list > of modules id ? > My user have all rights on Account, Contact, salesorder, Invoice > modules > I test with admin and the error is the same > > > My code : > <?php > require_once('/var/www/regie/www/vtwsclib/Vtiger/WSClient.php'); > > $vtwsclib = new Vtiger_WSClient('http://crm.url.fr'); > $login= $vtwsclib->doLogin('admin', 'key'); > > > $data = array( > 'subject' => 'Test SalesOrder', > 'sostatus' => 'Created', > 'invoicestatus'=>'AutoCreated', > > 'account_id'=> '3x1357', // Existing account id > > > 'bill_street' => 'Bill Street', > 'ship_street' => 'Ship Street', > ); > $result = $vtwsclib->doCreate('SalesOrder', $data); > > var_dump($vtwsclib->lastError()); > var_dump($result); > > ?> > > > Thanks for your help, > > Bruno > > French-vtiger manager > > Prasad a écrit : > > > I was able to successfully create the SalesOrder base information > > record with the following: > > > > ---- START ---- > > <?php > > require_once('vtwsclib/Vtiger/WSClient.php'); > > > > $vtwsclib = new Vtiger_WSClient('http://vtiger.server.url'); > > $login= $vtwsclib->doLogin('admin', 'accessKey'); > > > > $data = array( > > 'subject' => 'Test SalesOrder', > > 'sostatus' => 'Created', > > 'invoicestatus'=>'AutoCreated', > > 'account_id'=> '3x2', // Existing account id > > > > 'bill_street' => 'Bill Street', > > 'ship_street' => 'Ship Street', > > ); > > $result = $vtwsclib->doCreate('SalesOrder', $data); > > > > var_dump($vtwsclib->lastError()); > > var_dump($result); > > ---- END ---- > > > > Hope this helps. > > > > Regards, > > Prasad > > vtiger Team > > > > > On 11/2/09, *Fusioncore* <ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>> wrote: > > > > This is the script. > > I don't find the info about the product and service add syntax. > > but it's > > plan on a second time > > > > $client = new Vtiger_WSClient($crm_url); > > > > $login = $client->doLogin($crm_username, $crm_accesskey); > > if(!$login) > > echo 'Login Failed'; > > else > > { > > echo "Login Successful<br />"; > > $module = 'SalesOrder'; > > > > $record = $client->doCreate($module, > > array( > > 'subject'=>"$pack_number", > > 'duedate'=>"$_t", > > 'description'=>"$comment_t", > > 'recurring_frequency'=>"$bill_reccuring_t", > > 'cf_548'=>"$pay_method", > > 'cf_547'=>"$ip", > > 'cf_546'=>"$date", > > 'cf_540'=>"$pack_number", > > 'accountid'=>"$account_number", > > 'sostatus'=>"$sostatus", > > 'total'=>"$total", > > 'subtotal'=>"$subtotal", > > 'taxtype'=>"$taxtype", > > 'contactid'=>"$fact_contactid", > > ) > > ); > > $error = $client->lasterror(); > > if($error) {echo $error['code'] . ' : ' . > $error['message']; > > } > > > > if($record) { > > $salesorderid = $client->getRecordId($record['id']); > > } > > echo "<br />new SaleOrder id : $salesorderid <br />"; > > } > > > > When my website will be open, I think I clean my code and > enhance the > > css and translation to publish it on the extension vtiger > site. It's a > > complete commerce solution totaly integrate with vtiger. > > > > Thanks for your help, > > > > > > Bruno > > French-vtiger Manager > > > > > > Prasad a écrit : > > > Hi Bruno, > > > > > > > > Can you share the script? > > > > > > > > On 11/2/09, *Fusioncore* <ml@... > <mailto:ml@...> <mailto:ml@... <mailto:ml@...>> > > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>>> wrote: > > > > > > > Hi Prasad, > > > > > > The encode problem was solve by the update with the > last release > > > of the > > > vtwsclib. > > > But I have a new problem. When I use DoCreate action > to create a > > > salesorder, I have this error : ACCESS_DENIED : Permission > > to perform > > > the operation is denied > > > > > > The vtwslib user have all write permission on the crm. Do > > you have > > > an idea ? > > > > > > > > > Thanks, > > > > > > Bruno > > > French-vtiger manager > > > > > > > > > > > > Prasad a écrit : > > > > Hi Bruno, > > > > > > > > > > > php curl is required by vtwsclib and recommended to be > > present for > > > > vtiger CRM as well. > > > > > > > > I was pointing to > > > > > http://in2.php.net/manual/en/function.urlencode.php#92424, for > > > > urlencode API > > > > > > > > Its used in: > > > > > > > > * function doGet (Vtiger_HTTP_Client) and > > > > * function send_post_data (Curl_HTTP_Client, file: > > > > vtwsclib/third-party/curl_http_client.php) > > > > > > > > Regards, > > > > Prasad > > > > vtiger Team > > > > > > > > > > > On 10/7/09, *Fusioncore* <ml@... > <mailto:ml@...> > > <mailto:ml@... <mailto:ml@...>> > <mailto:ml@... <mailto:ml@...> <mailto:ml@... > <mailto:ml@...>>> > > > > > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>> > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>>>> wrote: > > > > > > > > php curl must be install on both server ? > > > > My class was on the website server and vtiger > was on an > > > other server. > > > > Actually curl was present only on the website server > > > > I don't understand your other hint urlencode API, > > where she > > > is use ? > > > > I search on the HTTP_Client.php and I return my > > feedback soon > > > > > > > > > > > > Thanks, > > > > > > > > Bruno > > > > French-vtiger manager > > > > > > > > > > > > Prasad a écrit : > > > > > > > > > Hi Bruno, > > > > > > > > > > PHP CURL API's are used to handle the > communication. > > > > > You might need to tune the UTF-8 support in > function > > > __construct of > > > > > class Vtiger_HTTP_Client (file: > > > vtwsclib/Vtiger/Net/HTTP_Client.php) > > > > > > > > > > I found the following article to be related: > > > > > http://markmail.org/message/m27ctd3qzzg7ts3i > > > > > Please update if you find any information. > > > > > > > > > > Another hint: urlencode API is being used > which could be > > > causing > > > > issue > > > > > with UTF-8, please watch out during your analysis. > > > > > > > > > > Regards, > > > > > Prasad > > > > > vtiger Team > > > > > > > > > > > > > > On 10/7/09, *Fusioncore* <ml@... > <mailto:ml@...> > > <mailto:ml@... <mailto:ml@...>> > > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>> > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>> <mailto:ml@... > <mailto:ml@...> > > <mailto:ml@... <mailto:ml@...>>>> > > > > > > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>> > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>> > > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>> > > <mailto:ml@... <mailto:ml@...> > <mailto:ml@... <mailto:ml@...>>>>>> wrote: > > > > > > > > > > Hi, > > > > > I have create a bridge who sent my website > user > > on the > > > account > > > > > table on > > > > > vtiger. > > > > > This bridge extract data from the website > database > > > (utf8_general > > > > > encode) > > > > > and send it to vtiger with vtwsclib. (vtiger > > database was > > > > full utf8) > > > > > I have a problem with the accent on some > string. For > > > example, I > > > > > have an > > > > > address "Avenue Jean Sébastien BACH" on my > > website and > > > when > > > > I sync > > > > > with > > > > > crm, the address save on the crm was > "Avenue Jean S" > > > > > Does vtwsclib support accent ? > > > > > > > > > > Thanks, > > > > > > > > > > Bruno > > > > > French-vtiger manager > > > > > > _______________________________________________ > > > > > Reach hundreds of potential candidates - > > > http://jobs.vtiger.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > > > > > > > > > _______________________________________________ > > > > > Reach hundreds of potential candidates - > > > http://jobs.vtiger.com > > > > _______________________________________________ > > > > Reach hundreds of potential candidates - > > http://jobs.vtiger.com > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > > > > > > _______________________________________________ > > > > Reach hundreds of potential candidates - > > http://jobs.vtiger.com > > > _______________________________________________ > > > Reach hundreds of potential candidates - > http://jobs.vtiger.com > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > > > _______________________________________________ > > > Reach hundreds of potential candidates - > http://jobs.vtiger.com > > _______________________________________________ > > Reach hundreds of potential candidates - http://jobs.vtiger.com > > > > > > > > ------------------------------------------------------------------------ > > > > > _______________________________________________ > > Reach hundreds of potential candidates - http://jobs.vtiger.com > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com > > > ------------------------------------------------------------------------ > > _______________________________________________ > Reach hundreds of potential candidates - http://jobs.vtiger.com Reach hundreds of potential candidates - http://jobs.vtiger.com |
| Free embeddable forum powered by Nabble | Forum Help |
