General discussion

Hi Brian,
I have two queries.
1. I just wanted to know if is it possible to find the script or logic behind smart analyzer app.
2. How do i build a app which can be shared and used in smart analyzer of other users or is it possible only through marketplace?
Regards
Padma
 

I have finally moved into the 21st century and created a twitter account.  I will be tweeting when I add new stuff to the site or things I find interesting to the IDEA users.  You can follow me at https://twitter.com/ideascripting.

 
Dear All,
I was wondering if some of the readers of this question may help me to solve this :
I would like to make some report on Active Directory extraction from CSVDE query.
Some fields corresponds to date and time and are represented either like 20040325075722.0Z (hereafter field 1) or 131242751793786660 (which reprensents the elpased time since 01/01/1601, hereafter field2 )
I have added a function for field 1

Hello everyone.  If anyone sent emails to me or were wondering why they were not receiving notices in the last week or so one of the sites on this server was hacked and used to send out spam emails so this site was blacklisted and emails were rejected by yahoo and other email companies.  The problem has been fixed and my host says that all emails should be going through but anything during that period would have been lost. 

Thanks

Brian

Hi,
trying to configurate a ODBC connection I have created lots of them and now, I don't know how to delete them from the ODBC import list. Can anyone help me, please?
Thanks!
 

Hi,
I would like to find an equation that allow me to find a number if it is in a range of numbering 
I attachd a file .xls as un example,
Thank you.

Hi All,
I have column of duration in second and i need to round it : first to 60 and to 30 by creating two column.
Using @Round isn't very helpful for me, so ; is there any function ? or should i use @Round with another function,
Thank you.

Hi,
I need to do a calcul to get a result in percentage % , so is there any function or script to do it ?
as alternative solution what I'm doing is : creating new numeric field and I insert this fomule : (Column A / Column B )*100  
Thank you.

Hi;
I've a database that I need to compare between the line 1 and the line 2 ...e, 
for example :  
In this case; i need to get the difference between the start call of line 2 with the end call of line 1  and 
 Thank you.

START CALL
DURATION
Duration_HOURS 
End_Call

17:26:18
139
00:02:19
17:28:37

17:28:50
60
00:01:00
17:29:50

17:29:52
45
00:00:45
17:30:37

Hello everybody,
I am having difficulty in appending multiple sheets importing from excel. Why i tried to join these sheet together, the system notify me about the field format is different. Is there a way or any tips to mass formatting multiples sheets at one? Since having 50+ sheets to append might be time consuming.
Thank you very much,
Best regards,
Trung Nguyen