Problem in Load lead file of excel format

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Problem in Load lead file of excel format

Postby dhru10 » Mon Jun 02, 2014 12:47 am

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.
dhru10
 
Posts: 9
Joined: Thu May 29, 2014 7:09 am

Re: Problem in Load lead file of excel format

Postby striker » Sun Jun 08, 2014 11:04 am

www.striker24x7.com www.youtube.com/c/striker24x7 Telegram/skype id : striker24x7
striker
 
Posts: 962
Joined: Sun Jun 06, 2010 10:25 am

Re: Problem in Load lead file of excel format

Postby dhru10 » Mon Jun 09, 2014 12:17 am

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.
dhru10
 
Posts: 9
Joined: Thu May 29, 2014 7:09 am

Re: Problem in Load lead file of excel format

Postby striker » Mon Jun 09, 2014 1:35 am

once you filled that CSV file click the save as and then select the file type as text tab delimated.
www.striker24x7.com www.youtube.com/c/striker24x7 Telegram/skype id : striker24x7
striker
 
Posts: 962
Joined: Sun Jun 06, 2010 10:25 am

Re: Problem in Load lead file of excel format

Postby dhru10 » Mon Jun 09, 2014 8:23 am

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?
dhru10
 
Posts: 9
Joined: Thu May 29, 2014 7:09 am

Re: Problem in Load lead file of excel format

Postby santhuarnold » Tue Jun 10, 2014 1:39 am

is that scratch installation or VICIbox installation??
ViciBox v.7.0.1| Asterisk 11.21.0-vici | VERSION: 2.12-546a | BUILD: 160328-0316
santhuarnold
 
Posts: 76
Joined: Mon Sep 02, 2013 7:32 am

Re: Problem in Load lead file of excel format

Postby williamconley » Tue Jun 10, 2014 1:46 am

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.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Problem in Load lead file of excel format

Postby dhru10 » Tue Jun 10, 2014 2:47 am

santhuarnold wrote:is that scratch installation or VICIbox installation??


it is a scratch installation.
dhru10
 
Posts: 9
Joined: Thu May 29, 2014 7:09 am

Re: Problem in Load lead file of excel format

Postby dhru10 » Tue Jun 10, 2014 2:50 am

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.
dhru10
 
Posts: 9
Joined: Thu May 29, 2014 7:09 am

Re: Problem in Load lead file of excel format

Postby santhuarnold » Tue Jun 10, 2014 6:27 am

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

Thanks
santhuarnold
ViciBox v.7.0.1| Asterisk 11.21.0-vici | VERSION: 2.12-546a | BUILD: 160328-0316
santhuarnold
 
Posts: 76
Joined: Mon Sep 02, 2013 7:32 am

Re: Problem in Load lead file of excel format

Postby dhru10 » Wed Jun 11, 2014 12:01 am

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?
dhru10
 
Posts: 9
Joined: Thu May 29, 2014 7:09 am

Re: Problem in Load lead file of excel format

Postby striker » Wed Jun 11, 2014 12:28 am

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
www.striker24x7.com www.youtube.com/c/striker24x7 Telegram/skype id : striker24x7
striker
 
Posts: 962
Joined: Sun Jun 06, 2010 10:25 am

Re: Problem solved thanks striker

Postby dhru10 » Wed Jun 11, 2014 8:33 am

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

Thank you so much striker
dhru10
 
Posts: 9
Joined: Thu May 29, 2014 7:09 am

Re: Problem in Load lead file of excel format

Postby BAMF » Thu Jul 14, 2016 5:24 pm

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
BAMF
 
Posts: 1
Joined: Thu Jul 14, 2016 5:09 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 41 guests