Genelia

Members
  • Content count

    125
  • Joined

  • Last visited

  • Days Won

    1

Genelia last won the day on December 17 2010

Genelia had the most liked content!

Community Reputation

2 Neutral

About Genelia

  • Rank
    member
  • Birthday 12/12/1983

Profile Information

  • Gender
    Not Telling

Contact Methods

  • Skype
    mfsi_geetanjalis
  • MSN
    tanjionly@gmail.com
  • Yahoo
    anj19832000@yahoo.com

FIleMaker Profile

  • FM Application
    14 Advanced
  • Platform
    Cross Platform
  • Skill Level
    Intermediate
  • Certification
    10
  • Membership
    FileMaker Business Alliance
  • Industry
    IT

Recent Profile Visitors

3,649 profile views
  1. Thanks Wim, Quite interesting that we have fmDotNet kind of .net platform by which we can implement CWP. I am eager to learn this. DO we have any stuff related to fmDotNet to learn? as on google , i just found 2 line of detail only. Thanks,
  2. Hi, We are currently using File-maker server 14 along with Pro(250 License) and Pro advanced( 1 license). In this we are also using webdirect for few reports and data entry and no. of users are less than 25. But i am thinking to replace Webdirect to CWP by PHP. So i need suggestion on it as my business scenario. Also we are not good in PHP, for CWP definitly we would be require PHP expertise resource. So 1 side webdirect with 25 License cost and 2nd side implement CWP using PH resource by requiring all related technical specification of it. Please suggest.
  3. Thanks Wim. but as you suggested Two ways around that: work with your Citrix guys so that each citrix session does have an outlook profile and can launch Outlook. Or, use "Send Mail" with the SMTP option instead option. So in first case :We have been running these apps for more than 15 years now.. never configured Outlook Profile in Citrix as it is NOT required or recommended by FileMaker too. 2nd case: use "Send Mail" with the SMTP option instead option: We are using Send email step using SMTP and it is working well in other scripts. Please advice/comment on this.
  4. Hi to All, I am getting Issue from users where they are getting very unusual error message while connect with Filemaker application. i have attched screenshot of that. Currently we are using Filemaker server 14 and filemaker pro 14. All database is installed on FMS 14 and through Citrix platform , they get connected to databse by using filemaker pro 14. But recently i get same kind of issue 3/4 times. They are trying to export something on application and they are getting error alert. I am attaching issue message. also when i checked Event log file, i got warning 30 for that particular user's id that means he is disconnecting his connection."Warning 30 DBXXX Client "ABCDEF server ip addres xxxxx" no longer responding; connection closed. (10) Please help me out. Thanks in Advance,
  5. OK but as fields are 90 so not good choice. But yes if fields are less then it is wise decision.
  6. Yes now i have defined fields as restricted numeric only, and imported data from excel so now problem is seems to solved. I have attached screenshot where i mentioned, How i coded that find condition and what i got as result. please see that.
  7. Yes i am using Filemaker and result found as i mentioned(might be by deafult i have set all number fields as Auto entry as 0 checked in database definition, so all records have 0 as be default). But good thing is that i got the way to solve my problem. Just export all the records in excel format with required all number fields along with their unique field and then just again import all records from excel to filemaker by using that unique field matching and it will update all number fields in validated number format.(During excel export, all number fields only export validated data means itself it removes white space and non numeric chars)
  8. Thanks to All, But i got the solution. Let me share. Actually when we export the number fields in excel format, it just automatically takes the valid number data only and it is the feature of filemaker export function by that it just omit invalid character and export only valid numbers. So my plan is just export the records in excel and then again import that excel and replce all number fields from excel data columns and it will clean up my database.
  9. I tried but it is also showing me records having data as 0(zero).
  10. Yes i got the point just to replce fields as getasnumber(field) is working perfect. but instead of replace code for all 90 fields for 40000 records is very time consuimg. I just wanted i say way i can find those invalid charas , so that i would have less records to replcace. Thanks,
  11. Hi Guys, I have big database where i am having problem of invalid characters like $, ,(COma),(Double dot for decimal number), and few other invalid character entry on number fields. There are around 90 number fields where this kind of data entered. and i am not able to find out any special search criteria by which i can find all invalid character. I have tried "?" but it is showing only double dot entry data. I have tried getasnumber(field)<> field and getasnumber(field)<> length(field) but showing 0 entry data. So please help me out if you have any idea. There are around 40000 records and also i hav etried to clean up all th 90 fields for 40000 records but file stopped suddendly after 3 hours working. So its better to find out invalid records and then clean up as i am sure thre are hardly 2000 records having this problem. SO really i need your expert suggestion. Thanks in advance,
  12. Hi, 1 more thing, i am getting data in single field when i am importing txt file(Although when i am opening txt file, it is showing data in vertical format in rows and column name is differentiated) , see attached snapshot. is it a way we can save file in such a way so that during import all column name could be split and during import column imported in individulal fields?
  13. Thanks a Lot Wim. It works for me and i got what i wanted , Now rest i will handle , main problem was with me to write batch script. But sure now i will also start to learn fundamentals of batch script coding . Thanks you so much.
  14. Thanks Wim, I have tried your given command prompt and got what i really wanted. But still same issue with me . My requirement is just to store that status somewhere in filemaker table so that i can keep track . Can i get it? like if i create batch script and put your given command "fmsadmin list schedules -s" . for example my filemaker server username is "ABCD" and password is "1234". I want to store that status in excel or tab format and to store it at documents folder of filemaker server. so that later i can import it into my filemaker table. so details are: 1.Username: ABCD 2. Password:1234 3. command:fmsadmin list schedules -s 4. store the result of command into excel file or tab file 5. save that file into Documents folder of Filemaker server Thanks in advance,
  15. Hi, So now i am thinking to import Eventlog which isexisting at scripts folder of Filemaker server (using windows filemaker) into filemaker temp. file so that later on i can do filter my required schedule data . To achieve this first i need to put that eventlog file onto Documents folder of filemaker server so that by filemaker scripting i can import it easily into my Temp. files. To achieve this i need to write system level shell script by that we can copy events log file from scripts folder to documents folder. But for me big problem is that i am completly zero in shell script. Help me to write batch script. Thanks in advance.