473,320 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

I give up on this one...

I have tried and tried to get this to work and I'm doing something dumb.
I'm going to include sample data and my format file. Can someone help
me figure out my dumb mistake on a bulk insert using a format file?
Don't worry about data types, I'll handle that later. Thanks a lot!!!

CSV File:

ID,NAME,SPEC_ORIGINAL,SPEC,CATEGORY,ADDRESS1,CITY, STATE,ZIP,PHONE,COMPET
ITOR,PLAN,HARVESTDATE,EIDs,EIDCount,sourceIds,minS core,maxScore,hasContr
act,matchFilter,matchFilterBGR,matchFilterCAS,matc hFilterMTV,forceMatch,
forceMatchUserId,paymentPlatforms,matchStatusColor ,recordId,dupId,Networ
kComparedTo
1,name1,Family Practice General Practice,FP,PCP,address1,Deerfield
Beach,FL,33442,phone1,C1,PPO,5/15/2004,1000067851,2,BADG_0874992,9,14.4,
Y,Y,Y,Y,Y,0,,3,G,1, ,netcomp1
2,name2,Family Practice General
Practice,FP,PCP,address2,Margate,FL,33063,phone2,C 2,PPO,5/15/2004,100006
7851,2,BADG_0874992,9,10,Y,Y,Y,Y,Y,0,,3,G,2, ,netcomp2
3,name3,General Practice,GP,PCP,address3,Deerfield
Beach,FL,33442,phone3,C3,PPO,5/15/2004,1000067851,2,BADG_0874992(14.4
Y)|BADG_1901859,9,14.4,Y,Y,Y,Y,Y,0,,3,G,3, ,netcomp3
4,name4,Reproductive
Endocrinology,OBEN,OB,address4,Davie,FL,33328,phon e4,C4,PPO,5/15/2004,10
00083687,1,CAS_650410436,10.3,10.3,Y,N,N,N,N,0,,0, Y,4, ,netcomp4
Format File:
8.0
31
1 SQLCHAR 0 1 "\r\n" 0 quote Latin1_General_CI_AS
2 SQLCHAR 0 3000 "," 1 Provider_Raw_ID Latin1_General_CI_AS
3 SQLCHAR 0 3000 "," 0 none_name Latin1_General_CI_AS
4 SQLCHAR 0 3000 "," 0 none_Spec_orig Latin1_General_CI_AS
5 SQLCHAR 0 3000 "," 3 SpecialtyCode Latin1_General_CI_AS
6 SQLCHAR 0 3000 "," 2 Category Latin1_General_CI_AS
7 SQLCHAR 0 3000 "," 0 none_Address Latin1_General_CI_AS
8 SQLCHAR 0 3000 "," 0 none_City Latin1_General_CI_AS
9 SQLCHAR 0 3000 "," 0 none_State Latin1_General_CI_AS
10 SQLCHAR 0 3000 "," 0 none_Zip Latin1_General_CI_AS
11 SQLCHAR 0 3000 "," 0 none_Phone Latin1_General_CI_AS
12 SQLCHAR 0 3000 "," 0 none_Competitor Latin1_General_CI_AS
13 SQLCHAR 0 3000 "," 0 none_Plan Latin1_General_CI_AS
14 SQLCHAR 0 3000 "," 0 none_HarvestDate Latin1_General_CI_AS
15 SQLCHAR 0 3000 "," 0 none_EIDs Latin1_General_CI_AS
16 SQLCHAR 0 3000 "," 5 EIDCount Latin1_General_CI_AS
17 SQLCHAR 0 3000 "," 0 SourceIds Latin1_General_CI_AS
18 SQLCHAR 0 3000 "," 6 minScore Latin1_General_CI_AS
19 SQLCHAR 0 3000 "," 7 maxScore Latin1_General_CI_AS
20 SQLCHAR 0 3000 "," 8 hasContract Latin1_General_CI_AS
21 SQLCHAR 0 3000 "," 9 matchFilter Latin1_General_CI_AS
22 SQLCHAR 0 3000 "," 10 matchFilterBGR Latin1_General_CI_AS
23 SQLCHAR 0 3000 "," 11 matchFilterCAS Latin1_General_CI_AS
24 SQLCHAR 0 3000 "," 12 matchFilterMTV Latin1_General_CI_AS
25 SQLCHAR 0 3000 "," 13 forceMatch Latin1_General_CI_AS
26 SQLCHAR 0 3000 "," 14 forceMatchUserId Latin1_General_CI_AS
27 SQLCHAR 0 3000 "," 15 paymentPlatforms Latin1_General_CI_AS
28 SQLCHAR 0 3000 "," 16 matchStatusColor Latin1_General_CI_AS
29 SQLCHAR 0 3000 "," 17 recordId Latin1_General_CI_AS
30 SQLCHAR 0 3000 "," 18 dupId Latin1_General_CI_AS
31 SQLCHAR 0 3000 "," 4 NetworkComparedTo Latin1_General_CI_AS

Here's a script for the table!

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Provider_Results]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[Provider_Results]
GO

CREATE TABLE [dbo].[Provider_Results] (
[Provider_Raw_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Category] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SpecialtyCode] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[NetworkComparedTo] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[EIDCount] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[minScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[maxScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[hasContract] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilter] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterBGR] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterCAS] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterMTV] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[forceMatch] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[forceMatchUserId] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[paymentPlatforms] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[matchStatusColor] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[recordId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[dupId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

Thanks again. I am dying on this one. With everything included
hopefully someone (smarter than me) can figure it out.

Thanks,

Andrew

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #1
2 1193
me
Might look at the solution Erland gave me...
see subject "Bulk Insert Problems"

HTH

CBL

"Andrew Slentz" <aj******@yahoo.com> wrote in message
news:40**********************@news.newsgroups.ws.. .
I have tried and tried to get this to work and I'm doing something dumb.
I'm going to include sample data and my format file. Can someone help
me figure out my dumb mistake on a bulk insert using a format file?
Don't worry about data types, I'll handle that later. Thanks a lot!!!

CSV File:

ID,NAME,SPEC_ORIGINAL,SPEC,CATEGORY,ADDRESS1,CITY, STATE,ZIP,PHONE,COMPET
ITOR,PLAN,HARVESTDATE,EIDs,EIDCount,sourceIds,minS core,maxScore,hasContr
act,matchFilter,matchFilterBGR,matchFilterCAS,matc hFilterMTV,forceMatch,
forceMatchUserId,paymentPlatforms,matchStatusColor ,recordId,dupId,Networ
kComparedTo
1,name1,Family Practice General Practice,FP,PCP,address1,Deerfield
Beach,FL,33442,phone1,C1,PPO,5/15/2004,1000067851,2,BADG_0874992,9,14.4,
Y,Y,Y,Y,Y,0,,3,G,1, ,netcomp1
2,name2,Family Practice General
Practice,FP,PCP,address2,Margate,FL,33063,phone2,C 2,PPO,5/15/2004,100006
7851,2,BADG_0874992,9,10,Y,Y,Y,Y,Y,0,,3,G,2, ,netcomp2
3,name3,General Practice,GP,PCP,address3,Deerfield
Beach,FL,33442,phone3,C3,PPO,5/15/2004,1000067851,2,BADG_0874992(14.4
Y)|BADG_1901859,9,14.4,Y,Y,Y,Y,Y,0,,3,G,3, ,netcomp3
4,name4,Reproductive
Endocrinology,OBEN,OB,address4,Davie,FL,33328,phon e4,C4,PPO,5/15/2004,10
00083687,1,CAS_650410436,10.3,10.3,Y,N,N,N,N,0,,0, Y,4, ,netcomp4
Format File:
8.0
31
1 SQLCHAR 0 1 "\r\n" 0 quote Latin1_General_CI_AS
2 SQLCHAR 0 3000 "," 1 Provider_Raw_ID Latin1_General_CI_AS
3 SQLCHAR 0 3000 "," 0 none_name Latin1_General_CI_AS
4 SQLCHAR 0 3000 "," 0 none_Spec_orig Latin1_General_CI_AS
5 SQLCHAR 0 3000 "," 3 SpecialtyCode Latin1_General_CI_AS
6 SQLCHAR 0 3000 "," 2 Category Latin1_General_CI_AS
7 SQLCHAR 0 3000 "," 0 none_Address Latin1_General_CI_AS
8 SQLCHAR 0 3000 "," 0 none_City Latin1_General_CI_AS
9 SQLCHAR 0 3000 "," 0 none_State Latin1_General_CI_AS
10 SQLCHAR 0 3000 "," 0 none_Zip Latin1_General_CI_AS
11 SQLCHAR 0 3000 "," 0 none_Phone Latin1_General_CI_AS
12 SQLCHAR 0 3000 "," 0 none_Competitor Latin1_General_CI_AS
13 SQLCHAR 0 3000 "," 0 none_Plan Latin1_General_CI_AS
14 SQLCHAR 0 3000 "," 0 none_HarvestDate Latin1_General_CI_AS
15 SQLCHAR 0 3000 "," 0 none_EIDs Latin1_General_CI_AS
16 SQLCHAR 0 3000 "," 5 EIDCount Latin1_General_CI_AS
17 SQLCHAR 0 3000 "," 0 SourceIds Latin1_General_CI_AS
18 SQLCHAR 0 3000 "," 6 minScore Latin1_General_CI_AS
19 SQLCHAR 0 3000 "," 7 maxScore Latin1_General_CI_AS
20 SQLCHAR 0 3000 "," 8 hasContract Latin1_General_CI_AS
21 SQLCHAR 0 3000 "," 9 matchFilter Latin1_General_CI_AS
22 SQLCHAR 0 3000 "," 10 matchFilterBGR Latin1_General_CI_AS
23 SQLCHAR 0 3000 "," 11 matchFilterCAS Latin1_General_CI_AS
24 SQLCHAR 0 3000 "," 12 matchFilterMTV Latin1_General_CI_AS
25 SQLCHAR 0 3000 "," 13 forceMatch Latin1_General_CI_AS
26 SQLCHAR 0 3000 "," 14 forceMatchUserId Latin1_General_CI_AS
27 SQLCHAR 0 3000 "," 15 paymentPlatforms Latin1_General_CI_AS
28 SQLCHAR 0 3000 "," 16 matchStatusColor Latin1_General_CI_AS
29 SQLCHAR 0 3000 "," 17 recordId Latin1_General_CI_AS
30 SQLCHAR 0 3000 "," 18 dupId Latin1_General_CI_AS
31 SQLCHAR 0 3000 "," 4 NetworkComparedTo Latin1_General_CI_AS

Here's a script for the table!

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Provider_Results]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[Provider_Results]
GO

CREATE TABLE [dbo].[Provider_Results] (
[Provider_Raw_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Category] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SpecialtyCode] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[NetworkComparedTo] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[EIDCount] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[minScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[maxScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[hasContract] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilter] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterBGR] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterCAS] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterMTV] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[forceMatch] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[forceMatchUserId] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[paymentPlatforms] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[matchStatusColor] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[recordId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[dupId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

Thanks again. I am dying on this one. With everything included
hopefully someone (smarter than me) can figure it out.

Thanks,

Andrew

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!


Jul 20 '05 #2
me
Might look at the solution Erland gave me...
see subject "Bulk Insert Problems"

HTH

CBL

"Andrew Slentz" <aj******@yahoo.com> wrote in message
news:40**********************@news.newsgroups.ws.. .
I have tried and tried to get this to work and I'm doing something dumb.
I'm going to include sample data and my format file. Can someone help
me figure out my dumb mistake on a bulk insert using a format file?
Don't worry about data types, I'll handle that later. Thanks a lot!!!

CSV File:

ID,NAME,SPEC_ORIGINAL,SPEC,CATEGORY,ADDRESS1,CITY, STATE,ZIP,PHONE,COMPET
ITOR,PLAN,HARVESTDATE,EIDs,EIDCount,sourceIds,minS core,maxScore,hasContr
act,matchFilter,matchFilterBGR,matchFilterCAS,matc hFilterMTV,forceMatch,
forceMatchUserId,paymentPlatforms,matchStatusColor ,recordId,dupId,Networ
kComparedTo
1,name1,Family Practice General Practice,FP,PCP,address1,Deerfield
Beach,FL,33442,phone1,C1,PPO,5/15/2004,1000067851,2,BADG_0874992,9,14.4,
Y,Y,Y,Y,Y,0,,3,G,1, ,netcomp1
2,name2,Family Practice General
Practice,FP,PCP,address2,Margate,FL,33063,phone2,C 2,PPO,5/15/2004,100006
7851,2,BADG_0874992,9,10,Y,Y,Y,Y,Y,0,,3,G,2, ,netcomp2
3,name3,General Practice,GP,PCP,address3,Deerfield
Beach,FL,33442,phone3,C3,PPO,5/15/2004,1000067851,2,BADG_0874992(14.4
Y)|BADG_1901859,9,14.4,Y,Y,Y,Y,Y,0,,3,G,3, ,netcomp3
4,name4,Reproductive
Endocrinology,OBEN,OB,address4,Davie,FL,33328,phon e4,C4,PPO,5/15/2004,10
00083687,1,CAS_650410436,10.3,10.3,Y,N,N,N,N,0,,0, Y,4, ,netcomp4
Format File:
8.0
31
1 SQLCHAR 0 1 "\r\n" 0 quote Latin1_General_CI_AS
2 SQLCHAR 0 3000 "," 1 Provider_Raw_ID Latin1_General_CI_AS
3 SQLCHAR 0 3000 "," 0 none_name Latin1_General_CI_AS
4 SQLCHAR 0 3000 "," 0 none_Spec_orig Latin1_General_CI_AS
5 SQLCHAR 0 3000 "," 3 SpecialtyCode Latin1_General_CI_AS
6 SQLCHAR 0 3000 "," 2 Category Latin1_General_CI_AS
7 SQLCHAR 0 3000 "," 0 none_Address Latin1_General_CI_AS
8 SQLCHAR 0 3000 "," 0 none_City Latin1_General_CI_AS
9 SQLCHAR 0 3000 "," 0 none_State Latin1_General_CI_AS
10 SQLCHAR 0 3000 "," 0 none_Zip Latin1_General_CI_AS
11 SQLCHAR 0 3000 "," 0 none_Phone Latin1_General_CI_AS
12 SQLCHAR 0 3000 "," 0 none_Competitor Latin1_General_CI_AS
13 SQLCHAR 0 3000 "," 0 none_Plan Latin1_General_CI_AS
14 SQLCHAR 0 3000 "," 0 none_HarvestDate Latin1_General_CI_AS
15 SQLCHAR 0 3000 "," 0 none_EIDs Latin1_General_CI_AS
16 SQLCHAR 0 3000 "," 5 EIDCount Latin1_General_CI_AS
17 SQLCHAR 0 3000 "," 0 SourceIds Latin1_General_CI_AS
18 SQLCHAR 0 3000 "," 6 minScore Latin1_General_CI_AS
19 SQLCHAR 0 3000 "," 7 maxScore Latin1_General_CI_AS
20 SQLCHAR 0 3000 "," 8 hasContract Latin1_General_CI_AS
21 SQLCHAR 0 3000 "," 9 matchFilter Latin1_General_CI_AS
22 SQLCHAR 0 3000 "," 10 matchFilterBGR Latin1_General_CI_AS
23 SQLCHAR 0 3000 "," 11 matchFilterCAS Latin1_General_CI_AS
24 SQLCHAR 0 3000 "," 12 matchFilterMTV Latin1_General_CI_AS
25 SQLCHAR 0 3000 "," 13 forceMatch Latin1_General_CI_AS
26 SQLCHAR 0 3000 "," 14 forceMatchUserId Latin1_General_CI_AS
27 SQLCHAR 0 3000 "," 15 paymentPlatforms Latin1_General_CI_AS
28 SQLCHAR 0 3000 "," 16 matchStatusColor Latin1_General_CI_AS
29 SQLCHAR 0 3000 "," 17 recordId Latin1_General_CI_AS
30 SQLCHAR 0 3000 "," 18 dupId Latin1_General_CI_AS
31 SQLCHAR 0 3000 "," 4 NetworkComparedTo Latin1_General_CI_AS

Here's a script for the table!

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Provider_Results]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[Provider_Results]
GO

CREATE TABLE [dbo].[Provider_Results] (
[Provider_Raw_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Category] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SpecialtyCode] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[NetworkComparedTo] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[EIDCount] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[minScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[maxScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[hasContract] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilter] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterBGR] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterCAS] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterMTV] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[forceMatch] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[forceMatchUserId] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[paymentPlatforms] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[matchStatusColor] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[recordId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[dupId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

Thanks again. I am dying on this one. With everything included
hopefully someone (smarter than me) can figure it out.

Thanks,

Andrew

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!



Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

21
by: Leonardo | last post by:
I have the following associative array: $user=1; $user=1; $user=0; $user=1; $user=0; $user=1; $user=1;
10
by: techy techno | last post by:
Hiii Hello.. I just wanted to know if anyone can tell me how can I give my website visitors the feature of "FRIENDLY PRINTING" through IE. I would definitely like to give a feature like...
3
by: Marc Walgren | last post by:
Greetings I have an ASP application to enter reservations. There are multiple user security settings that require some users to have a restricted list of client in a drop list on a form. I...
1
by: Az Tech | last post by:
Hi people, (Sorry for the somewhat long post). I request some of the people on this group who have good experience using object-orientation in the field, to please give some good ideas for...
6
by: vb. | last post by:
Why we give a function data type? when we declare a function we gave a name and datatype for that function what for? if i make a parameter i declare it and give it a datatype and if i use variabels...
11
by: Wayne | last post by:
I am a one man enterprise and have been asked by a prospective client what happens to their database regarding ongoing changes etc if I get hit by a bus. Obviously my databases are distributed...
25
by: FAQ server | last post by:
----------------------------------------------------------------------- FAQ Topic - Why does parseInt('09') give an error? ----------------------------------------------------------------------- ...
1
by: Venkat | last post by:
Hi, Is there any way to give feedback to the application while a stored procedure execution is in progress? I am using sql server and my application is built using c#. The stored procedure tries...
3
by: Charlotte | last post by:
Hello, info: I'me a rookie with IIS I have on a WinXP Pro the IIS installed, so I can test some pages before uploading to the hostserver online on the hostserver is a possibility (with the...
2
dlite922
by: dlite922 | last post by:
This is a totally n00b question but I'm saying good bye to Windows slowly and I've come across where I need to own a directory but I want to give write permission to Smarty (Apache user). Right now I...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.