mdc101 15 Posted November 27, 2013 Report Share Posted November 27, 2013 HI Guys I have been trying to figure out how to do you insert a .csv file into a database with the databse query command?This has me stumped.Could someone post a code sample here just to see how the loop works to create the insert statements for each row? Any help would be appreciated Regards Matt Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted November 27, 2013 Report Share Posted November 27, 2013 As far as I know you have to loop through the hole file. ie add csv to table and loop each row. sucks on big files. I know you can do from command line the hole file at once. You will have to search Google on that one you will find easy. This is for SQLite Plugin from Aymen. The DB commands from Ubot idk know to much about, this is what I know here http://wiki.ubotstudio.com/wiki/Database_Commands HTH,TC Quote Link to post Share on other sites
mdc101 15 Posted November 27, 2013 Author Report Share Posted November 27, 2013 Hi Thanks for the reponse. Now that UBot can connect to a database it has really caught my attention. It would be great if they can expand on making db commands more efficient so processes can easily be implemented so we can bulk move lots of data more easily.Loving where its going though Quote Link to post Share on other sites
blumi40 222 Posted November 28, 2013 Report Share Posted November 28, 2013 hii realy didnt see the problem...if u need a frequently query with fillup data to your database why u dont do a define with needet columns and placeholders for your data?same with get data....make a querytemplate as define and fill it up Quote Link to post Share on other sites
mdc101 15 Posted December 3, 2013 Author Report Share Posted December 3, 2013 HI Blumi40 Could you maybe provide an example? Quote Link to post Share on other sites
blumi40 222 Posted December 3, 2013 Report Share Posted December 3, 2013 mdc 101normal i try to be helpfull for all but to do a example means lot of work.i dont use a definetemplate for my selft because im fast with sql-statementsso i dont needet... but if u realy need help that would means for me explane u step by step what a template for sql doesso dont understand me wrong i dont wanna melk a cow but u have to spend some bucks for if u ready lemmy know Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.