Jump to content

Genelia

Members
  • Content count

    129
  • 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

  • Industry
    IT
  • Gender
    Not Telling

Contact Methods

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

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Windows server 2012

Recent Profile Visitors

3,838 profile views
  1. Hi To All, I wants to know possible ways/methods so that multi-user environment and simultaneous transactions can update the same data/record to produce consistent results. Currently there is either zero or less control of data concurrency and data consistency in my FileMaker App. Like as in Oracle , there is Transaction Isolation level setup with help of Serializability concept. What possible ways we can do to make Data Concurrency and consistency in FileMaker Apps? Need suggestion and all of you expert comments. Thanks in advance,
  2. Hi to All, I am creating 1 batch script to automate my manual task. in this task i have to copy 5 csv files from 1 location server to another location( my filemaker server documents folder). I am able to copy single batch file to put on another location but not able to copy multiple files and put all in single batch script even after googling. Lets say my files name are A.csv, B.CSV, C.CSV, D.csv, E.CSV Below is my code. Please do help/correct me where i am wrong . /log="D:\Program Files\FileMaker\FileMaker Server\Data\Documents\XYZ.log" /command "open XXX_Test" "get "/home/ge00/TEST_SFTP/A.csv ""D:\Program Files\FileMaker\FileMaker Server\Data\Documents\A.csv"" "exit" Thanks in Advance,
  3. Hi Wim, As per outlook error, i have configured my outlook profile onto server . Then i again export ..this time excel file attached to email but i got server Busy error log which results my screen freezed and again i need to sign out from there(already attached in my first post of this conversation). So i am attaching the internal event error log. But i want to know is really this filemaker functionality working ? i mean while export, to select attach email option functionality working perfect or not? Event_error.txt
  4. 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,
  5. 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.
  6. 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.
  7. 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,
  8. OK but as fields are 90 so not good choice. But yes if fields are less then it is wise decision.
  9. 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.
  10. 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)
  11. 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.
  12. I tried but it is also showing me records having data as 0(zero).
  13. 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,
  14. 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,
×

Important Information

By using this site, you agree to our Terms of Use.