Excel data import into WHMCS MySQL db

เสร็จสมบูรณ์ โพสต์แล้ว 5 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
เสร็จสมบูรณ์ ชำระเงินเมื่อจัดส่ง

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

การบริหารฐานข้อมูล Excel MySQL สถาปัตยกรรมซอฟต์แวร์ WHMCS

หมายเลขโปรเจค: #18431127

เกี่ยวกับโปรเจกต์

5 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

มอบให้กับ:

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 เพิ่มเติม

$70 CAD ใน 1 วัน
(154 รีวิว)
7.0

freelancer 5 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $53

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 เพิ่มเติม

$30 CAD ใน 1 วัน
(31 รีวิว)
5.0
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 เพิ่มเติม

$83 CAD ใน 3 วัน
(1 รีวิว)
3.8
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 เพิ่มเติม

$50 CAD ใน 3 วัน
(1 รีวิว)
3.1
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, เพิ่มเติม

$30 CAD ใน 1 วัน
(1 รีวิว)
1.3