SyncExtractOptions
0.2.1
This script is used to switch off or switch on some data sources in FastStats Designer to allow a build with only a few tables (like customer data)
and then later do a bigger build with customer and transactional data.
This example just changes the behaviour of the extract options and saves it in the same xml
SyncExtractOptions -DesignFile "C:\Apteco\Build\20220714\
and then later do a bigger build with customer and transactional data.
This example just changes the behaviour of the extract options and saves it in the same xml
SyncExtractOptions -DesignFile "C:\Apteco\Build\20220714\
This script is used to switch off or switch on some data sources in FastStats Designer to allow a build with only a few tables (like customer data)
and then later do a bigger build with customer and transactional data.
This example just changes the behaviour of the extract options and saves it in the same xml
SyncExtractOptions -DesignFile "C:\Apteco\Build\20220714\designs\20220714.xml" -Include "Bookings", "People"
Do the same, but also execute DesignerConsole to load the data
SyncExtractOptions -DesignFile "C:\Apteco\Build\20220714\designs\20220714.xml" -Include "Bookings", "People" -StartDesigner
To execute from a scheduled task, do it like
Program/Script
powershell.exe
Add arguments
-Command "& 'SyncExtractOptions' -DesignFile 'C:\Apteco\Build\20220714\designs\20220714.xml' -Include 'Bookings', 'People'"
Two more examples
powershell.exe -Command "& 'SyncExtractOptions' -DesignFile 'C:\Apteco\Build\20221107\designs\20221107.xml' -Exclude 'Bookings', 'People' -StartDesigner"
powershell.exe -Command "& 'SyncExtractOptions' -DesignFile 'C:\Apteco\Build\20221107\designs\20221107.xml' -Exclude 'People' -Include 'Bookings' -StartDesigner"
It also works with incremental extracts with discards. When you put the table into the exclude list, the table won't be
extracted and no records will be discarded. It will just output something like
07.11.2022 10:42:57 INFO Bookings will not be extracted. 44.998 record(s) were previously extracted.
You do not need to put all tables in the include or exclude list. Only those tables will be changed to extract or not to extract.
Use the -Verbose flag if you want to get more details
Don't forget that if you turn off some tables with -Exclude than they are turned off until you actively turn them on again.
Wildcards are supported now, too, so you could do
SyncExtractOptions -DesignFile "C:\Apteco\Build\20220714\designs\20220714.xml" -Include "Bookings*"
if you have multiple tables that begin with 'Bookings'
Show more
and then later do a bigger build with customer and transactional data.
This example just changes the behaviour of the extract options and saves it in the same xml
SyncExtractOptions -DesignFile "C:\Apteco\Build\20220714\designs\20220714.xml" -Include "Bookings", "People"
Do the same, but also execute DesignerConsole to load the data
SyncExtractOptions -DesignFile "C:\Apteco\Build\20220714\designs\20220714.xml" -Include "Bookings", "People" -StartDesigner
To execute from a scheduled task, do it like
Program/Script
powershell.exe
Add arguments
-Command "& 'SyncExtractOptions' -DesignFile 'C:\Apteco\Build\20220714\designs\20220714.xml' -Include 'Bookings', 'People'"
Two more examples
powershell.exe -Command "& 'SyncExtractOptions' -DesignFile 'C:\Apteco\Build\20221107\designs\20221107.xml' -Exclude 'Bookings', 'People' -StartDesigner"
powershell.exe -Command "& 'SyncExtractOptions' -DesignFile 'C:\Apteco\Build\20221107\designs\20221107.xml' -Exclude 'People' -Include 'Bookings' -StartDesigner"
It also works with incremental extracts with discards. When you put the table into the exclude list, the table won't be
extracted and no records will be discarded. It will just output something like
07.11.2022 10:42:57 INFO Bookings will not be extracted. 44.998 record(s) were previously extracted.
You do not need to put all tables in the include or exclude list. Only those tables will be changed to extract or not to extract.
Use the -Verbose flag if you want to get more details
Don't forget that if you turn off some tables with -Exclude than they are turned off until you actively turn them on again.
Wildcards are supported now, too, so you could do
SyncExtractOptions -DesignFile "C:\Apteco\Build\20220714\designs\20220714.xml" -Include "Bookings*"
if you have multiple tables that begin with 'Bookings'
Installation Options
Owners
Copyright
2022 Apteco GmbH. All rights reserved.
Package Details
Author(s)
- florian.von.bracht@apteco.de
Tags
PSEditions
Dependencies
This script has no dependencies.
Release Notes
0.2.1 Fix for loading XML from a variable
0.2.0 Preverse Whitespace in XML
Small improvements
Allow wildcards for matching tablenames with -like
0.1.1 Adding icon for info
Adding Apteco tag to info
0.1.0 Initial release of SyncExtractOptions script through psgallery
FileList
- SyncExtractOptions.nuspec
- SyncExtractOptions.ps1
Version History
Version | Downloads | Last updated |
---|---|---|
0.2.1 (current version) | 13 | 11/22/2023 |
0.2.0 | 6 | 11/22/2023 |
0.1.1 | 30 | 11/7/2022 |
0.1.0 | 12 | 11/7/2022 |