Sedang Disiapkan

ajax csv import

I would like a webpage that can import csv files and fixed width files using a format definition (see below).

The user can select a file, it is that echod back into a textarea or paste csv straight into text area.

It should use the right format definition below to convert into correct fields/format (sql field format)

After find a correct format send the data to the server using ajax (send 500 records at once),

i no format found then send plain data into other table (optional)

I added a htm file that parses the csv file already. only converting to destination format needs to be coded.

it is not a difficult design, will take 1-2 days i estimate.

// filedef: ['formatname']= "[sepchar],fielddef[,fielddef]]";

// fielddef: importfieldname[:xx]:datatype:newfieldname

// xx= is fixed fieldsize

// datatype= ['string','date','float']

// every csv value is checked against a datatype, maxlength

// make a function for every datatype that convert the value to the destination format (sql format)

var aFormats= new Array()

// Example of postbank format (only first 2 fields implemented)

aFormats["postbank_csv"]= ",,datum:date:docdate,naamomschrijving:string:description,rekening,tegenrekening,code,afbij,bedrag(eur),mutatiesoort,mededelingen";

if you hv any questions let me know,

hope to get a good offer, in the future it needs to be updated with different formats.

regards,

Niek

Kemahiran: AJAX, HTML, jQuery / Prototaip, PHP

Lihat lebih lanjut: ajax csv, ajax csv import, import csv ajax, ajax datatype csv, sql get date, php ajax sql, definition of format, definition format, using ajax, sql import, import sql, import csv, float, csv import, correct csv, converting files format, convert to ajax, import data csv sql server, sql server import text, php text array, string float, text file import sql server, php table array, string find, php table csv

Tentang Majikan:
( 13 ulasan ) Eindhoven, Netherlands

ID Projek: #1551181

Dianugerahkan kepada:

FreeAl

Hello, I can make it with good level of quality

€55 EUR dalam 2 hari
(12 Ulasan)
4.3

15 freelancers are bidding on average €164 for this job

lightcresent

Got Expertise in doing this sort of stuff... All payments through Milestone Payment (Escrow)... Online 16 Hours a day, Can start right away.. Thanks

€165 EUR dalam 2 hari
(433 Ulasan)
8.8
toinnisfree

pls chk pmb

€185 EUR dalam 3 hari
(523 Ulasan)
7.8
buraqtech

Check your PMB for details!!!

€150 EUR dalam 3 hari
(60 Ulasan)
7.5
cygital

Let me do it for you.

€150 EUR dalam 3 hari
(35 Ulasan)
6.0
MustafaSR

Hello Sir, Please check pmb

€120 EUR dalam 3 hari
(65 Ulasan)
5.5
stefanache

Hello, Please see PMB. Thanks.

€150 EUR dalam 5 hari
(16 Ulasan)
4.8
devloperIT

ajax/mysql experienced

€200 EUR dalam 2 hari
(13 Ulasan)
4.4
ITNova

Hi, I've done all these things in a stock portfolio management project. It could be completed elegantly with html5 file api and json api. Thanks

€99 EUR dalam 3 hari
(1 Ulasan)
4.2
lukepl

Hi, I'd like to do this job for you. Please see my private message.

€100 EUR dalam 3 hari
(6 Ulasan)
3.4
softaic

Hi Sir. I have rich experiences enough to do this and so i think i can complete this only for a day. I'll wait for your reply. Thanks. ahn

€30 EUR dalam sehari
(3 Ulasan)
3.0
elishashimon

PLEASE CHECK PMB

€220 EUR dalam 4 hari
(0 Ulasan)
0.0
elishaparmar

PLEASE CHECK PMB

€220 EUR dalam 5 hari
(0 Ulasan)
0.0
husnainali

i can do this work

€200 EUR dalam 5 hari
(2 Ulasan)
0.0
devfl

Hi, Please check your PM Thanks

€150 EUR dalam 2 hari
(0 Ulasan)
0.0
agilanr17

I can implement the YII php framework in this project and it makes your performance very fast and the website become very light to handle requests. And also can use java script libraries and css3 to make the user inter Lagi

€300 EUR dalam 21 hari
(0 Ulasan)
0.0