Export Nav Objects by Code

Exporting locked nav objects can be a problem when importung in target database. it’s not that easy to unlock them in the target database. So for that you can export nav objects by code and check Lock status before exporting. Create a new report, add dataitem Object. set report to processingonly. select dataitem Object, set… Continue reading Export Nav Objects by Code

How to: Get record count for all tables

In newer Nav versions the tables overview in development environment/database information has gone. So how to get that list back ? Let’s got to SSMS (Sql Server Management Studio). There select the database, for which you want that information. Right click on database -> Reports -> Standard Reports -> Disk usage by Top Tables There we… Continue reading How to: Get record count for all tables

How to work with big item descriptions

Sometimes it’s needed to save very long descriptions, but in Nav text fields can have only 250 characters. Additional you may want to search in these long text values. You can add a couple of these text fields to save long texts or save the text in text files and add them to the item.… Continue reading How to work with big item descriptions

Mass data import

There was an issue with importing all UK post codes from a csv file, about 3m post codes. Importing using rapidstart services (excel import) can cause buffer overflow messages. excel itself has row/size limitations. Increasing MaxNoOfXMLRecordsToSend in config file ClientUserSettings.config from default value 5000 to e.g. 20000 is no problem and can help. Also changing MaxUploadSize in server… Continue reading Mass data import

ReplaceString and a new SelectString

With function ConvertStr you can replace substrings in strings. The original substring and the replacement have to have the same length. So what to do, if the length is different? Here is a solution. ReplaceString(String : Text[250];OrigSubStr : Text[100];ReplSubStr : Text[100]) : Text[250] // StartPos : Integer StartPos := STRPOS(String,OrigSubStr); WHILE StartPos > 0 DO BEGIN String… Continue reading ReplaceString and a new SelectString

Convert Tab delimited strings

I had an issue to process a csv file with TAB delimited text lines. The existing code expected text lines with ; as delimiter. Character TAB has ASCII Code 9. So i wrote following code: ConvertTabString(line : Text[250]) : Text[250] ch := 9; // of type Char line := CONVERTSTR(line,FORMAT(ch),’;’); exit(line); test code: // set… Continue reading Convert Tab delimited strings

Textual Data Export by Configuration

An often by customers wanted feature is to get a data export to a text/csv file, which can then be edited in excel or text editor. Yes, you can use Rapidstart Services. But with that feature you can only export data in excel format, not in text format. That’s ok for editing in Excel and reimport the changed data back to… Continue reading Textual Data Export by Configuration