Search found 41 matches

by Dave23
Thu Oct 19, 2017 12:36 pm
Forum: Flows
Topic: SQL to CSV
Replies: 7
Views: 6998

Re: SQL to CSV

Hi,
Is there a way to delete the first two rows of the log file that comes out? or disable it somehow?

Cheers
by Dave23
Thu Oct 19, 2017 11:59 am
Forum: Flows
Topic: Database connect - SQL Statement
Replies: 3
Views: 6313

Re: Database connect - SQL Statement

Apologies me being stupid, it was an error with my odbc connection. All sorted.

Cheers
by Dave23
Thu Oct 19, 2017 9:20 am
Forum: Flows
Topic: SQL to CSV
Replies: 7
Views: 6998

Re: SQL to CSV

Me being a plonker, it was my odbc connection not configured properly. Got it working cheers mate.
by Dave23
Wed Oct 18, 2017 10:46 pm
Forum: Flows
Topic: Database connect - SQL Statement
Replies: 3
Views: 6313

Re: Database connect - SQL Statement

alright sander, apologies i know this is an old thread i also have created a view with just the orders i need to process, but how do you query at the start of flow? do you use database connect? also exactly how do i get all the order info out into a csv file from the database connect log? i have tri...
by Dave23
Wed Oct 18, 2017 9:58 pm
Forum: Flows
Topic: SQL to CSV
Replies: 7
Views: 6998

Re: SQL to CSV

alright padawan,

yeh i want to be able to write from my sql database to csv. i've tried creating a csv log but all i seem to be getting is a red cog on my database connect element which says warning job was started. you seen this before?

cheers
by Dave23
Wed Oct 18, 2017 8:04 pm
Forum: Applications
Topic: Client vs Web Portal
Replies: 2
Views: 5939

Re: Client vs Web Portal

brilliant cheers dkelly
by Dave23
Tue Oct 17, 2017 9:09 pm
Forum: Applications
Topic: Client vs Web Portal
Replies: 2
Views: 5939

Client vs Web Portal

Alright guys,

Just a couple of questions, possibly already a topic, but what are the differences between Switch Client and Switch web portal? Why would you use one over the other? I have the client module but don't no much about it. Is this a separate download?

Cheers
by Dave23
Tue Oct 17, 2017 11:30 am
Forum: Flows
Topic: Capture page count in multiple PDF files
Replies: 6
Views: 9204

Re: Capture page count in multiple PDF files

Alright gabrielp, apologies I have tried looking on the link you provided but couldn't find much on that script. I have created ODBC connections which work great with the database module that I have. I just thought maybe this script will make creating a csv file quicker if in fact it actually does t...
by Dave23
Tue Oct 17, 2017 11:22 am
Forum: Flows
Topic: SQL to CSV
Replies: 7
Views: 6998

Re: SQL to CSV

Alright Padawan,

Yeh i do have the database module. I am currently using this to update my database once a row has been added. I was just wondering if there is a way to write multiple rows in one go rather than one row at a time? I also have the scripting module too.

Cheers
by Dave23
Thu Oct 12, 2017 5:32 pm
Forum: Flows
Topic: Capture page count in multiple PDF files
Replies: 6
Views: 9204

Re: Capture page count in multiple PDF files

Hi,

I was wondering gabrielp do you by any chance have a flow that has this script working? i'm quite new to switch and I can't seem to get it to work.

Cheers
by Dave23
Thu Oct 12, 2017 5:17 pm
Forum: Flows
Topic: SQL to CSV
Replies: 7
Views: 6998

SQL to CSV

Hi all, Pretty new to this forum and switch and i was wondering if I could pick your brains. Currently I have a flow that writes to a csv file from my sql database. I use execute command with an argument that contains select sql statements which then writes one row to my csv file. This then continue...