• Content count

  • Joined

  • Last visited

  • Days Won


Genelia last won the day on December 17 2010

Genelia had the most liked content!

Community Reputation

2 Neutral

About Genelia

  • Rank
  • Birthday 12/12/1983

Profile Information

  • Gender
    Not Telling

Contact Methods

  • Skype
  • MSN
  • Yahoo

FIleMaker Profile

  • FM Application
    12 Advanced
  • Platform
    Cross Platform
  • Skill Level
  • Certification
  • Membership
    FileMaker Business Alliance

Recent Profile Visitors

3,520 profile views
  1. OK but as fields are 90 so not good choice. But yes if fields are less then it is wise decision.
  2. 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.
  3. 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)
  4. 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.
  5. I tried but it is also showing me records having data as 0(zero).
  6. 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,
  7. 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,
  8. 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?
  9. 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.
  10. 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,
  11. 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.
  12. Thanks Wim for help. Can i get any template to get the things more clear?
  13. Hello Guys, I have around 16/17 automated schedules that run from server and as we know that after completing of every schedule we get notification about that Schedule status like Run successfully or with abort status or kind of error status . I am giving few examples Case 1: Successfully run "Schedules 1-ABCD" completed. FileMaker Server automatically sent you this email. Contact the administrator if you no longer want to receive these notifications: Contact information not specified Case 2: Error occurs: "Schedule 2 XYZ" completed; last scripting error (101). FileMaker Server automatically sent you this email. Contact the administrator if you no longer want to receive these notifications: Contact information not specified. Case 3: "Schedule Report 3" completed; last scripting error (401). FileMaker Server automatically sent you this email. Contact the administrator if you no longer want to receive these notifications: Contact information not specified. case 4: Schedule "Report_123" aborted; FileMaker scripts can't be run because FileMaker Script Engine (FMSE) process is stopped So my concern is that we get these kind of email notifications after every schedule run. Is there a way, we can just capture schedule status in any table/fields log file and just track them at one place. and at last when all schedules completed. just send that table log file to show result status of all schedules instead of sending email notification every time after schedule completion ? or is there any batch script that could capture all and send all of schedules status in just one go? Please advice me. Thanks in advance,
  14. HI to All, Just recently i am moved from filemaker 12 to filemaker 14 and after migration found performance issues in application. Later i got to know that as my layout is using Classic theme and now it is no more in fielamker 14, so i have to change it from classic to other available theme like Cond. dark, cool grey etc... Now i have lots of layouts and i have to change theme of each layout. But i want to keep same desiging of my layouts. So what i am doing is: 1. Copy all content from layout, 2. then change theme from Classic to coll grey 3. Paste the content of layout.......... In that way design is keep same and theme is changing. So am i doing right or not...will it affect my performace issue as theme has changed but design is same. Please advice? Thanks,
  15. Yes i am using guest account with full access for both the files.