Mass Global Name Change

Mass Global Name Change

On occasions you may require a global name change to occur across multiple records. eg: you may need 10 customers requiring name changes. A script may be run to read data from a spreadsheet and then process each record in turn. Attached is a Standard script along with a spreadsheet template allowing you to load multiple customers or items to change.

NB: The script can be altered to work for Suppliers etc.. The same spreadsheet template can been used, irrespective of the tables concerned.

Before running this script, it is extremely important to ensure your data is 100% correct in the spreadsheet. May sure there are now special characters and all quote marks have been converted from ' to `.

Also ensure you have a backup of the database prior to running this. Like the standard Global Name Change option, this must be run with no other users logged into Ostendo.

 

It is suggested that this is run in blocks of 20-30 records at a time. As this can significantly increase the database size, it is recommended that a backup and restore be done in between each batch.

    • Related Articles

    • Global Name Change - Customer/Supplier etc with a blank name

      In versions of Ostendo (Up to and including Update 160) you were able to inadvertently change a key field (eg: Customer or Supplier name) to a blank through the Global Name Change. This of course becomes a big problem and needs fixing ASAP. In order ...

    • Dynamic SQL Error when performing a Global Name Change (Apostrophes in the Primary Key)

      If data has been introduced into Ostendo outside of the normal user interface eg: Importing, then in most cases the database will reject the record. The normal Ostendo interface automatically deals with this by changing a ’ to a ` when the record is ...

    • How can I change a Customers or Suppliers Name?

      You can amend many key fields in Ostendo. This is especially useful where your Customer or Supplier has changed their name. To reflect that name change in Ostendo go to File>System Configuration>Global Name Change and select the specific field that ...

    • Your user name and password are not defined

      If you get message 'Your user name and password are not defined. Ask your database administrator to set up a Firebird login' It appears that screen 'Alternate Database User' has been amended. You should note that this screen has nothing to do with ...

    • License Key Name for Ostendo is different from Freeway app Registered Company Name

      License Key name for Ostendo is different to the Freeway app company name appearing on the mobility devices. The "Registered To" Company Name appearing in Freeway can be any name you define. It does not have to be the same as the License Name. To ...