Jump to content

MacFileman

Members
  • Content Count

    42
  • Joined

  • Last visited

Community Reputation

0 Neutral

About MacFileman

  • Rank
    member
  • Birthday 12/14/1972

Recent Profile Visitors

1,095 profile views
  1. MacFileman

    LAST NAME, FIRST NAME

    WOW! You just made that make sense to me! I can't thank you enough!
  2. MacFileman

    LAST NAME, FIRST NAME

    I can not thank you enough!! While I am here though, I am trying to understand the code. I do not do this everyday like you might, but I have done some powerful programs with filmmaker. Mostly, I am trying to understand what the ; 1 ; 1 ) - 1 ) What that means in this calculation at the end here.
  3. MacFileman

    LAST NAME, FIRST NAME

    So the left works perfect... right is now "Can not find field?" I changed all "Full name" to "supplied name" SMH.... I quit filemaker and restarted. YOUR CALCULATION WORKS! OMG THANKS!!!! THIS DOES WORK PERFECTLY!! No idea why it didn't;t work the first time. But I quit the app... walked away, came back and it worked.
  4. MacFileman

    LAST NAME, FIRST NAME

    Give me 5 minutes... will post my file. Due to sensitivity, need to remove actual address and I will shorten the list. : )
  5. MacFileman

    LAST NAME, FIRST NAME

    Thanks for the fast response.... Ok... the left works well! The right is not working. It does not recognize "LENGTH" and I get an error in my calculation. Not sure what value to place there.
  6. First, I am sorry that this is most definitely a repeated topic and probably pretty common, however, I could not find it in this forum or on the internet and had to post the question. I am stuck with a mailing list that has 13,000 names set up with "Last Name, First Name," which obviously needs to become First Name (Space) Last name with no comma. This name field contains all of the headaches associated with people's names. Examples as follows: Smith, Bob Smith Jr., Bob Smith-Wesson Jr., Bob Smith Wesson IV, Bob Peter The good news, is that the list is solid with the respect that the there is only ONE comma. I need to simply reverse this order and delete the comma. Thank you in advance! This is a wonderful community and I wracked my brains on this now for too long and need your help! Mike
  7. MacFileman

    Random Question

    Ah....obviously the easiest way is to remove the last 20,000 etc. or the first 20,000. The database is over the course of 20 or so town in a county in NJ. Doing so would a remove an entire town from the list. So we wanted to randomize the removal.
  8. MacFileman

    Random Question

    Thanks for the reply. As I stated, this is just for a mailing. They have 60K+ addresses, only have a budget to mail 40K postcards. They had asked me to remove random addresses to get to 40,000, but I figured FM can do this automatically. It is just a list of given to me with name, address, city, stat and zip in excel. Plan to pull into filemaker and randomly extract 40,000. Thank you for your fast feedback. Looking at this later today.
  9. Hey... I have a database with 60,000 plus names and addresses. I need to mail to 40,000 exactly. I can do this manually...but I was wondering if there was a way to have FM extract 40,00 exact addresses randomly. Thanks in advance. Mike
  10. MacFileman

    Barcoding

    Thanks for these articles and pointing me I. the right direction! I didn't;t get to read them entirely yet, but I will over the weekend. Thanks Again!
  11. MacFileman

    Barcoding

    If I have a job ticket or work order in my shop. Can a barcode be printed on it.... when scanned, it could trigger a scrip. Basic Work Flow: Job is in Room A, when they are done, it goes to room B. They scan the job bag... filemaker now knows the job is in Room B. Similar to that of say FedEx. FedEx picks up and they scan the package. When they bring it back to base, it gets scanned. When out goes on the plane it gets scanned and so fourth. Or something simple like.... Scan barcode on Job Ticket and filemaker jumps to that project on screen.
  12. Hey... So I want to play with barcoding and scanning. Maybe have different departments scan a barcode on a job bag to update job statuses, etc. Before I thoroughly investigate this process, I thought I would ask the community about any experiences, etc. I guess my thought is that the a barcode could be a button. Also, any recommended barcode USB Scanners? Any insight, suggestions and tips would be appreciated. Work flow: Print various barcodes on my job tickets... when scanned, it would trigger filemaker to change the status of the job. From Active, to Shipped, or to billing, etc. (hope that makes sense) Thanks!
  13. MacFileman

    SSL Renewal Problems

    Last update....setting up a Filemaker Server is way easier then dealing with Filemaker Cloud! I am pleased to report that I just canceled my AWS Account. I had a server up and running in under 10 minutes. My advice... do not do Filemaker Cloud until they get their act together. Sorry, John May at Point in Space... I had the computer and I own Filemaker Server... just easier and no monthly Fees.
  14. MacFileman

    SSL Renewal Problems

    Current update...... So, the first simple domain I bought with Network Solutions will not point to the FM Cloud Server. After all my back and fourth with FM Support... I bought a new domain from a registrar of their choice, iPage. I gave them the credentials to point it themselves. They logged in and made the settings. New domain is not pointing to my server...I have to laugh at this point. It might by morning, I will give them the benefit of the doubt. I discussed this with my IT guru who happens to be away for two weeks magically while my SSL Cloud Certificate expired. Coincidence? Anyway, he feels its rather ridiculous to buy a website to "point" to the cloud server, and secure the site that the files are not even on. This is extremely convoluted he says. For the nonbelievers, I am working directly with FM Support to re-secure my FM Cloud Files. I have spent 10+ hours this week on the phone with them. I thought I would also share their published recomandation. http://help.filemaker.com/app/answers/detail/a_id/16125/track/AvMawQoYDv8S~ZOfGmQc~yJfbe8qNy75Mv_g~zj~PP9p I have followed these steps forward and backwards.... something is up! I love Filemaker, we all do here... but the cloud is not thought out on their part. Filemaker is a huge company, why don't they just put in their own servers, secure it all and cut this third party non-sense out with Amazon and Comodo? Updates coming tomorrow! Mike
  15. MacFileman

    SSL Renewal Problems

    The code I posted earlier did work. I was able to get the certificate and install into my Filemaker Cloud and it rebooted, etc. There was a minor glitch, the password I put into Terminal for the CSR and Key was not the password when I installed it. (We might be talking about different issues) It turns out, there was no password at all and that field was left blank for it to work. My actual problem is getting my website that is now secured to point to my FMI server...I am possible having a problem now with my Registrar and the CNAME Panel pointing it correctly, If I make a change in a setting it is like a 24-48 wait time... very frustrating. FIlemaker says it my Registrar. Right now I am in Limbo and my registrar, Network Solutions, is also looking into the matter. I am trying t be patient, but the whole process does not feel right. I am securing a website where my files are not located, but Filemaker assures me this is the process.
×

Important Information

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