Jump to content

Jaesin

Members
  • Content Count

    10
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jaesin

  • Rank
    member
  1. Thanks again, I will see if i can get this to work for me over the weekend! Appreciated!
  2. Thank you for the quick reply back.. I am fairly new at using Filemaker, would you perhaps know of a knowledge base that would have some information on making the Find & Replace a floating window?
  3. I am looking to make the switch from ACCESS to Filemaker 12, but am having a tough time on pulling the trigger. My concern is the way Filemakers Find and Replace works, versus ACCESS. In my use, I have to edit the text in fields pretty heavily, and having to bring up the find and replace window, use it, and then close it to select another field, has become quite annoying as well as much slower than having it already selected in ACCESS and then clicking into any field you want to make a change. Is there a way to alter the Filemaker Find & Replace to stay permanent on the screen? As mentioned allot of editing to the fields has to be done, moving data from a "description" filed into other fields and editing the data for consistency...,, Could someone recommend an add on that would provide some higher level text editing functions within Filemaker? Thanks for your help in advance. FYI - I am using Filemaker 12 Advanced.
  4. I have an excel sheet with the following fields- Product Name (ABC123) Image View (Front) Image location (x:myimages/photo1.jpg) New Name How would I go about asking file maker to 1. Retrieve the image from its current location 2. Rename the image using the Product Name and Image View (ABC123 Front.jpg) 3. Save the image in a new location (example C:/NewImage/) 4. Record the new image name. Could you advise me of the scripts and functions I would have to study to learn to do something like this? Thanks for any help in advance.
  5. Jaesin

    Creating an XSLT file for Filemaker 12 import

    I ordered a copy on Amazon of that book, thank you for the recommendation and the help.
  6. Jaesin

    Creating an XSLT file for Filemaker 12 import

    Thank you again for the fast reply back. In review of the FMPXMLResult gramar found on Filemakers site it notes the Row element is required, but the RECORDID and MODID attributes are not needed. In experimenting I have pulled these Attributes from the ROW element, and the import results look to be the same. Could you tell me what benefit/use is made in leaving the attributes values in this element?
  7. Jaesin

    Creating an XSLT file for Filemaker 12 import

    A big thank you, this samples you gave me really help me to understand the process. I will play with adding fields further, and try to learn as much as I can from this! Terrific help, and I now have a working idea of how the XSL helps to transform the XML! I do have a question about this - - <xsl:value-of select="position()"/> I have tried to find some information on its purpose / function in the file, but just cant seem to understand the examples I had found on the web. Could you give me some insight on its roll?
  8. Jaesin

    Creating an XSLT file for Filemaker 12 import

    Thank you for your quick reply, as requested I have added a sample file. You had responded to one of my questions as - "You create one XSL for each import and have a script that does all the imports." This is what I think would be best being that the information would be spread across multiple staging tables before being appended into my production database. Please have a look and let me know what you think, or the best way to approach this, as I mentioned Its a bit of a learning curve, but one I am interested in learning fully. As mentioned I also have an XSD for this if it would help, let me know Thanks again Sample3.0.xml
  9. I have a xml file I would like to import into Filemaker 12, however I find that I will need a XSLT file to make this work. I do not know much about XSLT files, and have picked up a "for dummies" book covering this, but still have a few questions I could use help on. I have an XSD file that would be used for validation of the XML file, does this file play any roll in the creation of my XSLT file? Is it possible to import the XML file so that the data is divided into multiple tables that I have in my database? Is it a better idea to import the XML file into a single staging table, and then query that table to populate my production tables? Last question, is it possible to reverse engineer the needed XSLT file by Building a table that caters to the XML structure and rules (using the XSD file) , then populating sample data, and then exporting the table and the Filemaker XSLT language? Would this create the needed XSLT file that can then be used with my XML import? Sorry if these questions seem to be simplistic, I am new to filemaker with mostly previous MS Access database experiences, I am trying to learn as much as I can self taught. Thank you in advance for any help given.
  10. This is my first post in joining the FM Forums. Glad to have found such great support/community source this early. I apologize if my question reads a little bit silly to some, as I am brand new to the Filemaker product, and getting my feet wet. I am using Filemaker Pro 12 Advanced On my PC, and currently using the VTC online training courses to help me learn my way around. My question is - when importing an XML file, Filemaker requires an XSLT file so that it efectively understands what it should "do" with the data being imported. I have not really found substantial (in my opinion) information on the Filemaker structure or requirements in XSLT files, that I can learn how to create this. I have an XML file that is essentially a catalog of product data (pricing, shipping, descriptions, supporting links, etc..), and I wish to import that file into my database to take the information and place it into the fields and tables I have created. I was hoping to automate this as much as possible, as the XML file is allways delivered in the same format (I have an XSD file with this format). I am hoping that someone can either tell me what function or aspoects of Filemaker I should be learning or studying to get a better understanding of how to acomplish this. I am hoping I understand this procedure I am trying to do (importing xml to the database) and I am on the right path, or am I making the import to difficult on myself? Also is there tools or programs that can simplify this type of work for me? I appreciate any help, and thank you in advance.
×

Important Information

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