maniootek Posted July 19, 2021 Posted July 19, 2021 I am looking for way to convert json data into array in fastest way. I guess this could be done using regex. This is my sample of json data: Quote { "invoices": [ { "invoice_id": 28532595, "order_id": 151550993, "series_id": 454192, "type": "normal", "number": "1/ADE19/06/2021", "year": 2021, "month": 6, "sub_id": 1, "postfix": "", "date_add": 1622534536, "date_sell": 1622429057, "date_pay_to": 0, "currency": "EUR", "total_price_brutto": 24.99, "total_price_netto": 21, "invoice_fullname": "", "invoice_company": "Amazon EU S.à r.l., Niederlassung Deutschland", "invoice_nip": "DE814584193", "invoice_address": "Marcel-Breuer-Str. 12", "invoice_city": "München", "invoice_postcode": "80807", "invoice_country": "Germany", "invoice_country_code": "DE", "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123", "payment": "Amazon", "additional_info": "", "correcting_to_invoice_id": 0, "correcting_reason": "", "correcting_items": false, "correcting_data": false, "external_invoice_number": "", "external_id": "", "exchange_currency": "PLN", "exchange_rate": 4.4845, "exchange_date": "2021-05-28", "exchange_info": "102/A/NBP/2021", "items": [ { "name": "Some item name", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 } ] }, { "invoice_id": 28735725, "order_id": 151551135, "series_id": 455582, "type": "normal", "number": "6/APL23/06/2021", "year": 2021, "month": 6, "sub_id": 6, "postfix": "", "date_add": 1622534544, "date_sell": 1622484857, "date_pay_to": 0, "currency": "EUR", "total_price_brutto": 91.46, "total_price_netto": 74.3577, "invoice_fullname": "Diego Hel", "invoice_company": "", "invoice_nip": "", "invoice_address": "An Der Son 112", "invoice_city": "Bracker", "invoice_postcode": "123", "invoice_country": "Germany", "invoice_country_code": "DE", "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123", "payment": "Amazon", "additional_info": "", "correcting_to_invoice_id": 0, "correcting_reason": "", "correcting_items": false, "correcting_data": false, "external_invoice_number": "", "external_id": "", "exchange_currency": "PLN", "exchange_rate": 4.4845, "exchange_date": "2021-05-28", "exchange_info": "102/A/NBP/2021", "items": [ { "name": "Some item name", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 }, { "name": "Some item name 2", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 }, { "name": "Some item name 3", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 } ] }, { "invoice_id": 287453274, "order_id": 1519521815, "series_id": 455482, "type": "normal", "number": "7/APL23/06/2021", "year": 2021, "month": 6, "sub_id": 7, "postfix": "", "date_add": 1622534545, "date_sell": 1622485464, "date_pay_to": 0, "currency": "EUR", "total_price_brutto": 21.49, "total_price_netto": 17.4715, "invoice_fullname": "John Wick", "invoice_company": "", "invoice_nip": "", "invoice_address": "Bluestreet 30", "invoice_city": "Some city", "invoice_postcode": "123123", "invoice_country": "Germany", "invoice_country_code": "DE", "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123", "payment": "Amazon", "additional_info": "", "correcting_to_invoice_id": 0, "correcting_reason": "", "correcting_items": false, "correcting_data": false, "external_invoice_number": "", "external_id": "", "exchange_currency": "PLN", "exchange_rate": 4.4845, "exchange_date": "2021-05-28", "exchange_info": "102/A/NBP/2021", "items": [ { "name": "iphone 7", "sku": "123", "ean": "123123123aa", "price_brutto": 21.49, "price_netto": 17.4715, "tax_rate": 23, "quantity": 1 } ] } ] } and I want to convert it into array with this structure: any idea?
Developers Jos Posted July 19, 2021 Developers Posted July 19, 2021 26 minutes ago, maniootek said: any idea? Yes, but wondering if you even tried to look for the answer yourself before dumping the question here as there are several JSON udfs available? SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past.
maniootek Posted July 19, 2021 Author Posted July 19, 2021 Yes I tried Json UDF and I can parse the json data into array but it takes too long time. My json files are large and I am trying to save some time. I think regex could be much faster to parse this data but I don't know to write the regex pattern. This is why I am looking for help in forum.
Developers Jos Posted July 19, 2021 Developers Posted July 19, 2021 So what about being way more specific and tell us what you have done, how long it takes now, post an example JSON file etc etc etc .... It seriously can't be that hard to provide enough details so people can really help you and is it not like you are new around here. SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past.
maniootek Posted July 19, 2021 Author Posted July 19, 2021 (edited) Thinking of faster json data parsing came up to my mind when I discovered that large files can be loaded to array very fast. I recently discovered function _FileReadToArray which can load 1MB csv report file into array in less than 1second. Wondering now if I can achieve similar result with json data parsing. At this moment I use JSON.au3 UDF downloaded from here: Quote https://www.autoitscript.com/forum/topic/148114-a-non-strict-json-udf-jsmn There is not much code I use. I simply read json string into variable and then decode it. Then I use Json_ObjGet function to get needed data Local $sJson = FileRead("test.json") Local $oJson = Json_Decode($sJson) Local $a_oJson = Json_ObjGet($oJson , "invoices") for $i=0 to Ubound($a_oJson) - 1 if Json_ObjGet(a_oJson[$i], "invoice_id") = "123" then MsgBox(0,0,1) next I just checked the time needed to parse the json data and result says that Json_Decode() function need 17.6seconds to load 1.7MB JSON file in my PC. I belive I can load the data faster. Or maybe I am wrong? Edited July 19, 2021 by maniootek
mLipok Posted July 19, 2021 Posted July 19, 2021 Did you try Chilkat UDF ? Signature beginning:* Please remember: "AutoIt"..... * Wondering who uses AutoIt and what it can be used for ? * Forum Rules ** ADO.au3 UDF * POP3.au3 UDF * XML.au3 UDF * IE on Windows 11 * How to ask ChatGPT for AutoIt Code * for other useful stuff click the following button: Spoiler Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind. My contribution (my own projects): * Debenu Quick PDF Library - UDF * Debenu PDF Viewer SDK - UDF * Acrobat Reader - ActiveX Viewer * UDF for PDFCreator v1.x.x * XZip - UDF * AppCompatFlags UDF * CrowdinAPI UDF * _WinMergeCompare2Files() * _JavaExceptionAdd() * _IsBeta() * Writing DPI Awareness App - workaround * _AutoIt_RequiredVersion() * Chilkatsoft.au3 UDF * TeamViewer.au3 UDF * JavaManagement UDF * VIES over SOAP * WinSCP UDF * GHAPI UDF - modest begining - comunication with GitHub REST API * ErrorLog.au3 UDF - A logging Library * Include Dependency Tree (Tool for analyzing script relations) * Show_Macro_Values.au3 * My contribution to others projects or UDF based on others projects: * _sql.au3 UDF * POP3.au3 UDF * RTF Printer - UDF * XML.au3 UDF * ADO.au3 UDF * SMTP Mailer UDF * Dual Monitor resolution detection * * 2GUI on Dual Monitor System * _SciLexer.au3 UDF * SciTE - Lexer for console pane * Useful links: * Forum Rules * Forum etiquette * Forum Information and FAQs * How to post code on the forum * AutoIt Online Documentation * AutoIt Online Beta Documentation * SciTE4AutoIt3 getting started * Convert text blocks to AutoIt code * Games made in Autoit * Programming related sites * Polish AutoIt Tutorial * DllCall Code Generator * Wiki: * Expand your knowledge - AutoIt Wiki * Collection of User Defined Functions * How to use HelpFile * Good coding practices in AutoIt * OpenOffice/LibreOffice/XLS Related: WriterDemo.au3 * XLS/MDB from scratch with ADOX IE Related: * How to use IE.au3 UDF with AutoIt v3.3.14.x * Why isn't Autoit able to click a Javascript Dialog? * Clicking javascript button with no ID * IE document >> save as MHT file * IETab Switcher (by LarsJ ) * HTML Entities * _IEquerySelectorAll() (by uncommon) * IE in TaskScheduler * IE Embedded Control Versioning (use IE9+ and HTML5 in a GUI) * PDF Related: * How to get reference to PDF object embeded in IE * IE on Windows 11 * I encourage you to read: * Global Vars * Best Coding Practices * Please explain code used in Help file for several File functions * OOP-like approach in AutoIt * UDF-Spec Questions * EXAMPLE: How To Catch ConsoleWrite() output to a file or to CMD *I also encourage you to check awesome @trancexx code: * Create COM objects from modules without any demand on user to register anything. * Another COM object registering stuff * OnHungApp handler * Avoid "AutoIt Error" message box in unknown errors * HTML editor * winhttp.au3 related : * https://www.autoitscript.com/forum/topic/206771-winhttpau3-download-problem-youre-speaking-plain-http-to-an-ssl-enabled-server-port/ "Homo sum; humani nil a me alienum puto" - Publius Terentius Afer"Program are meant to be read by humans and only incidentally for computers and execute" - Donald Knuth, "The Art of Computer Programming" , be and \\//_. Anticipating Errors : "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty." Signature last update: 2023-04-24
Nine Posted July 19, 2021 Posted July 19, 2021 Maybe something along those lines ? #include <Constants.au3> #include <Array.au3> Local $sJson = FileRead("Test.txt") Local $aArray = StringRegExp($sJson, '("invoice_id"|"order_id"|"series_id"): (\d+)', 3) _ArrayDisplay($aArray) “They did not know it was impossible, so they did it” ― Mark Twain Spoiler Block all input without UAC Save/Retrieve Images to/from Text Monitor Management (VCP commands) Tool to search in text (au3) files Date Range Picker Virtual Desktop Manager Sudoku Game 2020 Overlapped Named Pipe IPC HotString 2.0 - Hot keys with string x64 Bitwise Operations Multi-keyboards HotKeySet Recursive Array Display Fast and simple WCD IPC Multiple Folders Selector Printer Manager GIF Animation (cached) Screen Scraping Multi-Threading Made Easy
maniootek Posted July 20, 2021 Author Posted July 20, 2021 (edited) 15 hours ago, mLipok said: Did you try Chilkat UDF ? I need to install some component to make it work, right? 15 hours ago, Nine said: Maybe something along those lines ? #include <Constants.au3> #include <Array.au3> Local $sJson = FileRead("Test.txt") Local $aArray = StringRegExp($sJson, '("invoice_id"|"order_id"|"series_id"): (\d+)', 3) _ArrayDisplay($aArray) After some modification I have this code: #include "Array.au3" $json = FileRead("test.json") ;Local $aArray = StringRegExp($json, '"(.*)": (\[[^[]+]|[^,]+)', 4) Local $aArray = StringRegExp($json, '"(.*)": ("([^""]+)"|\[[^[]+]|[^,]+)', 4) _ArrayDisplay($aArray) for $I=0 to Ubound($aArray) - 1 _ArrayDisplay($aArray[$i]) Next test.json: Quote { "invoice_id": 28532595, "order_id": 151550993, "series_id": 454192, "type": "normal", "number": "1/ADE19/06/2021", "year": 2021, "month": 6, "sub_id": 1, "postfix": "", "date_add": 1622534536, "date_sell": 1622429057, "date_pay_to": 0, "currency": "EUR", "total_price_brutto": 24.99, "total_price_netto": 21, "invoice_fullname": "", "invoice_company": "Amazon EU S.à r.l., Niederlassung Deutschland", "invoice_nip": "DE814584193", "invoice_address": "Marcel-Breuer-Str. 12", "invoice_city": "München", "invoice_postcode": "80807", "invoice_country": "Germany", "invoice_country_code": "DE", "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123", "payment": "Amazon", "additional_info": "", "correcting_to_invoice_id": 0, "correcting_reason": "", "correcting_items": false, "correcting_data": false, "external_invoice_number": "", "external_id": "", "exchange_currency": "PLN", "exchange_rate": 4.4845, "exchange_date": "2021-05-28", "exchange_info": "102/A/NBP/2021", "items": [ { "name": "Some item name", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 } ] }, { "invoice_id": 28735725, "order_id": 151551135, "series_id": 455582, "type": "normal", "number": "6/APL23/06/2021", "year": 2021, "month": 6, "sub_id": 6, "postfix": "", "date_add": 1622534544, "date_sell": 1622484857, "date_pay_to": 0, "currency": "EUR", "total_price_brutto": 91.46, "total_price_netto": 74.3577, "invoice_fullname": "Diego Hel", "invoice_company": "", "invoice_nip": "", "invoice_address": "An Der Son 112", "invoice_city": "Bracker", "invoice_postcode": "123", "invoice_country": "Germany", "invoice_country_code": "DE", "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123", "payment": "Amazon", "additional_info": "", "correcting_to_invoice_id": 0, "correcting_reason": "", "correcting_items": false, "correcting_data": false, "external_invoice_number": "", "external_id": "", "exchange_currency": "PLN", "exchange_rate": 4.4845, "exchange_date": "2021-05-28", "exchange_info": "102/A/NBP/2021", "items": [ { "name": "Some item name", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 }, { "name": "Some item name 2", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 }, { "name": "Some item name 3", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 } ] }, { "invoice_id": 287453274, "order_id": 1519521815, "series_id": 455482, "type": "normal", "number": "7/APL23/06/2021", "year": 2021, "month": 6, "sub_id": 7, "postfix": "", "date_add": 1622534545, "date_sell": 1622485464, "date_pay_to": 0, "currency": "EUR", "total_price_brutto": 21.49, "total_price_netto": 17.4715, "invoice_fullname": "John Wick", "invoice_company": "", "invoice_nip": "", "invoice_address": "Bluestreet 30", "invoice_city": "Some city", "invoice_postcode": "123123", "invoice_country": "Germany", "invoice_country_code": "DE", "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123", "payment": "Amazon", "additional_info": "", "correcting_to_invoice_id": 0, "correcting_reason": "", "correcting_items": false, "correcting_data": false, "external_invoice_number": "", "external_id": "", "exchange_currency": "PLN", "exchange_rate": 4.4845, "exchange_date": "2021-05-28", "exchange_info": "102/A/NBP/2021", "items": [ { "name": "iphone 7", "sku": "123", "ean": "123123123", "price_brutto": 21.49, "price_netto": 17.4715, "tax_rate": 23, "quantity": 1 } ] } but it is much more slower, about 304seconds Edited July 20, 2021 by maniootek
jchd Posted July 20, 2021 Posted July 20, 2021 The provided sample is malformed for a strict JSON parser. This fixes that: Quote { "invoices": [ { "invoice_id": 28532595, "order_id": 151550993, "series_id": 454192, "type": "normal", "number": "1/ADE19/06/2021", "year": 2021, "month": 6, "sub_id": 1, "postfix": "", "date_add": 1622534536, "date_sell": 1622429057, "date_pay_to": 0, "currency": "EUR", "total_price_brutto": 24.99, "total_price_netto": 21, "invoice_fullname": "", "invoice_company": "Amazon EU S.à r.l., Niederlassung Deutschland", "invoice_nip": "DE814584193", "invoice_address": "Marcel-Breuer-Str. 12", "invoice_city": "München", "invoice_postcode": "80807", "invoice_country": "Germany", "invoice_country_code": "DE", "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123", "payment": "Amazon", "additional_info": "", "correcting_to_invoice_id": 0, "correcting_reason": "", "correcting_items": false, "correcting_data": false, "external_invoice_number": "", "external_id": "", "exchange_currency": "PLN", "exchange_rate": 4.4845, "exchange_date": "2021-05-28", "exchange_info": "102/A/NBP/2021", "items": [ { "name": "Some item name", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 } ] }, { "invoice_id": 28735725, "order_id": 151551135, "series_id": 455582, "type": "normal", "number": "6/APL23/06/2021", "year": 2021, "month": 6, "sub_id": 6, "postfix": "", "date_add": 1622534544, "date_sell": 1622484857, "date_pay_to": 0, "currency": "EUR", "total_price_brutto": 91.46, "total_price_netto": 74.3577, "invoice_fullname": "Diego Hel", "invoice_company": "", "invoice_nip": "", "invoice_address": "An Der Son 112", "invoice_city": "Bracker", "invoice_postcode": "123", "invoice_country": "Germany", "invoice_country_code": "DE", "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123", "payment": "Amazon", "additional_info": "", "correcting_to_invoice_id": 0, "correcting_reason": "", "correcting_items": false, "correcting_data": false, "external_invoice_number": "", "external_id": "", "exchange_currency": "PLN", "exchange_rate": 4.4845, "exchange_date": "2021-05-28", "exchange_info": "102/A/NBP/2021", "items": [ { "name": "Some item name", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 }, { "name": "Some item name 2", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 }, { "name": "Some item name 3", "sku": "123123", "ean": "123123123", "price_brutto": 24.99, "price_netto": 21, "tax_rate": 19, "quantity": 1 } ] }, { "invoice_id": 287453274, "order_id": 1519521815, "series_id": 455482, "type": "normal", "number": "7/APL23/06/2021", "year": 2021, "month": 6, "sub_id": 7, "postfix": "", "date_add": 1622534545, "date_sell": 1622485464, "date_pay_to": 0, "currency": "EUR", "total_price_brutto": 21.49, "total_price_netto": 17.4715, "invoice_fullname": "John Wick", "invoice_company": "", "invoice_nip": "", "invoice_address": "Bluestreet 30", "invoice_city": "Some city", "invoice_postcode": "123123", "invoice_country": "Germany", "invoice_country_code": "DE", "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123", "payment": "Amazon", "additional_info": "", "correcting_to_invoice_id": 0, "correcting_reason": "", "correcting_items": false, "correcting_data": false, "external_invoice_number": "", "external_id": "", "exchange_currency": "PLN", "exchange_rate": 4.4845, "exchange_date": "2021-05-28", "exchange_info": "102/A/NBP/2021", "items": [ { "name": "iphone 7", "sku": "123", "ean": "123123123", "price_brutto": 21.49, "price_netto": 17.4715, "tax_rate": 23, "quantity": 1 } ] } ] } Indeed, you want and array of invoices, each entry having an array of items. You can load such a JSON data into an SQLite table using the json1 extension. From there it's easy to navigate, select, compute, change, remove thanks to SQLite power. You can as well build a table of invoices and a linked table of sold items. Given that Amazon JSON uses a defined format for all invoices, things are pretty trivial. This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)
TheXman Posted July 20, 2021 Posted July 20, 2021 (edited) 7 hours ago, jchd said: The provided sample is malformed for a strict JSON parser. The original sample JSON was not malformed for a strict JSON parser. It met all JSON formatting standards. You only modified one line and that modification had nothing to do with strict-formatting. The data may be bad, but it is strictly-formatted. You changed: "ean": "123123123aa", to "ean": "123123123", Both values are strings, so it made no difference as it relates to strictly-formatted JSON? Edit: I see that you must have been referring to the last sample that was supplied. As I stated, I was referring to the original sample that was posted. Edited July 20, 2021 by TheXman Highlighted that I referred to the original post's JSON, not the last sample. CryptoNG UDF: Cryptography API: Next Gen jq UDF: Powerful and Flexible JSON Processor | jqPlayground: An Interactive JSON Processor Xml2Json UDF: Transform XML to JSON | HttpApi UDF: HTTP Server API | Roku Remote: Example Script About Me How To Ask Good Questions On Technical And Scientific Forums (Detailed) | How to Ask Good Technical Questions (Brief) "Any fool can know. The point is to understand." -Albert Einstein "If you think you're a big fish, it's probably because you only swim in small ponds." ~TheXman
jchd Posted July 20, 2021 Posted July 20, 2021 Doesn't it lack a closing bracket? It contains a list of unnammed invoices. Turning that list into an array removes the need to give each a name (a different name, that is, for strict JSON). This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)
jchd Posted July 20, 2021 Posted July 20, 2021 1 hour ago, TheXman said: You changed: No, I didn't. This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)
mLipok Posted July 20, 2021 Posted July 20, 2021 (edited) 6 hours ago, maniootek said: I need to install some component to make it work, right? Yes. For JSON it is free as far as I remember. Edited July 20, 2021 by mLipok Signature beginning:* Please remember: "AutoIt"..... * Wondering who uses AutoIt and what it can be used for ? * Forum Rules ** ADO.au3 UDF * POP3.au3 UDF * XML.au3 UDF * IE on Windows 11 * How to ask ChatGPT for AutoIt Code * for other useful stuff click the following button: Spoiler Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind. My contribution (my own projects): * Debenu Quick PDF Library - UDF * Debenu PDF Viewer SDK - UDF * Acrobat Reader - ActiveX Viewer * UDF for PDFCreator v1.x.x * XZip - UDF * AppCompatFlags UDF * CrowdinAPI UDF * _WinMergeCompare2Files() * _JavaExceptionAdd() * _IsBeta() * Writing DPI Awareness App - workaround * _AutoIt_RequiredVersion() * Chilkatsoft.au3 UDF * TeamViewer.au3 UDF * JavaManagement UDF * VIES over SOAP * WinSCP UDF * GHAPI UDF - modest begining - comunication with GitHub REST API * ErrorLog.au3 UDF - A logging Library * Include Dependency Tree (Tool for analyzing script relations) * Show_Macro_Values.au3 * My contribution to others projects or UDF based on others projects: * _sql.au3 UDF * POP3.au3 UDF * RTF Printer - UDF * XML.au3 UDF * ADO.au3 UDF * SMTP Mailer UDF * Dual Monitor resolution detection * * 2GUI on Dual Monitor System * _SciLexer.au3 UDF * SciTE - Lexer for console pane * Useful links: * Forum Rules * Forum etiquette * Forum Information and FAQs * How to post code on the forum * AutoIt Online Documentation * AutoIt Online Beta Documentation * SciTE4AutoIt3 getting started * Convert text blocks to AutoIt code * Games made in Autoit * Programming related sites * Polish AutoIt Tutorial * DllCall Code Generator * Wiki: * Expand your knowledge - AutoIt Wiki * Collection of User Defined Functions * How to use HelpFile * Good coding practices in AutoIt * OpenOffice/LibreOffice/XLS Related: WriterDemo.au3 * XLS/MDB from scratch with ADOX IE Related: * How to use IE.au3 UDF with AutoIt v3.3.14.x * Why isn't Autoit able to click a Javascript Dialog? * Clicking javascript button with no ID * IE document >> save as MHT file * IETab Switcher (by LarsJ ) * HTML Entities * _IEquerySelectorAll() (by uncommon) * IE in TaskScheduler * IE Embedded Control Versioning (use IE9+ and HTML5 in a GUI) * PDF Related: * How to get reference to PDF object embeded in IE * IE on Windows 11 * I encourage you to read: * Global Vars * Best Coding Practices * Please explain code used in Help file for several File functions * OOP-like approach in AutoIt * UDF-Spec Questions * EXAMPLE: How To Catch ConsoleWrite() output to a file or to CMD *I also encourage you to check awesome @trancexx code: * Create COM objects from modules without any demand on user to register anything. * Another COM object registering stuff * OnHungApp handler * Avoid "AutoIt Error" message box in unknown errors * HTML editor * winhttp.au3 related : * https://www.autoitscript.com/forum/topic/206771-winhttpau3-download-problem-youre-speaking-plain-http-to-an-ssl-enabled-server-port/ "Homo sum; humani nil a me alienum puto" - Publius Terentius Afer"Program are meant to be read by humans and only incidentally for computers and execute" - Donald Knuth, "The Art of Computer Programming" , be and \\//_. Anticipating Errors : "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty." Signature last update: 2023-04-24
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now