Jump to content

Tony Diaz

Members
  • Content Count

    84
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Tony Diaz

  • Rank
    member

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    18

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Any (6.0.8, 7.6, 8.6, 9.1 etc), OS X, MacOS, macOS
  1. Also, does it have a time limit on it? .. since it's been a little while now, is it worth messing with? As for HostGator. They use CentOS, so it shouldn't be any issue to do.
  2. A global field ... in the table that is on the layout where the target records are I gather, before the loop happens? Set Field [ Moby_Screenshots_Meta::GlobalField ; JSONGetElement ( $record ; "caption" ) ] ..and something instead of the New Record / Request? I'm not having too much success with finding examples of scripting / updating existing records. I'm having a mental block with it at the moment.. hopefully it will come to me.
  3. I've got this to skip existing records when parsing incoming JSON.. If [ not IsEmpty( $screenshots ) ] Set Field [ Moby_Games_Importer::JSON_VariableView0 ; $screenshots ] Set Variable [ $PLATFORM_ID ; Value: "5" ] Set Variable [ $MOBY_ID ; Value: Moby_Games_Importer::Game_ID ] Set Variable [ $n ; Value: ValueCount ( JSONListKeys ( $screenshots ; "" ) ) ] Freeze Window Go to Layout [ “Moby_Screenshots_Meta” (Moby_Screenshots_Meta) ; Animation: None ] Set Variable [ $existingIDs ; Value: ExecuteSQL ( "SELECT Caption FROM Moby_Screenshots_Meta" ; "" ; "" ) ] Loop Set Varia
  4. I actually don't care about the order of their selection. It was more of a precursor to "They're going to be listed in that order due to the way FileMaker works" so that does not matter to me. On the values being listed from the 2nd field, I don't care what the order is at all. I'm trying to duplicate this kind of display of whatever choices I've selected: Platforms and Genre each have multiple options selected. So they're separated by commas. The others in this example are each single values. Otherwise, right now I'm doing it manually when adding them: Clicking i
  5. If I want to create a new record during a script, I need to select the layout that is associated with that desired table.. (Freeze Window.. create new record .. in the background) .. But if I just want to set fields in a particular table (set field Table::Field), If I do not change the layout, will those changes always be on the same / last record accessed on the non-visible table?
  6. This is a two part question: A Checkbox Field is the selected options from a Value List separated by a return (¶) So if I have a Value List where the options are Alpha, Bravo, Charlie, Delta ... and I've selected three of them, the field will be stored as: Bravo¶Delta¶Alpha Or visibly: Bravo Delta Charlie What I'd like to do is re-format the display of those values as "Bravo, Delta, Charlie" (obviously in the order selected, as the standard way value lists populate the fields) In the sample Filemaker file attached, the blue text are examples of how I'd like
  7. Okay, that takes care of that problem. Though, Generator does help with the repetitive bits of setting up script steps and matching them up with their fields/tables.. (which is actually a pretty cool thing in itself!) but it does come across as over-complicated if you don't know whats going on first. Not looking a gift horse in the mouth at all, but at least in my case, it made -a lot- more sense what it's doing after I understand the steps needed to do what it's doing in the first place. It makes setting up the -next- one an absolute breeze ... because I don't have to do it one field at a
  8. I can pick a file, but then there's never any tables to pick from. If I enter the name of an existing table, it tells me the file isn't open. I'm going through the video again now. Hmm.. yup, I see that. I went over those and still missed that. Interestingly, changing it doesn't change a thing. The line to get the amount of keys works, the proper chunk of code is in the $GENRESARRAY variable.. It's kinda like the layout is acting like a portal showing weird values due to funky relationship values. I can pick the file.. But I never get a list of
  9. I've tried to get Generator to work.. and the BE plugin is installed.. I still get errors.
  10. Here's the way the data is formatted. https://drive.google.com/file/d/1FJCCf0yKNeEoWfVVOVwAILFoZEGhqJ_b/view?usp=sharing The red columns are Single Records, there's 10 red lines. That's the main Array that's being parsed. Set Field [ Moby_Games_Cache::Genres_Array ; JSONGetElement ( $record ; "genres" ) ] # Insert Array for Genres Set Variable [ $GENRESARRAY ; Value: JSONGetElement ( $record ; "genres" ) ] If [ not IsEmpty ( $GENRESARRAY ) ] Set Field [ Moby_Games_Cache::Field 12 ; $GENRESARRAY // JSON_Parse_Sandbox::Game_ID ] Set Variable [ $x ; Value: V
  11. I seem to be able to get one array worth to process, but I can't get any deeper than that. Open the Sandbox3 file: Select the two red buttons in the upper left to open a couple additional windows. Press "Test Script" that is just below those two buttons in the upper left. = In the "Moby Games Local Cache" window, 10 records will be created. These 10 records are coming from the JSON data in the left most JSON blob field (JSON_Blob_Parse) Each of the 10 records have mostly single field items, but there are three records within each of the 10 that have a further embedded a
  12. I've got a list of Platforms and a list of Attributes. Platforms are straight up by a unique ID. The amount of common Platforms is about 15, but the total possibilities are in the Mid 3 digit range. Platforms ID Name 1 Apple II 2 Apple /// 3 Macintosh 4 Atari 2600 5 Amiga 6 Commodore 64 7 Windows 8 Amstrad CPC 9 ... 130 ... 131 Emerson Arcadia 2000 132 Bally Astrocade ... The attributes are broken down by sub-categories (SubID) and a unique ID Attributes SubID ID SubID_Name Name 1 391 Sound Devices Supported Mockingboard Sound I 1 270 Sound Devices Supporte
  13. On this, you're getting the image into a web viewer first, then inserting from that URL, to the container. It works, as little as 1 second delay is fine, too- hasn't failed in any testing. Though yes, I realize it may need more .. so for testing the 5 second pause is what I fall back onto just to make sure. With some slight changes, it's still good: (I have the direct URL already stored in a field). So taking that same thing and using it here to get the screenshot and thumbnail image. (Yes, I could probably just have FileMaker create that thumbnail too I suppose)
  14. Okay, the fact that IF [ ... ] is doing exactly what I was blatantly missing. Giving me an option to skip ahead. D'oh! Set Variable [ $screenshots ; Value: JSONGetElement ( Items::JSON_Blob_Detail ; "screenshots" ) ] If [ not IsEmpty( $screenshots ) ] Set Field [ Items::JSON_VariableView0 ; $screenshots ] Set Variable [ $PLATFORM_ID ; Value: "5" ] Set Variable [ $MOBY_ID ; Value: Items::Moby_ID ] Set Variable [ $n ; Value: ValueCount ( JSONListKeys ( $screenshots ; "" ) ) ] Freeze Window Go to Layout [ “Moby_Screenshots_Meta” (Moby_Screenshots_Meta) ; Animation: None ] Set
  15. If I remove that inner loop, when it exits loop if the record exists, it's doing the same thing as the first Exit if $i > $n, and the whole thing quits parsing the rest. ..and if the data being parsed has duplicate values in it, and that $existingIDs doesn't take into consideration anything that has been added during this particular script running. Thats why I opted for that placement. I do realize it's doing that repetitively otherwise. If there's a more efficient way, please show me ..and with Set Variable $existingIDs outside of the inner most loop, it's actually fa
×
×
  • Create New...

Important Information

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