(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Pushing Data to SQL?
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Pushing Data to SQL? (Read 793 times)
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Pushing Data to SQL?
Mar 12th, 2015 at 2:46pm
Print Post Print Post  
Hi all,

I have a manual process right now where we export a CSV file from Sesame's data, and run a table update using Navicat for our MySQL asterisk phone server.  It's tedious, and I'd love to automate it.  Is there a way to use @redirectprocess to do that?

Thanks,
Blair
  
Back to top
WWW WWW Twitter Twitter  
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Pushing Data to SQL?
Reply #1 - Mar 12th, 2015 at 4:38pm
Print Post Print Post  
Short answer? Yes. mySQL has a CLI that you can use to issue commands to the mySQL server.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Re: Pushing Data to SQL?
Reply #2 - Mar 13th, 2015 at 4:54pm
Print Post Print Post  
Hmmm ... I use a third party interface app called Navicat to do my updates through a GUI.  So if I build a redirectprocess command, I should build it like I'm running a CLI command through my Linux server running the SQL tables?
  
Back to top
WWW WWW Twitter Twitter  
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Pushing Data to SQL?
Reply #3 - Mar 13th, 2015 at 7:39pm
Print Post Print Post  
I'm not familiar with Navicat, but here's the documentation for the CLI.
http://dev.mysql.com/doc/refman/5.5/en/mysql.html
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge