Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Plucky

  • Rank

Profile Information

  • Gender
    Not Telling
  1. Plucky

    XML Import

    I will give it a go.
  2. Plucky

    XML Import

    Hi Comment I'm probably asking to much now but Is it possible to import the xml elements and have FM split between two tables. Table one (XML) would have the Job and Plate fields and the second table (Portal) would be a portal and contain the Name fields. XML.fmp12 names_import.xsl
  3. Plucky

    XML Import

    Hi Comment Thanks for this. Ive now added the extra elements and its all working well.
  4. Plucky

    XML Import

    Hi Im looking at importing xml sheets into a database that gets generated by a digital platemaking machine after each cast is run. I would like the FM import to generate a new record for every Name element but each record must contain the Job and Plate element information as this stays the same for each cast run. Is it possible to use these xml sheets as they are or would they need changing. also does anyone one have a example I can look at to understand how it needs to be set up to import into FM RUN71-60X50-155DLC-PRIORITY16.xml RUN73-80X50-155FSC-PRIORITY17.xml RUN75-80X50-125FSC-PRIORITY18.xml RUN76-80X50-125FSC-PRIORITY18.xml XML.fmp12
  5. Thats perfect.. Thanks for your help.
  6. Hi Im after a bit of help please I have a small test database that I'm trying to figure out if its at all possible to export a single xml file to give me a result like this: <?xml version="1.0" encoding="UTF-8"?> <JOB> <PrimaryKey>88B2BDCE-A0B2-41EB-B190-0480DF3AD6A9</PrimaryKey> <WTN>3453</WTN> <Customer>Bosch</Customer> <Colours1>Red</Colours1> <Colours2>Blue</Colours2> <Colours3>Yellow</Colours3> <Colours4>Green</Colours4> <Colours5>Pink</Colours5> </JOB> everything is working correctly apart from the Colours field that contains 5 repetitions. my test.xsl just gives me this result: <?xml version="1.0" encoding="UTF-8"?> <JOB> <PrimaryKey>88B2BDCE-A0B2-41EB-B190-0480DF3AD6A9</PrimaryKey> <WTN>3453</WTN> <Customer>Bosch</Customer> <Colours>Red</Colours> </JOB> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fmp"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/> <xsl:template match="/"> <JOB> <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <PrimaryKey><xsl:value-of select="fmp:COL[1]/fmp:DATA"/></PrimaryKey> <WTN><xsl:value-of select="fmp:COL[2]/fmp:DATA"/></WTN> <Customer><xsl:value-of select="fmp:COL[3]/fmp:DATA"/></Customer> <Colours><xsl:value-of select="fmp:COL[4]/fmp:DATA"/></Colours> </xsl:for-each> </JOB> </xsl:template> </xsl:stylesheet> I know I can just create 5 separate colour fields and export them individually but this is just a test database for a much bigger database that contains multiple fields with repetitions. any help will be much appreciated. test.fmp12 test.xml test.xsl
  7. Hi jbante the problems I found with just having my script reducing the total stock level by one every time a user scans a code is sometimes they might want to reduce the amount by up to 6 or if stock is being added then we can have 50+ items added at one time. ive now changed the script to forward to a layout with a in and out field so they can enter a amount this seems to work better. i have found logging in to the FM Solution slow on a iPhone when sharing from the demo application on my laptop. im not sure what software I should purchase to roll it out. FM Server? If so how many users or should I just have FileMaker Pro sharing it on my network. i will have 5 or 6 users but probably maximum of 2 at anyone time using it. And I would like to automate a script to run at a certain time to check levels to email suppliers to replenish stock levels. Better still if I could open up a list view to supplies so they can check on stock levels via the web so they can control it. would I need a copy of your barcode creator per user or just one for me who would create any new products.
  8. Hi Please can some one help me with a bit of scripting: Im using the sample Inventory database that I have added a QR code for each Stock item. Ive then added a button on my iphone layout that runs my attached script and adds a transaction record and enters 1 in the Units OUT field. This works ok when removing just one stock Item but not when removing 5 or 6 or adding 20 or 30 I have a problem. Im not sure if this is the best course of action but I now have two different QR codes per item that either has IN_0000123 or OUT_0000123. If Im removing a stock item I would like to scan the OUT code and this then searches for the record and then gives me a option to create a transaction and enter a figure of items removed. The same with the IN code but this would add a figure in the Units IN field. Just need a bit of help on the script or if you can think of a better way. Thanks
  9. Thanks for your help. I will give it a go.
  10. Hi Im looking at introducing QR codes to the demo Inventory database supplied with Filemaker Pro 15. This will enable me to generate a code per item/record. I will then print off the code to a DYMO label and stick it to the actual stock item. I then would like to be able to have employees scan a code every time they use one of the products so that Filemaker then reduces the stock level by 1. I would like to be able to open the Inventory DB and then activate a script that scans a QR code then searches for the code/record and enters a new record in the stock transactions file adding a number one to the units out field. I plan to use Filemaker Go v15 for this on either iphones or ipads. Im ok with generating the codes its just the script that scans the QR code I’m stuck on. any help would much appreciated or Is there a demo file available that I can download to see how I need to set this up.
  11. Its ok now. I copied the 'server.pem' file from the 'Show package contents' of Filemaker Pro v9.03 on another networked mac and placed it in my Filemaker Pro Advanced packaged contents and it work. Filemaker Pro.app --> Show Package Contents --> Contents --> Mac OS / server.pem Thanks for your help.
  12. Hi I Have just installed Filemaker v10.0.3 on a new MacBook pro running 10.8 and found I can see my hosted server but no available hosts. I have other computers accessing the available databases on the network fine but they are running filemaker v9.0.3 and OS 10.5 The FM Server Advanced is version Any ideas
  13. Plucky

    Line Graph

    Hi Im trying to create a FM database on press readings I have taken and would normally enter into a Microsoft Excel spreadsheet. Each FM record would need it's own graph using multiple fields on the layout. I probably not explaining this very well so I have attached my FM12 database and my Excel sheet I'm trying to duplicate. Can someone take a look and see if it's possible please. regards Peter DGC.zip
  14. Hi Is it possible to create QR codes on my filemaker solution that I can print to a dymo label. This then can be stuck onto a product that I supply a customer. When my product needs replacing all my customer needs to do is scan the code using his smartphone and the code then email's automatically requesting a replacement product. The email would need to have all the information that was stored in the QR code. Regards Peter
  • Create New...

Important Information

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