Jump to content

Search the Community

Showing results for tags 'csv'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


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

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting


  • Community Calendar
  • FileMaker User Groups

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 8 results

  1. Source: I have a database of zip codes. Trying to Achieve I will have at text file of 12 zip codes that need to be found. Current Method: I click on find, enter one zip code, do a cntl-n, enter another zip code, cntrl-n, enter another zipcode... until done. Problem: This works but can be very time consuming. Today I had enough: Today, I had 35 zip code. 20 minutes later, I decided there has to be a faster way. Not sure where to start: I have been thinking about this, but not sure how to begin. Do I do a script, relationship, global, etc. Data: I have attached the Filemaker data and my text file of search data for reference.{see zip file--zipData.fp7 and samplesearch.txt} Help: I am hoping someone can get me started. My search data is in a simple text file with a return separating each zip(thus each zip is on its own line). Of course, the filemaker pro is holding 100's of zip codes. I would appreciate if someone can at least get me started. One way I can think is to do a script with a loop, but how do I pick up the data from the text file? My guess is there is probably a much better way. Thanks in advance for any suggestion or help you can give. Chuck ZipCodes&Search.zip
  2. What is the simplest way to export a found set of related records as a CSV file (using Export Field Contents script step) that includes a custom header row?
  3. So I have a working native applescript already: set stringToFind to """ set stringToReplace to "" set theFile to choose file set theContent to read theFile as «class utf8» set {oldTID, AppleScript's text item delimiters} to {AppleScript's text item delimiters, stringToFind} set ti to every text item of theContent set AppleScript's text item delimiters to stringToReplace set newContent to ti as string set AppleScript's text item delimiters to oldTID try set fd to open for access theFile with write permission set eof of fd to 0 write newContent to fd as «class utf8» close access fd on error close access theFile end try I want to eliminate the "choose file" step at the beginning since the file location is in a filemaker variable already, but if I change to it being a calculated script (only major changes in the first three lines): "set stringToFind to """¶ set stringToReplace to ""¶ set theFile to " & Quote($filePath) & "¶ set theContent to read theFile as «class utf8»¶ set {oldTID, AppleScript's text item delimiters} to {AppleScript's text item delimiters, stringToFind}¶ set ti to every text item of theContent¶ set AppleScript's text item delimiters to stringToReplace¶ set newContent to ti as string¶ set AppleScript's text item delimiters to oldTID¶ try¶ set fd to open for access theFile with write permission¶ set eof of fd to 0¶ write newContent to fd as «class utf8»¶ close access fd¶ on error¶ close access theFile¶ end try" I get the error: "Expected end of line, etc. but found identifier."
  4. I can manually import a .csv URL from the web just fine. Works every time. Why can't I script it to import that same URL? Thanks! An example (not a real URL) is: https://docs.google.com/spreadsheets/d/16irOtO503scu0pKguIzYSM0PTu1oc7rvY7Y/export?gid=0&format=csv
  5. As the title says I'm having trouble exporting records as a csv file to a file on the user's desktop. The problem I have is apparently these export paths: filemac:~/Desktop/LegAve_Orders/$file file:Desktop/LegAve_Orders/$file Both give a "File cannot be created on this disk" error. I assume because the export paths are not correct. Is there even a way to do this without knowing the user name?
  6. Hi everybody, happy Halloween!!! I have a problem to import a text file into FM. I have this scheme (without "[", "]" symbols): >[Accession Code1] [Description1] [ADFGDLFGRTGKRTKRDTHKRKTHKDRTHRDKTKHDR FGFGHSFHSFHSFGHFGSHFSSFHSFHFGHSFGHSFH GFHSGFHSFGHS] >[Accession Code2] [Description2] [ADFGRVSIVNANVAENBVIAENBIOAENBIHRDKTKHDR IVAVNAOENVIOENVIOAENVVIAENANOIANAVIOENVA GFHSGFHSFGHS] .... I would like to include this information in different columns as: Column1: [Accession Code] Column2: [Description] Column3: [Letter Sequence] Could anyone help me? Thank you very much, Wardiam
  7. I am trying to export a selection of records. I export them into a csv file. One of the fields is made up of several other concatenated together. e.g. field1 & " " & TextStyleAdd ( field2; Bold ) & Case( IsEmpty(field2); ""; "") & "¶" & TextStyleAdd(field3;SmallCaps) & "¶" & field4 & "¶" & TextStyleAdd ( field5; Italic ) & Case( IsEmpty(field5); ""; " ") & " " & Case( IsEmpty(field5); ""; "¶¶") & field6 & Case( IsEmpty(field6); ""; "¶") & Score_100 & Case( IsEmpty( field7) ; " "; TextStyleAdd ( "/ "; Subscript )) & " " & Year( Date) & Case( IsEmpty(Date); ""; TextStyleAdd ( " [Date]"; Superscript )) & Case ( 0 ; ( field8 ) * 100 & "%" ) & Case( IsEmpty(field8); ""; "¶") & GetAsText ( field9 ) & Case( IsEmpty(field9); ""; "¶") & Case ( 0 ; ( Alcohol ) * 100 & "%¶" ) & Region::Appellation&Case( IsEmpty(Region::Appellation); ""; "¶") & Region::Region&Case( IsEmpty(field1a); ""; "¶") & field1b&Case( IsEmpty(Region::field1b); ""; "¶") & field1c&Case( IsEmpty(field1c); ""; "") The field looks fine in FM (8.5 by the way), but when I EXPORT this to a csv file most of the contents of this run together and don't retain the formatting of the paragraphing as shown above. On the other hand if I 'SAVE AS' and choose Excel it seems better and then I convert into a csv using say OpenOffice. What can I do to keep the formatting to export to a csv - I click the retain formatting link ? Thanks.
  8. I'm having a problem I hope someone can help me with. I need to import a csv file on a daily basis that gets deposited on an FTP site. Problem is, FMP12 (my current version) does not easily allow for import of csv files in a cloud hosted application. I need to define a file path in order for the import process to work, but cannot find an easy solution to accomplish this. Any help would be much appreciated!
  • Create New...

Important Information

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