Veda2.0 Released!


Import/Export Sets
#1
Good morning.

I haven't error when I try export "Process Sets". But I have error when I try import "Process Sets".
I can't export "Table" due to error.

Coud You explain in what method I can export/import table and process sets, or save it after Veda update?

Reply
#2

Pl send me the error log file (VEDA_BE\Logs folder) for the error you mention.

VEDA update only affects the database folder "TIMES_DEMO". All other database folders are preserved during the update process. So, in general, you should not be working in this folder and you should not need to do anything special to preserve your sets/tables definitions.
For transferring sets/table definitions across database folders, the cleanest way is to use the Access route. Have the destination database active and point to the source database folder.
Let me know if this is not clear; we can do a quick GoToMeeting in the next couple hours.
Reply
#3

Sorry I have error in my last message. There is a problem with CommoditySet rather than CommoditySet.

This is log file. (..\Veda\Veda_BE\Logs\Errors_a a[GuestOrg].Log)
Error Log File for a a[GuestOrg]
Starts From 10/24/2010 12:04:49 PM
Error Stack  : Register Later() : mnuExportTables_Click() -> Stage 3
*************************************************************

Version: 4.8.705
10/24/2010 12:04:49 PM
Error in procedure mnuExportTables_Click
Source = Microsoft JET Database Engine
Number = -2147217900
Description = The INSERT INTO statement contains the following unknown field name: 'LastViewDT'.  Make sure you have typed the name correctly, and try the operation again.
Error Stack  : Register Later() : mnuExportTables_Click() -> Stage 3


Version: 4.8.705
10/24/2010 12:05:27 PM
Error in procedure mnuExportTables_Click
Source = Microsoft JET Database Engine
Number = -2147217900
Description = The INSERT INTO statement contains the following unknown field name: 'LastViewDT'.  Make sure you have typed the name correctly, and try the operation again.
Error Stack  : mnuExportTables_Click() -> Stage 3


Version: 4.8.705
10/24/2010 12:05:51 PM
Error in procedure mnuExportTables_Click
Source = Microsoft JET Database Engine
Number = -2147217900
Description = The INSERT INTO statement contains the following unknown field name: 'LastViewDT'.  Make sure you have typed the name correctly, and try the operation again.
Error Stack  : ExportSets() : mnuExportTables_Click() -> Stage 3

Thank You for help.

Reply
#4
"Import halted.Database could not match specification!"
This is error when I try import CommoditySet. Becouse I think There is no message in log file for this error.
Reply
#5
You seem to be running an old version of VEDA. Can you try the export/import operation after updating to the current version?
Reply
#6
I try import/export CommoditySet and it is work. But I try export Table in the last version.

Reply
#7

Send me the file you are trying to import.

Reply
#8
Sorry, I has bad explanation my problem.
When I try export table definition I have error ( In VEDA BE : Table->Export Table(s)->Text and chose file and table)

Log file message: 

Error Log File for a a[GuestOrg]
Starts From 10/24/2010 1:21:44 PM
Error Stack  : mnuExportTables_Click() -> Stage 3
*************************************************************

Version: 4.8.705
10/24/2010 1:21:44 PM 
Error in procedure mnuExportTables_Click
Source = Microsoft JET Database Engine
Number = -2147217900
Description = The INSERT INTO statement contains the following unknown field name: 'LastViewDT'.  Make sure you have typed the name correctly, and try the operation again.
Error Stack  : mnuExportTables_Click() -> Stage 3

Reply
#9
But the error log shows that you are using an old version of VEDA BE.
Reply
#10
Sorry for absence.
Now I have Version Veda-BE "4.8.74"

Is it finish version?

This is error file

Error Log File for a a
Starts From 11/29/2010 10:47:47 AM
Error Stack  : ExportSets() : mnuExportTables_Click() -> Stage 3
*************************************************************

Version: 4.8.74
11/29/2010 10:47:47 AM
Error in procedure mnuExportTables_Click
Source = Microsoft JET Database Engine
Number = -2147467259
Description = Field 'Layout_Temp.HideValuesCondition' cannot be a zero-length string.
Error Stack  : ExportSets() : mnuExportTables_Click() -> Stage 3
Table View:- [HETCOATEST]
Attribute = VAR_Cap
Attribute = VAR_FOut
DataValues = PV
Process = HETCOA

Reply
#11
Can you email me your VEDA_SnT.MDB from the active database folder?
Reply
#12
Could You write email?
Reply
#13
I update Veda BE
Error MSG:
"

Error Log File for a a
Starts From 11/29/2010 10:47:47 AM
Error Stack  : ExportSets() : mnuExportTables_Click() -> Stage 3
*************************************************************

Version: 4.8.74
11/29/2010 10:47:47 AM
Error in procedure mnuExportTables_Click
Source = Microsoft JET Database Engine
Number = -2147467259
Description = Field 'Layout_Temp.HideValuesCondition' cannot be a zero-length string.
Error Stack  : ExportSets() : mnuExportTables_Click() -> Stage 3
Table View:- [HETCOATEST]
Attribute = VAR_Cap
Attribute = VAR_FOut
DataValues = PV
Process = HETCOA


Version: 4.8.74
11/29/2010 11:14:13 AM
Error in procedure mnuExportTables_Click
Source = Microsoft JET Database Engine
Number = -2147467259
Description = Field 'Layout_Temp.HideValuesCondition' cannot be a zero-length string.
Error Stack  : Register Later() : mnuExportTables_Click() -> Stage 3

"


Attached Files
.zip   Veda_SnT.zip (Size: 31.95 KB / Downloads: 0)
Reply
#14
uploads/26/Veda_SnT.zip
Please see if this resolve the issue.


Attached Files
.zip   Veda_SnT.zip (Size: 32.8 KB / Downloads: 3)
Reply
#15
All works.
Many Thanks for help.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  CHPR~FX and Dummy Import JozefO 10 13,016 03-12-2020, 06:52 PM
Last Post: JozefO
  Error import results to VEDA-BE due to access 2GB limit [email protected] 9 19,489 20-05-2020, 03:09 PM
Last Post: AKanudia
  Autoformat options for VBE export tables JGlynn 2 5,078 26-04-2020, 08:23 PM
Last Post: JGlynn
  VEDA Backend Export Interruption SEM 6 14,728 30-08-2018, 10:13 PM
Last Post: SEM
  Import/Archive crush - Mode Issue GiadaVenturini 4 15,305 02-03-2017, 04:18 PM
Last Post: GiadaVenturini
  Sets ignored when importing tables to VEDA-BE pedodds 2 8,336 08-02-2016, 05:54 AM
Last Post: pedodds
  Creating TIMES run results for Import into VEDA-BE Shfa 1 7,104 10-11-2015, 05:29 AM
Last Post: AKanudia
  Don't see case results in VBE Import: ANSWER-TIMES Shfa 0 4,268 02-11-2015, 08:51 AM
Last Post: Shfa
  Problems with sets in VEDA_BE Pernille.S 2 8,684 09-02-2015, 04:00 AM
Last Post: Pernille.S
  Import to VBE StevePye 0 4,331 26-11-2014, 11:30 AM
Last Post: StevePye

Forum Jump:


Users browsing this thread: 1 Guest(s)