Problem in Load lead file of excel format

[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.

[striker]

check the below link
http://striker24x7.blogspot.in/2012/03/vicidialgoautodial-lead-format-sample.html

[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.

[striker]

once you filled that CSV file click the save as and then select the file type as text tab delimated.

[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?

[santhuarnold]

is that scratch installation or VICIbox installation??

[williamconley]

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.

[dhru10]

is that scratch installation or VICIbox installation??

it is a scratch installation.

[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?

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.

[santhuarnold]

File layout to use: Select "Custom Layout " and submit.
you will get custom lead upload format.

Thanks
santhuarnold

[dhru10]

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?

[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

[dhru10]

Problem has been solved .
there were missing CPAN module like Spreadsheet::ParseExcel and Text::CSV.

Thank you so much striker

[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