<div dir="ltr">Thanks for your reply Uma S.<div>The problem is not file format because I just tried to import in this demo server:<a href="http://demo.vgsglobal.com/index.php">http://demo.vgsglobal.com/index.php</a> and works fine</div><div><br></div><div>I think the possible causes could be:<br>Installation error?</div><div>Developer edition?</div><div>Or maybe I changed something unintentionally in settings or by writing code.</div><div><div class="gmail_extra"><br><div class="gmail_quote">2015-01-28 9:13 GMT+01:00 <span dir="ltr"><<a href="mailto:vtigercrm-developers-request@lists.vtigercrm.com" target="_blank">vtigercrm-developers-request@lists.vtigercrm.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Send vtigercrm-developers mailing list submissions to<br>
<a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers" target="_blank">http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers</a><br>
<br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:vtigercrm-developers-request@lists.vtigercrm.com" target="_blank">vtigercrm-developers-request@lists.vtigercrm.com</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:vtigercrm-developers-owner@lists.vtigercrm.com" target="_blank">vtigercrm-developers-owner@lists.vtigercrm.com</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of vtigercrm-developers digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Data import problem (Uma S)<br>
2. Server API set smcreatorid? (Alan Lord)<br>
3. Create entity with vtlib? (Richard Hills - Technologywise)<br>
4. Re: exchange and outlook plugins and https (SivaKumar J)<br>
5. Re: Create entity with vtlib? (Uma S)<br>
6. Re: Custom UItype (upload file field) working well except on<br>
Calendar/Events (Uma S)<br>
7. Re: Custom UItype (upload file field) working well except on<br>
Calendar/Events (apcloic)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Tue, 27 Jan 2015 21:26:00 +0530<br>
From: Uma S <<a href="mailto:uma.s@vtiger.com" target="_blank">uma.s@vtiger.com</a>><br>
To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br>
Subject: Re: [Vtigercrm-developers] Data import problem<br>
Message-ID:<br>
<CAH83Uo+GmmKxgjOoqyNmymSi_f_mQDjFHY5=<a href="mailto:nXhKmn1aqA8K5g@mail.gmail.com" target="_blank">nXhKmn1aqA8K5g@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi,<br>
<br>
The csv files that has been exported will be saved in particular format,<br>
with specific data separator when you edit and save the file need to be<br>
take care of this file format.<br>
<br>
On Tue, Jan 27, 2015 at 7:58 PM, Giovanni Incammicia <<br>
<a href="mailto:incammicia.it@gmail.com" target="_blank">incammicia.it@gmail.com</a>> wrote:<br>
<br>
><br>
> 2015-01-27 15:26 GMT+01:00 Giovanni Incammicia <<a href="mailto:incammicia.it@gmail.com" target="_blank">incammicia.it@gmail.com</a>>:<br>
><br>
>> Hi,<br>
>><br>
>> I tried to export csv from vtiger organizations, open it with openoffice<br>
>> calc and add data, then I save and import in vtiger.<br>
>><br>
>> First problem is that vtiger doesn't match automatically the fields<br>
>> created by him, after that he doesn't import anything (but skips correctly<br>
>> records that already exists).<br>
>> So I tried to create minimal csv:<br>
>><br>
>> Organization Name,Assigned To,Website<br>
>> first,,<a href="http://examples.com" target="_blank">http://examples.com</a><br>
>> second,,<a href="http://examples.com" target="_blank">http://examples.com</a><br>
>><br>
>> This time he matches the fields, but he doesn't import anything (see<br>
>> image in attachments).<br>
>><br>
>> Thanks for your help,<br>
>> Giovanni Incammicia<br>
>><br>
><br>
><br>
> _______________________________________________<br>
> <a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
><br>
<br>
<br>
<br>
--<br>
With<br>
Best Regards<br>
Uma.S<br>
Vtiger Team<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150127/c150328a/attachment-0001.html" target="_blank">http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150127/c150328a/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Tue, 27 Jan 2015 17:17:40 +0000<br>
From: Alan Lord <<a href="mailto:alanslists@gmail.com" target="_blank">alanslists@gmail.com</a>><br>
To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br>
Subject: [Vtigercrm-developers] Server API set smcreatorid?<br>
Message-ID: <ma8h7l$und$<a href="mailto:1@ger.gmane.org" target="_blank">1@ger.gmane.org</a>><br>
Content-Type: text/plain; charset=utf-8; format=flowed<br>
<br>
I'm trying to ensure that records I'm creating through a migration<br>
script have the smcreatorid set to the correct user, but the code below<br>
doesn't seem to make any difference. In vtiger_crmentity smcreatorid is<br>
always "1".<br>
<br>
Am I doing something wrong?<br>
<br>
> $user = new Users();<br>
> $temp_current_user = '';<br>
><br>
> echo "Creator: $creator" . PHP_EOL; ($creator can be a username from a custom field)<br>
> if($creator) {<br>
> $smcreator = Users_Record_Model::getInstanceByName($creator);<br>
> } else {<br>
> $smcreator = Users_Record_Model::getInstanceById($smownerid);<br>
> }<br>
><br>
> if($smcreator) {<br>
> $temp_current_user = $user->retrieveCurrentUserInfoFromFile($smcreator->getId());<br>
> }<br>
><br>
> if(!$temp_current_user) {<br>
> $temp_current_user = $user->retrieveCurrentUserInfoFromFile("1");<br>
> }<br>
><br>
> echo "Creating Meter $i..." . PHP_EOL;<br>
><br>
> //print_r($data);<br>
> $ent = vtws_create('LSMeters', $data, $temp_current_user);<br>
<br>
<br>
<br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Wed, 28 Jan 2015 14:45:22 +1300<br>
From: Richard Hills - Technologywise <<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>><br>
To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br>
Subject: [Vtigercrm-developers] Create entity with vtlib?<br>
Message-ID: <<a href="mailto:54C83F32.8090205@tw.co.nz" target="_blank">54C83F32.8090205@tw.co.nz</a>><br>
Content-Type: text/plain; charset=utf-8; format=flowed<br>
<br>
I have created a custom module for 6.1 which is a re-creation of a<br>
module in our previous 5.4 installation.<br>
<br>
Basically I want to query the old tables and recreate the entities after<br>
a migration. Can someone show me a basic snippet of entity creation with<br>
vtlib (maybe I am meant to use vtws..)?<br>
<br>
Thought I would find this on the wiki but had no luck, sorry if this has<br>
been covered 100x before.<br>
<br>
Thanks<br>
<br>
--<br>
Richard Hills<br>
TechnologyWise Ltd, Tauranga, NZ<br>
<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a><br>
<a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a><br>
ph: <a href="tel:%2B64%20%280%297%20571%201060" value="+6475711060" target="_blank">+64 (0)7 571 1060</a><br>
fax: <a href="tel:%2B64%20%280%297%20571%201061" value="+6475711061" target="_blank">+64 (0)7 571 1061</a><br>
<br>
<br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Wed, 28 Jan 2015 10:04:42 +0530<br>
From: SivaKumar J <<a href="mailto:sivakumar.j@vtiger.com" target="_blank">sivakumar.j@vtiger.com</a>><br>
To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br>
Subject: Re: [Vtigercrm-developers] exchange and outlook plugins and<br>
https<br>
Message-ID:<br>
<CAOc78RY9it7NcsUnq74SJ1JL+whnvWrz=F=<a href="mailto:d7PYYUvS8yLmwdA@mail.gmail.com" target="_blank">d7PYYUvS8yLmwdA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Exchange/Outlook Plugin should work with http and https both. Is normal<br>
webservice login with https works fine?<br>
May be Firewall is blocking, please have a look.<br>
<br>
<br>
On Mon, Jan 26, 2015 at 10:32 PM, Alan Bell <<a href="mailto:alan.bell@libertus.co.uk" target="_blank">alan.bell@libertus.co.uk</a>><br>
wrote:<br>
<br>
> should the exchange plugin and outlook plugin support https: both seem to<br>
> give the same error when trying to connect (UNKNOWN_ERROR) and work fine on<br>
> http.<br>
><br>
> I can see requests like "GET /webservice.php?operation=getchallenge&username=<br>
> . . . in the http log, but no sign of a connection attempt on the https<br>
> port.<br>
><br>
> Alan.<br>
> _______________________________________________<br>
> <a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
><br>
<br>
<br>
<br>
--<br>
Regards,<br>
Siva<br>
Vtiger<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150128/270990d9/attachment-0001.html" target="_blank">http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150128/270990d9/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 5<br>
Date: Wed, 28 Jan 2015 10:30:02 +0530<br>
From: Uma S <<a href="mailto:uma.s@vtiger.com" target="_blank">uma.s@vtiger.com</a>><br>
To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br>
Subject: Re: [Vtigercrm-developers] Create entity with vtlib?<br>
Message-ID:<br>
<CAH83UoJ=<a href="mailto:PS6hHf-7Uh-PyJHMGb7081TnOJNe-N4Roeni51WL0g@mail.gmail.com" target="_blank">PS6hHf-7Uh-PyJHMGb7081TnOJNe-N4Roeni51WL0g@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi,<br>
<br>
Hope this Server API's<br>
<<a href="https://community.vtiger.com/help/vtigercrm/developers/server-apis.html" target="_blank">https://community.vtiger.com/help/vtigercrm/developers/server-apis.html</a>><br>
might help you to meet your requirements.<br>
<br>
On Wed, Jan 28, 2015 at 7:15 AM, Richard Hills - Technologywise <<br>
<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>> wrote:<br>
<br>
> I have created a custom module for 6.1 which is a re-creation of a module<br>
> in our previous 5.4 installation.<br>
><br>
> Basically I want to query the old tables and recreate the entities after a<br>
> migration. Can someone show me a basic snippet of entity creation with<br>
> vtlib (maybe I am meant to use vtws..)?<br>
><br>
> Thought I would find this on the wiki but had no luck, sorry if this has<br>
> been covered 100x before.<br>
><br>
> Thanks<br>
><br>
> --<br>
> Richard Hills<br>
> TechnologyWise Ltd, Tauranga, NZ<br>
> <a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a><br>
> <a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a><br>
> ph: <a href="tel:%2B64%20%280%297%20571%201060" value="+6475711060" target="_blank">+64 (0)7 571 1060</a><br>
> fax: <a href="tel:%2B64%20%280%297%20571%201061" value="+6475711061" target="_blank">+64 (0)7 571 1061</a><br>
><br>
> _______________________________________________<br>
> <a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
><br>
<br>
<br>
<br>
--<br>
With<br>
Best Regards<br>
Uma.S<br>
Vtiger Team<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150128/e196ac0a/attachment-0001.html" target="_blank">http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150128/e196ac0a/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 6<br>
Date: Wed, 28 Jan 2015 10:34:39 +0530<br>
From: Uma S <<a href="mailto:uma.s@vtiger.com" target="_blank">uma.s@vtiger.com</a>><br>
To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br>
Subject: Re: [Vtigercrm-developers] Custom UItype (upload file field)<br>
working well except on Calendar/Events<br>
Message-ID:<br>
<<a href="mailto:CAH83UoKVpxRN0uEHx6gKtc0pJykZ4%2B3Sc%2BdC0ZjkMSdA7UKB1w@mail.gmail.com" target="_blank">CAH83UoKVpxRN0uEHx6gKtc0pJykZ4+3Sc+dC0ZjkMSdA7UKB1w@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi,<br>
<br>
You need to debug at record structure level to check, what is the field<br>
model that's getting generated for this custom field? That will provide a<br>
clue regarding this issue.<br>
<br>
On Tue, Jan 27, 2015 at 7:18 PM, apcloic <<a href="mailto:apcloic@gmail.com" target="_blank">apcloic@gmail.com</a>> wrote:<br>
<br>
> Hi,<br>
><br>
> Using the following forum contribution (with some little mods. to make it<br>
> work) I've been able to create a new UItype 201 for file upload/attachment.<br>
><br>
> <a href="https://discussions.vtiger.com/index.php?p=/discussion/168409/vtiger-6-custom-upload-file-field-mod/p1" target="_blank">https://discussions.vtiger.com/index.php?p=/discussion/168409/vtiger-6-custom-upload-file-field-mod/p1</a><br>
><br>
> It works very well on any module but not on calendar/event module, my<br>
> custom<br>
> field (added with vtlib but same results when adding it via GUI) appears as<br>
> simple text field instead of file upload field.<br>
><br>
> I've checked vtiger_fields and vtiger_activity tables, all seems OK and my<br>
> custom file upload field looks like all other UItype 201 fields.<br>
><br>
> Any reason why Calendar/Events modules don't find my custom UItype like<br>
> other do ?<br>
><br>
> Regards,<br>
><br>
><br>
><br>
><br>
><br>
> --<br>
> View this message in context:<br>
> <a href="http://vtiger-crm.2324883.n4.nabble.com/Custom-UItype-upload-file-field-working-well-except-on-Calendar-Events-tp15047.html" target="_blank">http://vtiger-crm.2324883.n4.nabble.com/Custom-UItype-upload-file-field-working-well-except-on-Calendar-Events-tp15047.html</a><br>
> Sent from the vtigercrm-developers mailing list archive at Nabble.com.<br>
> _______________________________________________<br>
> <a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
><br>
<br>
<br>
<br>
--<br>
With<br>
Best Regards<br>
Uma.S<br>
Vtiger Team<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150128/29788b1c/attachment-0001.html" target="_blank">http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150128/29788b1c/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 7<br>
Date: Wed, 28 Jan 2015 00:08:57 -0800 (PST)<br>
From: apcloic <<a href="mailto:apcloic@gmail.com" target="_blank">apcloic@gmail.com</a>><br>
To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br>
Subject: Re: [Vtigercrm-developers] Custom UItype (upload file field)<br>
working well except on Calendar/Events<br>
Message-ID: <<a href="mailto:1422432537094-15057.post@n4.nabble.com" target="_blank">1422432537094-15057.post@n4.nabble.com</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
Hi Uma,<br>
<br>
Here's the model field :<br>
<br>
/**<br>
* Function to get the Template name for the current UI Type object<br>
* @return <String> - Template Name<br>
*/<br>
public function getTemplateName() {<br>
return 'uitypes/FileField.tpl';<br>
}<br>
<br>
/**<br>
* Function to get the Display Value, for the current field type with given<br>
DB Insert Value<br>
* @param <String> $value<br>
* @param <Integer> $recordId<br>
* @param <Vtiger_Record_Model><br>
* @return <String><br>
*/<br>
public function getDisplayValue($value, $recordId, $recordModel = false) {<br>
$moduleName = $this->get('field')->getModule()->getName();<br>
if(!$recordModel) {<br>
$recordModel = Vtiger_Record_Model::getInstanceById($recordId,<br>
$moduleName);<br>
}<br>
<br>
if($recordModel) {<br>
if(!empty($value)) {<br>
$db = PearDatabase::getInstance();<br>
$fileIdRes = $db->pquery('SELECT <a href="http://vtiger_attachments.name" target="_blank">vtiger_attachments.name</a> FROM<br>
vtiger_attachments<br>
WHERE vtiger_attachments.attachmentsid=?', array($value));<br>
//$fileId = $db->query_result($fileIdRes, 0, 'attachmentsid');<br>
//if($fileId){<br>
$value = ' '.$db->query_result($fileIdRes, 0, 'name').'<br>
<index.php?module='.$moduleName.'&action=DownloadFile&record='.$recordId.'&fileid='.$value.'><br>
';<br>
//}<br>
}<br>
}<br>
return $value;<br>
<br>
File.php <<a href="http://vtiger-crm.2324883.n4.nabble.com/file/n15057/File.php" target="_blank">http://vtiger-crm.2324883.n4.nabble.com/file/n15057/File.php</a>><br>
<br>
Thanks ;)<br>
Regards,<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://vtiger-crm.2324883.n4.nabble.com/Custom-UItype-upload-file-field-working-well-except-on-Calendar-Events-tp15047p15057.html" target="_blank">http://vtiger-crm.2324883.n4.nabble.com/Custom-UItype-upload-file-field-working-well-except-on-Calendar-Events-tp15047p15057.html</a><br>
Sent from the vtigercrm-developers mailing list archive at Nabble.com.<br>
<br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
vtigercrm-developers mailing list<br>
<a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br>
<a href="http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers" target="_blank">http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers</a><br>
<br>
<br>
End of vtigercrm-developers Digest, Vol 108, Issue 71<br>
*****************************************************<br>
</blockquote></div><br></div></div></div>