Re: 4D eMail Editor - full HTML support
Have you looked at 4D PDF Printer? http://node.de/indexplug.htm We use it to automate printing from 4D to PDF and then emailing using Outlook. However, it also has PRO features for reading from Outlook into 4D. Looking at the Demo, when I click on Outlook Email Parsing Client it lists messages in Outlook (takes a minute with 6000 msgs) showing their details. I don't see HTML offhand but it looks like you could automate the copy/paste (export, read .eml, ...) Hth, spencer On 7/24/19, 12:34 PM, "4D_Tech on behalf of rooftop99--- via 4D_Tech" <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote: Thanks to all who have offered suggestions. Super helpful! The biggest challenge I face is the spec calls for composing the email in Outlook first, then copying and pasting the final version into 4D with full preview and edit capability. None of my tests have proved this is possible. (There is always something wacky in the transfer.) However, your input has given me ideas on how we might take a different path to get to the same end result. We’ll see... Much appreciated! Kirk ** 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: REATE SELECTION FROM ARRAY
Chip,
I have done some tests without result, in my system I not have the same
issue. The configuration is a 4D SERVER and Two clients.
The plausible case is that the record is locked, and when the record is
unlocked, all work normally.
Thanks
Ferdinando
Il 24/07/19 22:51, Chip Scheide ha scritto:
Ferdinando,
the test I outlined below will test this scenario
the 2 processes represent 2 users.
this test scenario is roughly equivalent to the the situation for live
system with 2 users; and it allows **you** to test the situation, in
the office, on your development system rather then going to the users
site for an indefinite time to wait/try to replicate the error.
On Wed, 24 Jul 2019 22:32:39 +0200, stardata.info wrote:
Chip,
The situation is this:
1 - Client_1 create the record.
2 - At the same time, Client_2 run a loop process every two seconds,
that search if there are new records using QUERY command.
If there are new record, Client_2 do:
SELECTION TO ARRAY([TABEL];Array)
ON ERR CALL ("ERR_MANAGER")
CREATE SELECTION FROM ARRAY([TABEL];Array)
ON ERR CALL ("")
At this point i have -10503 error.
Later wiht the same record number that give -10503 error, ( i know it
because i write a log ) everything works without error.
Thanks
Ferdinando
Il 24/07/19 22:10, Chip Scheide ha scritto:
Ferdinando
to test:
in one process: create (or edit) a record
in a second process: put the record number of the new/edited record
into an array
and create selection from array
if you get the error then this is the problem,
you might be able to catch the error with an On Err Call method.
If you do not get the error - then I would run MSC and repair the data
file.
Chip
---
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: Query by Formula Join vs. Comparison
Jim Medlen writes: > On Jul 24, 2019, at 13:28, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > I am trying to do a Query Selection By Formula that links two tables by the > filed ItemNum > with the condition that the value of a field in the first table does not > equal a value in the second table. > > When I look at the ResultPlan there is a Join on the Price fields even when I > used the # comparison. > > How do I define a comparison vs a join ? > I don’t have direct answer to your question, but I’ve frequently found it helpful to write these kind of comparisons in SQL rather than trying to understand what 4D may be thinking internally. It’s easier to be explicit in SQL, at least in my experience. I’m not good enough at SQL to write something off the top of my head, especially when I don’t have the data to test it on. Sorry this isn’t much help. Tom ** 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 **
Query by Formula Join vs. Comparison
I am trying to do a Query Selection By Formula that links two tables by the
filed ItemNum
with the condition that the value of a field in the first table does not equal
a value in the second table.
When I look at the ResultPlan there is a Join on the Price fields even when I
used the # comparison.
How do I define a comparison vs a join ?
C_TEXT($vResultPlan;$vResultPath)
DESCRIBE QUERY EXECUTION(True) //analysis mode
Query Selection by Formula([ItemDiscounts];\
( ([ItemDiscounts]ItemNum=[Items]ItemNum) \
& ([ItemDiscounts]BasePrice#[Items]PriceB) \
& ([Items]PriceA#0)))
$vResultPlan:=Get last query plan(Description in text format)
ConsoleMessage("vResultPlan\r"+$vResultPlan)
$vResultPath:=Get last query path(Description in text format)
ConsoleMessage("vResultPath\r"+$vResultPath)
DESCRIBE QUERY EXECUTION(False) //End of analysis mode
vResultPlan
Join on Table : Items : ItemDiscounts.ItemNum = Items.ItemNum &
ItemDiscounts.BasePrice = Items.PriceB
Items.PriceA != 0
vResultPath
Join on Table : Items : ItemDiscounts.ItemNum = Items.ItemNum &
ItemDiscounts.BasePrice = Items.PriceB
Items.PriceA != 0 (3247 records found in 4 ms)
--> 4030 records found in 22 ms
**
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: REATE SELECTION FROM ARRAY
Ferdinando to test: in one process: create (or edit) a record in a second process: put the record number of the new/edited record into an array and create selection from array if you get the error then this is the problem, you might be able to catch the error with an On Err Call method. If you do not get the error - then I would run MSC and repair the data file. Chip On Wed, 24 Jul 2019 21:42:38 +0200, stardata.info wrote: > Hi Chip, > > The database is ok. > > Consider that this issue appares when in another process one user add > the record that GOTO RECORD must to select. > > After this issue disappares and all work normally. > > I suspect that in some cases these means that the record is locked, > because the same record number after some minutes work. > > For this reason i think that the record that give this issue can be locked. > > Thanks > Ferdinando > > Il 24/07/19 21:31, Chip Scheide ha scritto: >> Ferdinando, >> From the language reference: >> Error -10503 - Record # is out of range (during GOTO RECORD, or data >> file needs to be repaired). (see note 3) >> >> Note 3: >> The error -10503 Record # is out of range generally means that your >> code (for example, the GOTO RECORD command) is attempting to access a >> record that no longer exists (or has never existed). In certain more >> unusual cases, this error may mean that the database needs repairing. >> >> Repair the data file. >> >> Chip >> On Wed, 24 Jul 2019 21:22:35 +0200, stardata.info via 4D_Tech wrote: >>> i all, >>> >>> I use CREATE SELECTION FROM ARRAY([table];Array_Record_Number) >>> command, in a 4D application in V13.2 on windows. >>> Sometimes I have an error -10503, the record number is correct and >>> the record exists. Are always a new records created from another >>> process, is possible that the record that give -10503 is locked? >>> I done several check but i cannot reproduce the conditions as happen >>> in the customer installation. >>> >>> Thanks >>> Ferdinando >>> >>> Il 24/07/19 21:00, 4d_tech-requ...@lists.4d.com ha scritto: Send 4D_Tech mailing list submissions to 4d_tech@lists.4d.com To subscribe or unsubscribe via the World Wide Web, visit https://lists.4d.com/mailman/listinfo/4d_tech or, via email, send a message with subject or body 'help' to 4d_tech-requ...@lists.4d.com You can reach the person managing the list at 4d_tech-ow...@lists.4d.com When replying, please edit your Subject line so it is more specific than "Re: Contents of 4D_Tech digest..." Today's Topics: 1. Re: PDF Viewer (UKVetDerm) 2. Re: 4D eMail Editor - full HTML support (Paul Dennis) 3. Re: Static Pictures to Library Pictures (Tom Benedict) 4. Re: Static Pictures to Library Pictures (Charles Miller) 5. Re: Static Pictures to Library Pictures (Chip Scheide) 6. Re: Static Pictures to Library Pictures (Charles Miller) -- Message: 1 Date: Wed, 24 Jul 2019 05:47:14 + From: UKVetDerm To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: PDF Viewer Message-ID: Content-Type: text/plain; charset="utf-8" Hi Koen Yes I have had an update today directly from Rob and all is well. This remains a very good plug-in purchase. Steve On 23/07/2019, 13:54, "4D_Tech on behalf of Koen Van Hooreweghe via 4D_Tech" <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote: Hi Steve, IIRC I've had some issues with PDF Viewer plugin when moving to 4D v17 even on older macOS than Mojave. Rob Lavaux from pluggers.nl promptly fixed them. You should contact him to get your issues solved. I personally do prefer PDF Viewer instead of picture fields or web areas (on mac). Rob might be on holiday right now, but normally he responds pretty quickly. HTH Koen > Op 22 jul. 2019, om 21:48 heeft UKVetDerm via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: > > Anyone having difficulties with Mac PDF Viewer plugin (2.01) with Mojave and v17 (r4 and r5) 64 bit. Can’t decide whether I have a bad form or there is a more systemic problem. Compass bvba Koen Van Hooreweghe Kloosterstraat 65 9910 Aalter Belgium tel +32 495 511.653 ** 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: REATE SELECTION FROM ARRAY
Hi Chip, The database is ok. Consider that this issue appares when in another process one user add the record that GOTO RECORD must to select. After this issue disappares and all work normally. I suspect that in some cases these means that the record is locked, because the same record number after some minutes work. For this reason i think that the record that give this issue can be locked. Thanks Ferdinando Il 24/07/19 21:31, Chip Scheide ha scritto: Ferdinando, From the language reference: Error -10503 - Record # is out of range (during GOTO RECORD, or data file needs to be repaired). (see note 3) Note 3: The error -10503 Record # is out of range generally means that your code (for example, the GOTO RECORD command) is attempting to access a record that no longer exists (or has never existed). In certain more unusual cases, this error may mean that the database needs repairing. Repair the data file. Chip On Wed, 24 Jul 2019 21:22:35 +0200, stardata.info via 4D_Tech wrote: i all, I use CREATE SELECTION FROM ARRAY([table];Array_Record_Number) command, in a 4D application in V13.2 on windows. Sometimes I have an error -10503, the record number is correct and the record exists. Are always a new records created from another process, is possible that the record that give -10503 is locked? I done several check but i cannot reproduce the conditions as happen in the customer installation. Thanks Ferdinando Il 24/07/19 21:00, 4d_tech-requ...@lists.4d.com ha scritto: Send 4D_Tech mailing list submissions to 4d_tech@lists.4d.com To subscribe or unsubscribe via the World Wide Web, visit https://lists.4d.com/mailman/listinfo/4d_tech or, via email, send a message with subject or body 'help' to 4d_tech-requ...@lists.4d.com You can reach the person managing the list at 4d_tech-ow...@lists.4d.com When replying, please edit your Subject line so it is more specific than "Re: Contents of 4D_Tech digest..." Today's Topics: 1. Re: PDF Viewer (UKVetDerm) 2. Re: 4D eMail Editor - full HTML support (Paul Dennis) 3. Re: Static Pictures to Library Pictures (Tom Benedict) 4. Re: Static Pictures to Library Pictures (Charles Miller) 5. Re: Static Pictures to Library Pictures (Chip Scheide) 6. Re: Static Pictures to Library Pictures (Charles Miller) -- Message: 1 Date: Wed, 24 Jul 2019 05:47:14 + From: UKVetDerm To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: PDF Viewer Message-ID: Content-Type: text/plain; charset="utf-8" Hi Koen Yes I have had an update today directly from Rob and all is well. This remains a very good plug-in purchase. Steve On 23/07/2019, 13:54, "4D_Tech on behalf of Koen Van Hooreweghe via 4D_Tech" <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote: Hi Steve, IIRC I've had some issues with PDF Viewer plugin when moving to 4D v17 even on older macOS than Mojave. Rob Lavaux from pluggers.nl promptly fixed them. You should contact him to get your issues solved. I personally do prefer PDF Viewer instead of picture fields or web areas (on mac). Rob might be on holiday right now, but normally he responds pretty quickly. HTH Koen > Op 22 jul. 2019, om 21:48 heeft UKVetDerm via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: > > Anyone having difficulties with Mac PDF Viewer plugin (2.01) with Mojave and v17 (r4 and r5) 64 bit. Can’t decide whether I have a bad form or there is a more systemic problem. Compass bvba Koen Van Hooreweghe Kloosterstraat 65 9910 Aalter Belgium tel +32 495 511.653 ** 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 ** -- Message: 2 Date: Wed, 24 Jul 2019 00:56:07 -0700 (MST) From: Paul Dennis To: 4d_tech@lists.4d.com Subject: Re: 4D eMail Editor - full HTML support Message-ID: <1563954967911-0.p...@n5.nabble.com> Content-Type: text/plain; charset=us-ascii Chuck, We have a template system for email replies so need to view in 4d and auto generate email contents. We import emails via exchange/imap parse the mime results all works ok HTMl is valid but write pro does not open or format correctly at the moment. Thomas Maul confirmed the format needs to xhmtl. Paul -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html -- Message: 3 Date: Wed, 24 Jul 2019 09:11:30 -0700 From: Tom Benedict To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Chuck Miller , Ben Sokal
Re: 4D eMail Editor - full HTML support
Thanks to all who have offered suggestions. Super helpful! The biggest challenge I face is the spec calls for composing the email in Outlook first, then copying and pasting the final version into 4D with full preview and edit capability. None of my tests have proved this is possible. (There is always something wacky in the transfer.) However, your input has given me ideas on how we might take a different path to get to the same end result. We’ll see... Much appreciated! Kirk > On Jul 24, 2019, at 12:56 AM, Paul Dennis via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Chuck, > We have a template system for email replies so need to view in 4d and auto > generate email contents. We import emails via exchange/imap parse the mime > results all works ok HTMl is valid but write pro does not open or format > correctly at the moment. Thomas Maul confirmed the format needs to xhmtl. > Paul > > > > -- > 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 > ** ** 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: REATE SELECTION FROM ARRAY
Ferdinando, From the language reference: Error -10503 - Record # is out of range (during GOTO RECORD, or data file needs to be repaired). (see note 3) Note 3: The error -10503 Record # is out of range generally means that your code (for example, the GOTO RECORD command) is attempting to access a record that no longer exists (or has never existed). In certain more unusual cases, this error may mean that the database needs repairing. Repair the data file. Chip On Wed, 24 Jul 2019 21:22:35 +0200, stardata.info via 4D_Tech wrote: > i all, > > I use CREATE SELECTION FROM ARRAY([table];Array_Record_Number) > command, in a 4D application in V13.2 on windows. > Sometimes I have an error -10503, the record number is correct and > the record exists. Are always a new records created from another > process, is possible that the record that give -10503 is locked? > I done several check but i cannot reproduce the conditions as happen > in the customer installation. > > Thanks > Ferdinando > > Il 24/07/19 21:00, 4d_tech-requ...@lists.4d.com ha scritto: >> Send 4D_Tech mailing list submissions to >> 4d_tech@lists.4d.com >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://lists.4d.com/mailman/listinfo/4d_tech >> or, via email, send a message with subject or body 'help' to >> 4d_tech-requ...@lists.4d.com >> >> You can reach the person managing the list at >> 4d_tech-ow...@lists.4d.com >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of 4D_Tech digest..." >> >> >> Today's Topics: >> >> 1. Re: PDF Viewer (UKVetDerm) >> 2. Re: 4D eMail Editor - full HTML support (Paul Dennis) >> 3. Re: Static Pictures to Library Pictures (Tom Benedict) >> 4. Re: Static Pictures to Library Pictures (Charles Miller) >> 5. Re: Static Pictures to Library Pictures (Chip Scheide) >> 6. Re: Static Pictures to Library Pictures (Charles Miller) >> >> >> -- >> >> Message: 1 >> Date: Wed, 24 Jul 2019 05:47:14 + >> From: UKVetDerm >> To: 4D iNug Technical <4d_tech@lists.4d.com> >> Subject: Re: PDF Viewer >> Message-ID: >> Content-Type: text/plain; charset="utf-8" >> >> Hi Koen >> >> Yes I have had an update today directly from Rob and all is well. >> This remains a very good plug-in purchase. Steve >> >> On 23/07/2019, 13:54, "4D_Tech on behalf of Koen Van Hooreweghe via >> 4D_Tech" <4d_tech-boun...@lists.4d.com on behalf of >> 4d_tech@lists.4d.com> wrote: >> >> Hi Steve, >> IIRC I've had some issues with PDF Viewer plugin when >> moving to 4D v17 even on older macOS than Mojave. Rob Lavaux from >> pluggers.nl promptly fixed them. You should contact him to get your >> issues solved. I personally do prefer PDF Viewer instead of picture >> fields or web areas (on mac). >> Rob might be on holiday right now, but normally he >> responds pretty quickly. >> HTH >> Koen >>> Op 22 jul. 2019, om 21:48 heeft UKVetDerm via 4D_Tech >> <4d_tech@lists.4d.com> het volgende geschreven: >> > >> > Anyone having difficulties with Mac PDF Viewer plugin (2.01) >> with Mojave and v17 (r4 and r5) 64 bit. Can’t decide whether I have >> a bad form or there is a more systemic problem. >> >> Compass bvba >> Koen Van Hooreweghe >> Kloosterstraat 65 >> 9910 Aalter >> Belgium >> tel +32 495 511.653 >> >> ** >> 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 >> ** >> >> >> -- >> >> Message: 2 >> Date: Wed, 24 Jul 2019 00:56:07 -0700 (MST) >> From: Paul Dennis >> To: 4d_tech@lists.4d.com >> Subject: Re: 4D eMail Editor - full HTML support >> Message-ID: <1563954967911-0.p...@n5.nabble.com> >> Content-Type: text/plain; charset=us-ascii >> >> Chuck, >> We have a template system for email replies so need to view in 4d and auto >> generate email contents. We import emails via exchange/imap parse the mime >> results all works ok HTMl is valid but write pro does not open or format >> correctly at the moment. Thomas Maul confirmed the format needs to xhmtl. >> Paul >> >> >> >> -- >> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html >> >> >> -- >> >> Message: 3 >> Date: Wed, 24 Jul 2019 09:11:30 -0700 >> From: Tom Benedict >> To: 4D iNug Technical <4d_tech@lists.4d.com> >> Cc: Chuck Miller , Ben Sokal >> >> Subject: Re: Static Pictures to Library Pictures >> Message-ID: <7c0d5b3e-730d-4c71-a899-39e507ad8...@comcast.net> >> Content-Type:
REATE SELECTION FROM ARRAY
i all, I use CREATE SELECTION FROM ARRAY([table];Array_Record_Number) command, in a 4D application in V13.2 on windows. Sometimes I have an error -10503, the record number is correct and the record exists. Are always a new records created from another process, is possible that the record that give -10503 is locked? I done several check but i cannot reproduce the conditions as happen in the customer installation. Thanks Ferdinando Il 24/07/19 21:00, 4d_tech-requ...@lists.4d.com ha scritto: Send 4D_Tech mailing list submissions to 4d_tech@lists.4d.com To subscribe or unsubscribe via the World Wide Web, visit https://lists.4d.com/mailman/listinfo/4d_tech or, via email, send a message with subject or body 'help' to 4d_tech-requ...@lists.4d.com You can reach the person managing the list at 4d_tech-ow...@lists.4d.com When replying, please edit your Subject line so it is more specific than "Re: Contents of 4D_Tech digest..." Today's Topics: 1. Re: PDF Viewer (UKVetDerm) 2. Re: 4D eMail Editor - full HTML support (Paul Dennis) 3. Re: Static Pictures to Library Pictures (Tom Benedict) 4. Re: Static Pictures to Library Pictures (Charles Miller) 5. Re: Static Pictures to Library Pictures (Chip Scheide) 6. Re: Static Pictures to Library Pictures (Charles Miller) -- Message: 1 Date: Wed, 24 Jul 2019 05:47:14 + From: UKVetDerm To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: PDF Viewer Message-ID: Content-Type: text/plain; charset="utf-8" Hi Koen Yes I have had an update today directly from Rob and all is well. This remains a very good plug-in purchase. Steve On 23/07/2019, 13:54, "4D_Tech on behalf of Koen Van Hooreweghe via 4D_Tech" <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote: Hi Steve, IIRC I've had some issues with PDF Viewer plugin when moving to 4D v17 even on older macOS than Mojave. Rob Lavaux from pluggers.nl promptly fixed them. You should contact him to get your issues solved. I personally do prefer PDF Viewer instead of picture fields or web areas (on mac). Rob might be on holiday right now, but normally he responds pretty quickly. HTH Koen > Op 22 jul. 2019, om 21:48 heeft UKVetDerm via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: > > Anyone having difficulties with Mac PDF Viewer plugin (2.01) with Mojave and v17 (r4 and r5) 64 bit. Can’t decide whether I have a bad form or there is a more systemic problem. Compass bvba Koen Van Hooreweghe Kloosterstraat 65 9910 Aalter Belgium tel +32 495 511.653 ** 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 ** -- Message: 2 Date: Wed, 24 Jul 2019 00:56:07 -0700 (MST) From: Paul Dennis To: 4d_tech@lists.4d.com Subject: Re: 4D eMail Editor - full HTML support Message-ID: <1563954967911-0.p...@n5.nabble.com> Content-Type: text/plain; charset=us-ascii Chuck, We have a template system for email replies so need to view in 4d and auto generate email contents. We import emails via exchange/imap parse the mime results all works ok HTMl is valid but write pro does not open or format correctly at the moment. Thomas Maul confirmed the format needs to xhmtl. Paul -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html -- Message: 3 Date: Wed, 24 Jul 2019 09:11:30 -0700 From: Tom Benedict To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Chuck Miller , Ben Sokal Subject: Re: Static Pictures to Library Pictures Message-ID: <7c0d5b3e-730d-4c71-a899-39e507ad8...@comcast.net> Content-Type: text/plain; charset=utf-8 Chuck Miller responded to Ben Sokal’s post regarding moving Static Pictures to Library Pictures... On Jun 4, 2019, at 17:06, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> wrote: If you had gone to one of 4D’s road shows, JPR had a db that would do this for you. Perhaps you can request it from 4D. You still have to load each form but it is pretty seamless. Regards Chuck On Jun 4, 2019, at 7:11 PM, Ben Sokal via 4D_Tech <4d_tech@lists.4d.com> wrote: We are finally moving to v17 and need to fix all our static PICT images. From previous posts and from the 4D knowledge base I understand how to convert library images by looping through them and running the conversion code. But the problem is we have over 1100+ static PICT images that aren't in the library. The MSC has identified these images but that's only somewhat helpful
Re: Static Pictures to Library Pictures
Not really you need more, as you have to convert old PICT pictures to another format. You also have to deal with transparency issues Regards Chuck On Wed, Jul 24, 2019 at 12:29 PM Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> wrote: > > well... > I do not have the mentioned database but... > > SET PICTURE TO LIBRARY > looks like the command you need > you should be able to step through your forms in code, and locate the > picture objects, then > send them to the library > > Chip > On Wed, 24 Jul 2019 09:11:30 -0700, Tom Benedict via 4D_Tech wrote: > > Chuck Miller responded to Ben Sokal’s post regarding moving Static > > Pictures to Library Pictures... > > > >> On Jun 4, 2019, at 17:06, Chuck Miller via 4D_Tech > >> <4d_tech@lists.4d.com> wrote: > >> > >> If you had gone to one of 4D’s road shows, JPR had a db that would > >> do this for you. Perhaps you can request it from 4D. You still have > >> to load each form but it is pretty seamless. > >> > >> Regards > >> > >> Chuck > >> > >> > >>> On Jun 4, 2019, at 7:11 PM, Ben Sokal via 4D_Tech > >>> <4d_tech@lists.4d.com> wrote: > >>> > >>> We are finally moving to v17 and need to fix all our static PICT > >>> images. From previous posts and from the 4D knowledge base I > >>> understand how to convert library images by looping through them > >>> and running the conversion code. But the problem is we have over > >>> 1100+ static PICT images that aren't in the library. The MSC has > >>> identified these images but that's only somewhat helpful since that > >>> still means we have to go to every object on hundreds of forms, and > >>> change the properties from STATIC PICTURE to LIBRARY PICTURE. I can > >>> spend week(s) doing this but...maybe someone has found a more > >>> efficient way to handle bad static images that aren't in the > >>> picture library? > >>> > >>> - Ben > > > > > > Chuck, I’ve looked through the USB Drive that we received at this > > year’s 4DWT and haven’t found the DB you mention. Perhaps it was part > > of another DB with an unrelated name? Or maybe it was from a previous > > 4DWT. > > > > Anyhow, if you have any further clues on this, it would be great. We > > have about 800 static pictures on forms which need conversion. > > > > Thanks, > > > > Tom Benedict > > ** > > 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 > ** -- - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Server connectivity https://www.informed-solutions.com - This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ** 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: Static Pictures to Library Pictures
It was from the previous road show. If you need it I can forward you a copy as I have JPRs permission to do so, please notify me privately Regards Chuck On Wed, Jul 24, 2019 at 12:11 PM Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Chuck Miller responded to Ben Sokal’s post regarding moving Static Pictures > to Library Pictures... > > > On Jun 4, 2019, at 17:06, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > > wrote: > > > > If you had gone to one of 4D’s road shows, JPR had a db that would do this > > for you. Perhaps you can request it from 4D. You still have to load each > > form but it is pretty seamless. > > > > Regards > > > > Chuck > > > > > >> On Jun 4, 2019, at 7:11 PM, Ben Sokal via 4D_Tech <4d_tech@lists.4d.com> > >> wrote: > >> > >> We are finally moving to v17 and need to fix all our static PICT images. > >> From previous posts and from the 4D knowledge base I understand how to > >> convert library images by looping through them and running the conversion > >> code. But the problem is we have over 1100+ static PICT images that aren't > >> in the library. The MSC has identified these images but that's only > >> somewhat helpful since that still means we have to go to every object on > >> hundreds of forms, and change the properties from STATIC PICTURE to > >> LIBRARY PICTURE. I can spend week(s) doing this but...maybe someone has > >> found a more efficient way to handle bad static images that aren't in the > >> picture library? > >> > >> - Ben > > > Chuck, I’ve looked through the USB Drive that we received at this year’s 4DWT > and haven’t found the DB you mention. Perhaps it was part of another DB with > an unrelated name? Or maybe it was from a previous 4DWT. > > Anyhow, if you have any further clues on this, it would be great. We have > about 800 static pictures on forms which need conversion. > > Thanks, > > Tom Benedict > ** > 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 > ** -- - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Server connectivity https://www.informed-solutions.com - This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ** 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: Static Pictures to Library Pictures
Chuck Miller responded to Ben Sokal’s post regarding moving Static Pictures to Library Pictures... > On Jun 4, 2019, at 17:06, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > If you had gone to one of 4D’s road shows, JPR had a db that would do this > for you. Perhaps you can request it from 4D. You still have to load each form > but it is pretty seamless. > > Regards > > Chuck > > >> On Jun 4, 2019, at 7:11 PM, Ben Sokal via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> We are finally moving to v17 and need to fix all our static PICT images. >> From previous posts and from the 4D knowledge base I understand how to >> convert library images by looping through them and running the conversion >> code. But the problem is we have over 1100+ static PICT images that aren't >> in the library. The MSC has identified these images but that's only somewhat >> helpful since that still means we have to go to every object on hundreds of >> forms, and change the properties from STATIC PICTURE to LIBRARY PICTURE. I >> can spend week(s) doing this but...maybe someone has found a more efficient >> way to handle bad static images that aren't in the picture library? >> >> - Ben Chuck, I’ve looked through the USB Drive that we received at this year’s 4DWT and haven’t found the DB you mention. Perhaps it was part of another DB with an unrelated name? Or maybe it was from a previous 4DWT. Anyhow, if you have any further clues on this, it would be great. We have about 800 static pictures on forms which need conversion. Thanks, Tom Benedict ** 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: 4D eMail Editor - full HTML support
Chuck, We have a template system for email replies so need to view in 4d and auto generate email contents. We import emails via exchange/imap parse the mime results all works ok HTMl is valid but write pro does not open or format correctly at the moment. Thomas Maul confirmed the format needs to xhmtl. Paul -- 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 **
