Mixing
vicidial lead loading issue with excel files
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?
excel vici
asked Jun 4 '14 at 5:09
DhrutenDhruten
8610
add a comment |
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?
excel vici
asked Jun 4 '14 at 5:09
DhrutenDhruten
8610
add a comment |
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?
excel vici
asked Jun 4 '14 at 5:09
DhrutenDhruten
8610
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?
excel vici
excel vici
asked Jun 4 '14 at 5:09
DhrutenDhruten
8610
asked Jun 4 '14 at 5:09
DhrutenDhruten
8610
asked Jun 4 '14 at 5:09
DhrutenDhruten
8610
asked Jun 4 '14 at 5:09
DhrutenDhruten
8610
asked Jun 4 '14 at 5:09
DhrutenDhruten
8610
8610
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
Vicidial generally doesn't like to deal with direct XLS files, it usually works a lot better with either CSV or tab delimited files. Excel tends to add a lot of extra formatting characters that throws it off.
answered Nov 25 '16 at 17:03
Ryan CoeRyan Coe
113
That doesn't matter. Vici converts both CSV and XLS files to tab delimetered TXT before processing them. There's a perl script it uses called sheet2tab.pl in it's main directory.
– PockeTiger
Dec 8 '16 at 14:49
add a comment |
We use Wombat that has a drag-and-drop interface for data uploading, but if your files are very large you'd be better off pushing them through an API.
edited May 9 '16 at 20:12
AlBlue
16k105377
answered Mar 27 '15 at 7:48
user1986421user1986421
111
add a comment |
Do a "Save As" for your excel file as a Text (MS-DOS) format and upload. And When you want to edit the text file you created do a "open with" excel.
The columns you may want to have in your .xlsx excel file and .txt text file.
lead_id entry_date
modify_date
status NEW
user VDAD
vendor_lead_code
source_id
list_id 6876
gmt_offset_now -4
called_since_last_reset Y
phone_code 1
phone_number 4563214667
title
first_name John
middle_initial
last_name Due
address1 34 BN Street
address2
address3
city Baltimore
state MD
province
postal_code 80002
country_code
gender
date_of_birth 0000-00-00
alt_phone
email
security_phrase
comments
called_count 1
last_local_call_time
rank 0
owner
entry_list_id 0
answered Jan 1 at 13:55
Anupam RekhaAnupam Rekha
907
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f24029466%2fvicidial-lead-loading-issue-with-excel-files%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Vicidial generally doesn't like to deal with direct XLS files, it usually works a lot better with either CSV or tab delimited files. Excel tends to add a lot of extra formatting characters that throws it off.
answered Nov 25 '16 at 17:03
Ryan CoeRyan Coe
113
That doesn't matter. Vici converts both CSV and XLS files to tab delimetered TXT before processing them. There's a perl script it uses called sheet2tab.pl in it's main directory.
– PockeTiger
Dec 8 '16 at 14:49
add a comment |
Vicidial generally doesn't like to deal with direct XLS files, it usually works a lot better with either CSV or tab delimited files. Excel tends to add a lot of extra formatting characters that throws it off.
answered Nov 25 '16 at 17:03
Ryan CoeRyan Coe
113
That doesn't matter. Vici converts both CSV and XLS files to tab delimetered TXT before processing them. There's a perl script it uses called sheet2tab.pl in it's main directory.
– PockeTiger
Dec 8 '16 at 14:49
add a comment |
Vicidial generally doesn't like to deal with direct XLS files, it usually works a lot better with either CSV or tab delimited files. Excel tends to add a lot of extra formatting characters that throws it off.
answered Nov 25 '16 at 17:03
Ryan CoeRyan Coe
113
Vicidial generally doesn't like to deal with direct XLS files, it usually works a lot better with either CSV or tab delimited files. Excel tends to add a lot of extra formatting characters that throws it off.
answered Nov 25 '16 at 17:03
Ryan CoeRyan Coe
113
answered Nov 25 '16 at 17:03
Ryan CoeRyan Coe
113
answered Nov 25 '16 at 17:03
Ryan CoeRyan Coe
113
answered Nov 25 '16 at 17:03
Ryan CoeRyan Coe
113
113
That doesn't matter. Vici converts both CSV and XLS files to tab delimetered TXT before processing them. There's a perl script it uses called sheet2tab.pl in it's main directory.
– PockeTiger
Dec 8 '16 at 14:49
add a comment |
That doesn't matter. Vici converts both CSV and XLS files to tab delimetered TXT before processing them. There's a perl script it uses called sheet2tab.pl in it's main directory.
– PockeTiger
Dec 8 '16 at 14:49
That doesn't matter. Vici converts both CSV and XLS files to tab delimetered TXT before processing them. There's a perl script it uses called sheet2tab.pl in it's main directory.
– PockeTiger
Dec 8 '16 at 14:49
That doesn't matter. Vici converts both CSV and XLS files to tab delimetered TXT before processing them. There's a perl script it uses called sheet2tab.pl in it's main directory.
– PockeTiger
Dec 8 '16 at 14:49
add a comment |
We use Wombat that has a drag-and-drop interface for data uploading, but if your files are very large you'd be better off pushing them through an API.
edited May 9 '16 at 20:12
AlBlue
16k105377
answered Mar 27 '15 at 7:48
user1986421user1986421
111
add a comment |
We use Wombat that has a drag-and-drop interface for data uploading, but if your files are very large you'd be better off pushing them through an API.
edited May 9 '16 at 20:12
AlBlue
16k105377
answered Mar 27 '15 at 7:48
user1986421user1986421
111
add a comment |
We use Wombat that has a drag-and-drop interface for data uploading, but if your files are very large you'd be better off pushing them through an API.
edited May 9 '16 at 20:12
AlBlue
16k105377
answered Mar 27 '15 at 7:48
user1986421user1986421
111
We use Wombat that has a drag-and-drop interface for data uploading, but if your files are very large you'd be better off pushing them through an API.
edited May 9 '16 at 20:12
AlBlue
16k105377
answered Mar 27 '15 at 7:48
user1986421user1986421
111
edited May 9 '16 at 20:12
AlBlue
16k105377
edited May 9 '16 at 20:12
AlBlue
16k105377
edited May 9 '16 at 20:12
AlBlue
16k105377
16k105377
answered Mar 27 '15 at 7:48
user1986421user1986421
111
answered Mar 27 '15 at 7:48
user1986421user1986421
111
answered Mar 27 '15 at 7:48
user1986421user1986421
111
111
add a comment |
add a comment |
Do a "Save As" for your excel file as a Text (MS-DOS) format and upload. And When you want to edit the text file you created do a "open with" excel.
The columns you may want to have in your .xlsx excel file and .txt text file.
lead_id entry_date
modify_date
status NEW
user VDAD
vendor_lead_code
source_id
list_id 6876
gmt_offset_now -4
called_since_last_reset Y
phone_code 1
phone_number 4563214667
title
first_name John
middle_initial
last_name Due
address1 34 BN Street
address2
address3
city Baltimore
state MD
province
postal_code 80002
country_code
gender
date_of_birth 0000-00-00
alt_phone
email
security_phrase
comments
called_count 1
last_local_call_time
rank 0
owner
entry_list_id 0
answered Jan 1 at 13:55
Anupam RekhaAnupam Rekha
907
add a comment |
Do a "Save As" for your excel file as a Text (MS-DOS) format and upload. And When you want to edit the text file you created do a "open with" excel.
The columns you may want to have in your .xlsx excel file and .txt text file.
lead_id entry_date
modify_date
status NEW
user VDAD
vendor_lead_code
source_id
list_id 6876
gmt_offset_now -4
called_since_last_reset Y
phone_code 1
phone_number 4563214667
title
first_name John
middle_initial
last_name Due
address1 34 BN Street
address2
address3
city Baltimore
state MD
province
postal_code 80002
country_code
gender
date_of_birth 0000-00-00
alt_phone
email
security_phrase
comments
called_count 1
last_local_call_time
rank 0
owner
entry_list_id 0
answered Jan 1 at 13:55
Anupam RekhaAnupam Rekha
907
add a comment |
Do a "Save As" for your excel file as a Text (MS-DOS) format and upload. And When you want to edit the text file you created do a "open with" excel.
The columns you may want to have in your .xlsx excel file and .txt text file.
lead_id entry_date
modify_date
status NEW
user VDAD
vendor_lead_code
source_id
list_id 6876
gmt_offset_now -4
called_since_last_reset Y
phone_code 1
phone_number 4563214667
title
first_name John
middle_initial
last_name Due
address1 34 BN Street
address2
address3
city Baltimore
state MD
province
postal_code 80002
country_code
gender
date_of_birth 0000-00-00
alt_phone
email
security_phrase
comments
called_count 1
last_local_call_time
rank 0
owner
entry_list_id 0
answered Jan 1 at 13:55
Anupam RekhaAnupam Rekha
907
Do a "Save As" for your excel file as a Text (MS-DOS) format and upload. And When you want to edit the text file you created do a "open with" excel.
The columns you may want to have in your .xlsx excel file and .txt text file.
lead_id entry_date
modify_date
status NEW
user VDAD
vendor_lead_code
source_id
list_id 6876
gmt_offset_now -4
called_since_last_reset Y
phone_code 1
phone_number 4563214667
title
first_name John
middle_initial
last_name Due
address1 34 BN Street
address2
address3
city Baltimore
state MD
province
postal_code 80002
country_code
gender
date_of_birth 0000-00-00
alt_phone
email
security_phrase
comments
called_count 1
last_local_call_time
rank 0
owner
entry_list_id 0
answered Jan 1 at 13:55
Anupam RekhaAnupam Rekha
907
edited Jan 1 at 14:07
answered Jan 1 at 13:55
Anupam RekhaAnupam Rekha
907
answered Jan 1 at 13:55
Anupam RekhaAnupam Rekha
907
answered Jan 1 at 13:55
Anupam RekhaAnupam Rekha
907
907
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f24029466%2fvicidial-lead-loading-issue-with-excel-files%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
