Search found 28 matches

by aridzv
Sat Feb 25, 2023 12:17 am
Forum: Reports
Topic: Export MAINLINESUM VALVE HL & RATIO to CSV
Replies: 1
Views: 987

Export MAINLINESUM VALVE HL & RATIO to CSV

Hi. I need help with exporting "MAINLINESUM VALVE HL & RATIO" report to CSV. I've tried to do it but I can't get the titles to align properly. The resault I'm trying to get is shown in the attached screenshot Capture.JPG. Thanks, aridzv. *EDIT: the fields that I must have are: Valve Na...
by aridzv
Fri Aug 26, 2022 12:29 pm
Forum: Databases and Materials Selection
Topic: need help with SQL query to update pipes usage
Replies: 6
Views: 11990

Re: need help with SQL query to update pipes usage

Hi Dan and thanks for the reply!
using the explicit table name as As you suggested did solved the issue,
And this is one Excel worksheet table that now both gets the data from the database and updates the item usage.
thanks again,
Ari.
by aridzv
Fri Aug 26, 2022 3:09 am
Forum: Databases and Materials Selection
Topic: need help with SQL query to update pipes usage
Replies: 6
Views: 11990

Re: need help with SQL query to update pipes usage

Hi Dan and thanks for the ideas!! After remebering this thread https://www.irricad.com/phpbb3/viewtopic.php?p=2044&hilit=sql#p2044 and watching last year webinar lesson No.10 I've went for the excel approach to the export and update tasks. I'm using 2 queries based on above lessons: 1. Export It...
by aridzv
Thu Aug 25, 2022 9:53 am
Forum: Databases and Materials Selection
Topic: need help with SQL query to update pipes usage
Replies: 6
Views: 11990

Re: need help with SQL query to update pipes usage

WOW that was fast... :D Thanks Dan - works like a charm! the tilde symbol (~) was indeed the missing link... I've changed the query a little using "OR" condition when adding the usage letter so I won't need to click YES for every pipe "UPDATE" statment, only 2 clicks - one for th...
by aridzv
Thu Aug 25, 2022 8:22 am
Forum: Databases and Materials Selection
Topic: need help with SQL query to update pipes usage
Replies: 6
Views: 11990

need help with SQL query to update pipes usage

Hi. I'm using IrriBase 20.07 (The latest update). I'm trying to write a SQL query to update pipes usage that will do this: 1. clear all pipe usages (the first UPDATE Statment in the code below). 2. assgin new usages to pipes (the second and third UPDATE Statments in the code below) in the test query...
by aridzv
Sat Aug 13, 2022 8:39 pm
Forum: Reports
Topic: Managment Symbol - Valve name instead of Area name
Replies: 3
Views: 2336

Re: Managment Symbol - Valve name instead of Area name

Hi Jo and thanks for the reply. to start with - the problem is resolved, and the key issue was to re-run Management like you wrote. about the steps I took: 1. since I use the sub division tool, I let Irricad to automaticaly assign zone and valve names at first and design the zones. 2. design the man...
by aridzv
Fri May 27, 2022 11:33 pm
Forum: Reports
Topic: Managment Symbol - Valve name instead of Area name
Replies: 3
Views: 2336

Managment Symbol - Valve name instead of Area name

Hi. the managment symbol by default puts the area name (tag #NAME#). is it possible to replaced it with the valve name (tag #CVALVENAME#)? see attached screenshot: the valve name of Area No. 36 - 3 is 18. is it possible that "18" will show instand of "Area No. 36 - 3"? thanks, Ari.
by aridzv
Fri May 13, 2022 8:37 pm
Forum: CAD Drawing
Topic: is it possible to combine maineline pipe segment labels to one label?
Replies: 2
Views: 1626

Re: is it possible to combine maineline pipe segment labels to one label?

Hi Jo and thanks for the reply.
here is the missing screenshot.
Ari.
Capture11.PNG
by aridzv
Fri May 13, 2022 6:23 am
Forum: Miscellaneous
Topic: Automatic selction of fittings - junction with 3 sizes
Replies: 1
Views: 1325

Automatic selction of fittings - junction with 3 sizes

Hi. I have a PE submain line that on one junction it change its size from 75 to 63 and the lateral pipe is PE 25 - see 2 attached screenshots. I need to get in the fittings selection this combination (both item exists in the database): 1. saddle DN75 with threaded offtake 1". 2. PE reducer 75-6...
by aridzv
Fri May 13, 2022 2:25 am
Forum: CAD Drawing
Topic: is it possible to combine maineline pipe segment labels to one label?
Replies: 2
Views: 1626

is it possible to combine maineline pipe segment labels to one label?

Hi.
is it possible to to combine the pipe labels of a mainline segments to one label with total length?
I've attached a screenshot that illustrate what I meen.

Thanks,
Ari.
by aridzv
Wed Apr 27, 2022 8:16 pm
Forum: Reports
Topic: looking for managment report with the attached columns
Replies: 5
Views: 2647

Re: looking for managment report with the attached columns

Hi Jo and IRRICAD Team.

1. yes,this report do meets the requirements perfectly.
2. is it possible to change it to a .csv output?

many thanks,
Ari
by aridzv
Tue Apr 26, 2022 7:11 pm
Forum: CAD Drawing
Topic: Management Symbol text size
Replies: 4
Views: 2638

Re: Management Symbol text size

Hi Jo and thanks for the reply.

1. about contact NETAFIM - will do.
2. I manged to re-generate the managment symbol by going to Design -> Assign Zones To System Flow -> OK -> Save&Exit without changing anything.
it re-generated the symbol and solved the problem.

regards,
Ari.
by aridzv
Sun Apr 24, 2022 1:26 am
Forum: Reports
Topic: looking for managment report with the attached columns
Replies: 5
Views: 2647

looking for managment report with the attached columns

Hi. is there a way to create a report (maybe as part of the managment reports?) with those columns: Area Name SHIFT No. Irrigated Area (Ha) Flow (m³/h) and also to get it as a .CSV report like the reports in this thread: https://www.irricad.com/phpbb3/viewtopic.php?p=1768&hilit=custom#p1768 also...
by aridzv
Fri Apr 22, 2022 8:32 pm
Forum: CAD Drawing
Topic: Management Symbol text size
Replies: 4
Views: 2638

Re: Management Symbol text size

Hi jo and thaks for the reply!! i will do that (explode & edit) after exporting to bricscad - it is more simple to do it there. I have another question on the same subject: some of the irrigation areas are corrupt (see attched screenshot), and one area - area No.32,Although Appears in the managm...
by aridzv
Fri Apr 22, 2022 2:04 am
Forum: CAD Drawing
Topic: Management Symbol text size
Replies: 4
Views: 2638

Management Symbol text size

Hi.
is it possible to control\change the text size in managment symbol?
see attached screenshot that emphasizes the problem - text in red circle is to big and the text in the blue circle is ok.
thanks,
Ari.
by aridzv
Fri Nov 26, 2021 8:44 pm
Forum: Hydraulic Design
Topic: how to design an over head foggers system?
Replies: 4
Views: 2231

Re: how to design an over head foggers system?

Hi Joe and thanks for the reply. See the attached free hand drawing,it is an example of an over head foggers system. is it possible for you to create a tutorial for this kind of system? **in the past, what I did was to design the system at "ground level" and insert a filter with head loss ...
by aridzv
Wed Nov 24, 2021 11:52 pm
Forum: Hydraulic Design
Topic: how to design an over head foggers system?
Replies: 4
Views: 2231

how to design an over head foggers system?

Hi. I've searched the forum but couldn't find a topic that deal with overhead foggers (micro sprinklers) system. how do I take in to account that the foggers are above ground level,say about 2.5M? and how do I take in to account the pipe length from the ground up to foggers? I'm taking a pipe from g...
by aridzv
Wed Oct 20, 2021 5:36 am
Forum: Databases and Materials Selection
Topic: DBS 1 Error Loop
Replies: 3
Views: 4130

Re: DBS 1 Error Loop

Hi joe and thanks for the reply. 1. I'll send you the D.B. 2. what I eventually did was to set the selection filter to valves, select al the valves in the design,and used the "change type" tool to change all the valves to the correct valve that I was using in the design, and the error mess...