Jump to content

Tony Morosco

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Tony Morosco

  • Rank
  • Birthday August 20

Profile Information

  • Title
  • Industry
    botanical databases
  • Gender
  • Location
    Soquel, CA
  • Interests

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    15 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Windows 10
  1. Hi all, We ended up re-creating the site in FM WebDirect. It was much simpler, than trying to suss out the problems with the older pHp custom web publishing scripts. So I am sure this thread won't be of much help for future researchers. Cheers, Tony
  2. Hi Jonathan , Yes, this site was originally generated in SiteAssistant back in 2010 or so. It's only recently updated to FileMaker Server 15 this year, thus the problems. Yes, I know it isn't returning any results, which is what I was looking for. I probably didn't phrase it very well. The online website is at http://cornucopia.sfbg.org/PublicPortal/home.php and called PlantFinder. (Obviously it looks for specimens at a botanical garden for the public.) But I presume you need to get into the computer. Will have to see if I can swing that. Why don't you contact me and I'll see what I can do! tmorosco@gmail.com Many thanks! I'll post any follow-up results here, once we get this solved. Cheers, Tony
  3. If I follow up the print_r($result); with the following, $statusLinks = getStatusLinks("recordlist.php", $result, $skip, $max); $records = $result->getRecords(); echo "\n<P>Records: "; echo $statusLinks['records']['rangestart']; echo " - "; echo $statusLinks['records']['rangeend']; echo " of "; echo $statusLinks['records']['foundcount']; echo ". <P>\n"; exit; I still get the following: Records: 0 - 0 of 0. I know this script ran for many years under a previous version of FileMaker, so very frustrating for me to update! :-P I did the initial design, but had a little thing called an AVM since then (a stroke.)
  4. Hi Jonathan, Early on, I did end up reverting the php back to the FileMaker supplied files, and removed the extraneous php version that IT had installed. However I seem to be running into the same issue, so the versioning does not seem to be an issue. I'm now running under php 5.6.24, and Microsoft Windows 2012 R2 Standard. For the second question, I've inserted this directly after the database call. Here is what it produces: FileMaker_Result Object ( [_impl] => FileMaker_Result_Implementation Object ( [_fm] => FileMaker_Implementation Object ( [V73ee434e] => Array ( [charset] => UTF-8 [locale] => en [logLevel] => 3 [hostspec] => [recordClass] => FileMaker_Record [prevalidate] => [database] => location [username] => [password] => ) [Vea4b3413] => [V9a3dcbce] => ) [_layout] => [_records] => [_tableCount] => [_foundSetCount] => [_fetchCount] => )
  5. Hello, I am trying to convert a custom web publishing site in php, from FM Server 12 to FM Server 15. We've updated the Windows machine that hosts it (to a shared server on the recommendation of IT) and installed FM Server 15. Direct opening of the existing scripts always yields 0 results, though the database hasn't changed. Is there some setting, somewhere, that I am oblivious to? I've consulted user's manuals, IIS settings, web postings, ... Attached is a copy of the website I am running. I can point you to the existing website, though I doubt it would be useful. The beginning part of this website are script tracking errors. I've been inserting them, trying to track down where this error is creeping up. So please ignore. Please ask any additional questions, I am sure there are many. Cheers, Tony PublicPortal.zip
  6. I'm a botanist, and the tables I am working with are for tracking botanical garden collections. The data represents plants in the garden, and the plants are tagged and show up in the database. The tables I am working with were created in FMP 7, and I'd like to open them up in FMP 11 (or later.) The system hasn't been used in years, but still has valuable information. One of the tables is giving me problems using the FMP convert and recover commands. These tables are all inter-related. The main table is the Accessions table, which contains records for all of one kind of plant, from the same source, received on the same date. It is basically a museum standard. The other tables are related to each other through this one main table. The Species table is related to the locations table through the Accessions table. (i.e. table A relates to table C through the table B, the intermediary) From the Locations table, we can't see the the species information unless the accessions table is present. When issuing the open command on the main table to convert the database to FMP 11, I get the message: "Accessions.fmp7" is damaged and cannot be opened. Use the Recover command to recover this file. When using the Recover command from v. 11, I get another message: WARNING: problems were detected while recovering the database. Please review the Recover.log file to see where problems were found and their severity. The recovered file should NOT be used going forward; copy only the most recent work from it into a backup copy of the original file. Recovery results: File blocks: scanned and rebuilt 563 blocks, dropped 214 invalid data blocks. Schema: scanned fields and tables, 1 items modified Structure: scanned; 1 items modified Field indexes: rebuilt Opening the recovered database, there are only three records present. There should be hundreds. So obviously I am looking on how to wrangle this database open. I've attached the log file here, as well as the database structure map. The other files have converted just fine. But since the main table won't open, we are kind of stuck. I can share the files with you through Dropbox or whatever, if needed. Please let me know any thoughts you have, either basic or advanced. And ask for any clarifications or additional questions. :-) Thanks! -Tony Recover.log
  7. Greetings! Sorry if my title is vague, I am not sure exactly how to describe this problem. I have taken a look in the Forums, and haven't found this question before. (If I did, please point me there.) And of course I've looked through the documentation in FM extensively. I am a botanical garden curator, and this database focuses on two tables: accessions of plants (groups of plants received at one time, with multiple individuals), and on locations of plants (individual plants of one accession, but planted in different areas). For each individual Location (of a single Accession) I would like to assign it a unique qualifier for that accession. These qualifiers are based on letters of the alphabet, so-as not to confuse them with the numerical accession numbers. For instance, for accession 2002-0101: For the first Location record, I would like the qualifier to be "A" For the second Location record, I'd like for it to be "B" For the third, I'd like it to be "C" and after the last Z value, I'd like for it to assign them AA, AB, AC, etc. I don't imagine there will be any values higher than AZ. So I am looking for a way to come up with a script and/or assigned calculation for qualifier to do this when creating a new location record in the locations table. I've already assigned these letters to existing records in our database with a script. Roughly, the existing script runs by: Sorting the Locations table,If the accession number is a new, the qualifier is set to "A", If the accession number already exists, then based on the previous records existing qualifier value, assign the next qualifier value for the record. Capture the accession number and qualifier in a variable, for use in the next recordMove on to the next record.I know that the plant collections registrar can come up with the qualifier in their head (de-novo), but frankly they don't need that headache searching through the records and coming up with a new qualifier to create a new location. I know this is rather complicated, but let me know if I should come up with two tables to let you know what is going on. I am sure it is something simple that I am overlooking. And please let me know if I am being confusing, or have not laid out the problem in a logical way. Thanks, Tony
  8. I am investigating interrelating FileMaker and ArcGIS databases. I am from the botanical world and design databases on a simplified level, so please bear with me! For instance, (and this is an over-simplified version) in both ArcGIS and FileMaker, we have a field in our databases which lists a plants status as alive or dead. Both of these databases are available outside, in the garden. We often would like to update just one source, and correct a plant's status in the garden on both systems. This would alter both the ArcGIS and the FileMaker databases, through just one update, probably in FileMaker Pro is my guess. I am imagining this can be accomplished through JDBC, ODBC, or SQL. Ideally it would be via SQL. It will provide a portal between the two systems, and update each others tables whenever the need arises. From what I understand, this should be possible. If for some reason we can't get the two databases talking directly with each other, perhaps inter-relating the two with a back-end SQL database is a possibility? We may try to build a FileMaker web portal to an ArcGIS web-viewer which can be updated, but it is kinda kludgey and does not update both tables. If anyone knows a method how this can be accomplished, please let me know! Or reccomendations on where I can post to the correct forum. And please let me know if I am not making any sense or I am garbling the language. I am known for both. ;-) Cheers, Tony
  9. I am encountering some puzzling behavior when performing a find in a portal. To back up and give the groundwork of the situation, I have a database that is a fairly typical students/classes/enrollments database. The database tracks student's enrollments in classes, among other things. It is a multi-year database, and thus has enrollment information from the past as well as the present. To facilitate working with current years enrollments, there are several relationships between tables so that I can isolate this year's enrollments. Specifically for the current enrollments table occurrence, the Students table is related to Enrollments by the relationship Students::Student_ID = Current_Enrollments::Student_ID AND Students::Current_Year = Current_Enrollments::Class_Year. Thus, a portal on the Student's details screen (Student Table) using Current Enrollments displays only the classes of the current year. (Another portal to All_Enrollments table occurrence on another tab displays all enrollments). This works flawlessly. The current problem is that sometimes the same classes are offered year to year, so they have the same title, but different Class_ID, Instructors, Start_Date, Class Fee, etc. Normally when we search from the Student Details screen (Students table) in the Current Enrollments portal for a class title, the results only include students who are enrolled in a current class. Well we now have an instance where if we search for Introduction to Bryophytes (FYI Bryophytes are mosses, and we're offered it in 2008 and 2010), the results include students in this year's class, as well as students from the same class in 2008. The Class table records have identical Class titles, but different other information, including Class Year. When paging through the results, students that are enrolled in this year's class have Current Enrollments portal details as expected. For those students who were enrolled in the 2008 class, there are no listings in the Current Classes portal at all! (also expected, but why did FileMaker find a resulting match??) So how is it that a search is producing results that are unrelated?? It sure has me puzzled. I just rechecked the search field, and it is using the correct table occurrences in the portal. Any suggestions on where to look would be appreciated. I can post a relationship diagram or other info as needed. I've temp fixed it by abbreviating the old class title so it isn't found in a longer name search. Ack! bad workaround! Thanks! Tony
  10. If the disappearing field is a related field, you may also check on the following, which caused me great problems for a few hours: If your related files are old-school (multiple tables, multiple FileMaker Files), it may be the an alteration to your External Data Sources (File > Manage > External Data Sources...). I recently 'cleaned up' our External Data Source listings, which had proliferated beyond belief. Since we host our tables on FileMaker server, I cleaned them all down to a single reference of fmnet:/host.domain.name/ But this broke my PHP scripts whenever I tried to access a related field in a table. (it would say the field wasn't there, despite everything working just peachy on the native FileMaker app layouts.) Of course this change was in the middle of a bunch of other changes to the database, so it took a lot of tail chasing with permissions (assumed it was because the related table had the wrong permissions for PHP access). I had to re-add the following to External Data Sources, and voila, everything was restored and my related fields started displaying again in PHP: fmnet:/host.domain.name/ file:.fp7 Cheers, Tony BTW, the reason I cleaned up the external data references was we suddenly had a problem of a 30 second time lag when first opening a database, for no apparent reason. But the cleanup didn't help.
  11. I wonder if this might be because FileMaker's global fields are what is called 'session specific'. That is, different users of the same database have independent values for their global fields. Anyways I would suggest you read up on the behavior of global fields in multi-user environments to get a better handle on it. Cheers, Tony
  12. Wish I had an apache machine option to test. (got one on linux at home, but that's no help!). Thanks for the pointers, I'll direct some research there. I've been getting no feedback on FileMaker's own forums on this or other issues. Is it me, or is customer service slipping precipitously at FM?
  13. *bump* Can anyone report that they are using FileMaker PHP and can successfully validate records with a field rule of "not Empty"?
  14. As I detailed in my first post, that is specified in the headers. (comes default with PHP Site Assistant, even.)
  15. Update: If I add to the FileMaker-generated PHP code: $userName = utf8_decode($userName); after the $userName = $cgi->get('userName'); Then I can authenticate the user just fine. I of course have to hand code this for all the scripts, in all the tables I am hosting, and re-add it each time I regenerate the site, which is not insubstantial given that we are in active development this summer. I am now thinking it might be Microsoft's IIS 6.0 butting its head into character encoding somehow, but am unable to find where the default character encoding is specified. The instructions here on how to check IIS character encoding are not applicable. That dialog does not contain "File types..." on our machine.
  • Create New...

Important Information

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