![]() You can use metacharacters \t \r \n \xHH (hex) or \\. Thus if you want tab-delimited, then put tabs between the expressions. Everything in the format string is returned verbatim except for anything inside which is treated as an expression which can reference the fields of the file being exported. To export with a particular format, use the format parameter. Using “=” as the search expression will export a single “record” containing just the field names for the file. If the search parameter is an empty string, you will get all records, otherwise only those matching the search expression. The table parameter may include a sort specifier (e.g. The result of the export operation is passed back in p_result or written to output_file if supplied. The first two parameters are the connection parameters from mwks_setup_connection ( p_connect and p_application). Obviously, all of the detail line array elements should have the same number of separators! In the example below, it inserts the 2nd array element into, and it will split array element 17 (using GS_ ASCII_Code as the separator) into one or more values, with separate detail lines for each. If the b_debug flag is set, this generated import file will be saved in the component's Resources\Moneyworks_import folder, so that you can import it manually later. However, mwks_import_arrays uses a pseudo import map which uses placeholders to insert the array data into in a suitably formatted XML file which is then imported into Moneyworks. Post seqnum='sequence number' :- Post the transaction identified by sequence numberįor REST connections, standard Moneyworks import maps cannot be used and so the import_map parameter is ignored for mwks_import_file and mwks_import_text. Optional parameter - if non blank, use XML output Optional parameter - if non blank, try to open the data file OS of DC server - either 'Windows' or 'Macintosh' Password for DC or DC REST server (may be left blank) ![]() ![]() Username for DC or DC REST server login (may be left blank if server not running in ASP mode, otherwise it is required) If left blank, uses default port (6674 for Gold server, 6699 for DC server, 6710 for DC REST server) IP address of Gold server/DC server/ DC REST server ![]() Password for data file (may be left blank) Username for data file (ignored if doc_pass is blank) Returned containing the Moneyworks application stringġ=Gold local, 2=Gold server, 3=DC server, 4=DC REST serverįull path to Moneyworks executable (not needed if connection=4)įull path to data file (if connection=1), or document filename (if connection=3 or 4) Now updated for 4D v15, including support for REST connections to versions of Moneyworks newer than v6.1 - see Įxamples using the available methods are included in the accompanying example database, which also includes a form which can be used to experiment (use the mwks_preferences method to open it). Pricing is a simple flat rate of $250 per year for unlimited use. For a license key, or to obtain the source code, please contact us ( ). The component has been tested on 4D versions v11r8 to v15.1, connecting to Moneyworks v5 to v7. This document is based on the Moneyworks command-line documentation from Cognito (. ![]() If you use Moneyworks v5 or newer, and would like to integrate it with 4D v11 or newer, then you've come to the right place! Simply download and install the component, play with the example database (or read the documentation), and you're away. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |