1C:DN > Forum > 1C:Enterprise Platform > 1C:Integration > Import data for testing purpose


1C:Enterprise platform integration capabilities and techniques

s bs
#1
People who like this: 0 Yes / 0 No
Dec 17, 2013 06:24 PM
Just came
Rating: 1
Joined: Dec 3, 2013
Company:

I want to test program written 1S, So  I would like to add data to the catalog. But my program have a very many catalogs, data processors, registers, document, report.....  So How can i test my program. Please help. And  have a program testing module in 1C ?
 
Sergey Polikarpov
#2
People who like this: 0 Yes / 0 No
Dec 17, 2013 11:14 PM
Active user
1C:Professional
Rating: 8
Joined: Jun 25, 2013
Company: 1C Company

You can export your data from MSSQL to Excel and then to your 1C application, or add your SQL sources to the 1C application as External data sources, select data with query, process it, and write to catalogs.

1C Company support team
 
Sergey Polikarpov
#3
People who like this: 0 Yes / 0 No
Dec 17, 2013 11:28 PM
Active user
1C:Professional
Rating: 8
Joined: Jun 25, 2013
Company: 1C Company

Quote
And have a program testing module in 1C ?

User action log converter could help you with testing.

1C Company support team
 
s bs
#4
People who like this: 0 Yes / 0 No
Dec 18, 2013 01:38 AM
Just came
Rating: 1
Joined: Dec 3, 2013
Company:

Tnx, 1C administrator. I added the external data processor,but this error occured  when i run program  " ODBC error SQLSTATE: IM002 "

Edited: s bs - Jan 09, 2014 06:01 AM
 
Sergey Polikarpov
#5
People who like this: 0 Yes / 0 No
Dec 18, 2013 02:49 AM
Active user
1C:Professional
Rating: 8
Joined: Jun 25, 2013
Company: 1C Company

You just added external data sources and got this error, right?

1C Company support team
 
s bs
#6
People who like this: 0 Yes / 0 No
Dec 18, 2013 03:00 AM
Just came
Rating: 1
Joined: Dec 3, 2013
Company:

yes,
 
s bs
#7
People who like this: 0 Yes / 0 No
Dec 18, 2013 03:02 AM
Just came
Rating: 1
Joined: Dec 3, 2013
Company:

this error

Edited: s bs - Jan 09, 2014 06:01 AM
 
s bs
#8
People who like this: 0 Yes / 0 No
Dec 18, 2013 03:18 AM
Just came
Rating: 1
Joined: Dec 3, 2013
Company:

check dbo_customer -> connect -> error
 
Sergey Polikarpov
#9
People who like this: 0 Yes / 0 No
Dec 18, 2013 11:30 PM
Active user
1C:Professional
Rating: 8
Joined: Jun 25, 2013
Company: 1C Company

Click General options... and fill Connection string with the string you specified in designer mode for the current external data source.

1C Company support team
 
s bs
#10
People who like this: 0 Yes / 0 No
Dec 19, 2013 12:23 AM
Just came
Rating: 1
Joined: Dec 3, 2013
Company:

Thank you very much, this is working :)

Edited: s bs - Jan 09, 2014 06:01 AM
 
Subscribe
Users browsing this topic (guests: 2, registered: 0, hidden: 0)

© 1C LLC. All rights reserved