EDI(FACT) format

2018-10-17 Thread Axel Kohlepp via 4D_Tech 

Hello.

does anyone have any experience with this format, or even suitable 4D code?

Example:

UNA:+.? '
UNB+UNOC:3+:+xx4711xx:+181017:1124+8741+'
UNH+1+INVOIC:D:96A:HE'
PCD+12:2'
BGM+380+7410268+9'
DTM+137:20181016:102'
RFF+VN:11775607'
CUX+2:EUR'
NAD+II+:91++sangro medical service GmbH+Albert-Einstein-Straße 
6+Erkrath+40699+DE'

RFF+VA:DE241684816'
NAD+IV+:91++MEDTECH GMBH+TANNENWEG 5+BAD MÜNDER+31848+DE'
NAD+PJ+++MEDTECH GMBH+TANNENWEG 5+BAD MÜNDER+31848+DE'
LIN+1++4250488601893:EN'
PIA+1+06718974:SA'
PIA+1+0802VSGHC 25VE:MF+:GN+:WG+06718974:ZZZ'
IMD+F++:::GHC SCHLITZKOMPRESSEN 25X2 1 St'
QTY+47:2:PCE'
MOA+66:12.10'
MOA+203:12.10'
RFF+ON:ECAC181012004518:3'
RFF+VN:11775607'
RFF+DQ:7410268:5'
TAX+7+VAT+++19.000'
TAX+7+VC+++M19.000'
NAD+DP+++Herr Olaf Knoerzer+GHP Halstenbek+Elisabeth-Miller-Weg 
2+Halstenbek+25469'

UNS+S'
CNT+2:1'
MOA+66:12.10'
MOA+131:0.00'
MOA+125:12.10'
MOA+124:2.30'
MOA+9:14.40'
TAX+7+VAT+++:::19.000'
MOA+124:2.30'
UNT+33+1'
UNZ+1+8741'

Many thanks for all tips in advance

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

Sets and the twinned process (Execute on server)

2018-10-17 Thread Kirk Brooks via 4D_Tech 
I haven't looked at this in a long time but I'm revisiting some code that
uses sets. This happens to be v15 and we are talking about client/server.

The docs are pretty clear
 about the scope
of sets with the only unusual thing being a process set created on the
client side is available to a trigger method which runs on the server.

I have an EOS method that does some queries and creates a set. I notice
that set is visible to the client as well.

This is contrary to what the docs say but the documentation was written
before we had Execute on Server. So I'm wondering if this is a fluke of
running server and client on the same machine or if sets are always created
as shared elements between the client process and the twin server process.

-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
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: Sets and the twinned process (Execute on server)

2018-10-17 Thread Kirk Brooks via 4D_Tech 
Thanks Arnaud,
That's what I suspected.

On Wed, Oct 17, 2018 at 9:21 AM Arnaud de Montard via 4D_Tech <
4d_tech@lists.4d.com> wrote:

>
> > Le 17 oct. 2018 à 17:58, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>
> a écrit :
> >
> > [...] a process set created on the
> > client side is available to a trigger method which runs on the server.
> >
> > I have an EOS method that does some queries and creates a set. I notice
> > that set is visible to the client as well.
>
> EoS method and trigger are executed in the same twin process, see
> "Execution Context" here:
> <
> http://doc.4d.com/4Dv17R2/4D/17-R2.1720/Execute-on-Server-attribute.300-3925945.en.html
> >
> this may explain that.
>
> --
> Arnaud de Montard
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
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: Sets and the twinned process (Execute on server)

2018-10-17 Thread Arnaud de Montard via 4D_Tech 

> Le 17 oct. 2018 à 17:58, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> [...] a process set created on the
> client side is available to a trigger method which runs on the server.
> 
> I have an EOS method that does some queries and creates a set. I notice
> that set is visible to the client as well.

EoS method and trigger are executed in the same twin process, see "Execution 
Context" here:

this may explain that. 

-- 
Arnaud de Montard 



**
4D Internet Users Group (4D iNUG)
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: Built Server—Best Practices...

2018-10-17 Thread Keith Goebel via 4D_Tech 
Robert, don’t know it this is relevant to your situation but many years ago, to 
get around the problem of losing the backup settings when installing a new 
built application version, I setup a system where, on quit, I stored the 
backups xml file in the data folder (or a record in the data - too long ago to 
remember exactly).
Anyway, on startup it replaces the existing file with the stored file and away 
you go.
It worked really well - no problems.
HTH, Keith
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Help->v11 to v17 Upgrade or New?

2018-10-17 Thread Robert ListMail via 4D_Tech 
I have an old v11 database running on Windows that’s not particularly 
well-designed and where there are more than a few subtables to deal with. 
Assuming that there is no additional budget for writing a new clean app, would 
you likely upgrade or re-write in v17 with the old v11 structure as guide?  I’m 
concerned that the upgrade path will be difficult because of the subtables and 
that by the time you deal with all of the legacy junk not this database from 
the early 90s you could have created something fresh and new. How might you 
approach this?

Also, the client originally said the new database would not have to migrate 
data forward from the old system and now they are wanting to have the data too.

Thanks,

Robert

**
4D Internet Users Group (4D iNUG)
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: Help->v11 to v17 Upgrade or New?

2018-10-17 Thread Timothy Penner via 4D_Tech 
The main conversion of subtables took place when upgrading to v11, this was 
automatic.
^ This only applied to sincle-level subtables as anything beyond the first 
level was lost: http://kb.4d.com/assetid=49513

The rest of the conversion needs to be done by the developer and consists of 
replacing the subtable commands and redrawing the relationship line. This is 
not automatic.

-Tim







-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Spencer Hinsdale via 
4D_Tech
Sent: Wednesday, October 17, 2018 1:11 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Spencer Hinsdale 
Subject: Re: Help->v11 to v17 Upgrade or New?


4D automatically converts Subtables. This should not be a problem.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Scroll keys

2018-10-17 Thread Peter Mew via 4D_Tech 
Hi
I have a forn, on which there are two pictures, which scroll in sync using
a single horizontal scroll bar.
How do I get the left/right arrow keys to operate the scroll bar.
The language ref says Scroll keys are automatically available for users
when a picture type object has a scroll bar. but it doesnt say how to
activate this function
4D 13.6 (this is supported from 13.2 on apparently)
Mac Yosemite
I'm sure Ive missed something obvious, but what?
thanks
-pm
**
4D Internet Users Group (4D iNUG)
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: Help->v11 to v17 Upgrade or New?

2018-10-17 Thread Chuck Miller via 4D_Tech 
I would go and using v 11 create new tables using key from main table move data 
and then upgrade. I would lastly delete the old sub table and mark the link as 
unused 

Sent from my iPhone

> On Oct 17, 2018, at 4:36 PM, Timothy Penner via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> The main conversion of subtables took place when upgrading to v11, this was 
> automatic.
> ^ This only applied to sincle-level subtables as anything beyond the first 
> level was lost: http://kb.4d.com/assetid=49513
> 
> The rest of the conversion needs to be done by the developer and consists of 
> replacing the subtable commands and redrawing the relationship line. This is 
> not automatic.
> 
> -Tim
> 
> 
> 
> 
> 
> 
> 
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Spencer Hinsdale 
> via 4D_Tech
> Sent: Wednesday, October 17, 2018 1:11 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Spencer Hinsdale 
> Subject: Re: Help->v11 to v17 Upgrade or New?
> 
> 
> 4D automatically converts Subtables. This should not be a problem.
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: Help->v11 to v17 Upgrade or New?

2018-10-17 Thread Dani Beaubien via 4D_Tech 
This is a very hard question to give any advice on. There are a lot of factors 
that could affect the decision.

Things to consider:
- Complexity of the structure (# of tables, forms, methods, etc)
- Are there any old style 4D extensions used?
- Are there any plugins that are no longer supported?
- Is the existing code readable and easy to understand?

Have you tried converting it to v17 to see if it is even possible? It might 
convert and everything works and then again it might not.

If they want the data converted as well, then you are going to have to deal 
with the subtables and the existing structure.

Dani Beaubien
Open Road Development


> On Oct 17, 2018, at 1:45 PM, Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I have an old v11 database running on Windows that’s not particularly 
> well-designed and where there are more than a few subtables to deal with. 
> Assuming that there is no additional budget for writing a new clean app, 
> would you likely upgrade or re-write in v17 with the old v11 structure as 
> guide?  I’m concerned that the upgrade path will be difficult because of the 
> subtables and that by the time you deal with all of the legacy junk not this 
> database from the early 90s you could have created something fresh and new. 
> How might you approach this?
> 
> Also, the client originally said the new database would not have to migrate 
> data forward from the old system and now they are wanting to have the data 
> too.
> 
> Thanks,
> 
> Robert
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: EDI(FACT) format

2018-10-17 Thread Dani Beaubien via 4D_Tech 
I have experience with the EDI formats regarding medicaid submissions.

This doc might help you. Seems to relate to the format of the message you have 
in the email.
https://www.editeur.org/files/EDIfact%20eancom%20pdfs/EDIfact%20Serials/S2%20EDIFACT%20Transmission%20v1.3%20(serials).pdf

Dani Beaubien
Open Road Development

> On Oct 17, 2018, at 12:34 PM, Axel Kohlepp via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello.
> 
> does anyone have any experience with this format, or even suitable 4D code?
> 
> Example:
> 
> UNA:+.? '
> UNB+UNOC:3+:+xx4711xx:+181017:1124+8741+'
> UNH+1+INVOIC:D:96A:HE'
> PCD+12:2'
> BGM+380+7410268+9'
> DTM+137:20181016:102'
> RFF+VN:11775607'
> CUX+2:EUR'
> NAD+II+:91++sangro medical service GmbH+Albert-Einstein-Straße 
> 6+Erkrath+40699+DE'
> RFF+VA:DE241684816'
> NAD+IV+:91++MEDTECH GMBH+TANNENWEG 5+BAD MÜNDER+31848+DE'
> NAD+PJ+++MEDTECH GMBH+TANNENWEG 5+BAD MÜNDER+31848+DE'
> LIN+1++4250488601893:EN'
> PIA+1+06718974:SA'
> PIA+1+0802VSGHC 25VE:MF+:GN+:WG+06718974:ZZZ'
> IMD+F++:::GHC SCHLITZKOMPRESSEN 25X2 1 St'
> QTY+47:2:PCE'
> MOA+66:12.10'
> MOA+203:12.10'
> RFF+ON:ECAC181012004518:3'
> RFF+VN:11775607'
> RFF+DQ:7410268:5'
> TAX+7+VAT+++19.000'
> TAX+7+VC+++M19.000'
> NAD+DP+++Herr Olaf Knoerzer+GHP Halstenbek+Elisabeth-Miller-Weg 
> 2+Halstenbek+25469'
> UNS+S'
> CNT+2:1'
> MOA+66:12.10'
> MOA+131:0.00'
> MOA+125:12.10'
> MOA+124:2.30'
> MOA+9:14.40'
> TAX+7+VAT+++:::19.000'
> MOA+124:2.30'
> UNT+33+1'
> UNZ+1+8741'
> 
> Many thanks for all tips in advance
> 
> Axel Kohlepp
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: Help->v11 to v17 Upgrade or New?

2018-10-17 Thread Spencer Hinsdale via 4D_Tech 

4D automatically converts Subtables. This should not be a problem.

> On Oct 17, 2018, at 12:45 PM, Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I have an old v11 database running on Windows that’s not particularly 
> well-designed and where there are more than a few subtables to deal with. 
> Assuming that there is no additional budget for writing a new clean app, 
> would you likely upgrade or re-write in v17 with the old v11 structure as 
> guide?  I’m concerned that the upgrade path will be difficult because of the 
> subtables and that by the time you deal with all of the legacy junk not this 
> database from the early 90s you could have created something fresh and new. 
> How might you approach this?
> 
> Also, the client originally said the new database would not have to migrate 
> data forward from the old system and now they are wanting to have the data 
> too.
> 
> Thanks,
> 
> Robert
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: Help->v11 to v17 Upgrade or New?

2018-10-17 Thread Timothy Penner via 4D_Tech 
> The rest of the conversion needs to be done by the developer and consists of 
> replacing the subtable commands and redrawing the relationship line. This is 
> not automatic.

See more here: http://livedoc.4d.com/4Dv17/help/Title/en/page3607.html#1693868


What we mean by “change the code everywhere if it is needed” is, basically:

* Create the new forms, update included forms

* In the methods (project, form, object, etc.):
   + Replace all commands of the “SubRecords” theme with the corresponding 
Selection or Record command (for example, replace _o_CREATE SUBRECORD with 
CREATE RECORD, filling the ID fields)
   + Explicitly load the N records when needed



-Tim



**
4D Internet Users Group (4D iNUG)
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: Help->v11 to v17 Upgrade or New?

2018-10-17 Thread Chip Scheide via 4D_Tech 
At some point, v18(?), 4D will completely drop support for subtables.

as I understand:
a simple conversion to the current version will allow all the functions 
of existing subtables to continue working -- without -- any change to 
code.
As noted by Tim Penner, but typo-ed :), this applies to a SINGLE level 
of sub-tables.

table OK
  sub-table OK
   sub-sub-table ... sub--table FAIL

There are changes to the structure during this conversion.
The subtable becomes a normal 4D table, with a new "relation" created 
between the previous subtable and it parent. This "special Relation" 
allows the sub-table commands to continue working.

If you delete/change this special relation all subtable functionality 
for that relationship is gone and can not be recovered (without 
reconverting the database).



On Wed, 17 Oct 2018 14:45:52 -0500, Robert ListMail via 4D_Tech wrote:
> I have an old v11 database running on Windows that’s not particularly 
> well-designed and where there are more than a few subtables to deal 
> with. Assuming that there is no additional budget for writing a new 
> clean app, would you likely upgrade or re-write in v17 with the old 
> v11 structure as guide?  I’m concerned that the upgrade path will be 
> difficult because of the subtables and that by the time you deal with 
> all of the legacy junk not this database from the early 90s you could 
> have created something fresh and new. How might you approach this?
> 
> Also, the client originally said the new database would not have to 
> migrate data forward from the old system and now they are wanting to 
> have the data too.
> 
> Thanks,
> 
> Robert
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
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: Structure to TEXT files... GitHub

2018-10-17 Thread Patrick Emanuel via 4D_Tech 
As I know, not yet for the moment, may be later V18 or 
V17R3 give us, for the moment, the capability to manage sources with  a
Version control system, like Hithub does.



-
Patrick EMANUEL

Administrator
www.association-qualisoft.eu 
(Soft1002, Simply Asso & QS_Toolbox)
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
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: Built Server—Best Practices...

2018-10-17 Thread Paul Dennis via 4D_Tech 
I only rebuild the entire client and server if there has been a 4D version
change ie moving from 16.3 to 16.4 etc. Otherwise I build the server and
just copy across the new .DC file from the Server Database folder.   You
need to make sure compiling on same version as deploying. Never had a
problem and you dont lose the settings.  



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
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: Structure to TEXT files... GitHub

2018-10-17 Thread Epperlein, Lutz (agendo) via 4D_Tech 
> So, could this structure data not be used to create a new 4D database?  Can 
> it be
> imported back into 4D…?

This question hits the nail on the head. So you can export all your code and 
the forms into text files and commit them into a source code revision system 
like git or hg. But this doesn't make possible really team development at 
different locations and you aren't able to use the advantages of the mentioned 
source code systems called distributed repositories.

The usual workflow with such systems is that one developer does a check-in of 
his code, another developer checks out this code, merges the code with his own 
code, maybe resolving conflicts and checks in this modifications. And so on. 
This is a completely usual process during software developing. For developing 
web applications you can use this approach with 4D too. But if you want to use 
this for the native 4D code you are lost. It will not work even with the new 
feature of 4D V14R3 since it supports only exporting of code.

To solve this problem for us we use, now since several years, this component: 
https://github.com/elutz/vc-framework-v15
(or for V17 https://github.com/elutz/vc-framework-v17, but it's basically the 
same). The component is based on J. Fletcher's work 
(https://github.com/4D/vc-framework-v14).

This component saves your code into text files (methods and forms, it looks 
like the new V17R3 feature is based on this component) automatically if you 
save a method. So far so good and this isn't really a big difference to this 
new 17R3 feature. But we extended the component with the possibility to 
re-import the code changes. The process is described in the Readme, it is a bit 
complicated using this import comparing to other software developing processes 
but it works flawlessly. As I said we do this for some years with success.

Regards
Lutz

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--



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