Alle activiteit

• Compact
• Uitgebreid

Deze tijdlijn wordt automatisch bijgewerkt     

1. Afgelopen uur
2. 

   Uploaded naar server

   menno antwoordde op een vraag van Frank in FileMaker Server 16

   Nou dat lijkt me zéér onwenselijk. Een web-account of een conversie-account wil je bijvoorbeeld nooit de db met een normale FM laten benaderen en als dat ineens wél gaat, dan is dat een levensgroot lek in je beveiliging. Dus toegang via het netwerk is een in te stellen privilege en dat mag nooit automatisch voor alle privilege-sets worden ingesteld zodra je een bestand uploadt.

   • 22 minuten geleden
   • 3 antwoorden
3. Vandaag
4. 

   Uploaded naar server

   Frank antwoordde op een vraag van Frank in FileMaker Server 16

   idd de oplossing tx. Gebeurt dat niet automatisch als je die data base upload naar de server via Filemaker. Ik zou toch verwachten dat de privilegesets worden toegewezen?

   • 1 uur geleden
   • 3 antwoorden
5. Gisteren
6. 

   Downloads van de Summit

   hbrendel antwoordde op een discussie van hbrendel in FileMakerCafé

   Bedankt he.

   • 14 uur geleden
   • 2 antwoorden
7. 

   Downloads van de Summit

   Marsau antwoordde op een discussie van hbrendel in FileMakerCafé

   https://www.fmsummit.info/doc

   • 21 uur geleden
   • 2 antwoorden
8. hbrendel volgt nu Downloads van de Summit 21 uur geleden
9. 

   Downloads van de Summit

   hbrendel voegde een discussie toe in FileMakerCafé

   Hallo iedereen, Wie kan me vertellen waar ik presentaties en voorbeeldbestanden van de Summit kan downloaden?

   • 21 uur geleden
   • 2 antwoorden
10. Afgelopen week
11. 

    Button bar

    Leen voegde een vraag toe in FileMaker Pro 16 Advanced

    Hallo allemaal. Ik loop tegen een klein, maar irritant probleem aan. In een keuzemenu heb ik een tweede button bar aangemaakt en in een popover van de eerste buttonbar gezet. Beide hebben een hover fuctie zodat de kleur veranderd wanneer de cursor hier overeen gaat. Bij de keuze die met de tweede buttonbar gemaakt wordt, wordt doormiddel van een card een andere lay-out getoond waarin de mogelijkheid geboden wordt om de gemaakte keuze af te breken. Wanneer dit echter wordt gedaan, werkt de hover functie van de tweede button bar niet meer omdat het segment hiervan in de actief modus blijft staan. Ik heb al geprobeerd om de popover en de button bar een naam te geven en in een script een refresh te geven en de popover te sluiten maar dit maakt geen verschil. Is er iemand die hier een oplossing voor weet? Alvast bedankt.

    • Wednesday om 11:57
12. 

    Uploaded naar server

    menno antwoordde op een vraag van Frank in FileMaker Server 16

    Het "extended privilege": "fmapp" toewijzen aan die privilege-sets zal je probleem denk ik oplossen

    • Wednesday om 10:51
    • 3 antwoorden
13. 

    Uploaded naar server

    Frank voegde een vraag toe in FileMaker Server 16

    Ik heb een data base naar de server opgeladen en die is geopend..so far so good. Probleem is dat ik alleen kan inloggen met accounts die full access hebben. Read only : geen toegang dat entry only : geen toegang eigen privilege set : geen toegang De credentials blijven dezelfde. Wat doe ik verkeerd?

    • Wednesday om 09:56
    • 3 antwoorden
14. 

    Database

    menno antwoordde op een vraag van John07 in Web

    Ik zou zelf proberen met de data-api van FMS17 (daar kan je scripts mee laten uitvoeren) iets te doen, maar dan moet je wel zorgen dat de beveiliging op orde is. Het kan niet de bedoeling zijn om user en password van het api-account openbaar te maken, zoals dat nu wel het geval is met de googlemaps-api-key. Ik heb hem even getest en hij werkt prima diverse van mijn GM-bestanden

    • Wednesday om 07:56
    • 4 antwoorden
15. 

    Database

    Banach antwoordde op een vraag van John07 in Web

    Kun je dit wat toelichten? Ik begrijp namelijk totaal niet wat de situatie is en evenmin waar je naartoe wilt en wat daarbij de obstakels zijn. Vanzelfsprekend ligt dat aan mijn ietwat autistische manier van proberen een vraag te begrijpen. Gaat het om een WebDirect toepassing?

    • Wednesday om 07:35
    • 4 antwoorden
16. 

    Database

    bey1 antwoordde op een vraag van John07 in Web

    Hi all, Kan dit ook op pagina niveau? Ik probeer scripts toe te voegen op de volgende pagina: https://www.valkexclusief.nl/hotels/hotel-utrecht/ maar het wilt mij niet lukken om het los te trekken van het gehele databestand. Tips?

    • Tuesday om 15:02
    • 4 antwoorden
17. 

    FMSummit 2018

    Peter Wagemans antwoordde op een discussie van andries in FileMakerCafé

    Vincent Mennano vroeg me om deze foto door te geven: Ik post ‘m maar even hier, voor het geval dat ik jullie vandaag niet tegenkom. Wie de email adressen weet, kan misschien even een mailtje sturen.

    • Tuesday om 07:56
    • 10 antwoorden
18. 

    FMSummit 2018

    menno antwoordde op een discussie van andries in FileMakerCafé

    Ik heb in de topic https://www.clarify.net/index.php?/topic/9801-fm-data-migration-tool-correct-installeren/ aanvullende informatie neergezet over de scriptjes die ik gebruik en de logs die de verschillende varianten produceren. Je ziet daarin het verschil tussen een migratie met een fmmigration-account en een full_access-account en het verschil tussen block- en record-migratie.

    • Tuesday om 05:44
    • 10 antwoorden
19. 

    FM Data Migration Tool correct installeren

    menno antwoordde op een discussie van menno in Tips & Truuks

    Voor de derde doorgang heb ik een on-geïndexeerd bron-bestand gebruikt, maar met dezelfde naam, dus het script is ongewijzigd t.o.v. de vorige voorbeeld-conversie. Het effect het on-geïndexeerde bestand is dat FMDMT ipv block-migratie nu record-migratie gaat uitvoeren. Alle opgeslagen berekeningen worden opnieuw uitgevoerd en alle indexen worden opnieuw opgebouwd. De conversie duurt ookm beduidend langer nu én de log is veel langer: 0:07:24 dus grofweg een factor 50 a 60 FMDataMigration 17.0.2.205 (07-03-2018) Source file: "Old/DemoData.fmp12" Source account: "admin" Clone file: "Clone/DemoData Clone.fmp12" Clone account: "admin" Target file: "New/DemoData.fmp12" Force overwrite: On Ignore value lists: On Ignore accounts: Off Ignore fonts: On Start: Tue Oct 16 07:28:51 2018 == Mapping source privileges to target privileges == Matching source and target privilege set by the name "[Full Access]" and internal id Matching source and target privilege set by the name "[Data Entry Only]" and internal id Matching source and target privilege set by the name "[Read-Only Access]" and internal id Matching source and target privilege set by the name "PriveSet1" and internal id Matching source and target privilege set by the name "PriveSet2" and internal id Matching source and target privilege set by the name "PriveSet3" and internal id Matching source and target privilege set by the name "PriveSet4" and internal id Matching source and target privilege set by the name "PriveSet5" and internal id Matching source and target privilege set by the name "PriveSet6" and internal id Matching source and target privilege set by the name "PriveSet7" and internal id Matching source and target privilege set by the name "PriveSet8" and internal id Matching source and target privilege set by the name "PriveSet9" and internal id Matching source and target privilege set by the name "noaccess" and internal id Account "[Guest]" not changed Account "Admin" not changed Account "menno" not changed Account "piet" not changed Account "jacky" not changed Account "tanja" not changed Account "jan" not changed Account "ellen" not changed Account "noaccess" not changed == Mapping source tables to target tables == Matching source and target table by the name "Apparatuur" and internal id Matching source and target table by the name "Productiviteit" and internal id Matching source and target table by the name "Regels" and internal id == Mapping fields in source table "Productiviteit" to target table "Productiviteit" == Matching source and target field by the name "_AanmaakDts" and internal id Matching source and target field by the name "_AanmaakSerial" and internal id Matching source and target field by the name "_AuditData" and internal id Matching source and target field by the name "_CreationID" and internal id Matching source and target field by the name "_MedewerkerID" and internal id Matching source and target field by the name "#1" and internal id Matching source and target field by the name "#tablename" and internal id Matching source and target field by the name "_ScanID" and internal id Matching source and target field by the name "Shipmentnummer" and internal id Matching source and target field by the name "HD_Grootte" and internal id Matching source and target field by the name "HD_Aantal" and internal id Matching source and target field by the name "Cleandatum" and internal id Matching source and target field by the name "ClnSeconds" and internal id Matching source and target field by the name "ID" and internal id Matching source and target field by the name "_Datum_Overzicht" and internal id Matching source and target field by the name "_Overzicht_Jaar" and internal id Matching source and target field by the name "_Overzicht_Jaar_Fiscal" and internal id Matching source and target field by the name "_Overzicht_Kwartaal" and internal id Matching source and target field by the name "_Overzicht_Maand" and internal id Matching source and target field by the name "_Overzicht_Week" and internal id Matching source and target field by the name "_HD_Aantal" and internal id Matching source and target field by the name "_rHD_Aantal" and internal id Matching source and target field by the name "_gUUID" and internal id Matching source and target field by the name "_gOwnerID" and internal id Matching source and target field by the name "_rUUID" and internal id -- Block mode migration for source table "Productiviteit" -- == Mapping fields in source table "Apparatuur" to target table "Apparatuur" == Matching source and target field by the name "_AanmaakDts" and internal id Matching source and target field by the name "_AanmaakSerial" and internal id Matching source and target field by the name "_UUID" and internal id Matching source and target field by the name "#1" and internal id Matching source and target field by the name "_OwnerID" and internal id Matching source and target field by the name "#tablename" and internal id Matching source and target field by the name "_Table_UUID" and internal id Matching source and target field by the name "_TableName" and internal id Matching source and target field by the name "_Apparatuurnummer" and internal id Matching source and target field by the name "Volgnummer" and internal id Matching source and target field by the name "_MedewerkerID" and internal id Matching source and target field by the name "Soort" and internal id Matching source and target field by the name "Merk" and internal id Matching source and target field by the name "Model" and internal id Matching source and target field by the name "Partnummer" and internal id Matching source and target field by the name "Serienummer" and internal id Matching source and target field by the name "Omschrijving" and internal id Matching source and target field by the name "Staat" and internal id Matching source and target field by the name "Opmerkingen" and internal id Matching source and target field by the name "Price" and internal id Matching source and target field by the name "DefectOmschrijving" and internal id Matching source and target field by the name "Report_dts" and internal id Matching source and target field by the name "Report_uinique.id" and internal id Matching source and target field by the name "Report_serial.id" and internal id Matching source and target field by the name "~~Report_company.id" and internal id Matching source and target field by the name "_gSortering" and internal id Matching source and target field by the name "Herkomst" and internal id Matching source and target field by the name "Disks" and internal id Matching source and target field by the name "Price_Base" and internal id Matching source and target field by the name "Price_Damage" and internal id Matching source and target field by the name "_CreationID" and internal id Matching source and target field by the name "_Serial_number" and internal id Matching source and target field by the name "_PrijsLijn" and internal id Matching source and target field by the name "Productie_date" and internal id Matching source and target field by the name "Inkoopprijs_orig" and internal id Matching source and target field by the name "_AuditData" and internal id Matching source and target field by the name "#importtro" and internal id Matching source and target field by the name "ECCM_Organisatie" and internal id Matching source and target field by the name "ECCM_VerwVerzoek" and internal id Matching source and target field by the name "ECCM_Aankoopdd" and internal id Matching source and target field by the name "ECCM_Configuratie" and internal id Matching source and target field by the name "ECCM_ValidatieDatum" and internal id Matching source and target field by the name "ECCM_ApparatuurOmschrijving" and internal id Matching source and target field by the name "ECCM_Serienummer" and internal id Matching source and target field by the name "ECCM_ProductCode" and internal id Matching source and target field by the name "Source" and internal id Matching source and target field by the name "_ScanID" and internal id Matching source and target field by the name "ITR_Categorie" and internal id Matching source and target field by the name "ITR_Serie" and internal id Matching source and target field by the name "Info4" and internal id Matching source and target field by the name "Info5" and internal id Matching source and target field by the name "_Datum_Overzicht" and internal id Matching source and target field by the name "_Overzicht_Jaar" and internal id Matching source and target field by the name "_Overzicht_Jaar_Fiscal" and internal id Matching source and target field by the name "_Overzicht_Kwartaal" and internal id Matching source and target field by the name "_Overzicht_Maand" and internal id Matching source and target field by the name "_Overzicht_Week" and internal id Matching source and target field by the name "_gUUID" and internal id Matching source and target field by the name "Biosdatum" and internal id Matching source and target field by the name "_rMassa" and internal id Matching source and target field by the name "_r#1" and internal id Matching source and target field by the name "ULVR_Designation" and internal id Matching source and target field by the name "_gOwnerID" and internal id Matching source and target field by the name "Aantal" and internal id Matching source and target field by the name "_Aantal" and internal id Matching source and target field by the name "_rUUID" and internal id Matching source and target field by the name "iUsed_b" and internal id Matching source and target field by the name "_Inkoopwaarde" and internal id Matching source and target field by the name "_InkoopiUsed" and internal id Matching source and target field by the name "_rDisks" and internal id Matching source and target field by the name "_NativeID" and internal id Matching source and target field by the name "_gUnlock" and internal id Matching source and target field by the name "PROJ_AssetTag" and internal id Matching source and target field by the name "AssetTag" and internal id Matching source and target field by the name "ExternalTag" and internal id Matching source and target field by the name "_rExternalTags" and internal id -- Record mode migration for source table "Apparatuur" -- -- Rebuilt the following indexes -- Target field "_AanmaakDts" Target field "_UUID" Target field "#1" Target field "_Table_UUID" Target field "_TableName" Target field "_Apparatuurnummer" Target field "Volgnummer" Target field "_MedewerkerID" Target field "Soort" Target field "Merk" Target field "Model" Target field "Serienummer" Target field "Omschrijving" Target field "Staat" Target field "_PrijsLijn" Target field "Source" Target field "_Datum_Overzicht" == Mapping fields in source table "Regels" to target table "Regels" == Matching source and target field by the name "_AanmaakDts" and internal id Matching source and target field by the name "_AanmaakSerial" and internal id Matching source and target field by the name "_UUID" and internal id Matching source and target field by the name "#1" and internal id Matching source and target field by the name "Aantal" and internal id Matching source and target field by the name "_OwnerID" and internal id Matching source and target field by the name "#tablename" and internal id Matching source and target field by the name "_TableName" and internal id Matching source and target field by the name "_Table_UUID" and internal id Matching source and target field by the name "_ArtikelID" and internal id Matching source and target field by the name "_RegelsID" and internal id Matching source and target field by the name "ArtikelCode" and internal id Matching source and target field by the name "GbVerkoop" and internal id Matching source and target field by the name "GbInkoop" and internal id Matching source and target field by the name "Omschrijving" and internal id Matching source and target field by the name "_LeverancierID" and internal id Matching source and target field by the name "PrijsInkoop" and internal id Matching source and target field by the name "BtwCode" and internal id Matching source and target field by the name "PrijsVerkoop" and internal id Matching source and target field by the name "DienstenSpecs" and internal id Matching source and target field by the name "_PrijsEmpty_b" and internal id Matching source and target field by the name "_Regelsnummer" and internal id Matching source and target field by the name "Volgnummer" and internal id Matching source and target field by the name "Categorie" and internal id Matching source and target field by the name "Diensten_Categorie" and internal id Matching source and target field by the name "OmschrijvingKort" and internal id Matching source and target field by the name "Type" and internal id Matching source and target field by the name "_MedewerkerID" and internal id Matching source and target field by the name "_OrganisatieID" and internal id Matching source and target field by the name "_PersoonID" and internal id Matching source and target field by the name "Levertijd" and internal id Matching source and target field by the name "BtwPerc" and internal id Matching source and target field by the name "_BestelregelsID" and internal id Matching source and target field by the name "Datum_O" and internal id Matching source and target field by the name "Datum_I" and internal id Matching source and target field by the name "Factuurnr" and internal id Matching source and target field by the name "Claim" and internal id Matching source and target field by the name "_BedragClaim" and internal id Matching source and target field by the name "_rAantal" and internal id Matching source and target field by the name "Ontvangen_b" and internal id Matching source and target field by the name "_LeverregelsID" and internal id Matching source and target field by the name "Serienummer" and internal id Matching source and target field by the name "#factuur" and internal id Matching source and target field by the name "_Percentage" and internal id Matching source and target field by the name "Aantal_Vervolg" and internal id Matching source and target field by the name "#serial" and internal id Matching source and target field by the name "_TeFacturerenAantal" and internal id Matching source and target field by the name "BestelOpmerking" and internal id Matching source and target field by the name "_gNoCodeCheck" and internal id Matching source and target field by the name "_CreationID" and internal id Matching source and target field by the name "_ApparatuurID" and internal id Matching source and target field by the name "Barcode" and internal id Matching source and target field by the name "_AuditData" and internal id Matching source and target field by the name "_ShipmentID" and internal id Matching source and target field by the name "_rBedragVerkoop" and internal id Matching source and target field by the name "_CategorieID" and internal id Matching source and target field by the name "_rBrutoWinst" and internal id Matching source and target field by the name "Datum_Overzicht" and internal id Matching source and target field by the name "_Datum_Overzicht" and internal id Matching source and target field by the name "_Overzicht_Jaar" and internal id Matching source and target field by the name "_Overzicht_Maand" and internal id Matching source and target field by the name "_Overzicht_Week" and internal id Matching source and target field by the name "_Overzicht_Jaar_Fiscal" and internal id Matching source and target field by the name "_Overzicht_Kwartaal" and internal id Matching source and target field by the name "_Overzicht_VerkoperID" and internal id Matching source and target field by the name "Status" and internal id Matching source and target field by the name "_gOveride" and internal id Matching source and target field by the name "_RegelBronID" and internal id Matching source and target field by the name "Rechtstreeks_b" and internal id Matching source and target field by the name "Toepassen_b" and internal id Matching source and target field by the name "_ArtikelCode" and internal id Matching source and target field by the name "_rBedragInkoop_Geselecteerd" and internal id Matching source and target field by the name "StatusAfdruk_dts" and internal id Matching source and target field by the name "_CategorieID_Check" and internal id Matching source and target field by the name "Aantal_Strippenkaart" and internal id Matching source and target field by the name "_Aantal_Strippenkaart" and internal id Matching source and target field by the name "Leverancier" and internal id Matching source and target field by the name "_gUUID" and internal id Matching source and target field by the name "_rBedragInkoop" and internal id Matching source and target field by the name "Datum_O_Afgedrukt" and internal id Matching source and target field by the name "Voorraad_JN" and internal id Matching source and target field by the name "ExtraOpmerking" and internal id Matching source and target field by the name "Datum_O_Ingevoerd" and internal id Matching source and target field by the name "#levering" and internal id Matching source and target field by the name "#bestelling" and internal id Matching source and target field by the name "_StatusGeleverd" and internal id Matching source and target field by the name "_rAantal_Strippenkaart" and internal id Matching source and target field by the name "_HistorischeInformatie" and internal id Matching source and target field by the name "_rBedragBtw" and internal id Matching source and target field by the name "_rBedragInclBtw" and internal id Matching source and target field by the name "Claim_Apple" and internal id Matching source and target field by the name "_BedragClaim_Apple" and internal id Matching source and target field by the name "Aantal_Apple" and internal id Matching source and target field by the name "#1_Strippenkaart" and internal id Matching source and target field by the name "#01_Regel" and internal id Matching source and target field by the name "_gOwnerID" and internal id Matching source and target field by the name "Marge_b" and internal id Matching source and target field by the name "_rUUID" and internal id Matching source and target field by the name "EAN13" and internal id Matching source and target field by the name "BolItemId" and internal id Matching source and target field by the name "_rAantal_Ontvangen" and internal id Matching source and target field by the name "_rBedragInkoop_Voorraad" and internal id Matching source and target field by the name "Bestel_Categorie" and internal id Matching source and target field by the name "FactuurnrInvoer" and internal id Matching source and target field by the name "BtwCodeBHS" and internal id Matching source and target field by the name "UitVoorraad_b" and internal id Matching source and target field by the name "#voorraad" and internal id Matching source and target field by the name "_VoorraadID" and internal id Matching source and target field by the name "_BestellingID" and internal id Matching source and target field by the name "#0" and internal id Matching source and target field by the name "ICTL_Diensten" and internal id Matching source and target field by the name "_ICTL_b" and internal id Matching source and target field by the name "Categorie_b" and internal id Matching source and target field by the name "CategoryIUsed" and internal id Matching source and target field by the name "_TeLeveren_b" and internal id Matching source and target field by the name "RetourReden" and internal id Matching source and target field by the name "RetourVervolgactie" and internal id Matching source and target field by the name "SKU" and internal id -- Record mode migration for source table "Regels" -- -- Rebuilt the following indexes -- Target field "_AanmaakDts" Target field "_AanmaakSerial" Target field "_UUID" Target field "_TableName" Target field "_Table_UUID" Target field "_ArtikelID" Target field "ArtikelCode" Target field "Omschrijving" Target field "_LeverancierID" Target field "Volgnummer" Target field "Categorie" Target field "Diensten_Categorie" Target field "OmschrijvingKort" Target field "Type" Target field "_MedewerkerID" Target field "_OrganisatieID" Target field "_PersoonID" Target field "_BestelregelsID" Target field "Factuurnr" Target field "_LeverregelsID" Target field "BestelOpmerking" Target field "_CreationID" Target field "_ApparatuurID" Target field "Barcode" Target field "_AuditData" Target field "Datum_Overzicht" Target field "_Datum_Overzicht" Target field "_Overzicht_VerkoperID" Target field "Status" Target field "_RegelBronID" Target field "_ArtikelCode" Target field "BolItemId" Target field "Bestel_Categorie" Target field "_VoorraadID" Target field "_BestellingID" Target field "CategoryIUsed" == Summary == Accounts migrated: 9 Accounts changed: 0 Custom value lists migrated: 0 Font entries added: 0 Tables migrated: 3 Tables not migrated: 0 Fields migrated: 219 Fields not migrated: 0 Fields triggering recalculations: 0 Fields with evaluation errors: 0 Fields with fewer repetitions: 0 Serial numbers updated: 0 End: Tue Oct 16 07:36:15 2018

    • Tuesday om 05:39
    • 5 antwoorden
20. 

    FM Data Migration Tool correct installeren

    menno antwoordde op een discussie van menno in Tips & Truuks

    Deze tweede doorgang heb ik gedaan met een [Full Access]-account. Het scriptje is alleen maar anders wat betreft de accountnamen en wachtwoorden: #!/bin/bash SOURCE="${BASH_SOURCE[0]}" DIR="$( cd -P "$( dirname "$SOURCE" )" >/dev/null && pwd )" cd $DIR/.. FMDataMigration -src_path Old/DemoData.fmp12 -clone_path Clone/DemoData\ Clone.fmp12 -target_path New/DemoData.fmp12 -src_account "admin" -src_pwd "qwerty" -clone_account "admin" -clone_pwd "qwerty" -force -ignore_fonts -ignore_valuelists -v > Logs/Conversielog.txt Het log van de conversie is veel uitgebreider, maar het is nog steeds zéér snel. Het duurde slechts 9 seconden: FMDataMigration 17.0.2.205 (07-03-2018) Source file: "Old/DemoData.fmp12" Source account: "admin" Clone file: "Clone/DemoData Clone.fmp12" Clone account: "admin" Target file: "New/DemoData.fmp12" Force overwrite: On Ignore value lists: On Ignore accounts: Off Ignore fonts: On Start: Tue Oct 16 07:22:57 2018 == Mapping source privileges to target privileges == Matching source and target privilege set by the name "[Full Access]" and internal id Matching source and target privilege set by the name "[Data Entry Only]" and internal id Matching source and target privilege set by the name "[Read-Only Access]" and internal id Matching source and target privilege set by the name "PriveSet1" and internal id Matching source and target privilege set by the name "PriveSet2" and internal id Matching source and target privilege set by the name "PriveSet3" and internal id Matching source and target privilege set by the name "PriveSet4" and internal id Matching source and target privilege set by the name "PriveSet5" and internal id Matching source and target privilege set by the name "PriveSet6" and internal id Matching source and target privilege set by the name "PriveSet7" and internal id Matching source and target privilege set by the name "PriveSet8" and internal id Matching source and target privilege set by the name "PriveSet9" and internal id Matching source and target privilege set by the name "noaccess" and internal id Account "[Guest]" not changed Account "Admin" not changed Account "menno" not changed Account "piet" not changed Account "jacky" not changed Account "tanja" not changed Account "jan" not changed Account "ellen" not changed Account "noaccess" not changed == Mapping source tables to target tables == Matching source and target table by the name "Apparatuur" and internal id Matching source and target table by the name "Productiviteit" and internal id Matching source and target table by the name "Regels" and internal id == Mapping fields in source table "Productiviteit" to target table "Productiviteit" == Matching source and target field by the name "_AanmaakDts" and internal id Matching source and target field by the name "_AanmaakSerial" and internal id Matching source and target field by the name "_AuditData" and internal id Matching source and target field by the name "_CreationID" and internal id Matching source and target field by the name "_MedewerkerID" and internal id Matching source and target field by the name "#1" and internal id Matching source and target field by the name "#tablename" and internal id Matching source and target field by the name "_ScanID" and internal id Matching source and target field by the name "Shipmentnummer" and internal id Matching source and target field by the name "HD_Grootte" and internal id Matching source and target field by the name "HD_Aantal" and internal id Matching source and target field by the name "Cleandatum" and internal id Matching source and target field by the name "ClnSeconds" and internal id Matching source and target field by the name "ID" and internal id Matching source and target field by the name "_Datum_Overzicht" and internal id Matching source and target field by the name "_Overzicht_Jaar" and internal id Matching source and target field by the name "_Overzicht_Jaar_Fiscal" and internal id Matching source and target field by the name "_Overzicht_Kwartaal" and internal id Matching source and target field by the name "_Overzicht_Maand" and internal id Matching source and target field by the name "_Overzicht_Week" and internal id Matching source and target field by the name "_HD_Aantal" and internal id Matching source and target field by the name "_rHD_Aantal" and internal id Matching source and target field by the name "_gUUID" and internal id Matching source and target field by the name "_gOwnerID" and internal id Matching source and target field by the name "_rUUID" and internal id -- Block mode migration for source table "Productiviteit" -- == Mapping fields in source table "Apparatuur" to target table "Apparatuur" == Matching source and target field by the name "_AanmaakDts" and internal id Matching source and target field by the name "_AanmaakSerial" and internal id Matching source and target field by the name "_UUID" and internal id Matching source and target field by the name "#1" and internal id Matching source and target field by the name "_OwnerID" and internal id Matching source and target field by the name "#tablename" and internal id Matching source and target field by the name "_Table_UUID" and internal id Matching source and target field by the name "_TableName" and internal id Matching source and target field by the name "_Apparatuurnummer" and internal id Matching source and target field by the name "Volgnummer" and internal id Matching source and target field by the name "_MedewerkerID" and internal id Matching source and target field by the name "Soort" and internal id Matching source and target field by the name "Merk" and internal id Matching source and target field by the name "Model" and internal id Matching source and target field by the name "Partnummer" and internal id Matching source and target field by the name "Serienummer" and internal id Matching source and target field by the name "Omschrijving" and internal id Matching source and target field by the name "Staat" and internal id Matching source and target field by the name "Opmerkingen" and internal id Matching source and target field by the name "Price" and internal id Matching source and target field by the name "DefectOmschrijving" and internal id Matching source and target field by the name "Report_dts" and internal id Matching source and target field by the name "Report_uinique.id" and internal id Matching source and target field by the name "Report_serial.id" and internal id Matching source and target field by the name "~~Report_company.id" and internal id Matching source and target field by the name "_gSortering" and internal id Matching source and target field by the name "Herkomst" and internal id Matching source and target field by the name "Disks" and internal id Matching source and target field by the name "Price_Base" and internal id Matching source and target field by the name "Price_Damage" and internal id Matching source and target field by the name "_CreationID" and internal id Matching source and target field by the name "_Serial_number" and internal id Matching source and target field by the name "_PrijsLijn" and internal id Matching source and target field by the name "Productie_date" and internal id Matching source and target field by the name "Inkoopprijs_orig" and internal id Matching source and target field by the name "_AuditData" and internal id Matching source and target field by the name "#importtro" and internal id Matching source and target field by the name "ECCM_Organisatie" and internal id Matching source and target field by the name "ECCM_VerwVerzoek" and internal id Matching source and target field by the name "ECCM_Aankoopdd" and internal id Matching source and target field by the name "ECCM_Configuratie" and internal id Matching source and target field by the name "ECCM_ValidatieDatum" and internal id Matching source and target field by the name "ECCM_ApparatuurOmschrijving" and internal id Matching source and target field by the name "ECCM_Serienummer" and internal id Matching source and target field by the name "ECCM_ProductCode" and internal id Matching source and target field by the name "Source" and internal id Matching source and target field by the name "_ScanID" and internal id Matching source and target field by the name "ITR_Categorie" and internal id Matching source and target field by the name "ITR_Serie" and internal id Matching source and target field by the name "Info4" and internal id Matching source and target field by the name "Info5" and internal id Matching source and target field by the name "_Datum_Overzicht" and internal id Matching source and target field by the name "_Overzicht_Jaar" and internal id Matching source and target field by the name "_Overzicht_Jaar_Fiscal" and internal id Matching source and target field by the name "_Overzicht_Kwartaal" and internal id Matching source and target field by the name "_Overzicht_Maand" and internal id Matching source and target field by the name "_Overzicht_Week" and internal id Matching source and target field by the name "_gUUID" and internal id Matching source and target field by the name "Biosdatum" and internal id Matching source and target field by the name "_rMassa" and internal id Matching source and target field by the name "_r#1" and internal id Matching source and target field by the name "ULVR_Designation" and internal id Matching source and target field by the name "_gOwnerID" and internal id Matching source and target field by the name "Aantal" and internal id Matching source and target field by the name "_Aantal" and internal id Matching source and target field by the name "_rUUID" and internal id Matching source and target field by the name "iUsed_b" and internal id Matching source and target field by the name "_Inkoopwaarde" and internal id Matching source and target field by the name "_InkoopiUsed" and internal id Matching source and target field by the name "_rDisks" and internal id Matching source and target field by the name "_NativeID" and internal id Matching source and target field by the name "_gUnlock" and internal id Matching source and target field by the name "PROJ_AssetTag" and internal id Matching source and target field by the name "AssetTag" and internal id Matching source and target field by the name "ExternalTag" and internal id Matching source and target field by the name "_rExternalTags" and internal id -- Block mode migration for source table "Apparatuur" -- == Mapping fields in source table "Regels" to target table "Regels" == Matching source and target field by the name "_AanmaakDts" and internal id Matching source and target field by the name "_AanmaakSerial" and internal id Matching source and target field by the name "_UUID" and internal id Matching source and target field by the name "#1" and internal id Matching source and target field by the name "Aantal" and internal id Matching source and target field by the name "_OwnerID" and internal id Matching source and target field by the name "#tablename" and internal id Matching source and target field by the name "_TableName" and internal id Matching source and target field by the name "_Table_UUID" and internal id Matching source and target field by the name "_ArtikelID" and internal id Matching source and target field by the name "_RegelsID" and internal id Matching source and target field by the name "ArtikelCode" and internal id Matching source and target field by the name "GbVerkoop" and internal id Matching source and target field by the name "GbInkoop" and internal id Matching source and target field by the name "Omschrijving" and internal id Matching source and target field by the name "_LeverancierID" and internal id Matching source and target field by the name "PrijsInkoop" and internal id Matching source and target field by the name "BtwCode" and internal id Matching source and target field by the name "PrijsVerkoop" and internal id Matching source and target field by the name "DienstenSpecs" and internal id Matching source and target field by the name "_PrijsEmpty_b" and internal id Matching source and target field by the name "_Regelsnummer" and internal id Matching source and target field by the name "Volgnummer" and internal id Matching source and target field by the name "Categorie" and internal id Matching source and target field by the name "Diensten_Categorie" and internal id Matching source and target field by the name "OmschrijvingKort" and internal id Matching source and target field by the name "Type" and internal id Matching source and target field by the name "_MedewerkerID" and internal id Matching source and target field by the name "_OrganisatieID" and internal id Matching source and target field by the name "_PersoonID" and internal id Matching source and target field by the name "Levertijd" and internal id Matching source and target field by the name "BtwPerc" and internal id Matching source and target field by the name "_BestelregelsID" and internal id Matching source and target field by the name "Datum_O" and internal id Matching source and target field by the name "Datum_I" and internal id Matching source and target field by the name "Factuurnr" and internal id Matching source and target field by the name "Claim" and internal id Matching source and target field by the name "_BedragClaim" and internal id Matching source and target field by the name "_rAantal" and internal id Matching source and target field by the name "Ontvangen_b" and internal id Matching source and target field by the name "_LeverregelsID" and internal id Matching source and target field by the name "Serienummer" and internal id Matching source and target field by the name "#factuur" and internal id Matching source and target field by the name "_Percentage" and internal id Matching source and target field by the name "Aantal_Vervolg" and internal id Matching source and target field by the name "#serial" and internal id Matching source and target field by the name "_TeFacturerenAantal" and internal id Matching source and target field by the name "BestelOpmerking" and internal id Matching source and target field by the name "_gNoCodeCheck" and internal id Matching source and target field by the name "_CreationID" and internal id Matching source and target field by the name "_ApparatuurID" and internal id Matching source and target field by the name "Barcode" and internal id Matching source and target field by the name "_AuditData" and internal id Matching source and target field by the name "_ShipmentID" and internal id Matching source and target field by the name "_rBedragVerkoop" and internal id Matching source and target field by the name "_CategorieID" and internal id Matching source and target field by the name "_rBrutoWinst" and internal id Matching source and target field by the name "Datum_Overzicht" and internal id Matching source and target field by the name "_Datum_Overzicht" and internal id Matching source and target field by the name "_Overzicht_Jaar" and internal id Matching source and target field by the name "_Overzicht_Maand" and internal id Matching source and target field by the name "_Overzicht_Week" and internal id Matching source and target field by the name "_Overzicht_Jaar_Fiscal" and internal id Matching source and target field by the name "_Overzicht_Kwartaal" and internal id Matching source and target field by the name "_Overzicht_VerkoperID" and internal id Matching source and target field by the name "Status" and internal id Matching source and target field by the name "_gOveride" and internal id Matching source and target field by the name "_RegelBronID" and internal id Matching source and target field by the name "Rechtstreeks_b" and internal id Matching source and target field by the name "Toepassen_b" and internal id Matching source and target field by the name "_ArtikelCode" and internal id Matching source and target field by the name "_rBedragInkoop_Geselecteerd" and internal id Matching source and target field by the name "StatusAfdruk_dts" and internal id Matching source and target field by the name "_CategorieID_Check" and internal id Matching source and target field by the name "Aantal_Strippenkaart" and internal id Matching source and target field by the name "_Aantal_Strippenkaart" and internal id Matching source and target field by the name "Leverancier" and internal id Matching source and target field by the name "_gUUID" and internal id Matching source and target field by the name "_rBedragInkoop" and internal id Matching source and target field by the name "Datum_O_Afgedrukt" and internal id Matching source and target field by the name "Voorraad_JN" and internal id Matching source and target field by the name "ExtraOpmerking" and internal id Matching source and target field by the name "Datum_O_Ingevoerd" and internal id Matching source and target field by the name "#levering" and internal id Matching source and target field by the name "#bestelling" and internal id Matching source and target field by the name "_StatusGeleverd" and internal id Matching source and target field by the name "_rAantal_Strippenkaart" and internal id Matching source and target field by the name "_HistorischeInformatie" and internal id Matching source and target field by the name "_rBedragBtw" and internal id Matching source and target field by the name "_rBedragInclBtw" and internal id Matching source and target field by the name "Claim_Apple" and internal id Matching source and target field by the name "_BedragClaim_Apple" and internal id Matching source and target field by the name "Aantal_Apple" and internal id Matching source and target field by the name "#1_Strippenkaart" and internal id Matching source and target field by the name "#01_Regel" and internal id Matching source and target field by the name "_gOwnerID" and internal id Matching source and target field by the name "Marge_b" and internal id Matching source and target field by the name "_rUUID" and internal id Matching source and target field by the name "EAN13" and internal id Matching source and target field by the name "BolItemId" and internal id Matching source and target field by the name "_rAantal_Ontvangen" and internal id Matching source and target field by the name "_rBedragInkoop_Voorraad" and internal id Matching source and target field by the name "Bestel_Categorie" and internal id Matching source and target field by the name "FactuurnrInvoer" and internal id Matching source and target field by the name "BtwCodeBHS" and internal id Matching source and target field by the name "UitVoorraad_b" and internal id Matching source and target field by the name "#voorraad" and internal id Matching source and target field by the name "_VoorraadID" and internal id Matching source and target field by the name "_BestellingID" and internal id Matching source and target field by the name "#0" and internal id Matching source and target field by the name "ICTL_Diensten" and internal id Matching source and target field by the name "_ICTL_b" and internal id Matching source and target field by the name "Categorie_b" and internal id Matching source and target field by the name "CategoryIUsed" and internal id Matching source and target field by the name "_TeLeveren_b" and internal id Matching source and target field by the name "RetourReden" and internal id Matching source and target field by the name "RetourVervolgactie" and internal id Matching source and target field by the name "SKU" and internal id -- Block mode migration for source table "Regels" -- == Summary == Accounts migrated: 9 Accounts changed: 0 Custom value lists migrated: 0 Font entries added: 0 Tables migrated: 3 Tables not migrated: 0 Fields migrated: 219 Fields not migrated: 0 Fields triggering recalculations: 0 Fields with evaluation errors: 0 Fields with fewer repetitions: 0 Serial numbers updated: 0 End: Tue Oct 16 07:23:06 2018

    • Tuesday om 05:32
    • 5 antwoorden
21. 

    FM Data Migration Tool correct installeren

    menno antwoordde op een discussie van menno in Tips & Truuks

    Aanvullend op mijn sessie over de FMDMT op de FmSummit hieronder de scriptjes die ik gebruik en de logs van de conversies. De eerste is de conversie met de account "noaccess" mmet het "extended privilege": "fmmigration...." Dit account heeft helemaal geen toegang tot de database, maar bestaat alleen om de conversie uit te voeren. Heel handig om bij bijvoorbeeld een "Vertical Market Solution" het conversiepakket aan je klant op te sturen en hen zelf op "de knop" te laten drukken. Om het zaakje te laten werken is het nodig om een mappenstructuur aan te leggen, maar die maakt het ook meteen overzichtelijker: Het Script (voor MacOS, dus opslaan in het Conversie.sh-bestandje): #!/bin/bash SOURCE="${BASH_SOURCE[0]}" DIR="$( cd -P "$( dirname "$SOURCE" )" >/dev/null && pwd )" cd $DIR/.. FMDataMigration -src_path Old/DemoData.fmp12 -clone_path Clone/DemoData\ Clone.fmp12 -target_path New/DemoData.fmp12 -src_account "noaccess" -clone_account "noaccess" -force -ignore_fonts -ignore_valuelists -v > Logs/Conversielog.txt Het resultaat-fm-bestand van de conversie komt in de map "New" terecht en het log in de map "Logs". Zoals je in de opties ziet staat daar een -v voor verbose logging, maar vanwege de zeer beperkte privileges van dit account zal het log toch zeer summier blijven: FMDataMigration 17.0.2.205 (07-03-2018) Source file: "Old/DemoData.fmp12" Source account: "noaccess" Clone file: "Clone/DemoData Clone.fmp12" Clone account: "noaccess" Target file: "New/DemoData.fmp12" Force overwrite: On Ignore value lists: On Ignore accounts: Off Ignore fonts: On Start: Tue Oct 16 06:27:24 2018 == Summary == Accounts migrated: 9 Accounts changed: 0 Custom value lists migrated: 0 Font entries added: 0 Tables migrated: 3 Tables not migrated: 0 Fields migrated: 219 Fields not migrated: 0 Fields triggering recalculations: 0 Fields with evaluation errors: 0 Fields with fewer repetitions: 0 Serial numbers updated: 0 End: Tue Oct 16 06:27:39 2018 De hele conversie heeft 15 seconden geduurd ... een bestand met 3 tabellen met elk 100.000 records en respectievelijk 94, 26 en 165 velden. Totaal ongeveer 300 Mb ... probeer dat maar eens met de hand

    • Tuesday om 04:34
    • 5 antwoorden
22. 

    FMSummit 2018

    andries antwoordde op een discussie van andries in FileMakerCafé

    Den baas van Clarify is het weer aan het uitleggen...

    • Monday om 21:01
    • 10 antwoorden
23. 

    FMSummit 2018

    Peter Wagemans antwoordde op een discussie van andries in FileMakerCafé

    @Joris Aarts rond vandaag af met eens sessie over graph databases.

    • Monday om 14:09
    • 10 antwoorden
24. 

    FMSummit 2018

    Peter Wagemans antwoordde op een discussie van andries in FileMakerCafé

    https://blog.beezwax.net/2017/05/09/introducing-logicator-a-modular-search-interface-for-filemaker-16/

    • Monday om 13:35
    • 10 antwoorden
25. 

    FMSummit 2018

    Peter Wagemans antwoordde op een discussie van andries in FileMakerCafé

    Schitterende sessie van Sjaak over hoe je efficient en correct drukwerk kunt genereren vanuit FileMaker.

    • Monday om 13:15
    • 10 antwoorden
26. 

    FMSummit 2018

    Peter Wagemans antwoordde op een discussie van andries in FileMakerCafé

    https://community.filemaker.com/community/platform/blog/2018/08/02/wan-performance-data-monitoring !!!

    • Monday om 11:28
    • 10 antwoorden
27. 

    FMSummit 2018

    Peter Wagemans antwoordde op een discussie van andries in FileMakerCafé

    Ik vraag me af waar zoal de verschillen zitten met een tooltje als https://push2fm.com/ Het gaat hier denk ik OOK over remote notifications. Een tijdje geleden geprobeerd met FileMaker 15 of 16, en het werkte prima. Maar ik had er toen geen toepassing voor. [Edit] pushFM ondersteunt wél dynamische parameters.

    • Monday om 09:13
    • 10 antwoorden
28. 

    FMSummit 2018

    Peter Wagemans antwoordde op een discussie van andries in FileMakerCafé

    @andries geeft nu een sessie over notificaties op iOS en de impact op FileMaker Go.

    • Monday om 08:54
    • 10 antwoorden
29. 

    FMSummit 2018

    Peter Wagemans antwoordde op een discussie van andries in FileMakerCafé

    Sessie van @Mennovanbeek over de nieuwe FMDataMigration tool. Schitterende software die ik nu dagelijks gebruik. Jammer genoeg alleen beschikbaar voor bepaalde FileMaker “subscriptions”.

    • Monday om 08:13
    • 10 antwoorden
30. 

    records bijwerken in een andere tabel

    emma antwoordde op een vraag van emma in FileMaker Pro 16 Advanced

    ok . het was de bedoeling dat als een VKN( verkorte naam) nog niet in " Namen" voorkomt deze via de tabel "ING bank_2018" aangevuld werd. ik heb het voorlopig nog maar opgelost via een script navigatie/kopieeren/plakken. nogmaals hartelijk dank voor uw uitleg

    • Monday om 08:12
    • 2 antwoorden

1. Meer activiteit laden