dcsimg

Search:

Type: Posts; User: Daniel Duta

Page 1 of 9 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    7
    Views
    484

    Re: RC5 without register it

    Hi Olaf. Yes, I try to make a small app RC5 based (...the previous parser) and it would be useful to deploy it in a regfree way. What I tried above, using the Trick's module, was to register the...
  2. Replies
    7
    Views
    484

    Re: RC5 without register it

    Thank you for reply, Trick. I would prefer to use early binding method but unfortunately I have got an error within CreateObjectEx1 function.
    170327 The code lines used are :

    Option Explicit
    ...
  3. Replies
    7
    Views
    484

    RC5 without register it

    I am interested to use the Trick's module presented at this link http://www.vbforums.com/showthread.php?835363-RESOLVED-VB6-ActiveX-dll-and-using-it-without-registering-it-(manifest-) and to use it...
  4. Replies
    17
    Views
    881

    Re: How to parse big files ?

    I took all these suggestions transferring the StringBuilder content on disk at each 1Mb accumulated in SB (that in this context is a buffer). The results are beyond my initial expectations: total...
  5. Replies
    17
    Views
    881

    Re: How to parse big files ?

    Hi, Dile. Of course, it would be more efficient to move all content in a database directly but we work in a team with some specific task. Shortly, we have 3 layers of tasks inside our ETL process: ...
  6. Replies
    17
    Views
    881

    Re: How to parse big files ?

    Thank you Olaf for your solution. You have synthesized very well above what I intend to do (what is it possible to do) within blocks and on the other hand the speed indeed increased significantly...
  7. Replies
    17
    Views
    881

    Re: How to parse big files ?

    Yes, it is a normal text file with row separators LF. My ''chunks'' are separated by "============================" (...I call them blocks because chunks are associated with space of a string and...
  8. Replies
    17
    Views
    881

    Re: How to parse big files ?

    A block is, in your example, a chunk of a file that has a size defined by the buffer size. You call it m_lBlock explicitly. In my case a block is the data within 2 delimiters (see above "======")...
  9. Replies
    17
    Views
    881

    Re: How to parse big files ?

    Thank you for reply, Arnout. I didn't understand very well the entire usage of the class but I was able to read the first line and I found out the file size (757517246) and total number of blocks...
  10. Replies
    17
    Views
    881

    Re: How to parse big files ?

    The initial request was based on a smaller file (100.000 rows) and the approach above worked very well and fast. The reason to read it twice was to capture some specific details from blocks...
  11. Replies
    17
    Views
    881

    [RESOLVED] How to parse big files ?

    I need to parse a big txt file (non csv) that has over 700 Mb and so far all my attempts failed with Out of memory error. Initially this file had a smaller size and the lines below worked very well...
  12. Re: [RESOLVED] How to save a xls file as csv via ADO ?

    Such files, which for some are exceptions, are common files at my workplace.
    These files come automatically from a BI tool and it only exports data from another tool where users have the freedom to...
  13. Re: How to save a xls file as csv via ADO ?

    Sorry for the late reply but I got stuck with some work. Well, I am glad to see the above CSV converters are 100% similar in terms of results both with original excel file and the Python output. I...
  14. Re: How to save a xls file as csv via ADO ?

    Thank you, Chris. Have you test it before ? For what reason you have used the loop For j = LBound(s1) To UBound(s1) : Next j ?
  15. Re: How to save a xls file as csv via ADO ?

    Absolutely, I am aware about it and for the second part I do not have big expectations considering that our small community is divided.


    No, Dile, I have just need to extract the excel info into...
  16. Re: How to save a xls file as csv via ADO ?

    Thank you Dile for details regarding CSV format in conjuction with MIME standard. Even I have to decode files often from this standard, in this case all tests above failed locally without having to...
  17. Re: How to save a xls file as csv via ADO ?

    I've tested approaches above and both of them, at a certain line, start to write data in a wrong format. While the ChrisE's routine mixes data even from the first line, the RC5 String Builder method...
  18. Re: How to save a xls file as csv via ADO ?

    After many attempts I've noticed that there are 3 sources of errors that affect my conversion to a csv file: some cells contain comma, other cells contain many carriage return and other cells contain...
  19. Re: How to save a xls file as csv via ADO ?

    Yes, Dile, I filled the db path with full path of my csv file according to wqweto suggestion and most likely this is the proper way as long as I get a different error :). Indeed, the excel file...
  20. Re: How to save a xls file as csv via ADO ?

    Yes, you are right wqweto, however Microsoft Access Database Engine 2010 (ODBC and OLEDB drivers) was accepted to be installed around SQL Server 2012 so that to have a connectivity with Office files...
  21. Re: How to save a xls file as csv via ADO ?

    Thank you for reply, Dile. For some reason first Execute command raises an error. I suspect that the destination path mentioned after INTO command is not declared properly or at least I do not...
  22. Re: How to save a xls file as csv via ADO ?

    No, that server has nothing installed from the Office package but the SQL server only. I do not understand very well which is the gain creating a linked table in database when my purpose is to have...
  23. Re: How to save a xls file as csv via ADO ?

    Thanks, Chris. Yes, this is the classic method (late binding) but I cannot use it as long as that machine doesn't know anything about Office library.
  24. Re: How to save a xls file as csv via ADO ?

    Thank you for reply westconn. Yes, I tried this approach before and it is a bit faster but the cells in the final csv looks very mixed. I have also tried an older function posted on site years ago...
  25. [RESOLVED] How to save a xls file as csv via ADO ?

    I need to open an excel file, to read a certain sheet and to save it as csv on a server where MS Office is not installed. I know how to set the ADO properties so that to get data either as array...
  26. Replies
    3
    Views
    353

    Re: RC5 Stream

    Thank you for your support, Olaf. Very useful the Base64Dec function because it may return the result either as string or byte array. In the same time it is amazing that in a single line of code you...
  27. Replies
    3
    Views
    353

    [RESOLVED] RC5 Stream

    I have a task where I used RC5 library due to some functions that suits my needs. The main file is coming in the MIME standard and does contain an attachment as tar.gz format. The processes of file...
  28. Replies
    9
    Views
    538

    Re: vbRichClient error

    Yes, Olaf, most likely I fell into that error...At first step I noticed that my app screams for vbRichClient5.dll and I registered it manually in the system folder just to test if it is seen in the...
  29. Replies
    9
    Views
    538

    Re: vbRichClient error

    I have uninstalled both libraries successfully (I received the pop-up message) but I have noticed that after the second re-installation no pop-up message occurred... And this lack of a successful...
  30. Replies
    9
    Views
    538

    Re: vbRichClient error

    Yes, I run the command prompt as admin and of course I called regsvr32 /s C:\Windows\SysWOW64\vbRichClient5.dll. The same for vbWidgets.dll.
    The function that failed is:
    mailBody =...
  31. Replies
    9
    Views
    538

    Re: vbRichClient error

    Thank you both for your reply. Yes, I placed all libraries in the SysWow64 (latest version from Olaf's site) and I used cmd.exe as admin to register them. It is interesting that I am able in design...
  32. Replies
    9
    Views
    538

    [RESOLVED] vbRichClient error

    After I installed Windows 10 and all components of RC5 in SysWOW64 I get each time a run-time error 429 : ActiveX component can't create object. Has anyone ever encountered such an error? Could it be...
  33. Re: How to create timer without interface ?

    Hi all,
    Meanwhile I preferred to use the code below. It was stable in time and it is maintained by an user service created with srvany.exe. (I didn't understand how the service control made by...
  34. Re: How to create timer without interface ?

    Thank you all for your hints. Meanwhile, after many searches on web, I found a beautiful solution written by a Russian years ago (Sergey Merzlikin). It seems he succeeded to avoid all inconveniences...
  35. Re: How to create timer without interface ?

    Thank you Dave for your 2 alternatives. The latest solution is even simple and very ingenious :) . I have just a question. I compared my timer control behavior with these two solutions and I have...
  36. Re: How to create timer without interface ?

    Yes, you are right. This small program will be deployed as a service on server and it is known for this kind of things there are not accepted GUI apps. The purpose is to keep in monitoring a small...
  37. Re: How to create timer without interface ?

    Thank you all for suggestions. The main issue is I cannot declare the WithEvents at a bas module level. Besides there is no issue to create a timer (without window) that does measure the duration...
  38. [RESOLVED] How to create timer without interface ?

    I need to replace the common Timer control with a routine that shouldn't have an interface. It would be preferable to create an event around the RC5 timing function as long as this library has some...
  39. Re: A library or ActiveX component for drawing and controlling shapes at runtime?

    Olaf, would you mind explaining to me how does the EnterMessageLoop method work with WidgetForms ? Is it necessary to be called it after a form is displayed ? Thank you.
  40. Replies
    9
    Views
    815

    Re: Spinner in VB6

    I have replaced my version 5.0.0.63 with latest from site (5.0.0.67) and now it works. Also I have kept your settings from class initialization because they seem perfect in terms of speed and...
Results 1 to 40 of 343
Page 1 of 9 1 2 3 4



Featured


Click Here to Expand Forum to Full Width