Simply Accounting import Transactions

Does anyone know the format of the import function for Simply accounting 2004 basic.  It seems to be a XML format.

Please help asap
ralphsautoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mikeopoloCommented:
The file you need to create is an .imp file, and the format varies according to the transaction type.

For example, this is a sales order file (which I found at
http://www.accountingsoftware411.com/AS411Msgbrds.nsf/msgBoards_vw/00619BC9CBFFA56D85256CB7005FE79F?OpenDocument ):

<Version>
"9001","1"
</Version>
<SalOrder>
"Lawn Maintenance Company", , , ,"Ontario", , , , ,
"1","2","1-1-2003", ,"3789.25","0.00"
"1000","1.0000","3295.0000","3295.00","GST","0","1","7.00","230.65","PST","0","0","8.00","263.60"
</SalOrder>

If you have access to the program, and can create the required transaction, *and* email it to yourself, then you can see the format from the file, and work out what the fields represent.

Regards
Mike
0
mikeopoloCommented:
Hi: are you making any progress?
Mike
0
ralphsautoAuthor Commented:
I have already looked at this format at the site you mentioned before I posted this message.  There is something wrong with this as the person using it couldn't get it to work either.  The problem is what goes where, can you supply me with this information?

Thanks

John
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

turn123Commented:
John,

Ugh this is one of the most unfrendly systems I've seen for importing info too.

Not much help but mabey gives an idea?
http://www.simplyaccounting.com/techsupport/kb/d_kbeditor.asp?xkbid=10252

Choose simply accounting (bottom Solution Set  choice) and type in import and you can see all 8 suggestions there.
http://www.simplyaccounting.com/techsupport/kb/kbsrch.asp 

If your withing the first 30 days of *any* purchase you might have a shot at their toll free phone support http://www.simplyaccounting.com/ce/support/default.asp

Their forum might have someone that has tried to do this before but it appears you need to sign up :-(.
http://www.simplyaccounting.com/_mem_bin/default.aspx?page=http://www.simplyaccounting.com/_mem_bin/CheckIfAuthenticated.aspx

According to this review the sales order import funcanality is limited.
http://www.accountingsoftwareanswers.com/asa/simply_full.htm

Doesn't look like fun at all.

What are you trying to do?  Did you check that all the information required by the import already exists in the database?

Turn123
0
ralphsautoAuthor Commented:
Hello Turn123,

Thanks for your answers, They are a little late.  I have already found these pages and the one that helped teh most is the first one.  There are a couple of things that people need to know in order to import into Simply Accounting.

1.  You can only import directly into the General Journal, unless you have the email system setup (described above)
2.  The file imported must be CSV format
3.  The totals must balance exactly any discrepancy and you are toast.
4.  The format for the xml import is hidden in secrecy so you can't import into sales or expenses, just the General Journal which doesn't apply the information to any other module.

ACCPAC's Simply Accounting is a good tool if you are not using any external programs to create data.

If you can find/decifer the format for the xml import I am extremely interested.

0
turn123Commented:
ralphsauto,

I'm sorry I can't help more :-(.

It is usually a good idea to request that your question be PAQd and your points refunded as soon as you find your answer to prevent someone looking for the answer for you when you already have it as it is discouraging to look for an answer only to find that the asker has already found the answer and you wasted your time.  :-)

If you want to PAQ this question, post a zero-point question in http://www.experts-exchange.com/Community_Support/

Subject: Moderator Please PAQ
Body: Please PAQ this question:
http://www.experts-exchange.com/Applications/Q_21365139.html

~~~Turn123
0
ralphsautoAuthor Commented:
Sorry Turn123,

This question was online for about 2 months and was hoping for a quicker answer than that.  I was also unaware I could do what you said, regarding the PAQ.  I am still looking for the format of the XML import though and that is what the original questions is about.

Ralphsauto
0
ralphsautoAuthor Commented:
The main problem with this import is I was looking for a way to import directly into two modules Sales and Payables.  Simply Accounting simply does not do it unless you are using Simply to send an email and receive an email and it needs to have specific header information with a check digit.

The answer to an import using XML is that you can't.  It has to be a Text file with the following format and follows the CSV (comma separated values) format

for expenses:
Date, "short des (9 char)", "Long Decription (39 Characters)"
Account number, Amount
Bank Number, neg Amount

for Sales:
Date, "short des (9 char)", "Long Decription (39 Characters)"
Account number, neg Amount
Bank Number, Amount

The last thing that you need to know is that the file being imported can only be imported into the General Journal

I wish to apologize to the two people who tried to answer the question I posted.  I needed to have the answers right away, I didn't expect Simply Accounting to have such limitations for importing.  The program is almost useless if you want to create a web-interface for it.
0
ralphsautoAuthor Commented:
Sorry one last point the Totals for the amounts need to balance, no exceptions.
0
NetminderCommented:
Closed, 500 points refunded.
Netminder
Site Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.