Desktop version

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

Forum

Search UsersRules
Import data for testing purpose
s bs
#1
Dec 17, 2013 06:24 PM
Just came
Points:: 0
Joined:: Dec 3, 2013

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 ?
Profile
Sergey Polikarpov
#2
Dec 17, 2013 11:14 PM
Active user
Points:: 0
Joined:: Jun 25, 2013

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.
Profile
Sergey Polikarpov
#3
Dec 17, 2013 11:28 PM
Active user
Points:: 0
Joined:: Jun 25, 2013

Quote
And have a program testing module in 1C ?

User action log converter could help you with testing.
Profile
s bs
#4
Dec 18, 2013 01:38 AM
Just came
Points:: 0
Joined:: Dec 3, 2013

Tnx, 1C administrator. I added the external data processor,but this error occured  when i run program  " ODBC error SQLSTATE: IM002 "
Profile
Sergey Polikarpov
#5
Dec 18, 2013 02:49 AM
Active user
Points:: 0
Joined:: Jun 25, 2013

You just added external data sources and got this error, right?
Profile
s bs
#6
Dec 18, 2013 03:00 AM
Just came
Points:: 0
Joined:: Dec 3, 2013

yes,
Profile
s bs
#7
Dec 18, 2013 03:02 AM
Just came
Points:: 0
Joined:: Dec 3, 2013

this error
Profile
s bs
#8
Dec 18, 2013 03:18 AM
Just came
Points:: 0
Joined:: Dec 3, 2013

check dbo_customer -> connect -> error
Profile
Sergey Polikarpov
#9
Dec 18, 2013 11:30 PM
Active user
Points:: 0
Joined:: Jun 25, 2013

Click General options... and fill Connection string with the string you specified in designer mode for the current external data source.
Profile
s bs
#10
Dec 19, 2013 12:23 AM
Just came
Points:: 0
Joined:: Dec 3, 2013

Thank you very much, this is working :)
Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.