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