Suoritettu

vtiger Import XLS files as Taks

Project Details :

Current Situation

a) We use vtiger crm, for Project Management.

b) 1 Project --> Many Tasks

c) Tasks are created by a 3rd software NOT VTIGER. Tasks are sent to us by email attachments as XLS files.

d) We then have to add every XLS task to Vtiger.

Currently, in order to import XLS files into Vtiger, we use the following procedure

1. We manually Open the XLS file

2. We Convert it to CSV file using Excel Macro

3. We Upload/Import it to vtiger (through an external simple PHP system created 5 years ago, one by one -)

In other words we created a PHP script which:

a)Allow us to upload the csv file (CSV file is generated using an EXCEL macro which converts XLS->CSV

b)Reads CSV's file data information eg "data1","data2","data3","data4" etc

c)Insert data into vtiger dabase, in order to create a new task

What we want:

1. We want to modify/create new system where we will be able to Upload/Import XLS file directly to vtiger (without any macros,modifications,etc) Keep in mind that ALL XLS tasks files have the same structure.

2. We want to upload MULTIPLE XLS files at once.

Thanks for watching

Taidot: Excel, MySQL, PHP, tietojärjestelmäarkkitehtuuri, vTiger

Näytä lisää: vtiger 7 import not working, vtiger import not working, vtiger 6 documentation, vtiger wiki, vtiger import contact csv, import xls files linux api, free vbs sample script import txt files xls, import as400 table using excel macro iseries driver, vtiger import big files, import xls files winfax, vtiger import contacts csv, vtiger import large files, import xls files mysql tutorial, import xls files mysql, csv vtiger import, import xls files corel, combine text files using excel macro, vtiger import csv, vtiger import database, import graphic files

Tietoa työnantajasta:
( 32 arvostelua ) Limassol, Cyprus

Projektin tunnus: #17080627

Myönnetty käyttäjälle:

radus28

Hi 1. Can you share each type of Excel file 2. Do you want to upload each type of file one after one or single attempt? Thanks Sutharsan Jeganathan

$277 USD 7 päivässä
(48 Arvostelua)
6.9

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

SigmaVisual

Hi, I have experience of working on similar projects, I can update your existing script so it can import data from excel directly. If you are not available now we can agree on timing to chat and discuss on the proje Lisää

$150 USD 3 päivässä
(276 arvostelua)
8.2
fabest

Here you can put your comment. This comment will be added with your bid. Please see doc file for more information

$222 USD 3 päivässä
(72 arvostelua)
7.2
auriclesoft09

Hi, We are confident that we can accomplish the project as per your requirement. You are requested to go through our Profile to know our domain knowledge and our Services. We have done lots of customization on vTig Lisää

$200 USD 3 päivässä
(34 arvostelua)
6.3
BIBINGK

Hi, Expert level VtigerCRM consultant & developer with 7+ years great industry experience in VtigerCRM itself. Please have a look at my profile and check the customer feedback: https://www.freelancer.com/u/BIBINGK Lisää

$294 USD 10 päivässä
(49 arvostelua)
6.5
TheArtist1

I am a vTiger Expert based in Montreal Canada with over 12 years of experience. I did many vTiger project with similar tasks: - I did UI design for both Vtiger and its Customer Portal. - I did build new modules, e Lisää

$250 USD 1 päivässä
(36 arvostelua)
5.7
hassanalvi95

Hi sir hope you are fine and doing good... I worked with xls apis in java and in C# before... I can make this system in max 2 to 3 days... I think I have understood this and I can do it easily... Thanks please let me k Lisää

$166 USD 5 päivässä
(17 arvostelua)
4.4
crmexpert001

Hello Sir / Ma'am, I am having 7 years of experience on vTiger, Sugarcrm. I am ready to show you number of demo of customised crm application. Also ready to give references of my clients Waiting for hearing from Lisää

$188 USD 7 päivässä
(14 arvostelua)
4.0
subhchaitali

Hi there, I’d like to be considered for your project. I’m a vtiger developer. For 7 years I’ve worked in development and so I am accustomed to working with all type of vtiger customization and integration . I hav Lisää

$155 USD 5 päivässä
(3 arvostelua)
3.0
tjcg

We are passionate team of developers. Till now we have competed in the local market and now we are hitting to the online market as we want to expose our skills and expertise to the another level. We have 6.5 years o Lisää

$161 USD 3 päivässä
(1 arvostelu)
2.6
voronkov

Hello, I have experience in PHP and Excel reading-writing, I use PHPExcel library for these goals. The project will be a webpage, the user chooses several Excel files from hard or network disks and will send its to Lisää

$222 USD 10 päivässä
(2 arvostelua)
2.5
$220 USD 3 päivässä
(3 arvostelua)
1.6
$35 USD 2 päivässä
(1 arvostelu)
0.0
skinduptruk

vbs could start an excel.visible=false instance to convert all xls in a folder to csv. from there FTP will upload multiple csv (or unzip on server folder) from there a single PHP webpage should be able to work th Lisää

$333 USD 33 päivässä
(0 arvostelua)
0.0