Cancelled

Script Cron - Access to MySQL

Hi!

I need to have an access script or any script that could take the data of 1 mdb file into SQL or CSV.

There is 30 fields to transfer. Most of them are as it is and

Field to convert:

"Name" need to combine 3 fields from mdb (First Name "Space" Last Name "Space" Provider)

"Country" blank field must be replaced by "Switzerland"

"Customer No" must be converted with no spaces

"Option" must be converted as this exemple: "01" = "Full Pack" - "02" = "Medium Pack" - "A1" = "Small pack" - "1B" = "Minimum Pack"

"Contract Date" must be converted into Unix timestamp

"Amount" must be converted without the ".-" sign

"Hardware" must be converted as this exemple: "04" = "Full Equipment" - "05" = "Medium Equipment" - "A2" = "Small Equipment" - "2B" = "Minimum Equipment"

"Exp Date" must be converted from dd/mm/aaaa to mm/aa

"Card" must convert only the 4 last digits

"CardType" must convert card that start by 4 as "Visa" and 5 by "Mastercard"

"DDSort" must convert last 2 digits

"DD Account" must convert last 2 digits

Full description will be giving away one project accepted.

This needs to be setup as Cron so I can upload the database manually or automaticly from a Windows environnement to a remote MySQL server. (Which ever is the most practical)

Skills: Engineering, Microsoft Access, MySQL, PHP, Shell Script

See more: remote php contract, sign blank, access to sql, sql server convert mysql, remote access setup, project 2013 access, equipment database sql, converted mysql, sql mdb, setup mysql server, convert access access 2013, mysql date field, mysql combine, sql server access file upload, transfer mdb mysql, equipment access database, convert mdb access 2013, 2013 mdb convert, convert access database 2013, cron mysql, remote access mysql, convert mdb 2013, php sql script project, contract database access, convert access mdb access 2013

About the Employer:
( 6 reviews ) 1202, Switzerland

Project ID: #4494889

39 freelancers are bidding on average $125 for this job

codegur

Check PMB for Details.

$175 USD in 5 days
(212 Reviews)
7.5
DesignSolutionSW

Hello There!Please check PM.Thanks.

$262 USD in 7 days
(60 Reviews)
7.0
zeke

Available to start immediately and finish as soon as possible.

$154 USD in 1 day
(146 Reviews)
6.8
SEugeneV

will be done with the best quality

$165 USD in 3 days
(234 Reviews)
6.6
rhomeu

MS Access expert here. We can create the script in MS Access. Probably have a single and an export button to export the data into a CSV file. I have done a lot of MS Access projects here in freelance. Please see my pro More

$165 USD in 1 day
(40 Reviews)
6.5
cheapexcell

Please see PMB

$99 USD in 3 days
(127 Reviews)
6.0
gangabass

I have done several projects like this that's why I'm sure you'll be impressed with my work. See PM for details.

$103 USD in 1 day
(117 Reviews)
5.7
scriptphp87

Hello Please read more than private message thank you

$154 USD in 3 days
(46 Reviews)
5.7
pablotorres

i can do it

$55 USD in 7 days
(67 Reviews)
5.4
winghei

Hi, Please check my profile and your private message :)

$45 USD in 3 days
(29 Reviews)
5.3
newzonetechsl

Please check private message board for detail, thank you.

$236 USD in 7 days
(13 Reviews)
5.2
caneadysl

>>>>>CAN DELIVER WHAT YOU LOOKING FOR AS IT IS.....CHECK FOR PM ME SIR

$115 USD in 3 days
(32 Reviews)
5.1
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards winnet21

$110 USD in 3 days
(18 Reviews)
5.1
abhius

====== Hello Sir, Gone through the bid description. Ready to start. =====

$130 USD in 4 days
(40 Reviews)
5.1
farhaoui

HI, READY TO START WORK. LETS START AND FINISH IT ASAP. I HAVE 8 YEARS OF EXPERIENCE IN WEB DEVELOPMENT FIELD ( PHP, MYSQL, AJAX, JQUERY, HTML, CSS... ). THANK YOU !!

$63 USD in 3 days
(47 Reviews)
4.8
jaisnikhil

HI There! Ready to start now. Thanks

$105 USD in 3 days
(27 Reviews)
4.8
Voyageinfo

Dear Sir, We are in TOP 1000 among 70000000 freelancer in the world please check PMB. Thanks Voyage Team

$309 USD in 20 days
(13 Reviews)
4.8
techvolcano

Let start.

$64 USD in 5 days
(14 Reviews)
4.3
stevensow

Thanks & Best Regards, Sow

$60 USD in 3 days
(6 Reviews)
4.0
webdesignegor

hi. I'm sure I can do this fast.

$110 USD in 1 day
(3 Reviews)
3.6