Fermé

Custom client import script for whmcs.

Welcome.

We'd like to ask about price of creation of 2 import scripts for whmcs database.

--------------------------

#1st script

We've created client group named NewClients in our whmcs. We'd like to import all clients data from mysql base (231 records)

ofcourse all of them should be as 'NewClients' client group, to our whmcs base.

There are columns:

user_name - account login - NOT NEEDED to import on this step

user_osoba - First Name

user_nazwa - company

user_ulica - street

user_kod - postcode

user_miasto - city

user_nazwa_poczta - NOT NEEDED, could this be imported as line in admin notes for this client?

user_ulica_poczta - NOT NEEDED, could this be imported as line in admin notes for this client?

user_kod_poczta - NOT NEEDED, could this be imported as line in admin notes for this client?

user_miasto_poczta - NOT NEEDED, could this be imported as line in admin notes for this client?

user_nr_sms - vat number - this should be imported to our custom client field called 'nip' it has number 2 on the list of custom fields

user_mail - contact e-mail to owner

password for client area - random

#1a - is there a possibility that NOT NEEDED data will be restored as admin notes for client record?

#1b - is there a possibility to sent client area welcome e-mail and area details reminder for all clients in this NewClients group? We just want to do

this couple days after whole import which shouldn't generate any mails/reminders to mails stored in user_mail.

--------------------------

#2nd script

There's second mysql base where are rows:

id - account login (same as user_name in 1st base)

package - package name - already created in our whmcs

price - price which should be imported to package (sometimes default price of package should be override by price from this row)

date - due date of account ( DD/MM/YYYY )

This script should create (directadmin as it is set in whmcs) package named 'package' with login account 'id'

overriding price with 'price' and setting up due date 'date', than bind whole package with proper user from NewClients group.

--------------------------

I could merge all those databases so all records will be in one base, such us account login and company name.

Or this could be don through 3rd script, run between 1st and the 2nd, which will take data from 1st base and search for client with proper company name' and than create some default package with login 'user_name'. Than 3rd script will only have to search database for proper account login,

and than it could import all data from 2nd base.

Compétences : Saisie de Données, Traitement de Données

en voir plus : mysql client import script, whmcs import clients, import clients whmcs, import whmcs database, import data whmcs, whmcs import, client account script, whmcs create database client, whmcs create import, import whmcs, script import data whmcs, whmcs data import script, 30 second scripts, 30 second script, import clients data whmcs, us vat number, mysql client, processing e-mails, mail client, import mysql

Concernant l'employeur :
( 0 commentaires ) Poland

Nº du projet : #1318294

4 freelance font une offre moyenne de $300 pour ce travail

muthumuni

Hi, I am very much interesting about this project. and I am expert for it too. So can you kindly see my review here and give me chance to work with this interesting project. Thank you. muthumuni.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)
3.1
conswayla11

I am currently a Administrative Assistant at a social service agency, and my job is to enter data into a excel and access database and provide client support and have to ensure all deadlines are met. I am a diligent a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
maheshsayani

Hi Sir, I will complete this task within the time period with quality delivery. Please give me this opportunity to prove my self.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
baveshsrisaran

iam ready to work your project, send me details thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)
0.0