?
Solved

Simply Accounting import Transactions

Posted on 2005-03-25
11
Medium Priority
?
1,085 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
  • 2
  • +1
11 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

777 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