Re: Export/ImportSQL
Thanks y'all. I updated the database to v17 to both export and import the data - this was even worse! So ... Chip ... yes please! Thanks Pat On Tue, 21 Aug 2018 at 06:44, Nils Kollandsrud via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Pat, > > I started using Export/import sql to compact/move data between versions > since v12, and I remember having issues > with certain versions of v12 when the exported fields contained > single-quotes in that they were not escaped correctly. > If I remember correctly, it was fixed in late v12 versions (v12.6?). Also, > I had to make sure I hadn't renamed any tables/fields. > > > > On Mon, Aug 20, 2018 at 11:22 PM Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > I'm exporting data from a v12 database using EXPORT SQL and importing it > > into a v16 database. > > For the most part this works OK, but in some tables, records are missing. > > I can't see anything consistently different or wrong within the missing > > records. > > > > All text fields are stored within the records. > > > > Anybody have any ideas about this? > > > > -- > > * > > 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) > > Archive: http://lists.4d.com/archives.html > > Options: https://lists.4d.com/mailman/options/4d_tech > > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > > ** > > > > -- > Nils Kollandsrud > Ixmal Intelesis AS, Pilestredet 75 C, Postboks 5130 Majorstuen, 0302 Oslo, > Norway > Tel: +47 22121212 Mob: +47 920 15550 > ** > 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 > ** -- * 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) 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: Export/ImportSQL
Hi Pat, I started using Export/import sql to compact/move data between versions since v12, and I remember having issues with certain versions of v12 when the exported fields contained single-quotes in that they were not escaped correctly. If I remember correctly, it was fixed in late v12 versions (v12.6?). Also, I had to make sure I hadn't renamed any tables/fields. On Mon, Aug 20, 2018 at 11:22 PM Pat Bensky via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I'm exporting data from a v12 database using EXPORT SQL and importing it > into a v16 database. > For the most part this works OK, but in some tables, records are missing. > I can't see anything consistently different or wrong within the missing > records. > > All text fields are stored within the records. > > Anybody have any ideas about this? > > -- > * > 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) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** -- Nils Kollandsrud Ixmal Intelesis AS, Pilestredet 75 C, Postboks 5130 Majorstuen, 0302 Oslo, Norway Tel: +47 22121212 Mob: +47 920 15550 ** 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: Export/ImportSQL
Pat, There is a bug with dates when importing using SQL in v12. I don’t know if it has been addressed in v16 but check that you don’t have years that have 5 digits. > On Aug 20, 2018, at 5:22 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm exporting data from a v12 database using EXPORT SQL and importing it > into a v16 database. > For the most part this works OK, but in some tables, records are missing. > I can't see anything consistently different or wrong within the missing > records. > > All text fields are stored within the records. > > Anybody have any ideas about this? > Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardware, installation, training, support, programming, internet specializing in 4th Dimension =-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= "Microsoft is a cross between the Borg and the Ferengi. Unfortunately, they use Borg to do their marketing and Ferengi to do their programming." -- Simon Slavin ** 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: Export/ImportSQL
Pat, I have 4D native code that can do this task for you. if you need ti let me know can get it to you tomorrow Chip > I'm exporting data from a v12 database using EXPORT SQL and importing it > into a v16 database. > For the most part this works OK, but in some tables, records are missing. > I can't see anything consistently different or wrong within the missing > records. > > All text fields are stored within the records. > > Anybody have any ideas about this? Hell is other people Jean-Paul Sartre ** 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: Export/ImportSQL
Hi pat I have out code to clone data in v11 at one of summits. If you install that code it should get all data for you. I am in Alaska on vacation so can not get I for you till I return. Please advise if you have it. Regards Chuck Sent from my iPhone > On Aug 20, 2018, at 1:22 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm exporting data from a v12 database using EXPORT SQL and importing it > into a v16 database. > For the most part this works OK, but in some tables, records are missing. > I can't see anything consistently different or wrong within the missing > records. > > All text fields are stored within the records. > > Anybody have any ideas about this? > > -- > * > 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) > 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 **
Export/ImportSQL
I'm exporting data from a v12 database using EXPORT SQL and importing it into a v16 database. For the most part this works OK, but in some tables, records are missing. I can't see anything consistently different or wrong within the missing records. All text fields are stored within the records. Anybody have any ideas about this? -- * 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) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **