Skysnake

Czesc Michal @mLipok I need some advice. $c2 = StringReplace($c2, "Znak", "Click to open http://www.server.com/online/sample.pdf Znak") This works. And the link is active. But this is ugly. I am looking for a way to embed that hyperlink under some user friendly text. Like an HTML hyperlink. More like this <a href="https://www.w3schools.com/">Visit W3Schools.com!</a> Problem is that this hyperlink and it's position is dynamic. So I cannot preset the location. Best idea so far is to count lines, then write the hyperlink to the text location. ugly. bad. Like this.         ; Add a URL Link         _QPDF_AddLinkToWeb_Lite($oQP, 15, 65, 100, 20, 'http://www.autoitscript.com/forum/') ; the actual hyperlink         _QPDF_DrawText_Lite($oQP, 25, 75, 'http://www.autoitscript.com/forum/') ; text only (but hyperlink recognized) So have a function that combines the user text with the actual HTTP hyperlink just like HTML For clarity, when the text is written, the position is not predetermined, it goes into an array. The Array gets written to the PDF. There could be multiple links in the array. I need the actual hyperlink to correspond with its text. Do I make sense? Skysnake

nlohman json 3.11.3. Does this mean anything? IS there native JSON standard for AutoIt? Or is everything UDF dependent? And is there standard for that? Like Regex? Skysnake

😉 The combo actually contains Listview type data (multi column) --- the initial query returns the data in a predetermined sequence (ORDER BY), however now a user wants a different sort order. If I understand $CBS_SORT correctly this (very nifty switch) will force the default display to Automatically sorts strings added to the list box, and will override the initial SQL sequence. Not bad if alpha is all you need. I have decided on a SORT ICON, which will cycle through the different options ... my best solution so far. @Nine & @Musashi thank you for the interest. Skysnake

I like that suggestion. The ay I have looked a this, is that the FULL functions are available if you need to do everything, but to get going and get a feel of capabilities the (simple) wrappers are a great way to get started. Please do this Skysnake

Hi I have a combo with content which is the result of a SQL query. Problem is that AFTER populating the combo, user wants to sort the content. Any suggestions? I could add a button which would re-arrange the underlying array and re-populate the combo without going back to SQL. Any better, faster ideas? Thanks Skysnake

Yes, of course It will be my pleasure.

https://www.autoitscript.com/wiki/OutlookEX_UDF_-_Appointment_Item I experienced this issue From the wiki and documentation _OL_Wrapper_CreateAppointment($oOutlook, "Test Appointment", $sStart, $sEnd, "My office", False, "Testbody", 15, $olBusy, $olImportanceHigh, $olPrivate, $olRecursWeekly, $sStart, _DateAdd("w", 3, $sEnd), 1) The UDF example expressly lists this prototype: _OL_Wrapper_CreateAppointment($oOL, $sSubject, $sStartDate[, $vEndDate = ""[, $sLocation = ""[, $bAllDayEvent = False[, $sBody = ""[, $sReminder = 15[, $sShowTimeAs = ""[, $iImportance = ""[, $iSensitivity = ""[, $iRecurrenceType = ""[, $sPatternStartDate = ""[, $sPatternEndDate = ""[, $iInterval = ""[, $iDayOfWeekMask = ""[, $iDay_MonthOfMonth_Year = ""[, $iInstance = ""]]]]]]]]]]]]]]]) However, Where $sEnd(date) is blank, using "" (double quotes) does not behave as expected. Similar using a blank "" (double quotes) for Location caused unwanted behaviour. Using keyword Default fixed all problems _OL_Wrapper_CreateAppointment($oOutlook, $OLm_Subject, $OLm_DatStart, Default, Default, Default, $sBody) I could not find a caveat in the documentation stating keyword Default is to be used for default values. Have a nice day now Skysnake

I often work with large volume spreadsheet data. After many years I finally made the decision to move all data to SQL ASAP and then work in SQL. I retain the original spreadsheets for backup and reference purposes, but it is just so much easier to work with data in SQL. Typical workflow would be to Prep the spreadsheets for import, change empty cells to blank space or zero, unless I want to retain default NULLs. Save spreadsheet as CSV. Create a temp SQL table the looks like the data. Load CSV into SQL. Do quality control checks. Proceed in SQL. SQLite has the several benefits. Including it allows dynamically typed data columns, similar to spreadsheet and it provides for CLI dot imports, SQLite Commands - SQL Docs Extract, transform, load - Wikipedia For your specific situation SQL, would provide an additional layer of data security in the sense that casual, unintentional data modification or deletion would not be a major concern.

@Champak, have you tried simple select queries? Is it possible that your default connection is READ ONLY?

Try like this to see where you are going: ConsoleWrite("@WorkingDir " & @WorkingDir & @CRLF) ConsoleWrite("c: @ScriptDir SomeFolder\SubFolder " & "c:" & @ScriptDir & "SomeFolder\SubFolder" & @CRLF)

Obviously my needs are commercial and more involved than the example posted. I have two problems - the storage space and capacity of the PST files and the ability to catalogue and search. It is important to be able to select a "category tag" and get a list of relevant messages. The data may remain in PST, as long as I can build a searchable database of items. This may require (1) copying from online to offline PST and (2) creating a separate SQL db with PST item IDs only.

I need some inspiration. Mail items are stored in PST files. Typically IMAP also leaves items on the server. This means that server space is being used for data storage. What I am looking for is ideas on how to handle data storage. Simple copying of items to offline storage is not sufficient. Items need to be categorized and catalogued. Lets say I need to create categories for senders, such as Aunt Jo and uncle Bob, and events, such as Christmas 2020, Lockdown 2020 etc. Obviously items must be logged to a database on these characteristics, so that when the user clicks on Aunty Jo, all items from her are show, with sub categories. I can build a SQL database to store, identify and search for items, what I have never done is move data from PST to SQL and restore, and maintain integrity. The primary objective is to reduce "active" PST file sizes, and secondary to be able to search "offline" data storage and then ultimately restore / rebuild the original message(s). What are the issues to take notice of? Where do I start? Thank you Skysnake

Can also be overwritten by ZIP extraction. I agree, it is almost useless.

-- 2023.03.20 Postgres INSERT UNNEST Example CREATE TABLE IF NOT EXISTS demounnest (dname text, dbday text); TRUNCATE TABLE demounnest; INSERT INTO demounnest (dname, dbday) VALUES ('Abe' -- dname , '1969-07-04') ,('Ben' -- dname , '1979-08-05') ; INSERT INTO demounnest (dname, dbday) SELECT UNNEST(ARRAY['Devon','Earl']) ,UNNEST(ARRAY['1989-01-31','1999-02-28']) ; SELECT * FROM demounnest; -- RESULT "Abe" |"1969-07-04" "Ben" |"1979-08-05" "Devon"|"1989-01-31" "Earl" |"1999-02-28" PostgreSQL: Documentation: 15: 9.19. Array Functions and Operators unnest ( anyarray ) → setof anyelement Expands an array into a set of rows. The array's elements are read out in storage order. unnest(ARRAY[1,2]) → 1 2 unnest(ARRAY[['foo','bar'],['baz','quux']]) → foo bar baz quux The real power of UNNEST is the speed. When we select data from tables we tend to select rows, and insert rows. This is the standard approach. But it is slow. UNNEST, even in this mini example, is 0.25s faster than the conventional insert. UNNEST has been available since before version 9.0 and in 9.15 (Current) UNNEST for SELECT has been expanded.

Is Debenu discontinued? I rely heavily on that DLL