Concluído

Excel data import into WHMCS MySQL db

Looking to get this done ASAP,

I have an excel sheet with data in it:

1) customers informations = ID#, name, number, email, address, company, etc... some also include additional contacts within each customer's account.

2) notes recorded on all accounts = all notes have date and time stamp, and i'd like to import the notes to each correct customers account.

customers have ID numbers, each note recorded under a specific customer's account, it's assigned the same ID number.

If we can import the ID numbers, it would be great, if we can't or if it will cause issues when creating new customers in WHMCS MySQL db, then it's ok, we can ignore importing the IDs, however i still need the notes imported to the correct customers accounts accordingly.

attached is a sample excel sheet with 2 pages, first page shows a sample notes page, 2nd page shows sample customers data, all data in the excel sheet is fake, i just created it for the purpose of providing an example to everyone.

This project will have to be done ONLY on my own computer using TeamViewer or similar remote access, as the data has a lot of private customer data, so it will not be sent to anyone under any condition.

Budget assigned is just to get the project started, please bid what you think the project is worth to you, and how quickly you can deliver the results.

thank you

Habilidades: Administração de Bancos de Dados, Excel, MySQL, Arquitetura de software, WHMCS

Veja mais: whmcs database server, whmcs importassist, whmcs ecommerce, whmcs import assist, whmcs files, configure whmcs, whmcs whm import, client whmcs, excel 2003 data import mysql, excel data import template, php class import excel data mysql, uploading excel data via php mysql, import excel data mysql using php, excel data import virtuemart, excel data import microsoft dynamics, php import excel data mysql foreign keys, import excel data mysql via php, excel data import access crosstab queries, excel data import virtumart, import csv mysql db script perl php

Acerca do Empregador:
( 24 comentários ) Edmonton, Canada

ID do Projeto: #18431127

Concedido a:

iwebsynthesis

Hi there, My name is Atul. I have read your brief and can see that you would like to import client data from excel file into WHMCS client table. I have been working in WHMCS since last 6+ years and in PHP since la Mais

$70 CAD em 1 dia
(148 Comentários)
6.8

7 freelancers estão ofertando em média $50 para esse trabalho

rsm0128

Hi samimetro, I'm very familiar with Excel macro and SQL. I think this the the thing I can assist you. We can discuss in more detail and I can start right away Thanks, Chengmin

$50 CAD em 1 dia
(14 Comentários)
7.0
kosal1015

Hi, I have a good skills and experiences in data processing and mysql. I have 7 years of development experiences. I can complete this job in a short time and I think you will be happy. Please contact me. Looking f Mais

$35 CAD em 1 dia
(16 Comentários)
4.3
BHARATBEURA

Hello, Myself Bharat. I’ve read your project details & can see that you’d like to have a Virtual Assistant for your day-to-day business activities. I have been working as a full-time freelancer (Virtual Assistant) sinc Mais

$30 CAD em 1 dia
(19 Comentários)
4.3
brobb07

1. Excel expert with extensive vba programming experience. I can code a module that will allow you to update your accounts with some notes. What I would do is solution it out on my machine with your sample data then Mais

$83 CAD in 3 dias
(1 Comentário)
3.8
israelmoralesDEV

Good day, i can do this project for you, as you would like to be done, but first, convert this files to sql its possible, maybe even automate the process and it might not take too long, but to import to the database, Mais

$30 CAD em 1 dia
(1 Comentário)
1.2
rjlfurtado

Hello, how are you? I looked for you project and I'm sure I can complete this job perfectly. because I am highly capable for development with whmcs. I am available at this time to discuss more details about your projec Mais

$50 CAD in 3 dias
(0 Comentários)
0.0