Page 1 of 1

Problem in Load lead file of excel format

PostPosted: Mon Jun 02, 2014 12:47 am
by dhru10
hello everyone,
As i am new to vicidial facing problem while loading leads file (excel file with different versions).
so anyone can help me out with what are the suitable versions for lead files in excel format.
my vicidial version is 2.8-51 and build 130824-2322

and also when I upload lead files(excel format) with all required fields it shows an error every time - ERROR-the file does not have the required number of fields to process it.but when i upload same file with .CSV format it loads all lead successfully.
can anyone have idea about this what is going wrong?

Thanks.

Re: Problem in Load lead file of excel format

PostPosted: Sun Jun 08, 2014 11:04 am
by striker

Re: Problem in Load lead file of excel format

PostPosted: Mon Jun 09, 2014 12:17 am
by dhru10
Thank you striker for reply.
I used this format earliar but it cant parse lead file successfully.
after uploading file and submiting it redirects at next page and showing text like this..

Processing XLS: MS Excel 2000-XP file... (OR)
Processing XLSX: MS Excel 2007+ file...
LIST ID OVERRIDE FOR THIS FILE: 101
PHONE CODE OVERRIDE FOR THIS FILE: 1

but when I need to select lead file fields from drop down like-first name ,last name,etc...they are blank("").
parser cant find appropriate matching fields from file.

Re: Problem in Load lead file of excel format

PostPosted: Mon Jun 09, 2014 1:35 am
by striker
once you filled that CSV file click the save as and then select the file type as text tab delimated.

Re: Problem in Load lead file of excel format

PostPosted: Mon Jun 09, 2014 8:23 am
by dhru10
problem is not with .csv format but i need to upload excel files then how should i proceed?
Do i need to follow exact file structure as per format?
OR which are all mandatory fields?

Re: Problem in Load lead file of excel format

PostPosted: Tue Jun 10, 2014 1:39 am
by santhuarnold
is that scratch installation or VICIbox installation??

Re: Problem in Load lead file of excel format

PostPosted: Tue Jun 10, 2014 1:46 am
by williamconley
dhru10 wrote:problem is not with .csv format but i need to upload excel files then how should i proceed?
Do i need to follow exact file structure as per format?
OR which are all mandatory fields?

You should proceed by converting to tab delimited and using the exact column format for "standard". Once that works, you know your system works and you can work out other options later.

Re: Problem in Load lead file of excel format

PostPosted: Tue Jun 10, 2014 2:47 am
by dhru10
santhuarnold wrote:is that scratch installation or VICIbox installation??


it is a scratch installation.

Re: Problem in Load lead file of excel format

PostPosted: Tue Jun 10, 2014 2:50 am
by dhru10
williamconley wrote:
dhru10 wrote:problem is not with .csv format but i need to upload excel files then how should i proceed?
Do i need to follow exact file structure as per format?
OR which are all mandatory fields?

You should proceed by converting to tab delimited and using the exact column format for "standard". Once that works, you know your system works and you can work out other options later.

tab delimited data is working properly but when i convert it into .xls format then it wont work.

Re: Problem in Load lead file of excel format

PostPosted: Tue Jun 10, 2014 6:27 am
by santhuarnold
File layout to use: Select "Custom Layout " and submit.
you will get custom lead upload format.

Thanks
santhuarnold

Re: Problem in Load lead file of excel format

PostPosted: Wed Jun 11, 2014 12:01 am
by dhru10
santhuarnold wrote:File layout to use: Select "Custom Layout " and submit.
you will get custom lead upload format.

Thanks
santhuarnold


Actually after selecting custom layout page is redirect but there is option in all dropdowns are:- "".
is this a CPAN module problem or else?

Re: Problem in Load lead file of excel format

PostPosted: Wed Jun 11, 2014 12:28 am
by striker
which scratch installation document you used to install..?


make sure you have installed below CPAN modules
- install Unicode::Map (needed for super list loader Excel)
- install Jcode (needed for super list loader Excel)
- install Spreadsheet::WriteExcel (needed for super list loader Excel)
- install OLE::Storage_Lite (needed for super list loader Excel)
- install Proc::ProcessTable (needed for super list loader Excel)
- install IO::Scalar (needed for super list loader Excel)
- install Spreadsheet::ParseExcel (needed for super list loader Excel)
ref: http://www.eflo.net/files/vicidialfromscratch.pdf

Re: Problem solved thanks striker

PostPosted: Wed Jun 11, 2014 8:33 am
by dhru10
Problem has been solved .
there were missing CPAN module like Spreadsheet::ParseExcel and Text::CSV.

Thank you so much striker

Re: Problem in Load lead file of excel format

PostPosted: Thu Jul 14, 2016 5:24 pm
by BAMF
Hi All,
First Time here...

I am having the same problem when I tried to rename folders : agc and vicidial
I was just trying to make domain look like this : domain/dialer/welcome.php instead of domain/vicidial/welcome.php

All is working fine except when I tried to load leads. vicidial/admin_listloader_fourth_gen.php is just showing "" on file data fields when I tried to select from dropdown.

I revert back to naming folders back t agc and vicidial and it worked again.

All should be fine but my issue is I really want to rename agc and vicidial folders.

Does someone have Idea which php files I should edit to allow admin_listloader_fourth_gen.php work after renaming its directory?

Appreciate any advise. Thanks in advance