menno

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

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

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.

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

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

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

Heb je wel een code39-lettertype dat helemaal "vrij" om de door jou gekozen grootte weer te geven in een PDF. Je kan eens proberen een andere te installeren, bijvoorbeeld deze font van inflow of deze van barcodesinc Daarna FM even helemaal afsluiten en weer opstarten en dan het nieuwe 3of9-font toevoegen en kiezen

Ik gebruik OwnCloud al jaren en ben er nog steeds blij mee. Mijn iPad, iPhone, Mac en Windows pc kijken naar dezelfde mappen. Mijn boekhouder heb ik toegang gegeven tot een specifiek deel en af en toe een klant die dan in zijn eigen specifieke deel kan. Werkt echt perfect! Een tijd lang heb ik mijn agenda er ook op gedraaid (kon praten met de outlook-agenda én agenda op de mac), maar ben nu overgestapt op exchange-online.. eerlijk is eerlijk, dat werkt toch net iets beter. Het grote voordeel vind ik dat OwnCloud op mijn eigen private-server draait in de meterkast en dat ik dus zélf de sleutel van de voordeur heb! Inderdaad is dan inherent dat ik het onderhoud zelf moet doen .... dat ene nadeel weegt niet op tegen de voordelen

Kijk even hier: https://filemaker.livecode.com/native/

Het valt prima te automatiseren, mits je bestand in bepaalde opzichten maar altijd aan dezelfde voorwaarden voldoet. Je kan in een excel immers gemakkelijk kolommen toevoegen en verschuiven, dus dat lijkt me geen probleem. In het bijgaande voorbeeld heb ik jouw laatste voorbeeldbestand gebruikt. Uitgangspunten zijn in dit geval dat er altijd numerieke data wordt geleverd ... anders moet je de zaak even aanpassen. kolom1 het id van de persoon bevat kolommen 2 en 3 geen relevante informatie bevatten De niet relevante kolommen worden wél geïmporteerd, maar voor het verzamelen van de resultaten zijn ze niet van belang, vandaar irrelevant. Als je nu op de knop "Importeer Excel" klikt, kies je daarna het te importeren bestand en dat wordt meteen verwerkt. Het maakt niet uit of je nu 1 vraagkolom hebt of 200 (dat is het voorlopige maximum) het wordt verwerkt en er worden alleen records geschreven in het resultaat wanneer een vraag is beantwoord. Excel_Import.zip

Volgens deze topic in de FmCommunity is de compatibiliteit nog niet OK. Ik heb het nog niet geprobeerd, maar er zijn hier vast mensen die Mojave al hebben geïnstalleerd, dus ben benieuwd naar hun ervaringen. Ik begrijp uit de FMCommunity dat de updates voor FMS en FMPA gepland zijn voor November resp. December en dat FMS sowieso niet compatible is met Mojave .... uitkijken dus Er is ook nog een knowledgebase-artikel met info van FMI daarin wordt gebruik van FMS op MacOS-Mojave afgeraden

Ik neem aan dat je de "foute" datasourced tabellen wilt "omsourcen"? Daar heb je volgens mij geen speciale tools voor nodig: Open de Relaties in de DatabaseDefinitie Gooi van iedere tabel uit de verkeerde source een ongekoppelde TOC neer Selecteer 1 voor die tabellen en gebruik bij iedere tabel cmd-u (windows:ctrl-u) om de overige weergaven van die tabel te zien Wijzig vervolgens één voor één de basistabel door dezelfde uit de juiste datasource te kiezen, alles blijft werken en gekoppeld. Je moet bij het selecteren alleen eerst een spatie aan de TOC naam toevoegen en weer verwijderen, anders hernoemt FM de TOC naar de tabelnaam (met eventueel een indexnummer) Needless to say, maar toch: de hulp-TOC's uit de 2e stap even verwijderen Het is een enorm #$%@! werk, maar volgens mij de enige manier, geen tool die je daarbij help, behalve dat je er mee kan controleren of je er geen hebt gemist.

Ik gebruik de tool fmvis (is er voor MacOS én Windows https://www.fmvis.com) . Die is heel snel wanneer je er klonen in gooit en die toont keurig pér DataSource welke TOC's er aan zijn gekoppeld: geen gratis tool. Hij kost 310 euro ex btw, maar is icm fmdiff (https://www.fmdiff.com en nog eens 310 euro) zijn geld dubbel en dwars waard. Ik gebruik deze tools al jaren enkele malen per week en wil niet meer zonder.

Kijk eerst even in de documentatie. Die vind je op http://xx.xx.xx.xx/fmi/data/apidoc/ je geeft hier nu alleen maar een 1 of ander resultaat, maar niet wat je doet om dat te krijgen. in een notedop: je moet eerst authoriseren, daarmee verkrijg je een token en daarmee doe 1 of meer calls. Daarna sluit je je sessie door de token te verwijderen of te laten verlopen.

Ze willen, zo lijkt het, de admin-api een beetje doordrukken. Met https:/ipserver/fmi/admin/api/v1/databases krijg je een json terug met alle gesharede bestanden en welke clients daarop zijn ingelogd met welke rechten. Dat werkt best aardig, maar als je ik noem maar wat 80 bestanden en 130 actieve gebruikers hebt, dan is het JSON-netje aan de forse kant. Je zou dan je query een beetje moeten kunnen beperken met https:/ipserver/fmi/admin/api/v1/database/db-naam Het is echter niet mogelijk om van slechts één DB die gegevens op te vragen (ook niet hidden, heb ik geprobeerd). Er zijn inmiddels wel een paar aardige tools gemaakt door FellowFMDevelopers: https://thebrainbasket.com/?p=549 van Claus Lavendt https://github.com/SoliantMike/FM-Admin-API-Tool Soliant (Anders, Marc, Wim, Mike?) https://www.productivecomputinguniversity.com/courses/fm-server-manager Marc Larochelle https://community.filemaker.com/docs/DOC-9074 (door FMI zelf) Allemaal hebben ze voor en nadelen. Er is er geeneen helemaal af, maar je mag er zelf gelukkig alles aan wijzigen. Ben ik hier blij mee? ...... Nee niet echt...... Ik wil gewoon mijn DB's bouwen en bij mijn klanten neerpoten/onderhouden. Dus waarom heeft FMI nu allerlei functionaliteit van de FMS-console weggehaald, die iedereen wel regelmatig gebruikt(e): Bestanden uploaden in de console (kan al sinds 14 niet meer, maar ik baal daar nog steeds van) Overzicht van users en gebruikte rechten De live-statistieken zijn weg, dus je ziet de invloed van bepaalde acties op de performance niet meer Struinen door de logs om server-side scripts te debuggen. Dat was eigenlijk al veel te summier met informatie, maar nu moet je die logs eerst aanklikken, downloaden, uitpakken, openen, filteren, scrollen en dan zie je pas wat nodig hebt. Wie bij FMI dát PVD heeft bedacht, verdient écht een wandelkaart! Zo nu heb ik wel weer genoeg gezeurd 😁