Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Simply Accounting import Transactions

Posted on 2005-03-25
11
Medium Priority
?
1,101 Views
Last Modified: 2008-03-10
Does anyone know the format of the import function for Simply accounting 2004 basic.  It seems to be a XML format.

Please help asap
0
Comment
Question by:ralphsauto
  • 5
  • 2
  • 2
  • +1
10 Comments
 
LVL 10

Expert Comment

by:mikeopolo
ID: 13642203
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
 
LVL 10

Expert Comment

by:mikeopolo
ID: 13664622
Hi: are you making any progress?
Mike
0
 

Author Comment

by:ralphsauto
ID: 13665629
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 11

Expert Comment

by:turn123
ID: 13802486
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
 

Author Comment

by:ralphsauto
ID: 13808247
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
 
LVL 11

Expert Comment

by:turn123
ID: 13808434
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
 

Author Comment

by:ralphsauto
ID: 13808493
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
 

Author Comment

by:ralphsauto
ID: 13816693
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
 

Author Comment

by:ralphsauto
ID: 13816707
Sorry one last point the Totals for the amounts need to balance, no exceptions.
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 13847858
Closed, 500 points refunded.
Netminder
Site Admin
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Eseutil Hard Recovery is part of exchange tool and ensures Exchange mailbox data recovery when mailbox gets corrupt due to some problem on Exchange server.
Choosing the right mix of apps is very much necessary for CPAs for making the most of the latest technology through which they can boost their growth.
Using Adobe Premiere Pro, the viewer will learn how to set up a sequence with proper settings, importing pictures, rendering, and exporting the finished product.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question