Search the Community

Showing results for tags 'database'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Categories

  • Journal

Community Forums

  • Community Resources
    • FileMaker Pro 16 Discussions
    • FileMaker Pro 15 Discussions
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Server 15
    • FileMaker Custom SSL Certificates
    • External Server Authentication
    • Stand by Server Deployment
    • Legacy FileMaker Server Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
    • FileMaker Discussions
    • Brain Food
  • FileMaker and the Internet
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker

Categories

  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 15 results

  1. Hey, I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example. I'm just starting out with FileMaker so forgive me if there is an obvious solution that I'm not aware of. I have a background in software development, so the only solution that I can think of is writing a small program myself that does all the parsing for me and creates separate text files that contain all the orders and payments and other events that have been logged in the file. Then I could simply import each file into the table I need all the data in. So to sum everything up, my main question is if there is a way to somehow parse the text file before importing it. I know that you can create custom scripts in FileMaker but I'm not sure if what I need to do can be done just with that. Thanks in advance, Mike
  2. Version 1.0.0

    26 downloads

    Being unsatisfied with solutions I found on the internet and wanting a solution without plugin I created a set of custom functions that can read a path out of a json-string. Syntax: json_path ( json-string ; path ) examples: json_path( $user_prefs ; "Privileges/Modules" ) json_path( $json_data ; "Menus/Menu[10]/MenuItem[5]/Label" )

    Free

  3. One of the database was corrupted. So we have created clone of that database and performed recovery. We have imported records from this recovered file into new clone file. This database is connected(relationship) to other database.e.g there are two database Department & employee database.These two table are created via DEPT_ID.I performed recovery on employee database. Department Employee DEPT_ID EMP_ID DEPT_NAME DEPT_ID EMP_NAME Now When I create new employee for XYZ department.It is assigned to the another department. How to solve this ? I checked the recovery logs and did not find any errors but found this line
  4. Hiya, 1st of all - I have personally refrained from posting for help on a forum as I wanted to try and read, learn and solve my problems using trial and error! I am learning the FMP platform from scratch and am currently in week 2 of it. My question relates to a file I have attached to this post - the products area. For each product I have a number of 'size options' within it and each with their own unique SKU (stock keeping unit). Each SKU needs its own barcode. My job now is to produce a method to easily assign an 'available' barcode to a specific SKU. Barcodes are purchased from GS1 and are globally unique. I have a table hosting a pool of barcodes that I have available to me. They can only be assigned to one SKU and once assigned, needs to be removed from the available selection of barcodes in this pool. Issues I wanted to set a placeholder text for 'EAN-13' field in the product layout (this is the barcode). This field is a button! When clicked it can perform a script to open a popover or window containing all barcodes that do not have a 'ProductOptionID' assigned to it. How do I structure this script? Click the EAN field button - this sets the 'ProductOptionID' variable globally (is this correct to do) - [$$productOptionID] The script then opens the object 'Barcodes'. This is a popover button with a portal inside filtering all barcodes from the pool that do NOT have a productOptionID value in the foreign key field The script must then pause whilst I manually select a barcode and set a $BarcodeID variable? Or should I script it to pick a barcode at random from the pool of available barcodes (i've already set a script to give available a figure of 1 and unavailable a figure of 0) Then the script must put the BarcodeID variable in the product option record Is the above the right way to go about it? I also need a way to un-assign a barcode from a product and therefore remove the value from the product option id field in the barcode pool I have one more query. I have a relationship between Product Option table and the Barcode Pool. This relationship is O2M the barcodeIDpk with a lookup for the actual EAN (barcode) value on the Product Option table. When I set a barcode ID in the Product Option table - shouldn't the ProductOptionIDfk field update in the Barcode pool with the ID of the product option that the barcode is assigned to?? I am convinced I had it working earlier - but not anymore and cannot see to figure out why? See my relationship graph below and the solution attached. Thanks, Luke CRM Trial barcode.fmp12
  5. Hello! Although I used FileMaker 3-4 years ago to build a nice database to organize my material, research, and notes for my creative writing projects (and I still use that same database today), I haven't actually built anything new in FileMaker since then, so bear with me! My current objective is to create something that approximates a merger between the 'Starter Solution – Contacts' and the 'Starter Solution – Content Management' templates. The 'Contacts' starter solution template is a pretty great foundation for what I need in order to organize personnel because I'm doing a pretty large project wherein I will be working on a variety of smaller creative productions for which I will be collaborating with dozens of actors, actresses, musicians, writers, photographers, videographers/filmmakers, models, etc. The 'Content Management' template is only so-so for what I would like in order to organize a database of material, ideas, and notes (I will be primarily authoring or writing most of the scripts and sketches to be performed or produced as well as being the overall manager of all the creative content made). One concrete problem is that I'm having trouble creating a conditional value list, where I first select the "medium" or the type of content that will ultimately be produced (writing, still photography, or video/film), then according to my selection, the options for the next field will be narrowed down to a pre-determined set of choices (for example, if I chose 'still photography,' my options for the next field would be something like: "nature photos, portraiture photos, action photos, architecture photos, object photos," etc.). I did find a guide for doing this, but it's not quite working for me. If anyone knows the best (and possibly simplest!) way to achieve this, I'd very much appreciate it if you shared this with me. Anyway, I would also like other fields on Content Management database, like logistical information (date and time of production, location of production, etc.). But a key feature I would like is for it to be connect with the Contacts database. By this I mean that I can plug in perhaps 3-4 potential actors who might be compatible to cast for a specific role in a specific script in the Content Management database, and after plugging them in, I'd like for there to be some kind of button or function where I can click each of the candidates' names (or click a button next to each name) and be directed to their record or profile in the Contacts database (which will have their bio, photos, contact info, etc.). I appreciate any tips! I know I can find all of this out simply by researching more, but I was just hoping perhaps someone had a quick solution, as it seems like the need for combining these two types of databases might arise fairly often. Thanks!
  6. Hello all, I am new to this forum and also to filemaker. I have seen my colleagues use it and I believe it is what I need for my purpose and have now installed FM Pro 14 to get going. I would like to organise my vast classical music recording library in my house that consists of many recordings saved on various types of media, including Lps, cassettes, Reel to Reel tapes (alot of them), DVD, VHS, BluRay and also on my computer hard drives. I am in need of some assistance and some ideas how to go about building a database with relationships as to facilitate searching for a specific recording or an artist etc. I would like to be able to display my collection by say tape number (considering also that my reel to reel tapes are of various diameter sizes) and want to catalogue them as they are filed in my shelves at the moment by reel sizes. Each reel of tape has a number on it, starting from 1. The large reels of tape (120 of them) are numbered from 1-120 and the smaller reels that are also grouped together are also number from 1 upwards. This is causing a bit of confusion as how to be able to set up a database. In the fields I would like to include as much information as possible for my collection, including details such as Composer, artist, soloist, orchestra or ensemble, and the contents of the recordings, such as Symphony No. 4 op.4 and all the details of the movements of the work. As these are home made recordings, each tape might have different composers on it. Also I would like to include technical details such as: tape speed, tape type, spool type, box type, and information if any blank tape is left on the reel ( and how many minutes) or if the reel is full. If searching for a particular composer or work I wish that the database would guide me also to all the recordings I have and on which media it is on (whether LP, Cassette etc). The more information I can put in to access my library and can search for anything depending on what I input in my search would be truly ideal. I looked at other programs but I believe as this is a very specialized database, I need to set up a database using such a professional program. I hope that anyone can help me and if anyone might have a similar database that they are happy to share and which I can try to adapt for my needs with some help I would be most grateful. As it stands I am struggling to search for anything specific in my library without going through pages and pages in an A4 filing system and believe there must be a clever way out there. Many thanks,
  7. How does one integrate individual filemaker files? I have a contact management file, a task management file and event management file but I want them to work together to create one big database that works together. Is this possible and how do I go about this?
  8. Position Title: Developer / Consultant Description of Duties: We need assistance developing, refining, and enhancing an existing FM database. Our current database is used to track and manage orders from beginning to end, including the review/approval process for purchase orders and check requests. We need to work the bugs out of what we have and expand into additional functions, like managing service requests. We are seeking someone who is available to assist with maintenance of the database on an as-needed basis long-term. Location: Orlando, FL Deadline: ASAP (August 2014) Position: Consultant Employment: Onsite Contact Details: evelynn@amberusa.com or 407-438-7847. Amber Diagnostics buys, sells, services, and refurbishes radiology medical equipment such as MRIs and CT scanners nationally and internationally. Disclaimer: FM Forums does not endorse or warrantee these positions please contact the poster for further information regarding the position particulars.
  9. Hello everybody, I am working on a Metanalysis DB and I have currently 2 tables: STUDY (Parent) and REFERENCE (Child). The STUDY table has a primary key __pK_StudyID, while the REFERENCE Table has a primary key __pK_RefID and a foreign Key _fK_StudyID. I have set up a relationship one to many between STUDY and REFERENCE so that __pK_StudyID (STUDY) --> _fK_StudyID (REFERENCE), and I have allowed record creation through that relation. Now, as expected, when I create a Portal of REFERENCE fields in the STUDY layout table, I am able to create new records (that is new references for the same study) and fK is automatically populated. What I would like to do though is to be able to auto-populate _fK_StudyID and add new records to the REFERENCE Table using the same layout (i.e. the STUDY layout) but without a portal. If I move the REFERENCE table fields into the STUDY layout (without a portal), everytime I create a new Study, a new reference is created and _fK is auto-populated as expected. The (hopefully silly) problem come when I try to create a new record in the REFERENCE Table (that is to add a new Ref. for the same Study): I have created a simple script that: - Create a variable: $StudyID to store the specific __pK_StudyID - Go to the REFERENCES layout - Create a New Record - Set field _fK_StudyID (of the REFERENCE Table) to have the value stored in $StudyID - Go back to the original (Study) Layout. Now the script works flawlessly, and the new records (i.e. new references) for the specific study are correctly created, so that when I go to the REFERENCES layout I can see them. Unfortunately, in the Study Layout I can see only the first reference I have created, not the additional ones. Of course, when I put the same fields of REFERENCE Table in the STUDY layout inside a portal I can see all new records I have created.... Anyone can give me a reason fro that ? At this time, the only way I have to create study related references (and see them) is changing layout and that is not the most efficient way to face the problem. Thank you always in advance for your help
  10. I am not sure what are the macros defined in Filemaker. But I have came across a macro in Filemaker called - other which is equals to numeric value 10. i.e. other = 10 Â * This macro is case insensitive. e.g. other = Other = OTHER = 10 Â Use double quote ("") to use the text value for those text that are used as macros in FileMaker to avoid data error in calculation as well as in scripting. Â So be aware of using such texts like OTHER, while doing scripting in FileMaker. Please share if anybody else came across such MACROS in Filemaker. Â Â Â With Regards, Manjit
  11. Hi everyone,  I'm  new to Filemaker and have a beginner question about how to structure my tables (ERD'style).  Here's the situation:  I want to create a database in which I connect three entities:  1. Clients 2. Invoices 3. Artworks/Artists  - Clients can have multiple invoices - Invoices can have multiple artworks (however, every artwork is unique!! unlike generic products) - Artworks/Artists: every artwork is unique, and one artists can have multiple artkworks  *I would like to add a feature in which I can connect multiple pieces of art with multiple clients - I call this "interests". To avoid to creating a many to many relationship I created a separate item for this.  In the file I added is a first attempt to create a good relationship model. However, it does not seem to connect properly.  Any ideas on how to structure these entities in a good way are more than welcome. Tips, suggestions, and examples too!  Thank you,  ReepRutger  Â
  12. Dear fmforum,  i have a database with about 1000 items. each item has up to six images. i would like that each image has a filename that looks like this: "product id"_1.jpg the second image should have a filename that looks like this: "product id"_2.jpg  and so on.. where "product id" is the unique number for each item.  i have a script that exports the items image and changes its filename to: "product id"_x.jpg  is there a way to change the images filename when IMPORTING it to my database?  i attached a screenshot of my export filename script and another screenshot where you can see the difference between the filenames. the left one has the original filename and the right one has been exported and then imported back to my database and now has the right filename.  i am running filemaker advanced pro 12.0v3 on MAC.
  13. I'm in the early stages of building an app for iOS that would serve multiple purposes. A few of the options will send emails to a specific account that would be monitored for call-backs. We'd like few of the other options would be to place orders in our current Filemaker system, but I don't see a way to do that without FM:GO, and as nice as it looks, a dedicated database app is not really the solution we're looking for right now. Is there any way at all to make table updates or query FMP databases with native code similar to how I'd work with PHP+MySQL or C#+MSSQL, or am I out of luck?
  14. We have a FileMaker Server Advanced that hosts just under tables. Within those tables, there are hundreds (if not thousands) of database relationships. We just recently moved to a new location. Part of that move was implementing a new network schema and active directory. Is there a way to perform a batch update of all database relationships?
  15. All too often, the Refresh Window script step is used with the 'Flush Cached Join Results' option checked. Sometimes this is through lack of understanding, but other times it is required to refresh those pesky relationships which have trouble re-evaluating. This article explains why Flush Cache can be detrimental on performance, and offers an alternative and more efficient method for refreshing relationships… Read the Full Article Here…