Jump to content

Fred in Seattle

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Fred in Seattle

  • Rank

Profile Information

  • Gender
  • Location
    Seattle, WA
  1. Excel first asks (in the parsing mode) for the beginning line of the data. In the case of the FDIC text file, there are 6 lines of headers, etc before the actual data begins. I think Excel uses the delimiters for the 7th line, and goes from there. You can change delimiters or select "fixed width". There is no limit on the size of the line. In the FDIC file the lines are 600+ characters long. Fred
  2. Oh, yes - thank you. I have read every help file, just about every forum entry, and the latest book on FM12. You can use the CSV file type for import, but the results are far from acceptable in my case! I find it odd that Excel imports the same file without a hitch. I'm just trying to automate the process so there is no hands-on intervention. In fact very first thing I did was load the file into a text editor and did a search and replace of the quote marks. I replaced with paragraph marks first and saved as CSV file, at least with that extender. I tried a number of variations (I spe
  3. I have developed a database in FileMaker that dates back to the first versions of the software on the PC. I am now using FM12 and would like to automate the manual file importing that I have been doing for years! I use the database in my own company (we provide loan examinations to commercial banks). The database contains all the loan and borrower information in the client bank's trial balance. Over the last 20 years I have obtained the raw data from my client banks in ASCII format from their various different service providers. Since the data varies widely from bank to bank I have alw
  4. Darned if I didn't find my (MY!) problem. I was losing data right after input, but a search on the field would get all the fields with data (but showing blanks). Here's what was happening for anyone interested: As I mentioned, I import all of my data from different bank clients' host computers. Then I add a notation of issues found when we review the files (called "EXCEPTIONS"). I have an EXCEPTION table that is linked to a BORROWERS table using BORROWERNUMBER as the linking field (a one to many relationship). Since I import data, sometimes the BORROWERNUMBER field is not a number
  5. Sadly, what Fred has done (me) is run the main table through another database that has a "find distinct" option in the find menu (Lotus Approach - now owned by IBM, but probably an orphan by now). There are many, MANY instances where a user needs to extract DISTINCT records to create a main table. Mostly this is when you are starting with imported data based on all records. Most mainframe "pullfiles" will give you multiple instances of one field (with a new duplicated record each time). For example, I ask every bank client to download in a pullfile all of their NOTE data, so I hav
  6. The files are on the same machine, and on my local network. I wonder. . . Thanks for the tip, I'm going to explore that. I really have eliminated everything else, I think.
  7. I've been through this problem on the former forum, and got lots of help: the answer, there is no easy way to get "distinct" records. For example if your records are: blue blue red blue red red yellow blue I assume you want to do a search that returns only the following: blue red yellow No, I am told FM8 has no way to do that with a quick search. Several people wrote complex scripts for me, but I ended up using a different database for that portion of my needs. It seems so basic that you would import huge amounts of data and want to create a table of only "di
  8. Hello Lee, I have used this database since version 6 or earlier. I work on it all the time, but always save as an empty "clone" to import my new client bank data. Therefore the present copy is an evolutionary copy that goes back for probably 100 or more "clones". I have no "original copy" since I evolve it everytime I use it, and with every different bank. Wow! that even sounds hopeless to me. Odd thing is, I have several banks going right now, all cloned from a prior file, and this one bank is the only one that has the problem. It's almost as if the imported data makes a differenc
  9. Walter, I have only moderate experience with Filmaker, but like you, I am learning. I see some of the issues I had in your post, and I learned this way too. Relating the tables (you have three tables) requires more than just making the relationships. I don't know if you have found this or not, but on the relationship screen (where you connect the key fields - File/Define Database/then the relationships tab) there is a little box in the middle of the line connecting the fields. Double click on that box to get more settings (edit relationships). The one I hadn't set is the one that sa
  10. I've been using the same database program (that I wrote) for over a year. It has 4 related tables: 1)BORROWERS 2)NOTES 3)EXCEPTIONS 4)COLLATERAL. I own a company that provides examinations to commercial banks. The tables are all linked with "BORROWERNUMBER" field, a unique field for each borrower in the bank. NOTES, EXCEPTIONS, and COLLATERAL are child tables linked to BORROWERS, the parent. I input "exceptions" (things that are wrong with the loans) in a Layout that uses BORROWERS as the main table and EXCEPTIONS as the child with a one to many relationship. This has worked smoothly
  • Create New...

Important Information

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