Jump to content

FMRadio

Members
  • Content Count

    20
  • Joined

  • Last visited

Community Reputation

0 Neutral

About FMRadio

  • Rank
    member

Profile Information

  • Gender
    Male
  • Location
    Seattle, WA

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    11 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Sierra

Recent Profile Visitors

1,582 profile views
  1. Hey thanks! I suspected this was the problem from the start but my original attempt to address it by doing a search and replace within Apple's textedit with their marriage return was not viewed by Filemaker as a kosher new record indicator but when you said, ..."line-ending character (CR, LF or CRLF )," I realized that should try another. This time I inserted a Line Break and the CSV imported perfectly. Much thanks.
  2. Thanks for your reply. The data is private names and addresses so I made an exact facsimile... Tom,Barker,foghorn@gmail.com,Out List,Craig,Hopso,hoover@live.com,Out List,Judy,Flowerstalk,jam61@comcast.net,Out List,Lara,Oblong,uptop72@gmail.com,Out List,Judi,Thomas,mor64@gmail.com,Out List,Bruce,Fortrans,fourten@comcast.net,Out List,Dennis,Willybobba,oblong@comcast.net,Out List,Peter,Kates,fullset23@msn.com,Out List,Edward,Davies,glvb99@gmail.com,Out List,Larry,Kahn,leftbank@gmail.com,Out List,Alice,Comfortis,design92@gmail.com,Out List, The text block is 11 records, Each record: Firs
  3. Basic Question: I am attempting to import 60 records from a CSV file. There are 4 fields per record: First Name, Last Name, Email and Source. When I choose Import Records... > File... from the File menu, everything looks good, 4 data points point to the correct field names: arrow icon "Import this field" but the rest are the double dots icon, "Don't import this field," and when I click on the Import button only the first record is imported. I don't use Filemaker frequently enough to remember everything but when I need it, I really need it. I do not remember having to go thru
  4. I think that I stated my question quite poorly, because I received some very complicated answers for simple problem. But I still appreciate the time and trouble of the responses. I was trying to execute a find for a text string Durkan in a single field. Possibles: Durkan JennyDurkanforSeattle People for Jenny Durkan Turns out the answer is wrapping Durkan in asterisks. Thanks everyone.
  5. This seems so basic, not sure why it is not working. I am searching a database of campaign contributions, the candidate uses several variations. One is People for Jenny Durkan, another is JennyDurkanforSeattle. When I search "Durkan" it finds People for Jenny Durkan but not JennyDurkanforSeattle. FM Help says to use double quotes, what am I not understanding? I am using version 11 on the Mac. Thanks for your help.
  6. Fitch, sorry for the delay in responding. Crazy trail over here, I actually did not understand your suggestion, I did not have enough knowledge. So, as I so often do, I messed about and experimented. Thru a kind of accident I realized that I could (rather than above attempt) bring a remote, related table field into a calculation field and get the result I was looking for, a total of all the values of the records showing -all or a found set. So, in other words, exactly what you suggested in 'pipelining.' The accident was that I tried to sort a field that would not cooperate because th
  7. Can you export field labels from FileMaker? On import, you have the option to read the the first row as label or data, what about the other direction? Thank you.
  8. Thanks for your response. I thought a picture might be worth a thousand words, or so they say. I uploaded a screenshot of the table Neighborhood. Basically, the table is an elaborate calculator, the idea being to find sets of properties based on some criteria and get total values at the bottom of the window. Those totals could be total square feet or a total of land values. The find criteria might be the block property is located on or one of the alternative rezoning proposals. In the screenshot, all of the fields shown are from the Neighborhood table, the primary table. The only exc
  9. I am attempting to help my neighborhood organization with some land issues. I am using FM 11 on a Mac running OS Sierra. My primary database is Neighborhood and the related database is Parcel. Neighborhood and Parcel are joined by the field Parcel #. County parcel numbers are the ultimate identity of property, so each property parcel is an individual record in the Neighborhood table. Using the unique parcel number I am able to align the information from the two tables. Neighborhood is of my own creation and Parcel is provided by the county and since this is a major metropolitan area,
  10. Well a bit morte valuable than 2 cents, as I get it now. Comment and you meant like a spread sheet. Columns are a language and rows are the individual search terms, English and the rest following in that row. Thanks.
  11. I thought that I would get notifications via email from replies to posts, here in the forums. I have an email address setup in my profile settings but I am not seeing any email notifications. What am I missing? Thanks.
  12. Comment, thank you. Not only does that work, suing your example, I have expended it to other languages. "But I do believe you should use one table for all foreign languages (if not one big flat table as explained earlier)." I did not go deeply into the user experience issues when I described my problem earlier. The layout I am using, first version rather primitive compared to where it is going, needs to focus on one language at a time. There are two reasons for this: one is the lack of screen real estate, I need avery tight, columnar list showing just one language and its English count
  13. "That makes no sense, because the two values must be the same in order for the two records to be related." Your question made me realize that I am in a bit of Catch-22. Let me explain more clearly: I will enter a number of search terms (record for each) related to privacy and identity in the English table. These will act as an anchor. I should also point out that I may not know the exact term in advance for another language, such as German, for English term. When I am in the German table (layout) I will create a new record, for a known German term, and then choose from the popup me
×
×
  • Create New...

Important Information

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