Jump to content

Search the Community

Showing results for tags 'import'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • 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
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting

Categories

  • White Papers
  • Infographics
  • Samples
  • Add-ons
  • FMGo
  • Solutions
  • Tutorials
  • Plug-Ins

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

  1. Hi, all I need is to read the content of a text file into a text field and I can’t figure out how. Situation: I have ≈150’000 folders, each with one image file and one xml/text file with meta information about the image file. The image file and the meta data need to go into the same record. I’ve looked for hours now, but couldn’t find a solution: • I can’t use the import folder command, because it creates new records for each file in a directory. • I can’t use Do AppleScript > do shell script > cat x.txt, because I can’t get the result into FileMaker. • I ca
  2. I am trying to import data from a MySQL database and need to somehow also import fieldnames to be the fieldname in FMP. Is there anyway to do that? I have a CSV of the fieldnames and I also have a MySQL dump of fieldnames and associated data. Thanks for any help.
  3. Gents, there is a price list in Excel with images embedded. Do you have an idea how to import those records into DB with corresponding images preserved? Note that I've attached only two records, there are 600 of them. Any manual manipulations with the images is not an option. price.xlsx
  4. I have searched the forum and internet and not found an answer to my delima. I have a solution with a scripted import of a csv file. I do not want import dialog (e.g. mapping), so I have it set to no. I don't know the name of the file, only that it is a csv file. If I leave the filename out of the import dialogue, the default SHOW filetype in the open file dialog is for a filemaker database. The user needs education to change the SHOW to csv or all. That is undesirable. If I import a correct file once, the next time the script runs in that session, it prompts for a csv file, but if I qui
  5. My FMP pro 15 doesn't allow to import ".avi" and ".mkv" files. The error is the files are not the specified file type How to do so?
  6. Hi everyone, I am trying to run a server sided script that will import a found set. The server sided script opens a handler file that opens data file 1, does the find, imports into data file 2. However, the search works in script debugger but imports all records. The script opens layout A, searches goes to layout b, imports. Also the import of the selected fields seems not be remembered. I am stuck..... Thank you
  7. Hi! using FM18v3 I defined an import, update using key with option :add remaining. Odd enough, when running the import for the first time, the key field remains empty. (Unexpected) As a result the second time I run the script I get new records, but now the keyfieldfield is filled. (Expected) The third time the import also runs as expected ( no new records ). I fixed this by defining this script in FM18 using an if. Eventually, I launched FM17 and re-did the script. Now it works like it should. Anyone else can replicate this? Kind regards,
  8. Filemaker Pro 11 is running on two Windows 10 computers connected as Host and Client over a network. The script to import data from an Excel .csv file utilizes the following script step options: 1. Un-Checked - Specify data source - File 2. Check - Specify import order, Import Action a. Select - Update existing records in found set b. Check - Don't import first record (contains field names) 3. Check - Perform without dialog When the Import script is run from the Host computer, and the desired .csv file is manually selected, the Excel first row fi
  9. On windows 7 (VMware on OSX), using FMP17 and Microsoft Access 2016 Trying to do a ODBC import and selecting the datasource, I get asked for Username and password, even if the Access DB is not password protected. The data sources are correct (tested from Livecode) and should be working without user name and password. On the properties of the ODBC pane setup the path seems correct (not pointing to 32): %windir%\SysWOW64\odbcad32.exe What am I missing?
  10. I've attached two files. The first one is INVOICE, that is generated by every establishment when you purchase, and is in xml format. The second one is XSLT file, that is provided by government fiscal institution and is used to "translate" xml. PROBLEM DESCRIPTION: when I try to decode xml using attached xslt scheme on any online xml-converter website the output looks fine. BUT when importing to Filemaker, I receive an error: "XML parsing error: invalid document structure". I would appreciate any help with the issue. Thanks. XML input.xml XSLT scheme.xslt
  11. Hi everyone, I'm a beginner in FM, and i'm trying to develop a solution that allows me to import data from a csv file. I have two related tables Customer ("parent") and Alerts ("child"), each one has a primary key and the Alerts table has a foreign key to conect with the Customer table. I have to populated the alerts table from a cvs file that could have lots of records so I want to relate this new data to the right customers automatically when i import it, the new data does not have a field with the customer ID (primay key) only has its name. Could you please give me any advice with that
  12. Hi - I'm developing a business solution to be hosted on FM Server. It will be hosted on Soliant Cloud. This is my first time developing for Server. I read Steven and Wim's whitepaper on FM 16 security, which was very helpful. In the past, when I've created upgrades to my solution, I've imported data from the previous version into the new one. Each update is a modified version of the previous file. I read about the benefits of using File Access Protection. My solution is a single file solution so I can basically exclude any other file having access - except I'm not sure what impac
  13. I'd get some problems with date formats after installing FMS 15, and I'm trying to solve it by importing to a clone of the original database. But two tables has no layouts and I can't find a way to import these tables without making a layout in the clone or adding a table when importing. The last seems to be the simplest, but how will the relationships behave?
  14. Hello, I've done quite a bit with FileMaker in the past, but have never jumped into the XML arena. Now I have a need to do so, and I'm really needing some help with something I'm sure is quite basic...but still foreign to me. I have an external data source which export XML in a very specific format (see attached). I need to import that into FileMaker so I can manipulate the data, do some various lookups, etc. Once I've made my changes in the data, I need to export in the exact format it was when imported so the external data source can properly import. Not sure if it makes sense to i
  15. IN my db I have the following fields IMAGE (CONTAINS 14 FRAMES FROM A MOV FILES AS A JPG FILE) FILEPATH (TEXT FILE AS FOLLOWS: file://Data/Videos/MVI_9887.MOV) VIDEO A Container file where I would like to see the "file://Data/Videos/MVI_9887.MOV" In the DB I have several different records how can I create a SCRIPT AS SUCH GO TO FIELD VIDEO OPEN file://Data/Videos/MVI_9887.MOV I Don't want to keep the video file in the db but only look at it when needed The various INSERT QUICKTIME, URL and so on require me to set the actual file path for each MOVIE file
  16. 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
  17. Not sure if this is the relevant area however, I couldn't seem to find a scripting section What I would like to do and I have had no success so far is the following scenario. I have database which stores references to files in container field located on a folder on a shared computer. What I want to do is have a script which when run populates the database with the names of those files located in the folders on the computer and create a new record for those not already present and if they are already present ignore the import. I have tried a test script which gets the docume
  18. Over the past ten years our organization have been using a PO database solution to store all purchasing information. Each year the layout would change to illustrate which year it represents. We would like to merge each of these databases into one for better searching capabilities. Is there an easy way to accomplish this task while still maintaining data integrity? Thank you!
  19. Attention: Before posting in the general discussion forum please review the other forums that would best suit your topic. If you cannot find one then you may delete this text and post your topic in this forum. Hi all, I need to import into filemaker table an XML file as this: <?xml version="1.0" encoding="utf-8"?> <Account> <Field APIName="WrntyID">6029065</Field> <Field APIName="ExternalID">1761A</Field> <Field APIName="Name">sayIT SA</Field> </Account> now I'am trying to create the xls file. This is m
  20. Hi FMers, I'm trying to get multiple choice quiz questions into a FileMaker database. The information is in a plain text file. Question and options are simply separated by returns: Where in the cell is the genome located? Mostly in the cytosol. Mostly in the mitochondria. [X] Mostly in the nucleus. Stored in the membrane. Stored in RNA. Next question... Each question has 5 options, one of which is correct [X]. There's an empty line between questions. What's a good approach to get this into a FileMaker database with separate fields for the questions, the optio
  21. Hi i created a certificate and want that when it is clicked to save it it gets created into a pdf and then imported into the cetification container field , however for some reason i am recieving some error in my script , the pdf does not save at all. see script below: i would appreciate if someone could tell me where i went wrong why my pdf is not saving and if this is the method to save the pdf to a container
  22. I have come across this technique severally on this forum, but I can't figure out how this really works. Right now I am faced with a situation that requires similar technique and I can't seem to get it work. I have Table A and Table B. 1. I want to script an import Process that will first export all records in Table A into Table B (kinda A Clone Copy of Table A) Thats just my basic objective 2. Then from there, I would want to be able to do similar Process but this time, I will only update the records in Table B with that of Table A using a match field. 3. I will also love
  23. Hi We have a database in Go 14 and users need to Import records from Filemaker Server 14, to Filemaker Go. And it runs very good with all Users that have: Ipad Air 2 and Ipad Pro Import time: 8 to 9 Minutes But all the users that have: Ipad 3rd and Ipad 4rd Generation Import time: + 1Hour Both using the same wireless, Is there any way I can identify in a script what Ipad Model the user has ? Best Regards
  24. Hi, I have a problem with server side import of records. I have a simple script which just does an import of a textile (with tab delimiters): Set Variable [$FileList; Value: "filewin://server/folder/1795739.txt"] Go to Layout ["files" (files)] Import Records [No dialog; "$FileList"; Add; UTF-8] When I run it client side, everything is fine. When I run it server side with Perform Script on Server I'm getting an error: The previous script step, "Perform Script on Server", could not be completed because of an error.... If I run Get ( LastError), I get error code 100 (
  25. I have been able to use the Import script step to import pictures from a folder. However, doing the same for bunch of pdf and word document files have not been a success. Is there any special trick to achieve this?
×
×
  • Create New...

Important Information

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