today I want to leave a post on how to restore Acumatica snapshots with help of Acumatica Wizard.
Before creating snapshot you may need to switch Acumatica to maintenance mode. Below are the steps for achieveing it:
1. Go to System --> Management --> Apply Updates, click on the button "Schedule Lockout" and specify the reason for lockout
2. Don't forget to remove the lockout after you'll restore Snapshot.
Steps are the following:
1. Create a snapshot of the tenant you wish to back up
2. Export that snapshot (I recoment xml format).
3. In the folder where the corresponding Acumatica Wizard is installed (usually c:\program files\Acumatica ERP\), find the folder called \Database\Data, where there are individual folders with snapshot data.
4. Create a new folder for your new snapshot
5. Extract the contents of the .zip exported snapshot into the new folder you created
6. Run the Acumatica Wizard
7. Choose the "Perform Application Maintenance" option
8. Select the site into which you wish to import this data
9. Choose the "Tenant Maintenance" option or "Company Maintenance":
10. Click on the "Advanced Settings" button at the bottom
12. Click on the "Insert Data" option next to the tenant where the data should be imported and select the new folder/snapshot you added in step #4 above:
13. Proceed through the wizard as normal. When the install process is complete you should have a tenant with restored data.
Hello everybody,
today I want to write a few words about changes of PXUIFieldAttribute.SetVisibility method.
In the past, if you wanted to turn on some column, you could write in RowSelected event something like this:
PXUIFieldAttribute.SetVisibility<APRegister.finPeriodID>(Documents.Cache, null, true);
If you want to turn it off, then this:
PXUIFieldAttribute.SetVisibility<APRegister.finPeriodID>(Documents.Cache, null, false);
But for quite a long time ( even in 2017 version ), Acumatica team introduced PXUIVisibility enum. In code it looks like this:
[Flags]
public enum PXUIVisibility
{
Undefined = 0,
Invisible = 1,
Visible = 3,
SelectorVisible = 7,
Dynamic = 9,
Service = 19,
HiddenByAccessRights = 33,
}
For now I can comment on Visible and InVisible which correspond to false and true in the past implemtations. And in future posts I'll describe other selectors.
Hello everybody,
today I want to leave a post on how to change all emails, which are contained in Acumatica. For this purpose you may use script below:
UPDATE contact SET email = email + '.ts'
UPDATE socontact SET email = email + '.ts'
UPDATE apcontact SET email = email + '.ts'
UPDATE pocontact SET email = email + '.ts'
UPDATE crcontact SET email = email + '.ts'
UPDATE arcontact SET email = email + '.ts'
UPDATE fscontact SET email = email + '.ts'
UPDATE crcasecontacts SET email = email + '.ts'
UPDATE crcontact SET email = email + '.ts'
UPDATE pmcontact SET email = email + '.ts'
If you wonder, what can be the usage of such SQL, consider following scenario. You've restoed from back up some database. And you need to see if Automation schedules work fine. How can you do it without deletion of all of them and spamming of all customers of your customer? The only way would be updating emails in your database.
If you know any other table that contains e-mails which I've missed, let me know, I'll update this SQL script accordingly.