Search found 70 matches

by deesloop
Tue Dec 05, 2017 4:28 pm
Forum: General Discussion
Topic: Merge CSV to SQL
Replies: 4
Views: 13262

Re: Merge CSV to SQL

OK, I see what it's doing and I can read a line at a time from the CSV,
I'd never used a field as an array, so missed a trick there!

I got it all working thanks and appreciate the straightforwardness of your solution.
by deesloop
Tue Dec 05, 2017 10:04 am
Forum: General Discussion
Topic: Merge CSV to SQL
Replies: 4
Views: 13262

Re: Merge CSV to SQL

Thanks Oleg, you were right. While the data is fine, it's the structure of the table It's a 3 table with 3 fields, one being a unique ID whereas the CSV has 2 fields. I had hoped the ID would be created automatically but apparently not. So looks like I'm having to read the csv a line at a time and d...
by deesloop
Mon Dec 04, 2017 4:03 pm
Forum: General Discussion
Topic: Merge CSV to SQL
Replies: 4
Views: 13262

Merge CSV to SQL

I'm looking to automate the merge of a CSV file into SQL, but my DB EXEC SQL step is just not working. Provider=SQLOLEDB.1;Password=sdfsadfasf;Persist Security Info=True;User ID=sa;Initial Catalog=TabletForms;Data Source=befgon BULK INSERT Ages FROM 'c:\Book2.csv' WITH ( FIRSTROW = 2, FIELDTERMINATO...
by deesloop
Mon Apr 03, 2017 4:37 pm
Forum: General Discussion
Topic: Email the FileOwner
Replies: 3
Views: 19555

Re: Email the FileOwner

Yes, I use something similar in another product that extracts names from a pdf and creates filenames accordingly.
But I dont see there being an option to figure out who dropped the file in, like a file owner attribute.

Anyone?
by deesloop
Fri Jul 15, 2016 9:50 am
Forum: General Discussion
Topic: Email the FileOwner
Replies: 3
Views: 19555

Email the FileOwner

I want a fileshare that users can drop things into and then have an action performed on them.

What I'm needing from robotask is a way to find out who dropped the item in and then get their email address.
I'm not seeing anything under file attributes

Is this available anywhere?
by deesloop
Mon Feb 02, 2015 1:52 pm
Forum: General Discussion
Topic: Get part of web page
Replies: 7
Views: 27360

Re: Get part of web page

I have PMD you the task The issue I have is that this runs OK when robotask is running but I dont want robotask running all the time. This is to be an as and when type task, launched with a shortcut If I run the task without robotask running and i I get a dialogue box "Please wait until all the...
by deesloop
Mon Feb 02, 2015 1:24 pm
Forum: General Discussion
Topic: Get part of web page
Replies: 7
Views: 27360

Re: Get part of web page

Sorted it.
It's not CTRL - C for copy, you have to use the key combo
by deesloop
Mon Feb 02, 2015 1:04 pm
Forum: General Discussion
Topic: Get part of web page
Replies: 7
Views: 27360

Re: Get part of web page

I'm using your the browser.
by deesloop
Mon Feb 02, 2015 12:32 pm
Forum: General Discussion
Topic: Get part of web page
Replies: 7
Views: 27360

Get part of web page

I want to log into a web site, navigate to a new page and pull a data table from it and then display the table.

I've got the web login working fine and the navigation to the second page
Howver I cant see how to save the data from the site.
Any ideas how this can be achieved?

Thanks
by deesloop
Mon Jan 26, 2015 1:58 pm
Forum: General Discussion
Topic: Task not running in service
Replies: 6
Views: 28348

Re: Task not running in service

OK I followed the instruction and nothing happens.. According to your instructions - You will see this message. Press "View the message" That doesnt happen However using the 2nd method I could connect and see lots of errors. An error occurred. Step #1 (Dataset Loop). Out of interest, is us...