Search found 66 matches

by ZeitenWanderer
Sun May 29, 2016 4:17 pm
Forum: Beginners
Topic: SQL - why does this not work?
Replies: 1
Views: 3761

SQL - why does this not work?

Wanted to change the value in an MSAccess-field, but despite that no error message shows up, this minimum task does not do the job. Any idea anybody? Let>constr=provider=Microsoft.Jet.OLEDB.4.0;Data Source=DARP_DB.mdb DBConnect>constr,dbH UPDATE tblbuchdaten SET DataSelected = REPLACE(DataSelected,"...
by ZeitenWanderer
Thu Apr 30, 2015 7:45 am
Forum: Beginners
Topic: How to raise a value up to a limit in VBS
Replies: 5
Views: 7218

Re: How to raise a value up to a limit in VBS

Ok, these questions already help a bit. Well, I am using the latest MS version. And yes, I am running it inside a greater VBS script, using VBRUN. [snippet=] VBSTART Function GetData(Quantity,Sonderangebot) Const ForReading = 1, ForWriting = 2, ForAppending = 8 Dim SQLString Dim Value Dim TextLine D...
by ZeitenWanderer
Wed Apr 29, 2015 6:05 pm
Forum: Beginners
Topic: How to raise a value up to a limit in VBS
Replies: 5
Views: 7218

Re: How to raise a value up to a limit in VBS

Tried to figure it out myself, but it shows the same behaviour.

Once I run it in the MS editor it complains about the line

function max(a,b)

Calling it a syntax error ...

Next, I do not get, why the line is commented, which should transport the data from db to csv?
Hints appreciated ...
by ZeitenWanderer
Sun Apr 26, 2015 10:42 am
Forum: Beginners
Topic: How to raise a value up to a limit in VBS
Replies: 5
Views: 7218

How to raise a value up to a limit in VBS

Exporting from Access via VBS works well, now I need to modify a value. A currency field "price" is to exported not as is, but risen to a minimum. So, if usually I would have to export 0,01, I want this to become at least "3", if it is "3" or higher already, leave it untouched. I came up with this: ...
by ZeitenWanderer
Tue Mar 31, 2015 7:08 pm
Forum: Beginners
Topic: Picking data from a web field, splitting it into two values
Replies: 1
Views: 3001

Picking data from a web field, splitting it into two values

Wanted to pick data from a website comparing prices - this may be quick or dead slow. // Extract pricing and forum of top result // Used the IE Element Wizard to extract data here IEGetTagsByAttrib>{"http://www.recyclingmonster.de/verkaufen/buecher"},SPAN,,T,valueArray //top result is valuearray_1 L...
by ZeitenWanderer
Fri Jan 23, 2015 2:21 pm
Forum: Beginners
Topic: Restart: How to combine db and webrecorder
Replies: 3
Views: 3521

Re: Restart: How to combine db and webrecorder

I reworked the code for a different website, that ought to work now. This is my first attempt to transfer data from a list into web forms and it works all right so far. //if the xlsx file is not in the same folder as the script, modify the path in this line: Let>XLSPath=%SCRIPT_DIR%\test.xls //Start...
by ZeitenWanderer
Fri Jan 23, 2015 1:31 pm
Forum: Beginners
Topic: Restart: How to combine db and webrecorder
Replies: 3
Views: 3521

Restart: How to combine db and webrecorder

Ok, I take it that my planning was no good. Now I access the db directly and have parts of the mosaik, where I want to go to. That is meant for price comparison (oh, what a brand new idea ...) I already have another working script to extract data from the db, thus I just copied myself the first part...
by ZeitenWanderer
Fri Jan 23, 2015 9:55 am
Forum: Beginners
Topic: Results via csv and webrecorder - now how to combine?
Replies: 6
Views: 5308

Re: Results via csv and webrecorder - now how to combine?

Well, I used the wonderful IE Element Wizard to extract text from an ID: results_avg_price - but it inserts code containing the website address including that specific item, where I had expected it to grab only the value presented in that ID. Reading the comment, one can define where the text would ...
by ZeitenWanderer
Thu Jan 22, 2015 3:49 pm
Forum: Beginners
Topic: Results via csv and webrecorder - now how to combine?
Replies: 6
Views: 5308

Re: Results via csv and webrecorder - now how to combine?

Thanks for the first hint, that is a neat help! About the database: Actually the data comes out of an Access database, I had started with csv, since that was easy to follow ... I am still a beginner with this. :oops: So, that rewrites the last question: Would there be an example, a beginner could fo...
by ZeitenWanderer
Wed Jan 21, 2015 8:37 pm
Forum: Beginners
Topic: Results via csv and webrecorder - now how to combine?
Replies: 6
Views: 5308

Results via csv and webrecorder - now how to combine?

Hi, for once I have a somewhat unspecific question: I do manage to send data from a csv file to a website (thanks for the xltowebform how-to-zip in the support section). And it works to send content from different columns or rows to different fields. But now, I would like to pull the desired data ou...
by ZeitenWanderer
Tue Nov 18, 2014 8:57 am
Forum: Beginners
Topic: Devide/calculate a value
Replies: 12
Views: 9817

Re: Devide/calculate a value

And that solved it all ... :-)
by ZeitenWanderer
Tue Nov 18, 2014 8:43 am
Forum: Beginners
Topic: Devide/calculate a value
Replies: 12
Views: 9817

Re: Devide/calculate a value

That is because I had excluded the text lines on top. So these are the lines it complains about, if I try to run it in the editor, but it works fine, once it is compiled.

Let>x={Round(%x%)}
Let>y={Round(%y%)}

So, problem solved. :-)
by ZeitenWanderer
Mon Nov 17, 2014 9:42 pm
Forum: Beginners
Topic: Devide/calculate a value
Replies: 12
Views: 9817

Re: Devide/calculate a value

This is the complete code, in here it complains about line 21 and 22. Invalid parameters to round. But shouldn`t it have all? Let>ImageFile=test.jpg Dialog>ImageSizeDialog object ImageSizeDialog: TForm object MSImage1: tMSImage AutoSize = True end end EndDialog>ImageSizeDialog SetDialogProperty>Imag...
by ZeitenWanderer
Thu Nov 13, 2014 7:28 pm
Forum: Beginners
Topic: Devide/calculate a value
Replies: 12
Views: 9817

Re: Devide/calculate a value

Sorry to return so late - no nothing works.

Even in your example it complains about line 11 and invalid parameters.

I am lost ....
by ZeitenWanderer
Fri Nov 07, 2014 9:47 am
Forum: Beginners
Topic: How to cut a picture in its transparency?
Replies: 3
Views: 4646

Re: How to cut a picture in its transparency?

I am not making progress on this one, maybe my explanation was too fuzzy. http://www.zeitenwanderer.de/images/cut.jpg As one can see, these pictures are not always neat and straight and there might be a shadow in the corner. Instead of making them transparent in the beginning, I left them on the ori...
Sign up to our newsletter for free automation tips, tricks & discounts