Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About lanceomni

  • Rank

Profile Information

  • Gender
  • Location
  1. Brian & Michael, Thank you both for your responses. @Brian - I have not seen this example. It is a free unlocked example. I have found several other similar examples but they have all been paid solutions. In my past, I have automated many of my daily tasks and for the last year have been attempting to encourage my current firm to establish some automation. It has been frustrating more recently with Indesign 6 and 7. They have significantly changed the syntax for Applescript. This has forced me to rewrite most of the scripts that I have dug up from earlier years. In addition, it
  2. Anthony, Thank you for your reply. Have you produced layouts which are created from multiple related tables with records sorted manually? If so, how do you handle the sorting prior to export? What additional information would you require to provide assistance? Do you have any samples I could digg through in order to learn how they have been constructed.
  3. My database includes resume information which is to be exported into an Indesign template. My current solution is to use applescript to push fields into my layout. Using Comment's helpful tips, I have also explored exporting records to XML with stylesheet for import into my layout. My current issue is in regard to related records and their order. For instance, I have the following tables: Contacts Experience Experience holds multiple versions of narrative to include as a description. The user would choose between a list of narratives from this table and only one would be needed f
  4. I appreciate your help with this project and apologize for not responding to your last post. Your solutions worked great. I studied up on style sheets and was able to convert the information into a useable format. Thanks again!
  5. I see that this is starting to get a bit more simplified but I still have some questions. I am now getting something like this. <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="01-25-2011" NAME="FileMaker" VERSION="Pro 11.0v3"/> <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="MossDB_v0.2.03.fp7" RECORDS="10" TIMEFORMAT="h:mm:ss a"/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Project_Name" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Calc Cur
  6. The current game plan is to select a single person. I believe exporting as mentioned above would be the easiest but I do have an existing layout which would accept the projects in one node separated by carriage breaks. I may be interested in expanding down the road but how now I would like to take it one step at a time.
  7. I am working on an XSL file to reorder exported data from Filemaker. The filemaker data consists of a name, title, and list of projects through portal. Exporting to filemaker gives me the following: <?xml version="1.0" encoding="UTF-8" ?> <?xml-stylesheet href="resume.xsl" type="text/xsl"?> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="01-25-2011" NAME="FileMaker" VERSION="Pro 11.0v3"/> <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="L30_CONTACTS_Data_Entry" NAME="DB_v0.2.03.fp7" R
  8. Starting Point is fantastic. I can remove unneeded content and add in my specific needs. I only see two issues. One minor and one that I will need to address. 1. In my database, I have a separate table to store phone, address, & etc. In the past I would run into situations where contacts would have multiple entries for this type of information and I wanted to avoid this. By creating a separate table I have increased the complexity to the point where I would need help in order to add functionality to make this information useful beyond just looking at it. FM Starting Point gi
  9. Thank you for the advice. I believe I have now enabled personal conversations and email. I did not look for local consultants as I did not want to narrow my results. I thought about something like your RoleID solution but I was not sure how that would work out for listing related records in a portal. I may not be savvy enough to understand. If I am unable to find someone to help, I was considering starting from scratch and creating a simple version with limited features. I would hate to toss what I have as it took some time to conceptualize and add features. Do you have an
  10. I am working on a DB to help me organize some of my marketing coordinator tasks at a construction company. I have a pretty good start in terms of my concept but im starting to think that I may be painting myself into a corner. Description: The DB holds information about projects, entities(clients), and contacts. I am using join tables to handle the many-many relationships. For example an entity can have many contacts and projects associated with it and projects themselves can have many contacts associated. It would be nice to also have the ability to relate many entities with a single p
  11. I am working on a project containing employees and projects. I have a portal displaying a list of projects related to each employee. My goal is to create a checkbox next to certain projects in the portal and then have the capability to export the project information along with the employees info to an XML file. I have attached a barebones version of both tables with several records and a portal to display as an example. Would someone be able to point me in the right direction? After I find a way to mark certain items and then export I will try to find out how to change the
  12. This is a compilation of resources including credit with the goal of helping people better understand the Anchor-Buoy Model. I have combining key terms people have used in asking questions where this may be the answer. Circular Relationship: (I knew what I wanted to do but didn't know how to ask) If you have multiple tables with many to many relationships and/or also want to have portals showing these relationships. You can not simply relate them using a Join Table Anchor-Buoy Graph Model: Though it is not necessary to use this model throughout your graph it will pr
  13. SOLVED by strictly following the anchor-buoy method.
  14. I just mean you may want to duplicate the file you are having trouble with before tinkering so that you do not inadvertently cause more problems.
  15. Not that it needs to be said but I would back your DB up and try to repair a copy as to not complicate things more then they already are.
  • Create New...

Important Information

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