Soset Utils Menu in NamoUtil

5 Price+Currency
Clean an Repair
Conversion
Error system
ICT code Setup
Index Table
Inventory
Invoiced Status
Logo info from Stampdef
PageWizard reset
Password generation
Production status update
PurY2K
Release Licenses
Reports
Reset category block
Reset invoicing
Reset tables
Shipment export
Template Counter
Translation
Webtools
XML tools

5 Price+Currency

This option is used to enable you to choose from up to 4 different prices for one and the same product. Read more about this.

Clean and Repair

This includes SOSET table clean and repair tools.
Most of these options can be used to overcome problems with corrupted data or other database-related problems. 
It is advised to have a good backup of your SOSET-system, before using them. You might consider consulting Namosoft to be sure if a functionality will help you to cover your problem.

• Check double entries
  Will create a text-file with information about double entries in the selected table.
• Clean Temp dir
  Deletes all files in the SOSET-table temporary directory. (Default: ../Data/Soset/Temp)
• Page Table Fix
  Use this option to fix wrongly stored pagenumbers.
• Repair Table
  This option re-writes all data from a corrupted table, while eliminating corrupted data. You might loose data.
  

Conversion

Various tools for the conversion of data into the SOSET tables.
Use only after consulting a Namosoft representative. Special conversions can be developed for your specific situation.

Error System

Can be used to find cause of an occurred error. Namosoft staff might request you to run one of tyhese options for analysis purposes.

• Errorview
• Varcheck
• VarDump
• Formular test
• Print SOSET.log
• Erase SOSET,log
• Knowledge base

ICT code Setup

This procedure will automatically preset the field VAT-type for all your customers in the Customertable.
Based on the following tax-options, to be specified in the tax-table:
01=VAT domestic
02=countries within EU
03=countries outside EU
04=other tax-options, like tax exempt

Index table

Options for re-indexing of SOSET tables. Re-indexing is strongly recommended after power failure.
Make sure to close these before starting a reindex procedure.

• Check open tables
  You can only reindex a table if it can be opened exclusively. This option will check all tables and list possible open tables.
• Daily reindex
  This option only re-indexes frequently used tables.
• Reindex Archive files
  Option to re-index only the tables in the archive directories. (Default in: ../Data/Soset/Archive)
• Reindex all
  Will reindex all SOSET-tables. This will be time-consuming and depend on size of tables.
• Reindex table
  Will show all SOSET tables in a browse screen. Click on one of the tables and close the browse screen. You will be prompted before reindex starts.

Also read this.

Inventory

• Inventory
  Used for inventory control at end of year.
  Will import inventory-data from CSV files into a copy of the PurProd-table. The format of the CSV file needs to be: 
  ProductCode+,+Quantity+CRLF
  For productcode you may use the ProductID from the Product table, but also the EAN-code as specified in the BarCode field. The procedure also accepts the PurchaseID as specified in the PurProd-table.
  The results are stored into a copy of the PurProd-table in order to freeze the inventory at moment of counting.
• Cycle-Count
  Same as above option, but in active SOSET-tables. Comes with Cycle-count report.
• Stock update
  Option to update inventory information.

Invoiced Status

Used to set the invoiced status for old orders. This will mark them for archiving.

Logo Info from Stampdef

Will create an overview of all logo's used in all typeset-StampDef-fields.

PageWizard Reset

Resets the PageWizard status of stamps. This command should be used with GREAT care! More information.

Production status update
The archive-option in SOSET NamoSys and SOSET NamoUtil are not designed to create space and will only slightly compress data.
In general we do not recommend to delete data and/or files to generate diskspace.
Harddrives come with huge volumespace and database-systems are designed to handle large volume tables.
Searching for information within SOSET is faster than any other search. By simply entry of jobs, the data are simply build up and should be used.
The archive-procedure  is meant to get archive-files for each year and to enable you to isolate these.
The archive-procedure also checks data and correct errors and re-write the job-files, which improves disc-access and usually optimizes the performance of databases in general.

To prepare your tables for archiving use this. When the procedure has finished you can archive stamp via the Archive option in NamoSys.

PurY2K

Procedure to generate documents for all your vendors about changes and request for digital data-interface with your SOSET-tables.
Needs to be customized for your specific pruposes.

Release Licenses

Option to free all licenses after an unexpected program end or fatal error. You may use this option at any time. This does not have an effect to possible active use of SOSET.

Reports

Various reports generated from SOSET-table-data.

• All report
  Follow up and action completed information, extracted from CusCall table. This table contains data about visits and customer calls.
• Action reports
      -To do report
      Follow up report only.
      -Action report
      Action completed report only.
• Complaints
  Overview of complaints, directly entered via SOSET order entry or via SOSET-via-the-web routines.
• Entered totals
  Overview per product-group with quantities and net-totals.
• History Group Specs
  Overview per customerGroup and Product-group. Creates a CSV-file for import in Excel.
• Invoices Aging
  Invoices aging report.
• Payment by Invoice
  Specifies payments for each invoice.
• Overdue
  Invoices aging report.
• Sales per day of week
  Specifies the total salesfor each day of week in order to determine what day of week has most sales. Use this to find out more about your shop-results.
• Remake Order Entry
  Specified report of amount of remakes in selected period.
• Remake Stamp
  Specified report of amount of remakes in selected period.
• Web order
  Specification of web-orders in selected period.

Reset category block

To avoid conflicting categories, the category-table can only be edited by one person at the time. A possible hanging block (due to power failure) can be reset with this option.

Reset invoicing

Starting up of invoicing is blocked at the moment that any error occurs during the invoicing routines. In order to avoid serious damage of data this block can only be reset after verifying backup and after solving the cause of the error.
Call Namosoft before using this option and to get a code for activation.

Reset tables

This option resets some  table information to its original contents. This allows you to test. 
What does this procedure do?

1. All orders in the order table are deleted.
2. All ship-to addresses are deleted.
3. Sales and invoice-data are deleted in customer, customer-group and product tables.
4. Information in history tables are deleted.
5. Archive files are deleted.
6. Payment data are deleted.
7. Accounting export tables are deleted.

At the end of the routine you may re-enter the first available invoice- and ordernumber in the system-table.
Note: customer, customergroup, product and typesetting information remain untouched.

Shipment Export

Export of data into specific formats. Can be used to digitally interface with shipping companies.
Contact Namosoft to find out which option will fit to your specific circumstances or for custom interfaces.

Template Counter

Specifies the amount of templates for each product and per customer-group in the Stamp-table. Use in conjunction with web-setup.

Translation

This option simplifies the initial setup of a multi-language database-system. The SOSET software already offers screen-texts in multiple languages.
Now you can have the product and category information in any language.
In SOSET Order-entry you will find the option: Maintain, Product and Maintain Category.
In both screens you will find a "L"-button next to the description fields. There you can enter the translation of the various texts in several languages.

For the initial set-up you can use the Translation option fromNamoUtil.
In Namoutil you Open the product-table. You may specify a filter with View, Set filter.
Next you choose SOSET Utils, Translation, Create translation file.
A txt-file will be created.

Open this file in a text-editor (Notepad e.g.). This looks as follows:
1 ==DO NOT EDIT!!!===
==DO NOT EDIT!!!=== PRODUCT-NAME IN DEFAULT LANGUAGE: 
<InTxt1>

<ProdName>
SELFINKER Do NOT edit this line, as this is the identifier! 
</ProdName>
<USA>
SELFINKER You can overwrite this line with your own wording! 
</USA>
<GER>
SELF?RBER You can overwrite this line with your own wording! 
</GER>
<DUT>
STEMPELAUTOMAAT You can overwrite this line with your own wording! 
</DUT>
<FRE>
TIMBRE AUTO-ENCREUR You can overwrite this line with your own wording! 
</FRE>
<NOR>
Here you can write text in Norwegian,e.g.!
</NOR>
<SWE>

</SWE>
</InTxt1>

Do NOT edit one of the other labels or lines, only the texts between the language labels.
Contact Namosoft if you need to add another language.
NOTE: you might have the same prodname various times; these texts do not need to be translated again and again. Only fill out the translation once. SOSET will find the same translations for the other products.

Once you are done with the translation, you save the file as a TXT-file. This is very important. If you save it e.g. as a Word-file it want work!

Next you start the procedure to have the texts in the appropriate table in SOSET.
In Namoutil you choose SOSET Utils, Translation, Import from translation file.

You may now also use the following tool in the Namosys program:
Namosys > Utils menu > Add language text.
In the "text" field enter the original text (i.e. the English text) you want to change or translate. In the "Translation" field you can enter your translation on a per language basis. After you entered the new translation it becomes immediately effective on the website.

Webtools

• Category prepare
  Used to prepare the product table for use for an inter-active web-site with SOSET-via-the-web.
  This procedure will add a specified category to the category fields of that product in the product table.
  In order to do so, you need to prepare a file: c:\data\temp\code.txt
  Layout of this file: CategoryID from Category.dbf, Searchtext (to search for in product-description), accountnumber to limit the search.
  Example: 060708,SELFINKER,8210
  If the word selfinker appears in product description and the accountID of that product is 8210, this procedure will add the category 060708 to the category fields of that product!
• Currency from htmL
  Option to copy currency-values from a web-site into the SOSET currency-table. Can run fully automatic to have currency-values up-to-date at any time. Contact Namosoft for customized interface.
• Password generation
  Generate password for your customers for login to a SOSET-via-the-web site. Select Multiple passwords if you want to create login information for a selected group of customers. This option also generates data for mail-merge into a word-processor.
  Read more about this.

XML-tools

• XML catalog
  With this procedure you can create a catalog, containing basic product-information for an Ariba-eprocurement environment.
  Such a catalog can be released via an Ariba-site to eprocurement customers.
• XMLexport
  This procedure creates an XML-export-file from SOSET-orders.
• XML import
  This procedure converts XML-data into SOSET-tables based on a pre-defined filterset.
• Generate htm from XML
  In situations where punch-out e-procurement is not yet possible, you have the ability to create a semi-punch-out environment. This procedure creates htm-files based on a published, SOSET to XML-catalog for use in a semi-eprocurement environment locally.
• XML Viking
  This procedure will convert BASDA-XML-data from B-eX Viking system into SOSET-order and typeset data.
• XML SOSET link
  Option to pre-define and edit for automatic conversions of any XML-type file. You can select link between XML-labels and fields in SOSET-database-tables.

For these tools a special license is required. Please contact Namosoft for more information.

 

Contact us in case you have any question or comment via our email