Re: 7-Zip Unpacker?

[Wayne Stewart via 4D_Tech]

Bob,

This is outside 4D?

If you use a Mac look at keka - http://www.kekaosx.com/en/

If you use Windows, it serves you right!


Regards,

Wayne


[image: --]
Wayne Stewart
[image: http://]about.me/waynestewart



On 22 April 2018 at 12:43, Bob Miller via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi Everyone,
>
> I am being sent some files that are "deep" inside a 7-ZIP archive.  That
> means when you open them with the 7-ZIP GUI tool (7-ZIP is kind of like
> WinZip), you see a folder, then you open the folder, then another folder,
> then...then..and about 6 levels deep there's a couple of text files I wish
> to extract so I can then import them into 4D.
>
> I'm having a devil of a time figuring out the command line interface,
> because I have a lot of these files and the folder paths within each one
> isn't the same.  Basically I want to just open each folder and keep going
> until I get to a file, then I know I'm done.  Thankfully, there are no
> branches - in no case are there more than one folder within another folder
> - so I just need to figure out how to keep on drilling down.
>
> Has anyone some sample code they'd be willing to share that specifically
> navigates through 7-ZIP archives?  This would be so much appreciated.
>
> Thank you!
>
> Bob Miller
> Chomerics, a division of Parker Hannifin Corporation
>
>
> ll
> "PLEASE NOTE: The preceding information may be confidential or privileged.
> It only should be used or disseminated for the purpose of conducting
> business with Parker. If you are not an intended recipient, please notify
> the sender by replying to this message and then delete the information from
> your system. Thank you for your cooperation."
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

7-Zip Unpacker?

[Bob Miller via 4D_Tech]

Hi Everyone,

I am being sent some files that are "deep" inside a 7-ZIP archive.  That 
means when you open them with the 7-ZIP GUI tool (7-ZIP is kind of like 
WinZip), you see a folder, then you open the folder, then another folder, 
then...then..and about 6 levels deep there's a couple of text files I wish 
to extract so I can then import them into 4D.

I'm having a devil of a time figuring out the command line interface, 
because I have a lot of these files and the folder paths within each one 
isn't the same.  Basically I want to just open each folder and keep going 
until I get to a file, then I know I'm done.  Thankfully, there are no 
branches - in no case are there more than one folder within another folder 
- so I just need to figure out how to keep on drilling down.

Has anyone some sample code they'd be willing to share that specifically 
navigates through 7-ZIP archives?  This would be so much appreciated.

Thank you!

Bob Miller
Chomerics, a division of Parker Hannifin Corporation


ll
"PLEASE NOTE: The preceding information may be confidential or privileged. It 
only should be used or disseminated for the purpose of conducting business with 
Parker. If you are not an intended recipient, please notify the sender by 
replying to this message and then delete the information from your system. 
Thank you for your cooperation."
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Downloading files via FTP

[Keisuke Miyako via 4D_Tech]

I just wanted to point out that one can not expect a fix for a "bug" that is 
classified as standard behaviour.
(I am not in charge of bug classification)

I would encourage you to make your case for regression on TAOW.
I did not see "use an old build" being suggested as a workaround,
which might mean that the regression aspect has been overlooked by engineering.

> 2018/04/22 7:03、Koen Van Hooreweghe  のメール：
>
> Nope, no different cases. It is that very bug report ACI0096897.
> ...
> Since the date I was hit by this issue (when upgrading to v15.4) I have 
> successfully kept using an older version of the 4D Internet Commands with the 
> newer 4D versions. All is still working fine! But when switching to a later 
> version of the plugin, the errors appear. Something has been changed in 
> between those two versions.
>
> To be 1000% sure, I just tested once more while writing this message.
>
> On Mac 10.11.6. 4D version 15.5 build 218240. 4D Internet Commands version 
> 15.3 build 206770.
> FTP login, change dir, get dir list, fetch first file. No problem, file 
> received.
>
> Shut down database, change 4D Internet Commands to build 208269 (version 
> number is 15.4). Same Mac, same OS, same ftp server, same 4D version, same 
> database, just another plugin version: error 10049 returned by FTP_Receive 
> command, no file retreived. QED.




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Downloading files via FTP

[Koen Van Hooreweghe via 4D_Tech]

Hi Keisuke,

Nope, no different cases. It is that very bug report ACI0096897.

This bug report was created following my TAOW report. The issue was confirmed 
to be reproduced with v15.4 and it was OK with v15.3. 

Precisions:
on MaxOSX 10.12.4 I get the error with both 15.3 (public and HF1) and 15.4 
(212262).
on Windows 7 I get the error with 4D v15.4 (212262).

7 months later I even got a message there was a fix done (which imho means 4D 
engineering did aknowledge it as a bug at that time), but this fix was not 
validated by QA. And another 3 months later the bug was set as standard 
behavior and I got some details and a work around.

The problem also appears only on certain ftp servers, but the one I need to 
connect to is not under my control and I don’t know what they are using. The 
welcome message says the remote system type is unix.

Since the date I was hit by this issue (when upgrading to v15.4) I have 
successfully kept using an older version of the 4D Internet Commands with the 
newer 4D versions. All is still working fine! But when switching to a later 
version of the plugin, the errors appear. Something has been changed in between 
those two versions.

To be 1000% sure, I just tested once more while writing this message.

On Mac 10.11.6. 4D version 15.5 build 218240. 4D Internet Commands version 15.3 
build 206770.
FTP login, change dir, get dir list, fetch first file. No problem, file 
received.

Shut down database, change 4D Internet Commands to build 208269 (version number 
is 15.4). Same Mac, same OS, same ftp server, same 4D version, same database, 
just another plugin version: error 10049 returned by FTP_Receive command, no 
file retreived. QED.

Kind regards,
Koen


> Op 21 apr. 2018, om 21:49 heeft Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> it is possible that we are referring to different cases.
> 
> ACI0096897, which has been classified as "standard behaviour",
> is about Internet Commands issuing a specific FTP command,
> and a specific FTP server responding to that command with an error .

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Downloading files via FTP

[Keisuke Miyako via 4D_Tech]

it is possible that we are referring to different cases.

ACI0096897, which has been classified as "standard behaviour",
is about Internet Commands issuing a specific FTP command,
and a specific FTP server responding to that command with an error .

nothing has changed in Internet Commands, it was a limitation that has existed 
for ever.

> 2018/04/21 14:05、Koen Van Hooreweghe  のメール：
>
> If something is working fine (for years and different 4D versions) and it 
> doesn’t work any more in a new version (while the old version is still OK). 
> Isn’t that called a bug or regression?
>
> Unfortunately it took engineering more then 9 months to provide a valid work 
> around. Fortunately I can live with that work around.
>
> If it has to be fixed probably depends on how many other people are having 
> this issue. I guess I might be the only one until now. Nevertheless, it is 
> still a bug.




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: A thought on re-indexing of a large database after repairs, compacting etc

[Keisuke Miyako via 4D_Tech]

you can read about it in the 15R4 upgrade ref.

ftp://ftp-public.4d.fr/Documents/Products_Documentation/LastVersions/Line_15R4/VIntl/4D_Upgrade_v15_R4.pdf

p.62

> In 4D v15 R4, we have greatly optimized the algorithm for global reindexing 
> of a database. The whole process has been dramatically accelerated, and can 
> be up to two times faster.
>
> Note: A global reindexing is required, for example, after a database repair 
> or when the .4dindx file has been deleted.
>
> Since each record of each indexed table needs to be loaded in memory during 
> indexing, the optimization aimed at minimize disk swaps. This operation is 
> now performed on each table sequentially, which reduces record loading and 
> unloading operations.
>
> In a perfect scenario, the cache would be large enough to contain the whole 
> data file and index --- in this case there would be no speed improvement by 
> the new algorithm. However, the available server memory is usually not that 
> big. If the cache is large enough to hold at least the largest table and its 
> index(es), the new algorithm will be up to twice as fast as before.



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Legacy network layer or not: 4D v15 on Mac OS server and v15.5

[Jim Crate via 4D_Tech]

FWIW, on 4D 16.3 32-bit on MacOS 10.11.x server, using the new network layer 
caused multiple ghosted users every day. Using 4D 16.3 64-bit server, the 
ghosting pretty much disappears (one particular user still ends up ghosted 
multiple times), guess I should check their version of 4D.

Jim Crate

> On Apr 21, 2018, at 11:05 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> From everything I've heard, the new architecture will be a huge step forward 
> in performance, especially for larger deployments. There's no question that 
> push is better than poll when you have thousands of processes trying to 
> communicate (or not) with a server.
> 
> I'm really looking forward to flipping the switch -- I think it's really 
> close in 16.3 HF2.
> 
> 
> --
> Jeffrey Kain
> jeffrey.k...@gmail.com
> 
>> On Apr 21, 2018, at 7:21 AM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> What is spooky is that nobody seems to be 100% behind the ServerNet 
>> architecture. This means that if we want 64 bit support, we have to go with 
>> a potentially troublesome network layer.
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Legacy network layer or not: 4D v15 on Mac OS server and v15.5

[Jeffrey Kain via 4D_Tech]

From everything I've heard, the new architecture will be a huge step forward in 
performance, especially for larger deployments. There's no question that push 
is better than poll when you have thousands of processes trying to communicate 
(or not) with a server.

I'm really looking forward to flipping the switch -- I think it's really close 
in 16.3 HF2.


--
Jeffrey Kain
jeffrey.k...@gmail.com

> On Apr 21, 2018, at 7:21 AM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> What is spooky is that nobody seems to be 100% behind the ServerNet 
> architecture. This means that if we want 64 bit support, we have to go with a 
> potentially troublesome network layer.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Downloading files via FTP

[Chip Scheide via 4D_Tech]

do you need time stamps?
if it makes the process simpler could you use an MD5, or other hash to compare 
the files.


> In my project this now works just fine (so far ... limited testing ...) - I
> get the timestamps, which I need so that the files in the folder can be
> compared against files previously downloaded.
> In this particular project, the files are all images. I wonder if that
> makes a difference?
> Pat
> 
> On 21 April 2018 at 06:05, Koen Van Hooreweghe via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Hi Keisuke,
>> 
>> If something is working fine (for years and different 4D versions) and it
>> doesn’t work any more in a new version (while the old version is still OK).
>> Isn’t that called a bug or regression?
>> 
>> Unfortunately it took engineering more then 9 months to provide a valid
>> work around. Fortunately I can live with that work around.
>> 
>> If it has to be fixed probably depends on how many other people are having
>> this issue. I guess I might be the only one until now. Nevertheless, it is
>> still a bug.
>> 
>> Kind regards,
>> Koen
>> 
>>> Op 21 apr. 2018, om 00:52 heeft Keisuke Miyako via 4D_Tech <
>> 4d_tech@lists.4d.com> het volgende geschreven:
>>> 
>>> my understanding is that it is "standard behaviour",
>>> in that the behaviour is expected according to how 4D Internet Commands
>> was designed.
>> 
>> 
>> 
>> 
>> Compass bvba
>> Koen Van Hooreweghe
>> Kloosterstraat 65
>> 9910 Knesselare
>> Belgium
>> tel +32 495 511.653
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
>> 
> 

Hell is other people 
 Jean-Paul Sartre
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

A thought on re-indexing of a large database after repairs, compacting etc

[Paul Lovejoy via 4D_Tech]

Hi,

I’m working with a pretty big database, with about 120gb of data and about 45 
million records over about 250 tables. This database has been in use for about 
20 years and is growing ever faster.

I guess you could call this a gripe but I don’t understand why, if a table has 
several indexes, 4D can’t load the data once and generate all the indexes for 
that table in one go. It would presumably allow for reindexing a database much 
quicker.

Just my 2 cents worth. Maybe someone from the 4D engineering team could explain 
why I’m wrong.



Paul
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Legacy network layer or not: 4D v15 on Mac OS server and v15.5

[Paul Lovejoy via 4D_Tech]

What is spooky is that nobody seems to be 100% behind the ServerNet 
architecture. This means that if we want 64 bit support, we have to go with a 
potentially troublesome network layer.


Paul


> Le 21 avr. 2018 à 01:30, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Hi Jeff,
> 
>> I haven’t tried it yet, but I understand that the old network layer is 
>> available to all apps in v17.
> 
> You may be on to something, but the documentation still says it doesn't work:
> http://doc.4d.com/4Dv17/4D/17/Architecture-of-64-bit-applications.300-3743775.en.html
> 
> Quote: " (*) With 32-bit versions of 4D Server (both platforms) and 64-bit 
> versions of 4D Server for Windows, you need to make sure that the ServerNet 
> network layer is activated on the server side, ***since the legacy network 
> layer is not available in 64-bit versions of 4D***. For more information, 
> please refer to the New ServerNet Network Layer (compatibility) section."
> 
> I am checking with the team on this.
> 
> -Tim
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Downloading files via FTP

[Pat Bensky via 4D_Tech]

In my project this now works just fine (so far ... limited testing ...) - I
get the timestamps, which I need so that the files in the folder can be
compared against files previously downloaded.
In this particular project, the files are all images. I wonder if that
makes a difference?
Pat

On 21 April 2018 at 06:05, Koen Van Hooreweghe via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Keisuke,
>
> If something is working fine (for years and different 4D versions) and it
> doesn’t work any more in a new version (while the old version is still OK).
> Isn’t that called a bug or regression?
>
> Unfortunately it took engineering more then 9 months to provide a valid
> work around. Fortunately I can live with that work around.
>
> If it has to be fixed probably depends on how many other people are having
> this issue. I guess I might be the only one until now. Nevertheless, it is
> still a bug.
>
> Kind regards,
> Koen
>
> > Op 21 apr. 2018, om 00:52 heeft Keisuke Miyako via 4D_Tech <
> 4d_tech@lists.4d.com> het volgende geschreven:
> >
> > my understanding is that it is "standard behaviour",
> > in that the behaviour is expected according to how 4D Internet Commands
> was designed.
>
>
>
> 
> Compass bvba
> Koen Van Hooreweghe
> Kloosterstraat 65
> 9910 Knesselare
> Belgium
> tel +32 495 511.653
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**