Quick tutorial needed CSV->MYSQL, WIlling to pay

Wappler General How To
#1

I need a tutorial on the serverconnect setup needed to import this csv though a file upload to each line being placed into my database.

Download CSV here
http://isimrace.com/shared/eventresult_26072077.csv

I can get to where the file is uploaded to the host though an upload form and server connect but not passed that point. Happy to pay for your time I have put so much time into this its worth the help.

Thanks in advance.

#2

Hello, please check the following tutorial on DMXzone website:


It’s pretty much the same in Wappler.

#3

Thank you @Teodor that helped a ton.

I did have to remove the first three lines manually, could you tell me if there is a way to do that possibly? as the header of the csv is actually on the 4th line.

#4

Hello @plosey

You can do with wappler !
First step create temp database table then import all rows and read and write to new table

1 Like
#5

Thanks for the suggestion. Could you provide a step-by-step of how to do this. I’ve always used PHP to skip lines. If this can be done by Wappler, please, by all means, share your expertise. :blush: It would be a great time saver!

1 Like