Spring naar bijdragen

Alle activiteit

Deze tijdlijn wordt automatisch bijgewerkt     

  1. Afgelopen uur
  2. menno

    Uploaded naar server

    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.
  3. Vandaag
  4. Frank

    Uploaded naar server

    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?
  5. Gisteren
  6. hbrendel

    Downloads van de Summit

    Bedankt he.
  7. Marsau

    Downloads van de Summit

    https://www.fmsummit.info/doc
  8. hbrendel

    Downloads van de Summit

    Hallo iedereen, Wie kan me vertellen waar ik presentaties en voorbeeldbestanden van de Summit kan downloaden?
  9. Afgelopen week
  10. Leen

    Button bar

    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.
  11. menno

    Uploaded naar server

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

    Uploaded naar server

    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?
  13. menno

    Database

    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
  14. Banach

    Database

    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?
  15. bey1

    Database

    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?
  16. Peter Wagemans

    FMSummit 2018

    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.
  17. menno

    FMSummit 2018

    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.
  18. menno

    FM Data Migration Tool correct installeren

    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
  19. menno

    FM Data Migration Tool correct installeren

    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
  20. menno

    FM Data Migration Tool correct installeren

    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
  21. andries

    FMSummit 2018

    Den baas van Clarify is het weer aan het uitleggen...
  22. Peter Wagemans

    FMSummit 2018

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

    FMSummit 2018

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

    FMSummit 2018

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

    FMSummit 2018

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

    FMSummit 2018

    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.
  27. Peter Wagemans

    FMSummit 2018

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

    FMSummit 2018

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

    records bijwerken in een andere tabel

    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
  1. Meer activiteit laden
×