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.
Search found 70 matches
- Tue Dec 05, 2017 4:28 pm
- Forum: General Discussion
- Topic: Merge CSV to SQL
- Replies: 4
- Views: 13262
- 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...
- 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...
- 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?
But I dont see there being an option to figure out who dropped the file in, like a file owner attribute.
Anyone?
- 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?
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?
- 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...
- 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
It's not CTRL - C for copy, you have to use the key combo
- 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.
- 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
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
- 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...