Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
Import/Export data to/from EDB with lazarus |
Fri, Jan 15 2010 9:57 AM | Permanent Link |
"Fabio Codebue @ GestionaleOpen" | WinCE - Lazarus 0.28.3 - fpc 2.2.4
I know that I have to use unicode formatting to use eDB on WinCE. After I have created database on device I need to import/export dataa. I try with a simple SDF component, to manage CSV data file. Problem is: fpc LESS THEN 2.4.0 seem have some problem to use Unicode (without BOM) CSV file. Bug was resolved into 2.4.0, but this version have problem to produce a working executable with EDB for WinCE (I don't know if is EDB or WinCE the problem) So how I can import/export data to/from WinCE eDB? If I use import/export into stores defined in eDB, HOWTO: 1. mov it from WinCE to Win32 2. read it and put into another Win32 database? Fabio Codebue Gestionale Open srl |
Fri, Jan 15 2010 2:52 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Fabio,
<< So how I can import/export data to/from WinCE eDB? >> Use the native functionality for doing so in EDB. << If I use import/export into stores defined in eDB, HOWTO: 1. mov it from WinCE to Win32 >> The only difference is in how the stores are defined using CREATE STORE. You would simply define them without a drive letter when doing so on a WinCE device (\MyApp\MyStore) << 2. read it and put into another Win32 database? >> Read what ? The .csv file that is exported from EDB ? You can use local and remote stores for copying the .csv files from the WinCE device to an EDB Server, provided that you have network connectivity on the WinCE device. Once the files are copied over to the EDB Server, you can simply use the IMPORT TABLE statement to import them into the EDB Server database. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Jan 16 2010 9:47 AM | Permanent Link |
"Fabio Codebue @ GestionaleOpen" | On Fri, 15 Jan 2010 14:52:48 -0500, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote: >Fabio, > ><< So how I can import/export data to/from WinCE eDB? >> > >Use the native functionality for doing so in EDB. > ><< If I use import/export into stores defined in eDB, HOWTO: > 1. mov it from WinCE to Win32 >> > >The only difference is in how the stores are defined using CREATE STORE. >You would simply define them without a drive letter when doing so on a WinCE >device (\MyApp\MyStore) > ><< 2. read it and put into another Win32 database? >> > >Read what ? The .csv file that is exported from EDB ? You can use local >and remote stores for copying the .csv files from the WinCE device to an EDB >Server, provided that you have network connectivity on the WinCE device. >Once the files are copied over to the EDB Server, you can simply use the >IMPORT TABLE statement to import them into the EDB Server database. Using local and remote stores imply having two eDB? One on WinCE and one on Windows32? What I wanna understand is the procedure to transfer to from an eDB on winCE to a mySQL database on Win32. 1. create a local store into WinCE CREATE STORE "miatabella" AS LOCAL PATH '\miaapp\miatabella' 2. export data to local store EXPORT TABLE "art" TO '\miaapp\miatabella' IN STORE "miatabella" 3 . copy file to win32 copy \miaapp\miatabella to my hard disk on win32 4. how to read this miatabella file? Fabio Codebue Gestionale Open srl |
Sat, Jan 16 2010 1:10 PM | Permanent Link |
"Malcolm" | Fabio Codebue +AEA- GestionaleOpen wrote:
+AD4- +AD4- What I wanna understand is the procedure to transfer to from an eDB +AD4- on winCE to a mySQL database on Win32. +AD4- +AD4- 1. create a local store into WinCE +AD4- +AD4- CREATE STORE +ACI-miatabella+ACI- AS +AD4- LOCAL PATH '+AFw-miaapp+AFw-miatabella' +AD4- +AD4- 2. export data to local store +AD4- EXPORT TABLE +ACI-art+ACI- +AD4- TO '+AFw-miaapp+AFw-miatabella' +AD4- IN STORE +ACI-miatabella+ACI- +AD4- +AD4- 3 . copy file to win32 +AD4- copy +AFw-miaapp+AFw-miatabella to my hard disk on win32 +AD4- +AD4- 4. how to read this miatabella file? +AD4- +AD4- Fabio Codebue +AD4- Gestionale Open srl Fabio Something like this: 1. as above 2. EXPORT TABLE +ACI-art+ACI- TO +ACI-Data.txt+ACI- IN STORE +ACI-miatabella+ACIAOw- 3. as above 4. Well you can 'read' it with any text editor, but to load it into MySQL do something like: LOAD DATA LOCAL INFILE '+ADw-path+AD4-Data.txt' INTO TABLE 'art'+ADs- Malcolm |
Sat, Jan 16 2010 1:34 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Malcolm
What's with the +AD4- to indicate previous post contents? Roy Lambert |
Sat, Jan 16 2010 4:25 PM | Permanent Link |
"Malcolm" | Roy Lambert wrote:
+AD4- Malcolm +AD4- +AD4- +AD4- What's with the +AD4- to indicate previous post contents? +AD4- +AD4- Roy Lambert Dunno+ACE- It's what XanaNews does for me. Is it a problem? -- |
Sun, Jan 17 2010 8:36 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Malcolm
>Dunno+ACE- It's what XanaNews does for me. Is it a problem? Nah. Just being nosey Roy Lambert |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |