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,315 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: First Name, Last Name, Email, Source It seems to me that there should be an indicator for each record? But what would that be? Thanks
  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 and changing every icon in the Import dialog to import this field, I thought that was automatic. I there something missing in the CSV file? I can reprocess that if required. Having to indicate to import for every record will be tedious. Thanks in advance for any help.
  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 the original database set it as text, I needed a number. So I setup the calculation field to 'massage' that data into a number so that it sort correctly. That's when I realized that I could now carry out a Summary action because the data was now local. You told me to go out in back of the house to find what I wanted, but apparently I had to go out behind the barn and keep digging until I reached the house.Some of us are kind of slow. :-) Bringing the related data to a local field for analysis works beautifully, with a few extra features thrown in. Thanks again for your help.
  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 exception is the field labeled Lot Area (Parcel :: ParcelArea) which comes from the related table Parcel. The Parcel# field, at the far left, is the field that links the two tables with property parcel number. At the bottom of screenshot in the footer is the field ParcelAreaTotal, in line with the field Lot Area (Parcel :: ParcelArea), where the totaled value is to be shown. As you have pointed out and as I have read, you cannot use a summary field for this operation. But, so far, my attempts at using a calculation field have failed. You can see that value in ParcelAreaTotal is not a total of the found list but is the value of the currently active record 9547200070. This is my central question, how do you use a calculation field in this situation to total a value located in another table? Thank you. Privacy: The information in the screenshot is not private data. Public data from the online county records and the properties shown are from a commercial developer.
  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, it is quite large. Parcel has only one field I am interested in, ParcelArea., that contains the area of each piece of individual property, Parcel does not contain the individual property's address, while Neighborhood does. In Neighborhood, using this relationship, I am able to show the address, owner and other details of each piece of property, plus the area from the Parcel table. Using a list layout, I placed a Summary field in the footer that would tally what was showing in the list of individual property records, based on various search criteria. When I had the property field with the lot's area stored in Neighborhood, the Summary field, ParcelAreaTotal, worked fine. But when I switched designs, from internal data storage to an external, related table; the Summary field, ParcelAreaTotal, stopped working correctly. Instead of showing the total property area from a selected group of records, ParcelAreaTotal shows me the area of what is the currently selected record. I tried a number of options, failures all, my last attempt was using the function Sum ( EXTR_Parcel Converted::ParcelArea ) but this approach yielded the same outcome as before, whatever is the currently selected record. Judging by my repeated and varied efforts to get this to work and a bit of reading, I am clearly missing something obvious about total calculations and related tables. Thanks for any guidance.
  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 counterpart. The other reason is that I will be searching the web and other documents, one language at a time. Showing other languages would be distracting and get in the way. Really want to thank you again. I knew, in the back of mind, to take the approach you shared with me but like I said earlier I do not work in Filemaker often enough to keep the chops up to par. There was a day, but no longer. Its too bad because whenever I return to Filemaker my needs seem exceed my current ability. I do not care for a lot of Filemaker's interface design but it is one hell of a tool.
  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 menu the matching English term. Until that point, there is no relationship but I do need to see the list in advance to make that happen. Thus, the Catch-22. I thought you could show a Value list in another table without requiring a relationship? "Will there be always only one German term corresponding to each English term? Or is it possible to have alternatives?" Yes, there will only be one German term and one English term matching. Some English terms may not have a German equivalent so they will not have a matching German record. No alternatives, but as I mentioned earlier, there will be other tables for other languages hooked to the English table. I will have buttons to switch between different layouts views to show them.
  14. Thanks Eos, done. Search_Term_Translation.fp7.zip
×
×
  • Create New...

Important Information

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