Forum

Welcome Guest! To enable all features please try to register or login.
Export sifrarnika artikala ne radi
Options Go to last post Go to first unread
Previous Topic Next Topic
Vlado
#1 Posted : 05 April 2014 10:55:33(UTC)
Vlado

Rank: Member

Joined: 23/01/2013(UTC)
Posts: 15
Pozdrav,

prilikom exporta sifrarnika artikala iz AK program kreira prazan fajl the_setitem.vtd. Unosio sam datum i dalje radi isto. Sve ostalo izvozi kako treba. Sifrarnik ima preko 60000 zapisa. Sql server 2008 enterprise je instaliran na serveru.
markotdl
#2 Posted : 07 May 2014 06:03:47(UTC)
markotdl

Rank: Advanced Member

Joined: 17/12/2013(UTC)
Posts: 136
Izvozio sam više nego 120 tisoč idenata i mi radii, tako da bi rabio više informacija kako radite export.

Lp, Marko
Vlado
#3 Posted : 14 May 2014 09:20:11(UTC)
Vlado

Rank: Member

Joined: 23/01/2013(UTC)
Posts: 15
Utvrdio sam da je problem u slikama artikala. Na backup bazi sam obrisao sve slike i izvoz sifrarnika radi. Problem je izgleda u pogresnom formatu pojedinih slika. Pronasao sam da program u sifrarniku prevelike slike ne prikazuje, a u ispisima javlja gresku. U bazi pogresne slike cuva u formatu 0xFFD8FFE0. Sve slike sa greskom imaju ovaj string. Kako da uklonim samo ove automatski. Sql mi ne prepoznaje string?

Hvala na pomoci
PD
#4 Posted : 16 May 2014 12:27:00(UTC)
PD

Rank: Member

Joined: 03/03/2014(UTC)
Posts: 21
select *
from tHE_SetItem
where acPicture in (select acPicture from tHE_SetItem where acIdent = 'ident_with_bad_picture')

?
Vlado
#5 Posted : 16 May 2014 12:53:57(UTC)
Vlado

Rank: Member

Joined: 23/01/2013(UTC)
Posts: 15
Uspio sam da uradim UPDATE NA 'NULL' za sve slike koje su prijavljivale gresku. Pogresne su bile slike koje su imale duzinu karaktera do 10. Sada rade ispisi sa slikama ali i dalje mi sifrarnik ne izvozi. Kada uradim copy/paste iz sql-a u excel, sql server javi gresku:


Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib)

Program Location:

at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength)
at System.Text.StringBuilder.Append(String value)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.GetClipboardTextForCells(Int64 nStartRow, Int64 nEndRow, Int32 nStartCol, Int32 nEndCol)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.GetClipboardTextForSelectionBlock(Int32 nBlockNum)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.GetDataObjectInternal(Boolean bOnlyCurrentSelBlock)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.GetDataObject(Boolean bOnlyCurrentSelBlock)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.GridResultsTabPageBase.OnCopy(Object sender, EventArgs a)
Vlado
#6 Posted : 16 May 2014 12:55:11(UTC)
Vlado

Rank: Member

Joined: 23/01/2013(UTC)
Posts: 15
Ima oko 11000 artikala koji imaju slike.
Vlado
#7 Posted : 16 May 2014 13:07:28(UTC)
Vlado

Rank: Member

Joined: 23/01/2013(UTC)
Posts: 15
Izvoz u excel iz sifrarnika idenata izveze samo 16384 zapisa. Instaliran je Excel 2013
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2026, Yet Another Forum.NET
This page was generated in 0,564 seconds.